business logic query EmployeeLinkedToCreditorByUser

Parameters

iiCompanyId	integer	Company id
iiUsr_ID	integer
ilEmployeeIsExternal	logical
ilEmployeeIsActiveExpNote	logical
ilEmployeeIsActive	logical
icEmployeeCode	character

query condition

each Employee where

Employee.Company_Id = iiCompanyId AND
Employee.EmployeeIsActive = ilEmployeeIsActive AND
Employee.EmployeeIsExternal = ilEmployeeIsExternal AND
Employee.EmployeeIsActiveExpNotes = ilEmployeeIsActiveExpNote AND
Employee.EmployeeCode = icEmployeeCode AND
Employee.Usr_ID = iiUsr_ID

first Creditor (inner-join) where

Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = Employee.Creditor_ID AND

first Currency (outer-join) where

Currency.Currency_ID = Employee.Currency_ID AND

first Usr (inner-join) where

Usr.Usr_ID = iiUsr_ID

query resultset tqEmployeeLinkedToCreditorByUser

field name	data type	db field	description
tiCreditor_ID	integer	Employee.Creditor_ID	Supplier Code
tiCurrency_ID	integer	Employee.Currency_ID	Registration Currency
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tiEmployee_ID	integer	Employee.Employee_ID	Record ID
tcEmployeeCode	character	Employee.EmployeeCode	Employee 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.
tlEmployeeIsActive	logical	Employee.EmployeeIsActive	Active: This field indicates if this is an active record.
	api annotation:		PartialUpdate = yes - defaults to true
tlEmployeeIsActiveExpNotes	logical	Employee.EmployeeIsActiveExpNotes	Obsolete field
tlEmployeeIsExternal	logical	Employee.EmployeeIsExternal	External Employee: Indicate if the employee is a contractor or not employed directly by your organization.
	api annotation:		PartialUpdate = yes - defaults to false
tiUsr_ID	integer	Employee.Usr_ID	Login
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Employee),rowid(Creditor),rowid(Currency),rowid(Usr)

Internal usage

QadFinancials

method BEmployee.APIGetDefaultEmployeeForExpNote
method BExpenseNote.RefreshAdvances
method BExpenseNote.ValidateComponent