PO_DailyPostingWork PO Daily Posting Work Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: PO_ReceiptRegister_upd,PO_ReturnRegister_upd,PO_MaterialReqIssueRegister_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_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 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 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 ChngTag:Replace1/ARDivisionNo $ 19 DebitAmount . . . . . . . . . 16.2 NNY Debit Amount. . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00- 20 CreditAmount. . . . . . . . . 16.2 NNY Credit Amount . . . . . . . . .TRANSACTIONAMT Mask:###,###,###.00-