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-