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