UPDATE VS4TInventory Set TInvApproveNote=TInvTBraCode WHERE TInvTIntAlias in 
('REPACK', 'PURCHASERETURNBACK', 'RECEIVEFGBUILT' , 'RECEIVEFGBUILTNOMRP',
'RECEIVEFGBUILTOUT','RECEIVEFGBUILTOUTNOPO','SENDREPAIRRETURN',
'BORROW','BORROWBACK','BUILT','BUILTOUT','CHANGESTATUS',
'RECEIVEBORROW', 'PURCHASERETURN', 'SENDCONSIGN', 'SENDCONSIGNRETURN',
'RETURNBUILT','RETURNBUILTOUT','SENDREPAIR','TRANSFER')
GO
UPDATE VS4TInventory Set TInvTBraCode=TInvFromTBraCode WHERE TInvTIntAlias in 
('REPACK', 'PURCHASERETURNBACK', 'RECEIVEFGBUILT' , 'RECEIVEFGBUILTNOMRP',
'RECEIVEFGBUILTOUT','RECEIVEFGBUILTOUTNOPO','SENDREPAIRRETURN',
'BORROW','BORROWBACK','BUILT','BUILTOUT','CHANGESTATUS',
'RECEIVEBORROW', 'PURCHASERETURN', 'SENDCONSIGN', 'SENDCONSIGNRETURN',
'RETURNBUILT','RETURNBUILTOUT','SENDREPAIR','TRANSFER')
GO
UPDATE VS4TInventory Set TInvFromTBraCode=TInvApproveNote WHERE TInvTIntAlias in 
('REPACK', 'PURCHASERETURNBACK', 'RECEIVEFGBUILT' , 'RECEIVEFGBUILTNOMRP',
'RECEIVEFGBUILTOUT','RECEIVEFGBUILTOUTNOPO','SENDREPAIRRETURN',
'BORROW','BORROWBACK','BUILT','BUILTOUT','CHANGESTATUS',
'RECEIVEBORROW', 'PURCHASERETURN', 'SENDCONSIGN', 'SENDCONSIGNRETURN',
'RETURNBUILT','RETURNBUILTOUT','SENDREPAIR','TRANSFER')
GO
