     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$