GL_PeriodBudgetDetail GL Budget Detail By Period Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_PeriodBudgetDetail.M4T"
KPRIMARY: AccountKey+BudgetCode+FiscalYear+FiscalPeriod KBUDGETCODE: BudgetCode KYEAR: FiscalYear+FiscalPeriod+AccountKey+BudgetCode KYEARPERIOD: FiscalYear(d)+FiscalPeriod+AccountKey+BudgetCode
Fld Column Name M/L TUR Description/Notes Class
1 AccountKey. . . . . . . . . . 9 SNY Account Number. . . . . . . . .ACCOUNT Notes: Validated against GL_Account 2 BudgetCode. . . . . . . . . . 10 SYY Budget Code . . . . . . . . . .BUDGETCODE Notes: Validated against GL_Budget 3 FiscalYear. . . . . . . . . . 4 SNY Fiscal Year . . . . . . . . . .YEAR Mask:0000 FmtType:ZEROFILL 4 FiscalPeriod. . . . . . . . . 2 SNY Fiscal Period . . . . . . . . .FISCALPERIOD Mask:00 FmtType:ZEROFILL 5 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 6 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . . Read Only:Y 7 UserUpdatedKey. . . . . . . . 10 SYN User Updated Key. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 8 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00- 9 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00-