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