SY_ReportWizardSorts                   SY Report Wizard Sorts         Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: N/A
 SQL Def: Y  SysDB: N                                               MAS_SYSTEM\SY_ReportWizardSorts.M4T

 KPRIMARY: ReportID+Sequence+SortID
 KREPORT: ReportID+SortID

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  ReportID. . . . . . . . . . .    30 SNY  Report Surrogate Key. . . . . .
                                                Notes: Surrogate key of
                                                report
   2  Sequence. . . . . . . . . . .     3 SNY  Sequence Number . . . . . . . .
                                                Mask:000 FmtType:ZEROFILL
   3  SortID. . . . . . . . . . . .     8 SNY  Sort Surrogate Key. . . . . . .
                                                Notes: Surrogate key
                                                pointing to Sorts
   4  ExpressionID. . . . . . . . .     8 SNN  Expression Surrogate Key. . . .
                                                Notes: Surrogate key for
                                                Expression
   5  Order . . . . . . . . . . . .     1 SYN  Sort Order. . . . . . . . . . .
                                                Valid:A,D Notes: A=Ascending
                                                , D=Descending
   6  BreakType . . . . . . . . . .     1 SYN  Break Type. . . . . . . . . . .
                                                Valid:P,S Notes: P=Page
                                                break , S=Section break
   7  BreakHeader . . . . . . . . .     1 SYN  Break Header. . . . . . . . . .
                                                Valid:L,V,N,B Notes: L=Label
                                                only , V=Value only , N=None
                                                , B=Both label and value
   8  BreakFooter . . . . . . . . .     1 SYN  Break Footer. . . . . . . . . .
                                                Valid:L,V,N,B Notes: L=Label
                                                only , V=Value only , N=None
                                                , B=Both label and value