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