BM_DailyPostingWork BM Daily Posting Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/BM"+%C$+"/BM_DailyPostingWork.M4T"
KPRIMARY: PostingDate+SourceJournal+RegisterNo+AccountKey+SequenceNo KSEQUENCENO: SequenceNo(u) KREGISTERNO: RegisterNo+PostingDate+SourceJournal+AccountKey+SequenceNo KACCOUNTKEY: AccountKey+PostingDate+SourceJournal+RegisterNo+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 PostingDate . . . . . . . . . 8 SNY Posting Date. . . . . . . . . .DATE 2 SourceJournal . . . . . . . . 2 SNY Source Journal. . . . . . . . .SOURCEJOURNAL Notes: Validated against GL_SourceJournal 3 RegisterNo. . . . . . . . . . 6 SNY Register Number . . . . . . . . 4 AccountKey. . . . . . . . . . 9 SNY Account Number. . . . . . . . .ACCOUNT Notes: Validated against GL_Account 5 SequenceNo. . . . . . . . . . 14 SYY Sequence Number . . . . . . . . 6 SourceModule. . . . . . . . . 2 SYY Source Module . . . . . . . . . Notes: GL, AP, AR... 7 PostingComment. . . . . . . . 2048 SNY Posting Comment . . . . . . . .COMMENT 8 DocumentType. . . . . . . . . 1 SNY Document Type . . . . . . . . . Valid:I,C,R,S Notes: I=Invoice, C=Check, R=Receipt, S=Summary 9 DocumentNo. . . . . . . . . . 10 SYY Document Number . . . . . . . . 10 DocSequenceNo . . . . . . . . 14 SNY Document Sequence Number. . . . 11 ReceiptNo . . . . . . . . . . 7 SNY Receipt Number. . . . . . . . . 12 BatchType . . . . . . . . . . 2 SYY Batch Type. . . . . . . . . . . 13 BatchNo . . . . . . . . . . . 5 SYY Batch Number. . . . . . . . . .BATCHNO 14 LineSeqNo . . . . . . . . . . 14 SNY Data Entry Line Sequence Number 15 APDivisionNo. . . . . . . . . 2 SYY AP Division Number. . . . . . .APDIVISION Mask:00 16 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO 17 ARDivisionNo. . . . . . . . . 2 SYN AR Division Number. . . . . . .ARDIVISION Mask:00 18 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO 19 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00- 20 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00-