     PO_AutoReorderSelection                PO Auto Reorder Selection      Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: N/A
     SQL Def: N  SysDB: N                               "MAS_"+%C$+"/PO"+%C$+"/PO_AutoReorderSelection.M4T"

     KPRIMARY: APDivisionNo+VendorNo+ItemCode+WarehouseCode
     KEXTENDEDDESC: ExtendedDescriptionKey+APDivisionNo+VendorNo+ItemCode+WarehouseCode

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  APDivisionNo. . . . . . . . .     2 SNY  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00 FmtType:ZEROFILL
                                                    Notes: {PO8$(1,2)}
       2  VendorNo. . . . . . . . . . .     7 SYY  Vendor Number . . . . . . . . .VENDORNO
                                                    FmtType:MASTERNUM ChngTag:Rep
                                                    lace1/APDivisionNo$ Notes:
                                                    {PO8$(3,7)}
       3  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                    Notes: {PO8$(10,15)}
       4  ExtendedDescriptionKey. . . .    10 SNY  Extended Description Key. . . .EXTDESCKEY
                                                    Read Only:Y
       5  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM Notes:
                                                    {PO8$(30,3)}
       6  ItemType. . . . . . . . . . .     1 SNY  Item Type . . . . . . . . . . .
                                                    Valid:1,2,3,4,5 Notes:
                                                    1=Inventory Item, 2=Special
                                                    Item, 3=Charge Item,
                                                    4=Comment Item, 5=Miscellaneo
                                                    us Item
       7  ReorderMethod . . . . . . . .     1 SYN  Reorder Method. . . . . . . . .
                                                    Notes: {PO8$(53,1)}
       8  VendorAliasItemNo . . . . . .    30 SNN  Vendor Alias Item Number. . . .
                                                    Notes: {PO8$(54,30)}
       9  QuantityOnHand. . . . . . . . 16.6  NNN  Quantity On Hand. . . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[0]}
      10  QuantityOnPurchaseOrder . . . 16.6  NNN  Quantity On Purchase Order. . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[1]}
      11  QuantityOnSalesOrder. . . . . 16.6  NNN  Quantity On Sales Order . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[2]}
      12  QuantityOnBackOrder . . . . . 16.6  NNN  Quantity On Back Order. . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[3]}
      13  QuantityOnWorkOrder . . . . . 16.6  NNN  Quantity On Work Order. . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[14]}
      14  QuantityRequiredForWO . . . . 16.6  NNN  Quantity Required for Work OrdeQUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[15]}
      15  ReorderPointQty . . . . . . . 16.6  NNN  Reorder Point Quantity. . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[4]}
      16  MinimumOrderQty . . . . . . . 16.6  NNN  Minimum Order Quantity. . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[5]}
      17  EconomicOrderQty. . . . . . . 16.6  NNN  Economic Order Quantity . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[6]}
      18  MaximumOnHandQty. . . . . . . 16.6  NNN  Maximum On Hand Quantity. . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[7]}
      19  RecommendedOrderQty . . . . . 16.6  NNN  Recommended Order Quantity. . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[8]}
      20  QuantitySoldPTD . . . . . . . 16.6  NNN  Quantity Sold Period To Date. .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[9]}
      21  QuantitySoldYTD . . . . . . . 16.6  NNN  Quantity Sold Year To Date. . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[10]}
      22  QuantitySoldPY. . . . . . . . 16.6  NNN  Quantity Sold Prior Year. . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[11]}
      23  QuantitySoldNP. . . . . . . . 16.6  NNN  Quantity Sold Next Period . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[13]}
      24  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                    Mask:##,###,###.000000-
                                                    Notes: {PO8[12]}
      25  DateCreated . . . . . . . . .     8 SNY  Creation Date . . . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      26  TimeCreated . . . . . . . . .     8 SNY  Creation Time . . . . . . . . .
                                                    Read Only:Y
      27  UserCreatedKey. . . . . . . .    10 SYY  Creation User ID. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000