Use ATNDBTest
Go

Update 
	FactorCashSettlementCheckBridge
Set
	CashGetPayAmount = CashGetPay.Amount
From 
	dbo.CashGetPay Inner Join 
	dbo.FactorCashSettlementCheckBridge On dbo.CashGetPay.Serial = dbo.FactorCashSettlementCheckBridge.CashGetPayRef 
Go
--------------------------------------------------------------------------------------------------------------------
Update 
	FactorCashSettlementCheckBridge
Set
	SettlementGetPayAmount = CashGetPay.Amount
From 
	dbo.CashGetPay Inner Join 
	dbo.FactorCashSettlementCheckBridge On dbo.CashGetPay.Serial = dbo.FactorCashSettlementCheckBridge.SettlementGetPayRef 
Go
--------------------------------------------------------------------------------------------------------------------
Update 
	FactorCashSettlementCheckBridge
Set
	CheckGetPayAmount = CheckGetPayHeader.Totality
From 
	dbo.CheckGetPayHeader Inner Join 
	dbo.FactorCashSettlementCheckBridge On dbo.CheckGetPayHeader.Serial = dbo.FactorCashSettlementCheckBridge.CheckGetPayHeaderRef 
Go

	
	
	
	
	
	
	
