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