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