IM_ReorderReportWrk                   IM Reorder Report Work          Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: IM_ReorderReport_rpt
 SQL Def: Y  SysDB: N                            "MAS_"+%C$+"/IM"+%C$+"/IM_ReorderReportWrk"+%S$+".M4T"

 KPRIMARY: SortField

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  SortField . . . . . . . . . .   127 SYY  Sort Field. . . . . . . . . . .
   2  GroupField. . . . . . . . . .    30 SNN  Group Field . . . . . . . . . .
   3  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
   4  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
   5  PurchaseUnitOfMeasure . . . .     4 SNN  Purchase Unit Of Measure. . . .
   6  StandardUnitOfMeasure . . . .     4 SNN  Standard Unit Of Measure. . . .
   7  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .
   8  ProductLineDesc . . . . . . .    25 SNN  Product Line Description. . . .
   9  ProductType . . . . . . . . .     1 SNN  Product Type. . . . . . . . . .
  10  PrimaryAPDivisionNo . . . . .     2 SNN  Primary AP Division Number. . .
  11  PrimaryVendorNo . . . . . . .     7 SNN  Primary Vendor Number . . . . .
  12  PrimaryVendorName . . . . . .    30 SNN  Primary Vendor Name . . . . . .
  13  LastReceiptDate . . . . . . .     8 SNN  Last Receipt Date . . . . . . .DATE
  14  Category1Desc . . . . . . . .    15 SNN  Category 1 Description. . . . .
  15  Category1 . . . . . . . . . .    10 SNN  Category 1. . . . . . . . . . .
  16  Category2Desc . . . . . . . .    15 SNN  Category 2 Description. . . . .
  17  Category2 . . . . . . . . . .    10 SNN  Category 2. . . . . . . . . . .
  18  Category3Desc . . . . . . . .    15 SNN  Category 3 Description. . . . .
  19  Category3 . . . . . . . . . .    10 SNN  Category 3. . . . . . . . . . .
  20  Category4Desc . . . . . . . .    15 SNN  Category 4 Description. . . . .
  21  Category4 . . . . . . . . . .    10 SNN  Category 4. . . . . . . . . . .
  22  InventoryCycle. . . . . . . .     1 SNN  Inventory Cycle . . . . . . . .
  23  VendorAliasItemNo . . . . . .    30 SNN  Vendor Alias Item Number. . . .
  24  WarehouseCode . . . . . . . .     3 SNN  Warehouse Code. . . . . . . . .
  25  WarehouseDesc . . . . . . . .    30 SNN  Warehouse Description . . . . .
  26  BinLocation . . . . . . . . .    10 SNN  Bin Location. . . . . . . . . .
  27  ReorderMethod . . . . . . . .     1 SNN  Reorder Method. . . . . . . . .
  28  LastTotalUnitCost . . . . . . 16.6  NNN  Last Total Unit Cost. . . . . .
                                                Mask:########.000000-
  29  PurchaseUMConvFctr. . . . . . 12.4  NNN  Purchase Unit of Measure Conver
  30  SalesUMConvFctr . . . . . . . 12.4  NNN  Sales Unit of Measure Conversio
  31  EconomicOrderQty. . . . . . . 16.6  NNN  Economic Order Quantity . . . .
                                                Mask:########.000000-
  32  ReorderPointQty . . . . . . . 16.6  NNN  Reorder Point Quantity. . . . .
                                                Mask:########.000000-
  33  MinimumOrderQty . . . . . . . 16.6  NNN  Minimum Order Quantity. . . . .
                                                Mask:########.000000-
  34  MaximumOnHandQty. . . . . . . 16.6  NNN  Maximum On Hand Quantity. . . .
  35  QuantityOnHand. . . . . . . . 16.6  NNN  Quantity On Hand. . . . . . . .
                                                Mask:########.000000-
  36  QuantityOnPurchaseOrder . . . 16.6  NNN  Quantity On Purchase Order. . .
  37  QuantityOnSalesOrder. . . . . 16.6  NNN  QuantityOnSalesOrder. . . . . .
  38  QuantityOnBackOrder . . . . . 16.6  NNN  Quantity On Back Order. . . . .
                                                Mask:########.000000-
  39  QuantityOnWorkOrder . . . . . 16.6  NNN  Quantity On Work Order. . . . .
  40  QuantityRequiredForWO . . . . 16.6  NNN  Quantity Required For Work Orde
                                                Mask:########.000000-
  41  QuantitySoldPTD . . . . . . . 16.6  NNN  Quantity Sold Period To Date. .
                                                Mask:########.000000-
  42  QuantitySoldYTD . . . . . . . 16.6  NNN  Quantity Sold Year To Date. . .
                                                Mask:########.000000-
  43  QuantitySoldPY. . . . . . . . 16.6  NNN  Quantity Sold Prior Year. . . .
                                                Mask:########.000000-