GL_DailyPosting GL Daily 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_DailyPosting.M4T"
KPRIMARY: PostingDate+SourceJournal+RegisterNo+AccountKey+SequenceNo KBATCHNO: BatchNo+PostingDate+SourceJournal+RegisterNo+AccountKey+SequenceNo KSEQUENCENO: SequenceNo(u) KACCOUNTKEY: AccountKey+PostingDate+SourceJournal+RegisterNo+SequenceNo KVENDORNO: APDivisionNo+VendorNo+DocumentNo+PostingDate+SourceJournal+RegisterNo+AccountKey+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 PostingDate . . . . . . . . . 8 SNY Posting Date. . . . . . . . . .DATE Notes: YYYYMMDD 2 SourceJournal . . . . . . . . 2 SNY Source Journal. . . . . . . . .SOURCEJOURNAL Notes: Validated against GL_SourceJournal 3 RegisterNo. . . . . . . . . . 6 SNY Register Number . . . . . . . . Mask:000000 FmtType:ZEROFILL 4 AccountKey. . . . . . . . . . 9 SNY Account Number. . . . . . . . .ACCOUNT Notes: Validated against GL_Account 5 SequenceNo. . . . . . . . . . 14 SYY Sequence Number . . . . . . . . Mask:00000000000000 FmtType:ZEROFILL 6 SourceModule. . . . . . . . . 2 SYY Source Module . . . . . . . . . Notes: GL, AP, AR... 7 PostingComment. . . . . . . . 2048 SNY Posting Comment . . . . . . . .COMMENT 8 DocumentType. . . . . . . . . 1 SYY Document Type . . . . . . . . . Valid:I,C,R,S Notes: I=Invoice, C=Check, R=Receipt, S=Summary 9 DocumentNo. . . . . . . . . . 10 SNY Document Number . . . . . . . . 10 DocSequenceNo . . . . . . . . 14 SNY Document Sequence Number. . . . Mask:00000000000000 FmtType:ZEROFILL 11 ReceiptNo . . . . . . . . . . 7 SNY Receipt Number. . . . . . . . . 12 BatchType . . . . . . . . . . 2 SYY Batch Type. . . . . . . . . . . 13 BatchNo . . . . . . . . . . . 5 SYY Batch Number. . . . . . . . . .BATCHNO FmtType:ALPHANUM 14 LineSeqNo . . . . . . . . . . 14 SNY Data Entry Line Sequence Number 15 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION Mask:00 16 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . .VENDORNO 17 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE Read Only:Y Notes: YYYYMMDD 18 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . . Read Only:Y 19 UserCreatedKey. . . . . . . . 10 SNY Creation User ID. . . . . . . .USER Read Only:Y Mask:0000000000 FmtType:ZEROFILL 20 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00- 21 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00-