SY_ReportWizardExpressions SY Report Wizard Expressions Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N MAS_SYSTEM\SY_ReportWizardExpressions.M4T
KPRIMARY: ReportID+Type+ExpressionID KREPORT: ReportID+Type+ColumnName KEXPRID: ReportID+ExpressionID KGROUP: ReportID+Group KITEM: ReportID+ITM_NAME
Fld Column Name M/L TUR Description/Notes Class
1 ReportID. . . . . . . . . . . 30 SYY Report surrogate key. . . . . . 2 Type. . . . . . . . . . . . . 1 SYN Expression Type . . . . . . . . Valid:C,F,G,S Notes: C=Column, F=Filter, G=Group, S=Sort 3 ExpressionID. . . . . . . . . 8 SNN Surrogate Key to Expression . . 4 ColumnName. . . . . . . . . . 127 SNN Column Name . . . . . . . . . . 5 Caption . . . . . . . . . . . 30 SNN Caption . . . . . . . . . . . . 6 Justification . . . . . . . . 1 SYN Justification . . . . . . . . . Valid:C,L,R Notes: C=Center, L=Left, R=Right 7 Length. . . . . . . . . . . . 3 SNN Length. . . . . . . . . . . . . 8 DataType. . . . . . . . . . . 1 SYN Data Type . . . . . . . . . . . 9 Calculation . . . . . . . . . 3 SYN Calculation . . . . . . . . . . Notes: AVG=average, CNT=count, SUM=summary 10 Group . . . . . . . . . . . . 1 SYN Group . . . . . . . . . . . . . Valid:H,D,T Notes: H=Heading, D=Detail, T=Total 11 DecimalPlaces . . . . . . . . 1 SYY Decimal Places. . . . . . . . . Valid:0,1,2,3 12 NegativeValues. . . . . . . . 1 SYN Negative Values . . . . . . . . Valid:P,S.E Notes: P=Prefix, S=Suffix, E=Enclosed with parentheses 13 DecimalSeparator. . . . . . . 1 SYN Decimal Separator . . . . . . . Valid:C,P Notes: C=Comma, P=Period 14 ThousandsSeparator. . . . . . 1 SYY Thousands Separator . . . . . . Valid:C,P Notes: C=Comma, P=Period 15 StringMask. . . . . . . . . . 64 SNN String Mask . . . . . . . . . . 16 CanGrow . . . . . . . . . . . 1 SYN Can Grow. . . . . . . . . . . .YESNO Valid:Y,N 17 Expression. . . . . . . . . . 1024 SNN Expression. . . . . . . . . . . 18 LinkTable . . . . . . . . . . 30 SNN Link Table. . . . . . . . . . . DfltVal:Link Table 19 Enabled . . . . . . . . . . . 1 SYN Enabled . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N 20 OriginalField . . . . . . . . 1 SNN Original Field. . . . . . . . .YESNO DfltVal:N Valid:Y,N 21 ITM_SRC_ID. . . . . . . . . . 32 SNN Datasource Name . . . . . . . . 22 ITM_NAME. . . . . . . . . . . 30 SNN Internal Name . . . . . . . . . 23 ITM_FLD_SEQ . . . . . . . . . 4 SNN Element Sequence. . . . . . . . 24 ITM_CLASS . . . . . . . . . . 24 SNN Data Class. . . . . . . . . . . 25 VUE_SEQ . . . . . . . . . . . 4 SNN View Sequence . . . . . . . . . 26 VUE_PATH. . . . . . . . . . . 240 SNN Source Linkage. . . . . . . . .