UPDATE VS4TWAREHOUSE SET TWahGroup='BORROW' WHERE TWahCode='BORROW'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='CONSIGN' WHERE TWahCode='CONSIGN'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='CUSTOMER' WHERE TWahCode='CUSTOMER'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='INPROCESS' WHERE TWahCode='INPROCESS'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='LOAD' WHERE TWahCode='LOAD'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='OUTSOURCE' WHERE TWahCode='OUTSOURCE'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='PURCHASERETURN' WHERE TWahCode='PURCHASERETURN'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='SCRAP' WHERE TWahCode='SCRAP'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='SALERETURN' WHERE TWahCode='SALERETURN'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='SENDREPAIR' WHERE TWahCode='SENDREPAIR'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='STATIONERY' WHERE TWahCode='STATIONERY'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='SUPPLY' WHERE TWahCode='SUPPLY'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='TEMP' WHERE TWahCode='TEMP'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='VENDOR' WHERE TWahCode='VENDOR'
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='STOCK' WHERE TWahGroup is null
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='STOCK' WHERE TWahGroup <> ''
GO
UPDATE VS4TWAREHOUSE SET TWahGroup='STOCK' WHERE TwahCode<>'PURCHASERETURN' AND TwahCode<>'INPROCESS' AND TwahCode<>'OUTSOURCE' AND TwahCode<>'TEMP' AND TwahCode<>'CUSTOMER' AND TwahCode<>'BORROW' AND TwahCode<>'SALERETURN' AND TwahCode<>'LOAD' AND TwahCode<>'SCRAP'
GO
