AR_SummaryDrillDownWork AR Summary Drill Down Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_"+%C$+"/AR"+%C$+"/AR_SummaryDrillDownWork.M4T"
KPRIMARY: AccountKey+PostingDate+SourceJournal+RegisterNo+DocumentNo+SequenceNo
KPOSTINGDATE: PostingDate(d)+AccountKey+SourceJournal+RegisterNo+DocumentNo+SequenceNo
KREGISTERNO: RegisterNo+AccountKey+PostingDate+SourceJournal+DocumentNo+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 AccountKey. . . . . . . . . . 9 SYY Account Number. . . . . . . . .ACCOUNT
2 PostingDate . . . . . . . . . 8 SNY Posting Date. . . . . . . . . .DATE
3 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL
4 RegisterNo. . . . . . . . . . 6 SYY Register Number . . . . . . . .
5 DocumentNo. . . . . . . . . . 15 SNY Document Number . . . . . . . .
6 SequenceNo. . . . . . . . . . 14 SYY Sequence Number . . . . . . . .
7 SourceModule. . . . . . . . . 2 SYY Source Module . . . . . . . . .
8 DocumentType. . . . . . . . . 1 SYY Document Type . . . . . . . . .
9 ReceiptNo . . . . . . . . . . 7 SYY Receipt Number. . . . . . . . .
10 DocSequenceNo . . . . . . . . 14 SYY Document Sequence Number. . . .
11 AltDocType. . . . . . . . . . 1 SYY Alternate Document Type . . . .
12 APDivisionNo. . . . . . . . . 2 SYY AP Division Number. . . . . . .
13 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO
14 ARDivisionNo. . . . . . . . . 2 SYN AR Division Number. . . . . . .
15 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO
ChngTag:Replace1/ARDivisionNo
$