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-