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