Field help (TXSFORLIG) @ L.V. Expertise X3

Specify the accounts or account classes to be taken into consideration on this line. It features a series of codes separated by spaces. There are 3 different types of codes: ? The codes for the extraction of amounts from the general balance. ? The codes for the extraction of amounts from the analytical balance. ? The codes for the extraction of amounts from the budgets. For instance, in general accounting: ------------------------------- 707 All accounts starting with 707. 70-72 All accounts of classes 70 to 72. 70(7) The entire class 70, except those starting with 707. D44 All debit accounts of class 44. C44 All redit acounts of class 44. MD44 Only takes the sum of the debits. MC44 Only takes the sum of the credits. I("C1") Individually parses all the accounts of the collective account C1. H("C1") identical except without the account detail. B2("XY") All the accounts having "XY" as number 2 balance sheet code. A2("XY") Same but if a collective account meets this criterion, the individual accounts are parsed. IM("No_CATEG","NOM_VARIABLE") Extraction IMMO 2054 No_CATEG is the number of the fixed asset category VARIABLE_NAME is equal to: VALDEB value of asset fiscal year start REVAL revaluation ACQUIT Acquisitions, transfers+ CESSION Sales VIRMIN Transfers - VALFIN value of asset fiscal year end VALORG Original value fiscal year end AM("No_CATEG","VARIABLE_NAME","F") Extraction IMMO 2055 No_CATEG is the number of the fixed asset category VARIABLE_NAME is equal to: VALDEB value of asset fiscal year start REVAL revaluation ACQUIT Acquisitions, transfers+ CESSION Sales VIRMIN Transfers - VALFIN value of asset fiscal year end VALORG Original value fiscal year end Fixed asset type: E Economic, F FiscalCodes for the analytical accounting: -------------------------------------- NM(d,n,d1,d2,d3) All the amounts correspond to: d dimension view code (mandatory). n nature. d1 dimension 1 of the dimension view code. d2 dimension 2 of the dimension view code. d3 dimension 3 of the dimension view code. It is possible to use the * and ? wildcards for n, d1, d2, d3. The minimum number of arguments must match the number of crossed dimension view codes + 2 NQ(d,n,d1,d2,d3) Same for the quantities. EM(d,n,d1,d2,d3) Identical but for the committed amounts. EQ(d,n,d1,d2,d3) Identical but for the committed quantities. PM(d,n,d1,d2,d3) Identical but for the precommitted amounts. PQ(d,n,d1,d2,d3) Identical but for the precommitted quantities. Codes for the budget accounting: -------------------------------------- GM(b,n,d1,d2,d3) All the amounts corresponding to: b budget code (mandatory). n nature code. d1 dimension 1 of the dimension view code of the budget. d2 dimension 2 of the dimension view code of the budget. d3 dimension 3 of the dimension view code of the budget. GQ(d,n,d1,d2,d3) Identical but for the quantities. Other codes: ------------- T4 Picks up the calculation in line 4 of the current column. T-4 Picks up the calculation on the fourth line before the current line. For instance: Line 7, picks up the calculation of line 3. CAUTION, with T, the specified line number cannot be larger than the number of the current line. R(expr) Calculation of the same ratio for periods x. expr is an arithmetic expression that can use variables T(1), T(2), T(x), etc., in other words the results of the various lines. S(expr) Ratio between the values of x periods. expr is an arithmetic expression that can use variables T1(1), T1(2), ... results of 1st period T2(1), T2(2), ... results of 2nd period Tx(1), Tx(2), ... results of xth period. Caution, this series of codes will be 'Tokenized'. If balance sheets codes like BY are required, brackets should be used. For instance B2("BY").