PO_PurchasesHistory PO Purchases History Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: PO_ReceiptRegister_upd,PO_ReturnRegister_upd
SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_PurchasesHistory.M4T"
KPRIMARY: APDivisionNo+VendorNo+ItemCode+ItemType+ProductLine+WarehouseCode+DropShip+PostingDate+Receip
tDate
KADDITIONAL: DropShip+ItemCode+APDivisionNo+VendorNo+WarehouseCode+PostingDate+ReceiptDate
KITEMCODE: ItemCode+APDivisionNo+VendorNo+WarehouseCode+PostingDate+ItemType+ProductLine+DropShip+Recei
ptDate
KPURCHASENAME: VendorName+APDivisionNo+VendorNo+ItemCode+WarehouseCode(**)+PostingDate+ItemType+Product
Line+DropShip+ReceiptDate **=Case Sensitive
KWAREHOUSE: WarehouseCode+ItemCode+APDivisionNo+VendorNo+PostingDate+ItemType+ProductLine+DropShip+Rece
iptDate
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNN AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {POO$(22,2)}
2 VendorNo. . . . . . . . . . . 7 SYN Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/APDivisionNo$ Notes:
{POO$(24,7)}
3 ItemCode. . . . . . . . . . . 30 SYN Item Code . . . . . . . . . . .ITEMCODE
ChngTag:Replace0 Notes:
{POO$(1,15)}
4 ItemType. . . . . . . . . . . 1 SNN Item Type . . . . . . . . . . .
Valid:1,2,5 Notes: {POO$(21,
1)}1=Regular Item,
2=Special Item, 3=Charge
Item, 4=Comment Item,
5=Miscellaneous Item
5 ProductLine . . . . . . . . . 4 SNN Product Line. . . . . . . . . .PRODUCTLINE
6 WarehouseCode . . . . . . . . 3 SYN Warehouse Code. . . . . . . . .WAREHOUSE
FmtType:CHARNUM Notes:
{POO$(31,3)}
7 DropShip. . . . . . . . . . . 1 SYN Drop Ship . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
8 PostingDate . . . . . . . . . 8 SNN Posting Date. . . . . . . . . .DATE
9 ReceiptDate . . . . . . . . . 8 SNN Receipt Date. . . . . . . . . .DATE
10 PurchaseOrderDate . . . . . . 8 SNN Purchase Order Date . . . . . .DATE
11 ItemCodeDesc. . . . . . . . . 30 SNN Item Code Description . . . . .DESCRIPTION
Notes: {POO$(34,30)}
12 VendorName. . . . . . . . . . 30 SNN Vendor Name . . . . . . . . . .NAME
Notes: {POO$(64,30)}
13 QuantityPurchased . . . . . . 16.6 NNN Quantity Purchased. . . . . . .QUANTITY
Mask:##,###,###.000000-
ChngTag:Sum Notes: {POO[0]}
- PTD{POO[4]} - YTD{POO[8]}
- LYR{POO[12]} - Future
14 DollarsPurchased. . . . . . . 13.3 NNN Dollars Purchased . . . . . . .
Mask:#######0.000 ChngTag:Sum
Notes: {POO[1]} - PTD{POO[5
]} - YTD{POO[9]} -
LYR{POO[13]} - Future
15 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
16 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
17 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000