project QadFinancials > class BEmployee > business logic query EmployeeByEmployee


Parameters


iiCompanyIdintegerCompany id
iiEmployee_IDinteger
icEmployeeCodecharacter


query condition


  each Employee where
Employee.Company_Id = iiCompanyId AND
Employee.Employee_ID = iiEmployee_ID AND
Employee.EmployeeCode = icEmployeeCode


query resultset tqEmployeeByEmployee


field namedata typedb fielddescription
tiClaimPriceList_IDintegerEmployee.ObsoleteClaimPriceList_IDClaim Price List
tiCompany_IDintegerEmployee.Company_IDLink to Company
tiEmployee_IDintegerEmployee.Employee_IDRecord ID
tcEmployeeCodecharacterEmployee.EmployeeCodeEmployee Code. A code that identifies an employee. The code cannot match any other employee in the current entity or any other entities in the current domain.
If you leave the Employee Code field blank, the system automatically generates a number for the record based on the sequence defined in Employee Autonumber Create.
tlEmployeeIsExternallogicalEmployee.EmployeeIsExternalExternal Employee: Indicate if the employee is a contractor or not employed directly by your organization.
api annotation:PartialUpdate = yes - defaults to false
tlEmployeeIsTravelOverSalarylogicalEmployee.EmployeeIsTravelOverSalaryInclude Travel Hours/Overtime
api annotation:PartialUpdate = yes - defaults to false
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Employee)


Internal usage


QadFinancials
method BCompany.ValidateComponent