     GL_AllocationJournalWrk               GL Allocation Journal Work      Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: GL_AllocationJournal_upd,GL_AllocationListing_rpt
     SQL Def: Y  SysDB: N                        "MAS_"+%C$+"/GL"+%C$+"/GL_AllocationJournalWrk"+%S$+".M4T"

     KPRIMARY: AllocationNo+LineSeqNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  AllocationNo. . . . . . . . .     7 SYY  Allocation Number . . . . . . .ALLOCATIONNO
                                                    FmtType:CHARNUM
       2  LineSeqNo . . . . . . . . . .    14 SNN  LineSeqNo . . . . . . . . . . .
                                                    Mask:00000000000000
       3  SourceAccount . . . . . . . .    41 SYN  Source Account Fully Formatted.
       4  SourceAccountDesc . . . . . .    50 SNN  Source Account Description. . .
       5  AllocationMethod. . . . . . .     1 SYY  Allocation Method . . . . . . .
                                                    DfltVal:P Valid:P,Q,B Notes:
                                                    P=Percent*, Q=Quantity,
                                                    B=Basis
       6  AllocationCycle . . . . . . .     1 SYY  Allocation Cycle. . . . . . . .
                                                    DfltVal:M Valid:P,Q,A,M
                                                    Notes: P=Period, Q=Quarter,
                                                    A=Annual, M=Manual*
       7  AllocationBasis . . . . . . .     1 SYY  Allocation Basis. . . . . . . .
                                                    DfltVal:N Valid:N,C,P,B,E,Y,
                                                    D Notes: N=N/A, C=Current
                                                    activity, P=Prior year,
                                                    B=Beginning balance,
                                                    E=Ending balance, Y=prior
                                                    Year activity, D=buDget
       8  AmountToAllocate. . . . . . .     1 SYY  Amount To Allocate. . . . . . .
                                                    DfltVal:A Valid:A,B,M Notes:
                                                    A=Activity*, B=Balance,
                                                    M=Manual
       9  JournalNo . . . . . . . . . .     6 SYY  Journal Number. . . . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    Notes: Assigned during
                                                    Journal Entry
      10  JournalType . . . . . . . . .     1 SYY  Journal Type. . . . . . . . . .
                                                    Notes: F=Financial,
                                                    N=Non-Financial
      11  SourceJournal . . . . . . . .     2 SYY  Source Journal. . . . . . . . .SOURCEJOURNAL
                                                    Notes: Validated against
                                                    GL_SourceJournal
      12  SourceJournalDesc . . . . . .    40 SNN  Source Journal Description. . .
      13  JournalComment. . . . . . . .  2048 SNN  Journal Comment . . . . . . . .COMMENT
      14  LastPostingDate . . . . . . .     8 SNN  Last Posting Date . . . . . . .DATE
      15  BudgetCode. . . . . . . . . .    10 SYN  Budget Code . . . . . . . . . .
                                                    Notes: Validated against
                                                    GL_Budget
      16  BudgetDesc. . . . . . . . . .    40 SNN  Budget Description. . . . . . .
      17  Account . . . . . . . . . . .    41 SYN  Account Fully Formatted . . . .
      18  AccountDesc . . . . . . . . .    50 SNN  Account Description . . . . . .
      19  LinkedValue . . . . . . . . .     1 SYY  Linked Value. . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      20  LinkedAccount . . . . . . . .    41 SYN  Linked Account Fully Formatted.
      21  PostingComment. . . . . . . .  2048 SNN  Posting Comment . . . . . . . .COMMENT
      22  UserUpdatedLogon. . . . . . .    60 SNN  User Updated Logon. . . . . . .
      23  SourceAmount. . . . . . . . . 16.2  NNN  Source Amount . . . . . . . . .BALANCEAMT
                                                    Mask:#,###,###,###.00-
      24  Quantity. . . . . . . . . . . 13.2  NNN  Quantity. . . . . . . . . . . .
                                                    Mask:###,###,###.00-
      25  AllocationPercent . . . . . . 10.4  NNN  Allocation Percent. . . . . . .
                                                    Mask:-###.0000%
      26  PostingAmount . . . . . . . . 16.2  NNY  Posting Amount. . . . . . . . .BALANCEAMT
                                                    Mask:#,###,###,###.00-
      27  DebitAmount . . . . . . . . . 16.2  NNY  Debit Amount. . . . . . . . . .TRANSACTIONAMT
                                                    Mask:###,###,###.00-
      28  CreditAmount. . . . . . . . . 16.2  NNY  Credit Amount . . . . . . . . .TRANSACTIONAMT
                                                    Mask:###,###,###.00-