GL_SummaryDetailDrillDown GL Summary Detail Drill Down Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/GL"+%C$+"/GL_SummaryDetailDrillDown.M4T"
KPRIMARY: AccountKey+PostingDate+SourceJournal+RegisterNo+DocumentNo+SequenceNo KPOSTINGDATE: PostingDate(d)+AccountKey+SourceJournal+RegisterNo+DocumentNo+SequenceNo KVENDORNO: APDivisionNo+VendorNo+DocumentNo+PostingDate+SourceJournal+RegisterNo+AccountKey+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 AccountKey. . . . . . . . . . 9 SYY Account Number. . . . . . . . .ACCOUNT Notes: Validated against GL_Account 2 PostingDate . . . . . . . . . 8 SNY Posting Date. . . . . . . . . .DATE Notes: YYYYMMDD 3 SourceJournal . . . . . . . . 2 SYY Source Journal. . . . . . . . .SOURCEJOURNAL Notes: Validated against GL_SourceJournal 4 RegisterNo. . . . . . . . . . 6 SYY Register Number . . . . . . . . Mask:000000 FmtType:ZEROFILL 5 DocumentNo. . . . . . . . . . 15 SNY Document Number . . . . . . . . 6 SequenceNo. . . . . . . . . . 14 SYY Sequence Number . . . . . . . . Mask:00000000000000 FmtType:ZEROFILL 7 SourceModule. . . . . . . . . 2 SYY Source Module . . . . . . . . . 8 DocumentType. . . . . . . . . 1 SYY Document Type . . . . . . . . . Valid:I,C,R,S Notes: C=Check, I=Invoice, R=Receipt, S=Summary 9 ReceiptNo . . . . . . . . . . 7 SYY Receipt Number. . . . . . . . . 10 DocSequenceNo . . . . . . . . 14 SYY Document Sequence Number. . . . Mask:00000000000000 FmtType:ZEROFILL 11 AltDocType. . . . . . . . . . 1 SYY Alternate Document Type . . . . Valid:A,C,D,F,H,I,X,R Notes: A=Adjustment, C=Credit memo, D=Debit memo, F=Finance charge, H=casH, I=Invoice, X=deleted, R=Receipt 12 APDivisionNo. . . . . . . . . 2 SYY AP Division Number. . . . . . . 13 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO FmtType:MASTERNUM ChngTag:Rep lace1/APDivisionNo$ 14 ARDivisionNo. . . . . . . . . 2 SYN AR Division Number. . . . . . . 15 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$