UPDATE VS4TPOServiceMB SET TPnMPrice=(SELECT TPOBPrice FROM VS4TPOMB WHERE VS4TPOServiceMB.TPnMTPDETPOBTPODNo=VS4TPOMB.TPOBTPODNo AND VS4TPOServiceMB.TPnMTPDETPOBLn=VS4TPOMB.TPOBLn)
GO
UPDATE VS4TPOServiceMB SET TPnMPerQuantity=(SELECT TPOBPerQuantity FROM VS4TPOMB WHERE VS4TPOServiceMB.TPnMTPDETPOBTPODNo=VS4TPOMB.TPOBTPODNo AND VS4TPOServiceMB.TPnMTPDETPOBLn=VS4TPOMB.TPOBLn)
GO
UPDATE VS4TPOServiceMB SET TPnMDiscountText=(SELECT TPOBDiscountText FROM VS4TPOMB WHERE VS4TPOServiceMB.TPnMTPDETPOBTPODNo=VS4TPOMB.TPOBTPODNo AND VS4TPOServiceMB.TPnMTPDETPOBLn=VS4TPOMB.TPOBLn)
GO
UPDATE VS4TPOServiceMB SET TPnMIsPremium=(SELECT TPOBIsPremium FROM VS4TPOMB WHERE VS4TPOServiceMB.TPnMTPDETPOBTPODNo=VS4TPOMB.TPOBTPODNo AND VS4TPOServiceMB.TPnMTPDETPOBLn=VS4TPOMB.TPOBLn)
GO
UPDATE VS4TPOServiceMB SET TPnMAmount=TPnMPrice/TPnMPerQuantity*TPnMQuantity
GO
UPDATE VS4TPOServiceMB SET TPnMDiscountTotal=TPnMAmount-TPnMNetAmount
GO
