View: dbo.Online_Bill_Pay_Bank_Transaction_Full_View | |||
View definition | |||
-- adds a view that contains CREATE VIEW dbo.Online_Bill_Pay_Bank_Transaction_Full_View as SELECT bank_transaction_KEY = OBPBT.bank_transaction_KEY, client_KEY = Ch.client_KEY, checkbook__description = Ch.description, bank_transaction__description = BT.description, transaction_date = BT.transaction_date, amount = BT.amount, online_bill_pay_transmission_status_KEY = OBPBT.online_bill_pay_transmission_status_KEY, transaction_transmitted_date = OBPBT.transaction_transmitted_date FROM dbo.Online_Bill_Pay_Bank_Transaction as OBPBT JOIN dbo.Bank_Transaction as BT ON OBPBT.bank_transaction_KEY = BT.bank_transaction_KEY JOIN dbo.Checkbook as Ch ON BT.checkbook_KEY = Ch.checkbook_KEY | |||