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-