     IM_InventoryLabelsWrk                 IM Inventory Labels Work        Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: IM_InventoryLabelPrinting_rpt
     SQL Def: Y  SysDB: N                          "MAS_"+%C$+"/IM"+%C$+"/IM_InventoryLabelsWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  GroupField. . . . . . . . . .    30 SNN  Group Field . . . . . . . . . .
       3  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
       4  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
       5  LabelNumber . . . . . . . . .    14 SNN  Label Number. . . . . . . . . .
       6  CalculateCommission . . . . .     1 SNN  Calculate Commission. . . . . .
       7  PriceCode . . . . . . . . . .     4 SNN  Price Code. . . . . . . . . . .
       8  PriceCodeDesc . . . . . . . .    25 SNN  Price Code Description. . . . .
       9  AllowTradeDiscount. . . . . .     1 SNN  Allow Trade Discount. . . . . .
      10  SalesUnitOfMeasure. . . . . .     4 SNN  Sales Unit Of Measure . . . . .
      11  PurchaseUnitOfMeasure . . . .     4 SNN  Purchase Unit Of Measure. . . .
      12  StandardUnitOfMeasure . . . .     4 SNN  Standard Unit Of Measure. . . .
      13  TaxClass. . . . . . . . . . .     2 SNN  Tax Class . . . . . . . . . . .
      14  PurchasesTaxClass . . . . . .     2 SNN  Purchases Tax Class . . . . . .
      15  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .
      16  ProductLineDesc . . . . . . .    25 SNN  Product Line Description. . . .
      17  ProductType . . . . . . . . .     1 SNN  Product Type. . . . . . . . . .
      18  Valuation . . . . . . . . . .     1 SNN  Valuation . . . . . . . . . . .
      19  AllowBackOrders . . . . . . .     1 SNN  Allow Back Orders . . . . . . .
      20  DefaultWarehouseCode. . . . .     3 SNN  Default Warehouse Code. . . . .
      21  DefaultWarehouseDesc. . . . .    30 SNN  Default Warehouse Description .
      22  PrimaryAPDivisionNo . . . . .     2 SNN  Primary AP Division Number. . .
      23  PrimaryVendorNo . . . . . . .     7 SNN  Primary Vendor Number . . . . .
      24  PrimaryVendorName . . . . . .    30 SNN  Primary Vendor Name . . . . . .
      25  PrimaryVendorAliasItemNo. . .    30 SNN  Primary Vendor Alias Item Numbe
      26  NextAPDivisionNo. . . . . . .     2 SNN  Next AP Division Number . . . .
      27  NextVendorNo. . . . . . . . .     7 SNN  Next Vendor Number. . . . . . .
      28  NextVendorName. . . . . . . .    30 SNN  Next Vendor Name. . . . . . . .
      29  NextVendorAliasItemNo . . . .    30 SNN  Next Vendor Alias Item Number .
      30  LastSoldDate. . . . . . . . .     8 SNN  Last Sold Date. . . . . . . . .DATE
      31  LastReceiptDate . . . . . . .     8 SNN  Last Receipt Date . . . . . . .DATE
      32  Category1Desc . . . . . . . .    15 SNN  Category 1 Description. . . . .
      33  Category1 . . . . . . . . . .    10 SNN  Category 1. . . . . . . . . . .
      34  Category2Desc . . . . . . . .    15 SNN  Category 2 Description. . . . .
      35  Category2 . . . . . . . . . .    10 SNN  Category 2. . . . . . . . . . .
      36  Category3Desc . . . . . . . .    15 SNN  Category 3 Description. . . . .
      37  Category3 . . . . . . . . . .    10 SNN  Category 3. . . . . . . . . . .
      38  Category4Desc . . . . . . . .    15 SNN  Category 4 Description. . . . .
      39  Category4 . . . . . . . . . .    10 SNN  Category 4. . . . . . . . . . .
      40  SalesPromotionCode. . . . . .    10 SNN  Sales Promotion Code. . . . . .
      41  SaleStartingDate. . . . . . .     8 SNN  Sale Starting Date. . . . . . .DATE
      42  SaleEndingDate. . . . . . . .     8 SNN  Sale Ending Date. . . . . . . .DATE
      43  SaleMethod. . . . . . . . . .     1 SNN  Sale Method . . . . . . . . . .
      44  ShipWeight. . . . . . . . . .    10 SNN  Ship Weight . . . . . . . . . .
      45  NextLotSerialNo . . . . . . .    15 SNN  Next Lot Serial Number. . . . .
      46  InventoryCycle. . . . . . . .     1 SNN  Inventory Cycle . . . . . . . .
      47  RoutingNo . . . . . . . . . .    20 SNN  Routing Number. . . . . . . . .
      48  ProcurementType . . . . . . .     1 SNN  Procurement Type. . . . . . . .
      49  ReorderWarehouseCode. . . . .     3 SNN  Reorder Warehouse Code. . . . .
      50  ReorderWarehouseDesc. . . . .    30 SNN  Reorder Warehouse Description .
      51  BinLocation . . . . . . . . .    10 SNN  Bin Location. . . . . . . . . .
      52  ReorderMethod . . . . . . . .     1 SNN  Reorder Method. . . . . . . . .
      53  LotSerialNo . . . . . . . . .    15 SNN  Lot Serial Number - Auto Only .
      54  StandardUnitCost. . . . . . . 16.6  NNN  Standard Unit Cost. . . . . . .
      55  StandardUnitPrice . . . . . . 16.6  NNN  Standard Unit Price . . . . . .
      56  LastTotalUnitCost . . . . . . 16.6  NNN  Last Total Unit Cost. . . . . .
      57  AverageUnitCost . . . . . . . 16.6  NNN  Average Unit Cost . . . . . . .
      58  SalesPromotionPrice . . . . . 16.6  NNN  Sales Promotion Price . . . . .
      59  SuggestedRetailPrice. . . . . 16.6  NNN  Suggested Retail Price. . . . .
      60  SalesPromotionDiscountPercent 12.3  NNN  Sales Promotion Discount Percen
      61  CommissionRate. . . . . . . .  9.3  NNN  Commission Rate . . . . . . . .
      62  BaseCommAmt . . . . . . . . . 12.2  NNN  Base Commission Amount. . . . .
      63  PurchaseUMConvFctr. . . . . . 12.4  NNN  Purchase Unit of Measure Conver
      64  SalesUMConvFctr . . . . . . . 12.4  NNN  Sales Unit of Measure Conversio
      65  Volume. . . . . . . . . . . . 11.4  NNN  Volume. . . . . . . . . . . . .
      66  PrimaryVendorStandardLeadTime  6.0  NNN  Primary Vendor Standard Lead Ti
      67  NextVendorStandardLeadTime. .  6.0  NNN  Next Vendor Standard Lead Time.
      68  EconomicOrderQty. . . . . . . 16.6  NNN  Economic Order Quantity . . . .
      69  ReorderPointQty . . . . . . . 16.6  NNN  Reorder Point Quantity. . . . .
      70  MinimumOrderQty . . . . . . . 16.6  NNN  Minimum Order Quantity. . . . .
      71  MaximumOnHandQty. . . . . . . 16.6  NNN  Maximum On Hand Quantity. . . .
      72  ReceivedQty . . . . . . . . . 16.6  NNN  Received Quantity . . . . . . .