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$