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-