PO_AutomaticReorderSelectWrk        PO Automatic Reorder Selection WorRel: 4.40  Bld: 398  8/28/2009
 Bus Obj: N/A
 SQL Def: Y  SysDB: N                   "MAS_"+%C$+"/PO"+%C$+"/PO_AutomaticReorderSelectWrk"+%S$+".M4T"

 KPRIMARY: SortField

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
   2  APDivisionNo. . . . . . . . .     2 SNN  AP Division Number. . . . . . .
   3  APDivisionDesc. . . . . . . .    30 SNN  AP Division Description . . . .
   4  VendorNo. . . . . . . . . . .     7 SNN  Vendor Number . . . . . . . . .
   5  VendorName. . . . . . . . . .    30 SNN  Vendor Name . . . . . . . . . .
   6  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
   7  ExtendedDescriptionKey. . . .    10 SNN  Extended Description Key. . . .
   8  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
   9  WarehouseCode . . . . . . . .     3 SNN  Warehouse Code. . . . . . . . .
  10  ReorderMethod . . . . . . . .     1 SNN  Reorder Method. . . . . . . . .
  11  VendorAliasItemNo . . . . . .    30 SNN  Vendor Alias Item Number. . . .
  12  PurchaseUnitOfMeasure . . . .     4 SNN  Purchase Unit Of Measure. . . .
  13  StandardUnitOfMeasure . . . .     5 SNN  Standard Unit Of Measure. . . .
  14  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .
  15  ProductType . . . . . . . . .     1 SNN  Product Type. . . . . . . . . .
  16  LastReceiptDate . . . . . . .     8 SNN  Last Receipt Date . . . . . . .DATE
  17  LastTotalUnitCost . . . . . . 16.6  NNN  Last Total Unit Cost. . . . . .
  18  EconomicOrderQty. . . . . . . 16.6  NNN  Economic Order Quantity . . . .
  19  ReorderPointQty . . . . . . . 16.6  NNN  Reorder Point Quantity. . . . .
  20  MinimumOrderQty . . . . . . . 16.6  NNN  Minimum Order Quantity. . . . .
  21  MaximumOnHandQty. . . . . . . 16.6  NNN  Maximum On Hand Quantity. . . .
  22  QuantityOnHand. . . . . . . . 16.6  NNN  Quantity On Hand. . . . . . . .
  23  QuantityOnPurchaseOrder . . . 16.6  NNN  Quantity On Purchase Order. . .
  24  QuantityOnSalesOrder. . . . . 16.6  NNN  Quantity On Sales Order . . . .
  25  QuantityOnBackOrder . . . . . 16.6  NNN  Quantity On Back Order. . . . .
  26  QuantityOnWorkOrder . . . . . 16.6  NNN  Quantity On Work Order. . . . .
  27  QuantityRequiredForWO . . . . 16.6  NNN  Quantity Required for Work Orde
  28  QuantitySoldPTD . . . . . . . 16.6  NNN  Quantity Sold Period To Date. .
  29  QuantitySoldYTD . . . . . . . 16.6  NNN  Quantity Sold Year To Date. . .
  30  QuantitySoldPY. . . . . . . . 16.6  NNN  Quantity Sold Prior Year. . . .
  31  PurchaseQty . . . . . . . . . 16.6  NNN  Purchase Quantity . . . . . . .
  32  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .