GL_DetailPosting GL Detail Posting Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: GL_GeneralJournal_upd,GL_RecurringJournal_upd,GL_AllocationJournal_upd,GL_TransactionJournal_u SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_DetailPosting.M4T"
KPRIMARY: AccountKey+PostingDate+SourceJournal+JournalRegisterNo+SequenceNo KSOURCEJOURNAL: SourceJournal+JournalRegisterNo+PostingDate+SequenceNo KSEQNO: SequenceNo(u) KPOSTINGDATE: PostingDate(d)+AccountKey+SourceJournal+JournalRegisterNo+SequenceNo KSOURCEMODULE: SourceModule+AccountKey+PostingDate+SourceJournal+JournalRegisterNo(**)+SequenceNo **=C ase Sensitive
Fld Column Name M/L TUR Description/Notes Class
1 AccountKey. . . . . . . . . . 9 SNY Account Number. . . . . . . . .ACCOUNT Notes: Validated against GL_Account 2 PostingDate . . . . . . . . . 8 SNY Posting Date. . . . . . . . . .DATE Notes: YYYYMMDD 3 SourceJournal . . . . . . . . 2 SNY Source Journal. . . . . . . . .SOURCEJOURNAL Notes: Validated against GL_SourceJournal 4 JournalRegisterNo . . . . . . 6 SNY Journal/Register Number . . . . Mask:000000 FmtType:ZEROFILL Notes: This can also be a Journal Number from GL Data Entry tables. 5 SequenceNo. . . . . . . . . . 14 SNY Sequence Number . . . . . . . . Mask:00000000000000 FmtType:ZEROFILL 6 SourceModule. . . . . . . . . 2 SYY Source Module . . . . . . . . . Notes: GL, AP, AR... 7 DocumentType. . . . . . . . . 1 SNY Document Type . . . . . . . . . Valid:I,C,R,S Notes: I=Invoice, C=Check, R=Receipt, S=Summary 8 DocumentNo. . . . . . . . . . 15 SNY Document Number . . . . . . . . 9 DocSequenceNo . . . . . . . . 14 SNY Document Sequence Number. . . . Mask:00000000000000 FmtType:ZEROFILL 10 ReceiptNo . . . . . . . . . . 7 SNY Receipt Number. . . . . . . . . 11 BatchType . . . . . . . . . . 2 SYY Batch Type. . . . . . . . . . . 12 BatchNo . . . . . . . . . . . 5 SYY Batch Number. . . . . . . . . .BATCHNO FmtType:ALPHANUM 13 PostingComment. . . . . . . . 2048 SNY Posting Detail Comment. . . . .COMMENT 14 HeaderRec . . . . . . . . . . 1 SYN Header Record . . . . . . . . .YESNO DfltVal:N Valid:Y,N 15 LineBankCode. . . . . . . . . 1 SNN Line Bank Code. . . . . . . . .BANKCODE 16 LineDocRefer. . . . . . . . . 10 SNN Line Document Reference . . . . 17 LineDate. . . . . . . . . . . 8 SNN Line Date . . . . . . . . . . .DATE 18 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 19 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 20 UserCreatedKey. . . . . . . . 10 SNY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 21 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00- 22 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00-