CI_StandardCostAdjustmentWork CI Standard Cost Adjustment RegisterRel: 4.40 Bld: 398 8/28/2009 Bus Obj: IM_StandardCostAdjustReg_upd SQL Def: Y SysDB: N "MAS_"+%C$+"/CI"+%C$+"/CI_StandardCostAdjustmentWork.M4T"
KPRIMARY: Source+RegisterNo+ItemCode+WarehouseCode+TransactionDate KPRODUCTLINE: Source+RegisterNo+ProductLine(l**)+WarehouseCode+ItemCode+TransactionDate **=Case Sensit ive
Fld Column Name M/L TUR Description/Notes Class
1 Source. . . . . . . . . . . . 2 SYY Source. . . . . . . . . . . . . Valid:BC,WC,IC 2 RegisterNo. . . . . . . . . . 6 SNN Register Number . . . . . . . . 3 ItemCode. . . . . . . . . . . 30 SYY Item Code . . . . . . . . . . .ITEMCODE 4 WarehouseCode . . . . . . . . 3 SYY Warehouse Code. . . . . . . . .WAREHOUSE 5 TransactionDate . . . . . . . 8 SNN Transaction Date. . . . . . . .DATE 6 ProductLine . . . . . . . . . 4 SYN Product Line. . . . . . . . . .PRODUCTLINE 7 InventoryAcctKey. . . . . . . 9 SNN Inventory Account Key . . . . .ACCOUNT 8 AdjustmentAcctKey . . . . . . 9 SNN Adjustment Account Key. . . . .ACCOUNT 9 QuantityAdjusted. . . . . . . 16.6 NNN Quantity Adjusted . . . . . . .QUANTITY Mask:##,###,###.000000- 10 NewUnitCost . . . . . . . . . 16.6 NNN New Unit Cost . . . . . . . . .COST Mask:##,###,###.000000- 11 OldUnitCost . . . . . . . . . 16.6 NNN Old Unit Cost . . . . . . . . .COST Mask:##,###,###.000000- 12 AdjustmentAmt . . . . . . . . 12.2 NNN Adjustment Amount . . . . . . .COST Mask:##,###,###.000000- 13 DateCreated . . . . . . . . . 8 SNN Date Created. . . . . . . . . .DATE 14 TimeCreated . . . . . . . . . 8 SNN Time Created. . . . . . . . . . 15 UserCreatedKey. . . . . . . . 10 SNN User Created Key. . . . . . . .USER Mask:0000000000