View: dbo.Payroll_Check_Payroll_Item_Distribution_Denormalized_View
View definition
CREATE VIEW dbo.Payroll_Check_Payroll_Item_Distribution_Denormalized_View
WITH SCHEMABINDING
AS
SELECT
pcpi.payroll_check_payroll_item_KEY
, pcpid.payroll_check_payroll_item_distribution_KEY
, pcpi.bank_transaction_KEY
, pcpi.client_payroll_item_KEY
, pcpi.vendor_KEY
, pcpid.payroll_department_KEY
, pcpid.work_location_KEY
, pcpid.amount
FROM
dbo.Payroll_Check_Payroll_Item AS pcpi
INNER JOIN dbo.Payroll_Check_Payroll_Item_Distribution AS pcpid
ON pcpi.payroll_check_payroll_item_KEY = pcpid.payroll_check_payroll_item_KEY
;