SY_FinancialReportColumn Financial Report Column Mapping Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N MAS_SYSTEM/SY_FinancialReportColumn.M4T
KPRIMARY: ReportType+ColumnFormat+ReportPeriod
Fld Column Name M/L TUR Description/Notes Class
1 ReportType. . . . . . . . . . 1 SYY Report Type . . . . . . . . . .
DfltVal:I Valid:B,I,Q,T,C
2 ColumnFormat. . . . . . . . . 1 SYY Column Format . . . . . . . . .
Valid:1-9,A,B
3 ReportPeriod. . . . . . . . . 1 SYN Report Period . . . . . . . . .
4 TemplateID. . . . . . . . . . 30 SNN Template Report Name. . . . . .
5 Column1Title1 . . . . . . . . 100 SNN Column 1 Title 1. . . . . . . .
6 Column1Title2 . . . . . . . . 100 SNN Column 1 Title 2. . . . . . . .
7 Column1Data . . . . . . . . . 100 SNN Column 1 Data . . . . . . . . .
8 Column1CalcFormula. . . . . . 100 SNN Column 1 Calc Formula . . . . .
9 Column2Title1 . . . . . . . . 100 SNN Column 2 Title 1. . . . . . . .
10 Column2Title2 . . . . . . . . 100 SNN Column 2 Title 2. . . . . . . .
11 Column2Data . . . . . . . . . 100 SNN Column 2 Data . . . . . . . . .
12 Column2CalcFormula. . . . . . 100 SNN Column 2 Calc Formula . . . . .
13 Column3Title1 . . . . . . . . 100 SNN Column 3 Title 1. . . . . . . .
14 Column3Title2 . . . . . . . . 100 SNN Column 3 Title 2. . . . . . . .
15 Column3Data . . . . . . . . . 100 SNN Column 3 Data . . . . . . . . .
16 Column3CalcFormula. . . . . . 100 SNN Column 3 Calc Formula . . . . .
17 Column4Title1 . . . . . . . . 100 SNN Column 4 Title 1. . . . . . . .
18 Column4Title2 . . . . . . . . 100 SNN Column 4 Title 2. . . . . . . .
19 Column4Data . . . . . . . . . 100 SNN Column 4 Data . . . . . . . . .
20 Column4CalcFormula. . . . . . 100 SNN Column 4 Calc Formula . . . . .
21 Column5Title1 . . . . . . . . 100 SNN Column 5 Title 1. . . . . . . .
22 Column5Title2 . . . . . . . . 100 SNN Column 5 Title 2. . . . . . . .
23 Column5Data . . . . . . . . . 100 SNN Column 5 Data . . . . . . . . .
24 Column5CalcFormula. . . . . . 100 SNN Column 5 Calc Formula . . . . .
25 Column6Title1 . . . . . . . . 100 SNN Column 6 Title 1. . . . . . . .
26 Column6Title2 . . . . . . . . 100 SNN Column 6 Title 2. . . . . . . .
27 Column6Data . . . . . . . . . 100 SNN Column 6 Data . . . . . . . . .
28 Column6CalcFormula. . . . . . 100 SNN Column 6 Calc Formula . . . . .
29 Column7Title1 . . . . . . . . 100 SNN Column 7 Title 1. . . . . . . .
30 Column7Title2 . . . . . . . . 100 SNN Column 7 Title 2. . . . . . . .
31 Column7Data . . . . . . . . . 100 SNN Column 7 Data . . . . . . . . .
32 Column7CalcFormula. . . . . . 100 SNN Column 7 Calc Formula . . . . .
33 Column8Title1 . . . . . . . . 100 SNN Column 8 Title 1. . . . . . . .
34 Column8Title2 . . . . . . . . 100 SNN Column 8 Title 2. . . . . . . .
35 Column8Data . . . . . . . . . 100 SNN Column 8 Data . . . . . . . . .
36 Column8CalcFormula. . . . . . 100 SNN Column 8 Calc Formula . . . . .
37 Column9Title1 . . . . . . . . 100 SNN Column 9 Title 1. . . . . . . .
38 Column9Title2 . . . . . . . . 100 SNN Column 9 Title 2. . . . . . . .
39 Column9Data . . . . . . . . . 100 SNN Column 9 Data . . . . . . . . .
40 Column9CalcFormula. . . . . . 100 SNN Column 9 Calc Formula . . . . .
41 Column10Title1. . . . . . . . 100 SNN Column 10 Title 1 . . . . . . .
42 Column10Title2. . . . . . . . 100 SNN Column 10 Title 2 . . . . . . .
43 Column10Data. . . . . . . . . 100 SNN Column 10 Data. . . . . . . . .
44 Column10CalcFormula . . . . . 100 SNN Column 10 Calc Formula. . . . .
45 Column11Title1. . . . . . . . 100 SNN Column 11 Title 1 . . . . . . .
46 Column11Title2. . . . . . . . 100 SNN Column 11 Title 2 . . . . . . .
47 Column11Data. . . . . . . . . 100 SNN Column 11 Data. . . . . . . . .
48 Column11CalcFormula . . . . . 100 SNN Column 11 Calc Formula. . . . .
49 Column12Title1. . . . . . . . 100 SNN Column 12 Title 1 . . . . . . .
50 Column12Title2. . . . . . . . 100 SNN Column 12 Title 2 . . . . . . .
51 Column12Data. . . . . . . . . 100 SNN Column 12 Data. . . . . . . . .
52 Column12CalcFormula . . . . . 100 SNN Column 12 Calc Formula. . . . .
53 Column13Title1. . . . . . . . 100 SNN Column 13 Title 1 . . . . . . .
54 Column13Title2. . . . . . . . 100 SNN Column 13 Title 2 . . . . . . .
55 Column13Data. . . . . . . . . 100 SNN Column 13 Data. . . . . . . . .
56 Column13CalcFormula . . . . . 100 SNN Column 13 Calc Formula. . . . .
57 Column14Title1. . . . . . . . 100 SNN Column 14 Title 1 . . . . . . .
58 Column14Title2. . . . . . . . 100 SNN Column 14 Title 2 . . . . . . .
59 Column14Data. . . . . . . . . 100 SNN Column 14 Data. . . . . . . . .
60 Column14CalcFormula . . . . . 100 SNN Column 14 Calc Formula. . . . .