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
;