GL_TransactionJournalDetail GL Transaction Journal Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: GL_TransactionJournalDetail_bus SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_TransactionJournalDetail.M4T"
KPRIMARY: SourceJournal+EntryNo+LineKey KDISPLAY: SourceJournal+EntryNo+LineSeqNo+LineKey
Fld Column Name M/L TUR Description/Notes Class
1 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL Read Only:Y 2 EntryNo . . . . . . . . . . . 6 SYY Entry Number. . . . . . . . . . Read Only:Y Mask:000000 FmtType:ZEROFILL 3 LineKey . . . . . . . . . . . 6 SNY Line Key. . . . . . . . . . . . Read Only:Y Mask:000000 FmtType:ZEROFILL 4 LineSeqNo . . . . . . . . . . 14 SNY Line Sequence Number. . . . . . Read Only:Y Mask:000000000000 00 FmtType:ZEROFILL 5 DocRefer. . . . . . . . . . . 10 SNN Document Reference. . . . . . . DepVal:REQUIRED 6 CheckNo . . . . . . . . . . . 10 SYN Check Number. . . . . . . . . . FmtType:ALPHANUM DepVal:REQUI RED 7 BankCode. . . . . . . . . . . 1 SYN Bank Code . . . . . . . . . . .BANKCODE DepVal:REQUIRED 8 Date. . . . . . . . . . . . . 8 SNY Date. . . . . . . . . . . . . .DATE Notes: YYYYMMDD 9 PostingComment. . . . . . . . 2048 SNN Posting Comment . . . . . . . .COMMENT 10 AccountKey. . . . . . . . . . 9 SYN Account Number. . . . . . . . .ACCOUNT DepVal:REQUIRED Notes: Validated against GL_Account 11 CreditAmount. . . . . . . . . 16.2 NNN Credit Amount . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00- 12 DebitAmount . . . . . . . . . 16.2 NNN Debit Amount. . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00-