View: dbo.Payroll_Check_Tax_Item_Distribution_Denormalized_View | |||
View definition | |||
CREATE VIEW dbo.Payroll_Check_Tax_Item_Distribution_Denormalized_View WITH SCHEMABINDING AS SELECT pcti.payroll_check_tax_item_KEY , pctid.payroll_check_tax_item_distribution_KEY , pcti.bank_transaction_KEY , pcti.client_tax_item_KEY , pcti.vendor_KEY , pctid.payroll_department_KEY , pctid.work_location_KEY , pctid.amount FROM dbo.Payroll_Check_Tax_Item AS pcti INNER JOIN dbo.Payroll_Check_Tax_Item_Distribution AS pctid ON pcti.payroll_check_tax_item_KEY = pctid.payroll_check_tax_item_KEY ; | |||