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