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.