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$