GL_PeriodPostingHistory GL Posting History By Period Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: GL_GeneralJournal_upd,GL_RecurringJournal_upd,GL_AllocationJournal_upd,GL_TransactionJournal_u
SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_PeriodPostingHistory.M4T"
KPRIMARY: AccountKey+FiscalYear+FiscalPeriod
KYEAR: FiscalYear+FiscalPeriod+AccountKey
KYEARACCOUNTKEY: FiscalYear+AccountKey+FiscalPeriod
KYEARPERIOD: FiscalYear(d)+FiscalPeriod+AccountKey
Fld Column Name M/L TUR Description/Notes Class
1 AccountKey. . . . . . . . . . 9 SNY Account Number. . . . . . . . .ACCOUNT
Notes: Validated against
GL_Account
2 FiscalYear. . . . . . . . . . 4 SNY Fiscal Year . . . . . . . . . .YEAR
Mask:0000 FmtType:ZEROFILL
3 FiscalPeriod. . . . . . . . . 2 SNY Fiscal Period . . . . . . . . .FISCALPERIOD
Mask:00 FmtType:ZEROFILL
4 BeginningBalance. . . . . . . 16.2 NNY Beginning Balance . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
Notes: Period 1 only
5 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-
6 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .BALANCEAMT
Mask:#,###,###,###.00-