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