View: dbo.Vendor_Bank_Transaction_View | |||
View definition | |||
CREATE VIEW dbo.Vendor_Bank_Transaction_View AS SELECT bank_transaction_KEY = VT.bank_transaction_KEY , vendor_KEY = VT.vendor_KEY , CASE --Determine the payment type and return the corresponding key in Vendor_Payment_Method WHEN VT.bank_transaction_KEY IN (SELECT bank_transaction_KEY FROM dbo.Direct_Deposit_Bank_Transaction) THEN 2 --DirectDeposit WHEN VT.bank_transaction_KEY IN (SELECT bank_transaction_KEY FROM dbo.Eftps_Transaction) THEN 3 --EFTPS ELSE 1 --Check END AS vendor_payment_method_KEY , vendor_amortization_schedule_entry_KEY = VT.vendor_amortization_schedule_entry_KEY FROM dbo.Vendor_Bank_Transaction VT | |||