     AP_VendorPurchasesHistory              AP Vendor Purchases History    Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: AP_VendorPurchasesHistory_bus,AP_ARClearingRegister_upd,AP_InvoiceRegister_upd,AP_ManualCheckR
     SQL Def: Y  SysDB: N                             "MAS_"+%C$+"/AP"+%C$+"/AP_VendorPurchasesHistory.M4T"

     KPRIMARY: APDivisionNo+VendorNo+FiscalYear+FiscalPeriod
     KALTERNATE: FiscalYear+FiscalPeriod+APDivisionNo+VendorNo
     KYEARPERIOD: FiscalYear(d**)+FiscalPeriod+APDivisionNo+VendorNo  **=Case Sensitive

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  APDivisionNo. . . . . . . . .     2 SNY  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00 FmtType:ZEROFILL
       2  VendorNo. . . . . . . . . . .     7 SYY  Vendor Number . . . . . . . . .VENDORNO
                                                    FmtType:MASTERNUM ChngTag:Rep
                                                    lace1/APDivisionNo$
       3  FiscalYear. . . . . . . . . .     4 SNY  Fiscal Year . . . . . . . . . .YEAR
                                                    Mask:0000
       4  FiscalPeriod. . . . . . . . .     2 SNY  Fiscal Period . . . . . . . . .FISCALPERIOD
                                                    Mask:00 FmtType:ZEROFILL
       5  Purchases . . . . . . . . . . 15.2  NNN  Purchases . . . . . . . . . . .
                                                    Mask:##,###,###,###.00-
                                                    ChngTag:Sum
       6  Payments. . . . . . . . . . . 15.2  NNN  Payments. . . . . . . . . . . .
                                                    Mask:##,###,###,###.00-
                                                    ChngTag:Sum
       7  DiscountsTaken. . . . . . . . 15.2  NNN  Discounts Taken . . . . . . . .
                                                    Mask:##,###,###,###.00-
                                                    ChngTag:Sum
       8  DiscountsLost . . . . . . . . 15.2  NNN  Discounts Lost. . . . . . . . .
                                                    Mask:##,###,###,###.00-
                                                    ChngTag:Sum
       9  DateUpdated . . . . . . . . .     8 SNN  Last Update Date. . . . . . . .DATE
                                                    Read Only:Y ChngTag:Max
                                                    Notes: YYYYMMDD
      10  TimeUpdated . . . . . . . . .     8 SNN  Last Update Time. . . . . . . .
                                                    Read Only:Y ChngTag:CopyMax/D
                                                    ateUpdated$
      11  UserUpdatedKey. . . . . . . .    10 SYN  Last Update User ID . . . . . .USER
                                                    Read Only:Y Mask:0000000000
                                                    FmtType:ZEROFILL ChngTag:Copy
                                                    Max/DateUpdated$