View: dbo.Payroll_Transaction_Employee_Reporting_Type_View | |||
View definition | |||
-- This view is used to link the employee’s reporting types to the payroll transaction and -- will be used in the system for Employee Reporting Type Filter in Payroll Datasource create view [dbo].[Payroll_Transaction_Employee_Reporting_Type_View] as select bank_transaction_KEY = PBT.bank_transaction_KEY , employee_reporting_type_KEY = EERT.employee_reporting_type_KEY from dbo.Payroll_Bank_Transaction PBT inner join dbo.Employee_N_Employee_Reporting_Type_View EERT on PBT.employee_KEY = EERT.employee_KEY | |||