View: dbo.Bank_Transaction_Distribution_View
View definition
CREATE VIEW dbo.Bank_Transaction_Distribution_View
AS
SELECT
bank_transaction_distribution_KEY = BTD.bank_transaction_distribution_KEY
, bank_transaction_KEY = BTD.bank_transaction_KEY
, gl_account_KEY = BTD.gl_account_KEY
, gl_account_number = GLA.gl_account_number
, description = COALESCE(BTD.description, GLA.description, N'')
, amount = BTD.amount
, sequence_number = BTD.sequence_number
, first__w2_1099_box_type_KEY = BTD.first__w2_1099_box_type_KEY
, second__w2_1099_box_type_KEY = BTD.second__w2_1099_box_type_KEY
, w2_1099_type_KEY = W2_1099_Box_Type.w2_1099_type_KEY
FROM
dbo.Bank_Transaction_Distribution BTD
LEFT JOIN
dbo.GL_Account GLA ON BTD.gl_account_KEY = GLA.gl_account_KEY
LEFT JOIN
dbo.W2_1099_Box_Type
ON
BTD.first__w2_1099_box_type_KEY = W2_1099_Box_Type.w2_1099_box_type_KEY