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