GL_FiscalYearDetail GL Fiscal Year Detail Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_FiscalYearDetail_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_FiscalYearDetail.M4T"
KPRIMARY: FiscalYear+FiscalPeriod
KPERIODEND: PeriodEndingDate+FiscalYear+FiscalPeriod
Fld Column Name M/L TUR Description/Notes Class
1 FiscalYear. . . . . . . . . . 4 SNY Fiscal Year . . . . . . . . . .YEAR
Mask:0000 Valid:1900-2099
FmtType:ZEROFILL
2 FiscalPeriod. . . . . . . . . 2 SNY Fiscal Period . . . . . . . . .FISCALPERIOD
Mask:00 FmtType:ZEROFILL
3 PeriodEndingDate. . . . . . . 8 SNY Period Ending Date. . . . . . .DATE
Notes: YYYYMMDD
4 AllocationsComp . . . . . . . 1 SYY Allocations Complete. . . . . .YESNO
DfltVal:N Valid:Y,N
5 CompanyCode . . . . . . . . . 3 SYY Company Code. . . . . . . . . .
DfltVal: Notes:
Used to "join" Crystal
Tables.