ALTER TABLE VS4TInventoryLOTP ADD
	TIMCInputTCurCode nvarchar(5) NULL,
	TIMCInputCostRate float(53) NULL,
	TIMCAdjustCost money NULL
GO
UPDATE VS4TInventoryLOTP SET TIMCInputTCurCode='THB' where TIMCInputTCurCode is null
GO
UPDATE VS4TInventoryLOTP SET TIMCInputCostRate=1 where TIMCInputCostRate is null
GO
UPDATE VS4TInventoryLOTP SET TIMCAdjustCost=0 where TIMCAdjustCost is null
GO
UPDATE VS4TInventoryLOTP SET TIMCLastUnitCost=TIMCUnitCost+TIMCAdjustCost where TIMCLastUnitCost is null
GO
