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-