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

     KPRIMARY: SourceJournal+EntryNo+SequenceNo
     KSEQNO: SequenceNo(u)
     KPOSTINGDATE: PostingDate(d)+SourceJournal+EntryNo+SequenceNo

     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  SequenceNo. . . . . . . . . .    14 SNY  Sequence Number . . . . . . . .
                                                    Mask:00000000000000
                                                    FmtType:ZEROFILL
       4  PostingDate . . . . . . . . .     8 SNY  Posting Date. . . . . . . . . .DATE
       5  JournalComment. . . . . . . .  2048 SNN  Journal Comment . . . . . . . .COMMENT
       6  OffsetAccountKey. . . . . . .     9 SYY  Offset Account Number . . . . .ACCOUNT
                                                    Notes: Validated against
                                                    GL_Account
       7  Offset. . . . . . . . . . . .     1 SYY  Orientation for Offset Account1
                                                    Valid:D,C Notes: D=Debit,
                                                    C=Credit
       8  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
       9  JournalType . . . . . . . . .     1 SYY  Journal Type. . . . . . . . . .
                                                    Valid:F,N Notes: F=Financial,
                                                     N=Non-financial
      10  JournalDeleted. . . . . . . .     1 SYY  Journal Deleted . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      11  TransferNo. . . . . . . . . .    10 SNY  Transfer Number . . . . . . . .
      12  DepositNo . . . . . . . . . .    10 SNY  Deposit Number. . . . . . . . .
      13  DepositComment. . . . . . . .  2048 SNN  Deposit Comment . . . . . . . .COMMENT
      14  BankCode. . . . . . . . . . .     1 SYY  Bank Code . . . . . . . . . . .BANKCODE
                                                    Notes: Validated against
                                                    GL_Bank
      15  BatchNo . . . . . . . . . . .     5 SYY  Batch Number. . . . . . . . . .BATCHNO
                                                    FmtType:ALPHANUM
      16  DateUpdated . . . . . . . . .     8 SNN  Date Updated. . . . . . . . . .DATE
                                                    Read Only:Y
      17  TimeUpdated . . . . . . . . .     8 SNN  Time Updated. . . . . . . . . .
                                                    Read Only:Y
      18  UserUpdatedKey. . . . . . . .    10 SYN  User. . . . . . . . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL
      19  JournalTotal. . . . . . . . . 16.2  NNY  Journal Total . . . . . . . . .BALANCEAMT
                                                    Mask:#,###,###,###.00-