     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