SY_ReportWizardGroups SY Report Wizard Groups Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N MAS_SYSTEM\SY_ReportWizardGroups.M4T
KPRIMARY: ReportID+GroupID+SortID+Sequence
Fld Column Name M/L TUR Description/Notes Class
1 ReportID. . . . . . . . . . . 30 SNY Report Surrogate Key. . . . . . Notes: Surrogate key of report 2 GroupID . . . . . . . . . . . 8 SNY Group Surrogate Key . . . . . . Notes: Surrogate key for this field 3 SortID. . . . . . . . . . . . 8 SNY Sort Surrogate Key. . . . . . . Notes: Surrogate key pointing to Sorts 4 Sequence. . . . . . . . . . . 3 SNY Sequence Number . . . . . . . . Mask:000 FmtType:ZEROFILL 5 ExpressionID. . . . . . . . . 8 SNN Expression Surrogate Key. . . . Notes: Surrogate key for Expression 6 Location. . . . . . . . . . . 1 SYN Location of Field . . . . . . . Notes: H=in group Header , F=in group Footer , B=in group Body , P=Page header , T=Trailer (page footer) 7 Calculation . . . . . . . . . 3 SYN Calculation to perform on field Notes: SUM=sum , AVG=average 8 GroupPath . . . . . . . . . . 1024 SNN Group Path. . . . . . . . . . . Notes: Full path of group setting.