     IM_NegativeTierRegisterWork           IM Negative Tier Register Work  Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: IM_NegativeTierRegister_upd
     SQL Def: Y  SysDB: N                           "MAS_"+%C$+"/IM"+%C$+"/IM_NegativeTierRegisterWork.M4T"

     KPRIMARY: ItemCode+WarehouseCode+TierType+GroupSort+GroupSortAdjusted

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  ProductLine . . . . . . . . .     4 SNN  Product Line. . . . . . . . . .
       2  ProductLineDesc . . . . . . .    25 SNN  Product Line Description. . . .
       3  ItemCode. . . . . . . . . . .    30 SNN  Item Code . . . . . . . . . . .
       4  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .
       5  StandardUnitOfMeasure . . . .     4 SNN  Standard Unit Of Measure. . . .
       6  WarehouseCode . . . . . . . .     3 SNN  Warehouse Code. . . . . . . . .
       7  TierType. . . . . . . . . . .     1 SNN  Tier Type . . . . . . . . . . .
       8  GroupSort . . . . . . . . . .    16 SNN  Group Sort. . . . . . . . . . .
       9  ReceiptDate . . . . . . . . .     8 SNN  Receipt Date. . . . . . . . . .DATE
      10  ReceiptNo . . . . . . . . . .     8 SNN  Receipt Number. . . . . . . . .
      11  LotSerialNo . . . . . . . . .    15 SNN  Lot Serial Number . . . . . . .
      12  GroupSortAdjusted . . . . . .    16 SNN  Group Sort Adjusted . . . . . .
      13  ReceiptDateAdjusted . . . . .     8 SNN  Receipt Date Adjusted . . . . .DATE
      14  ReceiptNoAdjusted . . . . . .     8 SNN  Receipt Number. . . . . . . . .
      15  LotSerialNoAdjusted . . . . .    15 SNN  Lot Serial Number Adjusted. . .
      16  AdjustedTierFuturePeriod. . .     1 SNN  Adjusted Tier in a Future Perio
      17  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .
      18  QuantityOnHand. . . . . . . . 16.6  NNN  Quantity On Hand. . . . . . . .
      19  AllocatedCost . . . . . . . . 13.2  NNN  Allocated Cost. . . . . . . . .
      20  UnitCostAdjusted. . . . . . . 16.6  NNN  Unit Cost Adjusted. . . . . . .
      21  QuantityOnHandAdjusted. . . . 16.6  NNN  Quantity On Hand Adjusted . . .
      22  AllocatedCostAdjusted . . . . 13.2  NNN  Allocated Cost Adjusted . . . .
      23  AdjustmentAmt . . . . . . . . 13.2  NNN  Adjustment Amount . . . . . . .