请您参照 实施的文档资料
新建一个新的财务数据抽取分为5个部分:
介绍
左侧的清单中显示的是按系分组的财务数据抽取(报表组)。
关闭
字段
下列字段存在于这个页签中 :
标识
| Code for the financial data extraction entered on a maximum of 10 characters. These extraction codes are unique irrespective of the group of reports. |
| Title for the extraction entered over a maximum of 30 characters. |
| The report group is designed only for the classification of grids and it is used to present a left list hierarchy by report group/grid. |
| Title for the report group entered over a maximum of 30 characters. This field can only be accessed when creating a group or in the first grid (by alphabetical order) of the report group. It is then used again automatically for each grid of the group. |
|
| This access code makes it possible to prohibit access to the financial data extractions for certain users. According to the rights granted, the following operations will be possible:
|
账册
|
|
关闭
介绍
财务数据抽取的数量和列是在一个表格中定义的。最多可以定义20列。
例如:
列名 | 累计 | 方式 | 效率 | 衡量因数 | 小数 |
发生年N-1 | 粗体 | 正常 | 1 | 2 | |
发生年N | 正常 | 正常 | 1 | 2 | |
%N-1年 | 1/(1+2) | 粗体 | 斜体 | 0.01 | 0 |
%N年 | 2/(1+2) | 粗体 | 斜体 | 0.01 | 0 |
请注意如果在列中使用百分数,可将衡量因数换算为0.01。最后,衡量因数/小数可能造成舍入不规则。例如,如果要求的小数位数为0,那么金额0.03欧元将为视为0欧元。
默认对所有的计算金额进行细节存储。需要确定是否存储各项财务数据抽取的科目明细,商业伙伴明细或分析元明细。然后,可使用细节存储在各查询界面中切换:可使用树形结构分类。可以设定将额外的部分链接到细节存储的已保存部分。
例如:打印按照地点/科目/商业伙伴分类的辅助余额并显示各商业伙伴的国家代码。
细节是/否 | 已存储信息 | 附加信息 |
是 | 地点明细 | |
是 | 科目明细 | |
是 | 商业伙伴明细 | 国家 |
为了简化或得出总数可以只获取集合报表:在这种情况下,不得启动存储复选框。只有按地点存储是必填的,因为每条报表记录附属在一个地点上。
财务数据抽取版本编号可以在必要时自动生成;但特别在这种情款下还可以进行手动编号。
也可以在括号中打印负数。
最后,可以默认产生与各财务数据抽取对应的报表和图形代码。
关闭
字段
下列字段存在于这个页签中 :
表 列
| Title of the columns in the grid entered on a maximum of 25 characters. |
| Field used to parameterize calculations between columns. The formula is simply entered by using the four arithmetic operators and by designating a column by its number (eg.: 1-2 to define a difference calculation between column 1 column 2). Brackets are authorized. Warning, each entered number represents a column number. If a formula is entered here, all the lines of the column (Lines tab) will be entered with the formula and it will then not be possible to enter them. However, the re-zeroing of this field does not erase the formulas in the Lines tab. |
|   |
| The style applied to the lines in the column is defined here. This parameterisztion is only active in printing mode.
|
| Defined here is the impression effect that is applied to the column.
|
| Indicate the divisor for the amounts in this column. The divisor must be strictly greater than zero. It makes it possible, for instance, to display amounts in thousands of Euros. By default, this field is initialized to the value of the divisor of the previous column. |
| Indicate the number of decimals for the amounts in this column. This number must be between 0 and 15. |
存储选项
| Storage options for the details used during the calculation of the financial data extraction. If an option is not checked, the corresponding detail will not be stored in the tables. The site detail is transparent for the user and is always active. It should be noted that the business partner detail depends on the account detail and that the dimension detail also includes the nature detail. |
| This field is used to associate an additional information, such as a label, to each detail field if required. This information will appear in detail enquiry mode as well as in printing mode. For instance, for the accounts, enter the DESSHO field if the short title should appear next to each account. |
| Storage options for the details used during the calculation of the financial data extraction. If an option is not checked, the corresponding detail will not be stored in the tables. The site detail is transparent for the user and is always active. It should be noted that the business partner detail depends on the account detail and that the dimension detail also includes the nature detail. |
| This field is used to associate an additional information, such as a label, to each detail field if required. This information will appear in detail enquiry mode as well as in printing mode. For instance, for the accounts, enter the DESSHO field if the short title should appear next to each account. |
| Storage options for the details used during the calculation of the financial data extraction. If an option is not checked, the corresponding detail will not be stored in the tables. The site detail is transparent for the user and is always active. It should be noted that the business partner detail depends on the account detail and that the dimension detail also includes the nature detail. |
| This field is used to associate an additional information, such as a label, to each detail field if required. This information will appear in detail enquiry mode as well as in printing mode. For instance, for the accounts, enter the DESSHO field if the short title should appear next to each account. |
| Storage options for the details used during the calculation of the financial data extraction. If an option is not checked, the corresponding detail will not be stored in the tables. The site detail is transparent for the user and is always active. It should be noted that the business partner detail depends on the account detail and that the dimension detail also includes the nature detail. |
| This field is used to associate an additional information, such as a label, to each detail field if required. This information will appear in detail enquiry mode as well as in printing mode. For instance, for the accounts, enter the DESSHO field if the short title should appear next to each account. |
特性
|
| Display option of the negative amounts. By default, the negative amounts are printed with the minus sign. |
| Specific/custom report code for the extraction. The report used during the printing can be customized. This zone is optional. By default, the TXSVAL report is launched. |
关闭
介绍
当设置各列之后,可以按照各行对应的主题新建抽取行。
在每行/列的交汇处,都可以录入一个不超过250个字符的公式。录入的公式不得带有空格,而且如果公式含有若干个表达式,将计算累计金额。
按照其来源将表达式分解为4中类型:T
公式 | 这是什么 |
从普通余额中抽取的金额 | |
70或"70" | 以70开头的所有科目 |
70..72 | 以从70至72开头的所有科目(包含首尾项) |
70(5) | 以70开头的所有科目,除了以705开头的以外 |
701704 | 以701和704开头的科目金额求和 |
I(C1)或I("C1") | 仅限总汇科目C1 |
H(C1)或H("C1") | 仅限控制科目C1但不包含科目详情 |
Bn("XY") | 在报表代码中所有带有"XY"的科目 |
An("XY") | 同上,但是控制科目可能与标准对应 |
C和D | 将该字母置于表达式开始处可以只抽取贷方或借方余额科目。可用于所有科目的表达式。 |
C70或C"70" | 所有以70开头的贷方余额。 |
CA和DA | 可以只抽取借方/贷方余额不包括科目余额。 |
例如:CA401或CA"401" | 所有以401开头的科目的贷方金额。 |
-7,-I("C1"),6-"7" | 按照借-贷协议表示金额。可以在金额前面加上负号以便转换金额。 |
NB:公式H和I之间的差。I(C1)表示总汇科目C1的所有独立科目;H(C1)表示总余额。只有在需要其它总余额的情况下,获取的结果才会不同。例如:DI(C1)与DH(C1)不同。
公式 | 这是什么 |
从分析余额抽取的金额 | |
分析金额 | |
NM("c","n","s1","s2","s3") | 对应下列内容的所有金额: |
c |
|
n |
|
s1,s2,s3 |
|
NM("CR1","706000","01") | 分析元视图代码CR1的金额(一个分析元视图),包含科目本性706000和分析元视图代码1的分析元01 |
NM("CR2","707000","SDR","PARB") | 分析元视图代码CR02的金额(两个分析元视图),包含科目本性707000和分析元视图1的分析元SDR和分析元视图2的分析元PARB |
分析数量 | |
NQ("c","n","s1","s2","s3") | 各数量对应: |
c |
|
n |
|
s1,s2,s3 |
|
NQ("CR1","706000","01") | 分析元视图代码CR1的数量(分析元视图),分析元视图1的科目本性706000和分析元1 |
NQ("CR2","707000","SDR","PARB") | 分析元视图代码CR2的数量(两个分析元视图),包括科目本性707000和分析元视图1的分析元SDR以及分析元视图2的分析元PARB |
预提交金额 | |
PM("c","n","s1","s2","s3") | 表达式同上 |
预提交数量 | |
PQ("c","n","s1","s2","s3") | 表达式同上 |
提交金额 | |
EM("c","n","s1","s2","s3") | 表达式同上 |
提交数量 | |
EQ("c","n","s1","s2","s3") | 表达式同上 |
特殊字符 | |
* | 代替n个字符。用于分析元视图代码以外的其它数据。 |
NM("CR2","707000","SDR","*") | 分析元视图代码CR2的金额(两个分析元视图),包含科目本性707000和分析元视图1的分析元SDR和分析元查看的所有分析元) |
? | 代替1个字符。可用于除了分析元视图代码以外的其它数据。 |
NM("CR2","707000","SDR","PA?B") | 分析元视图代码CR2的金额(两个分析元视图),科目本性707000和分析元视图1的分析元SDR以及所有分析元视图2从PA0B到PAZB的分析元。 |
公式 | 含义 |
金字塔使用 | |
"金字塔组" | 所有的上述语法可以应用到一个金字塔组(分析,提交,预提交金额和数量)。 |
NM("CR2","RES.GRP1","SDR","GEO.CEE") | 分析元视图代码CR2的金额(两个分析元视图),包括RES金字塔的GRP1科目本性组和分析元视图1的分析元SDR和分析元视图2的GEO金字塔的CEE分析元组。 |
公式 | 含义 |
预算的抽取金额 | |
预算金额 | |
GM("b","n","s1","s2","s3") | 个预算金额对应下列内容: |
b |
|
n |
|
s1,s2,s3 |
|
GM("BD1","607000","SDR","PARB") | BD1预算金额(以两个分析元视图的分析元代码为基础),包含科目本性607000和分析元视图1的分析元SDR和分析元视图2的分析元PARB。 |
预算数量 | |
GQ("b","n","s1","s2","s3") | 各预算数量对应: |
b |
|
n |
|
s1,s2,s3 |
|
GQ("BD1",607000","SDR","PARB") | BD1的预算数量(以两个分析元视图的分析元代码为基础),包含科目本性607000和分析元视图1的分析元SDR以及分析元视图2的分析元PARB。 |
其它公式如下:
公式 | 含有 |
其它公式 | |
L1 | 计算当前列的第1行。 |
L3(2) | 计算第2列第3行 |
L1:5 | 当前列1至5行总和 |
L1:5(2) | 第2列1至5行总和 |
R(L1*V_TAUX) | 将(当前列)第1行的金额乘以变量V_TAUX |
由于是按列进行计算,可以将此类公式用于计算上述各列之一所有行或计算当前列的上述各行。可以使用录入到公式中的变量查找其它版本和/或财务数据抽取的数值。当开始计算时,在变量中录入的版本和任何抽取代码前应带有字符$,而且按照上述公式在累计的单元格前加上"L".
例如:
$V1("L5")用于获取当前表格的版本V1的当前列第5行的金额,
$TAB1.V2("L5(2)")用于获取财务数据抽取TAB1的版本V2的第2列第5行的金额。可选择是否使用""。
与带有"L"的累计公式不同,可以使用语法进入表格或版本中的任何单元格,即使列数比当前列的大。
关闭
字段
下列字段存在于这个页签中 :
表 明细
|   |
| Calculation formula that can be entered over a maximum of 250 characters. (For the "Field format" and Centralizable Y/N" scrolling menus available by right click, see the Format help file). A formula is the concatenation of expressions separated by a space. An expression must therefore be entered without spaces. In the case where a formula contains several expressions, the amounts are added up. The expressions are broken down into 4 types according to their origin:
Formulas
NB: Difference between formulas H and I. I(C1) reads all the individual accounts of collective account C1 ; H(C1) reads the global balance. The results obtained are only different if anything other than the global balance is requested. For instance: DI(C1) is different from DH(C1).
The other formulas are as follows:
关闭
操作图标
页签 变量介绍 变量在分析和累计公式中使用,还可以用于查找其它版本和/或抽取中的数值。它们可以替换这些公式中的任何自变量。
关闭
字段 下列字段存在于这个页签中 : 表 明细
关闭
页签 报表介绍 可以在此表格中对报表中使用的页面格式进行参数定义。与公式字段或访问变量(GUSER:当前用户)的情况相反([F:TXS]DES:财务数据抽取台头),应在""之间录入自由文本("我的财务数据抽取")。这些不同的表达式可以联合。 关闭
字段 下列字段存在于这个页签中 : 表 页眉
表 页脚
关闭
|
下列字段在通过这个按钮触发的窗口中 : 块编码 1
块编码 2
关闭 可以使用此按钮将财务数据抽取传送到其它的文件夹中。 |