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$