project QadFinancials > class BEmployee > business logic query EmployeeLinkedToCreditorByUser


Parameters


iiCompanyIdintegerCompany id
iiUsr_IDinteger
ilEmployeeIsExternallogical
ilEmployeeIsActiveExpNotelogical
ilEmployeeIsActivelogical
icEmployeeCodecharacter


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 namedata typedb fielddescription
tiCreditor_IDintegerEmployee.Creditor_IDSupplier Code
tiCurrency_IDintegerEmployee.Currency_IDRegistration Currency
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
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.
tlEmployeeIsActivelogicalEmployee.EmployeeIsActiveActive: This field indicates if this is an active record.
api annotation:PartialUpdate = yes - defaults to true
tlEmployeeIsActiveExpNoteslogicalEmployee.EmployeeIsActiveExpNotesObsolete field
tlEmployeeIsExternallogicalEmployee.EmployeeIsExternalExternal Employee: Indicate if the employee is a contractor or not employed directly by your organization.
api annotation:PartialUpdate = yes - defaults to false
tiUsr_IDintegerEmployee.Usr_IDLogin
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Employee),rowid(Creditor),rowid(Currency),rowid(Usr)


Internal usage


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