project QadFinancials > class BEmployee > business logic query EmployeeByUser


Parameters


iiCompanyIdintegerCompany id
iiUsr_IDinteger
ilUsrIsActivelogical


query condition


  each Employee where
Employee.Company_Id = iiCompanyId AND
Employee.Usr_ID = iiUsr_ID

      first Usr (inner-join) where
Usr.Usr_ID = Employee.Usr_ID AND
Usr.UsrIsActive = ilUsrIsActive


query resultset tqEmployeeByUser


field namedata typedb fielddescription
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.
tiUsr_IDintegerUsr.Usr_IDRecord ID
tlUsrIsActivelogicalUsr.UsrIsActiveActive


Internal usage


QadFinancials
method BEmployee.APIGetDefaultEmployee