AR_DailyPostingWork AR Daily Posting Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: AR_SalesJournal_upd,AR_FinanceChargeJournal_upd,AR_CommissionEditRegister_upd,AR_CashReceiptsJ
SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_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-