     GL_TransactionJournalWrk              GL Transaction Journal Work     Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: GL_TransactionJournal_upd,GL_ReprintJournals_rpt
     SQL Def: Y  SysDB: N                       "MAS_"+%C$+"/GL"+%C$+"/GL_TransactionJournalWrk"+%S$+".M4T"

     KPRIMARY: SourceJournal+EntryNo+LineSeqNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SourceJournal . . . . . . . .     2 SYY  Source Journal. . . . . . . . .SOURCEJOURNAL
       2  EntryNo . . . . . . . . . . .     6 SYY  Entry Number. . . . . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
       3  LineSeqNo . . . . . . . . . .    14 SYY  Line Sequence Number. . . . . .
                                                    Mask:00000000000000
                                                    FmtType:ZEROFILL
       4  BatchFlag . . . . . . . . . .     1 SYY  Batch Flag. . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
       5  BatchNo . . . . . . . . . . .     5 SYY  Batch Number. . . . . . . . . .BATCHNO
                                                    FmtType:ALPHANUM
       6  JournalType . . . . . . . . .     1 SYY  Journal Type. . . . . . . . . .
                                                    DfltVal:F Valid:F,N
       7  TransactionType . . . . . . .     1 SYY  Transaction Type. . . . . . . .
                                                    Valid:A,B,C,D,R Notes:
                                                    A=Adjustment, B=Bank
                                                    transfer, C=Check number,
                                                    D=Deposit, R=document
                                                    Reference
       8  PostingDate . . . . . . . . .     8 SNY  Posting Date. . . . . . . . . .DATE
                                                    Notes: YYYYMMDD
       9  JournalComment. . . . . . . .  2048 SNN  Journal Comment . . . . . . . .COMMENT
      10  TransferNo. . . . . . . . . .    10 SNN  Transfer Number . . . . . . . .
      11  TransferBankCode. . . . . . .     1 SYN  Transfer Bank Code. . . . . . .BANKCODE
      12  DepositNo . . . . . . . . . .    10 SNN  Deposit Number. . . . . . . . .
      13  DepositComment. . . . . . . .  2048 SNN  Deposit Comment . . . . . . . .COMMENT
      14  PostBRDepositInSummary. . . .     1 SYN  Post Bank Rec. Deposit In SummaYESNO
                                                    DfltVal:N Valid:Y,N
      15  OffsetAccountKey. . . . . . .     9 SNY  Offset Account Number . . . . .
      16  OffsetAccount . . . . . . . .    41 SYN  Offset Account. . . . . . . . .
      17  Offset. . . . . . . . . . . .     1 SYY  Offset Orientation. . . . . . .
                                                    Valid:D,C Notes: D=Debit,
                                                    C=Credit
      18  JournalDeleted. . . . . . . .     1 SYY  Journal Deleted . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      19  BankCode. . . . . . . . . . .     1 SYY  Bank Code . . . . . . . . . . .BANKCODE
      20  EnterBatchTotForTransJrnlDE .     1 SYN  Enter Batch Total for TransactiYESNO
                                                    DfltVal:N Valid:Y,N
      21  UserUpdatedLogon. . . . . . .    60 SNN  User Updated Logon. . . . . . .
      22  CheckNo . . . . . . . . . . .    10 SYY  Check Number. . . . . . . . . .
      23  DocRefer. . . . . . . . . . .    10 SNN  Document Reference. . . . . . .
      24  Date. . . . . . . . . . . . .     8 SYY  Date. . . . . . . . . . . . . .DATE
                                                    Notes: YYYYMMDD
      25  PostingComment. . . . . . . .  2048 SNN  Posting Comment . . . . . . . .COMMENT
      26  AccountKey. . . . . . . . . .     9 SYY  Account Number. . . . . . . . .ACCOUNT
                                                    Notes: Validated against
                                                    GL_Account
      27  Account . . . . . . . . . . .    41 SYY  Fully Formatted Account Number.
      28  AccountDesc . . . . . . . . .    50 SNN  Account Description . . . . . .
      29  DebitAmount . . . . . . . . . 16.2  NNY  Debit Amount. . . . . . . . . .TRANSACTIONAMT
                                                    Mask:###,###,###.00-
      30  CreditAmount. . . . . . . . . 16.2  NNY  Credit Amount . . . . . . . . .TRANSACTIONAMT
                                                    Mask:###,###,###.00-
      31  JournalTotal. . . . . . . . . 16.2  NNN  Journal Total . . . . . . . . .BALANCEAMT
                                                    Mask:#,###,###,###.00-