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 . . . . . . .