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 ; | |||