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. . . . .