View: dbo.Bank_Feeds_Bank_Transaction_View
View definition
--This view surfaces the client key in the BankFeedsBankTransaction entity.
CREATE VIEW dbo.Bank_Feeds_Bank_Transaction_View
AS
SELECT
bank_feeds_bank_transaction_KEY = BFBT.bank_feeds_bank_transaction_KEY
, bank_transaction_KEY = BFBT.bank_transaction_KEY
, transaction_id = BFBT.transaction_id
--client_KEY will never be NULL. This is meant for the toolchain to restore the cannot-be-NULL-ness of this column on the entity.
, client_KEY = ISNULL(CB.client_KEY,0)
FROM
dbo.Bank_Feeds_Bank_Transaction AS BFBT
INNER JOIN dbo.Bank_Transaction AS BT ON BT.bank_transaction_KEY = BFBT.bank_transaction_KEY
INNER JOIN dbo.Checkbook AS CB ON CB.checkbook_KEY = BT.checkbook_KEY
;