View: dbo.Liability_Item_View
View definition
CREATE VIEW dbo.Liability_Item_View
AS
SELECT
vendor_KEY = V.vendor_KEY
, vendor_type_KEY = V.current__vendor_type_KEY
, client_payroll_item_KEY = CPI.client_payroll_item_KEY
, client_tax_item_KEY = null
, description = CPI.description
, fund_tax_agent_transaction = FUND.fund_tax_agent_transaction
, fund_payroll_agent_transaction = FUND.fund_payroll_agent_transaction
, item_type = PIT.description
FROM dbo.Client_Payroll_Item CPI
JOIN dbo.Vendor V ON CPI.vendor_KEY=V.vendor_KEY
JOIN dbo.Client_Payroll_Information FUND ON CPI.client_KEY=FUND.client_KEY
JOIN dbo.Payroll_Item_Type PIT ON CPI.payroll_item_type_KEY=PIT.payroll_item_type_KEY
UNION
SELECT
vendor_KEY = V.vendor_KEY
, vendor_type_KEY = V.current__vendor_type_KEY
, client_payroll_item_KEY = null
, client_tax_item_KEY = CTI.client_tax_item_KEY
, description = CTI.description
, fund_tax_agent_transaction = FUND.fund_tax_agent_transaction
, fund_payroll_agent_transaction = FUND.fund_payroll_agent_transaction
, item_type = CTIT.description
FROM dbo.Client_Tax_Item CTI
JOIN dbo.Vendor V ON CTI.vendor_KEY=V.vendor_KEY
JOIN dbo.Client_Payroll_Information FUND ON V.client_KEY=FUND.client_KEY
JOIN dbo.Client_Tax_Item_Type CTIT ON CTI.client_tax_item_type_KEY=CTIT.client_tax_item_type_KEY