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