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-