project QadFinancials > class BEmployee > business logic query EmployeeForExcelInteg


Parameters


iiCompanyIdintegerCompany id


query condition


  each Employee where
Employee.Company_Id = iiCompanyId AND


query resultset tqEmployeeForExcelInteg


field namedata typedb fielddescription
tiActivityCode_IDintegerEmployee.ActivityCode_IDActivity Code
tiActivityCostPriceList_IDintegerEmployee.ObsoleteActCstPriceList_IDActual Costing Price List
tiBusinessRelation_IDintegerEmployee.BusinessRelation_IDBusiness Relation
tiClaimPriceList_IDintegerEmployee.ObsoleteClaimPriceList_IDClaim Price List
tiCompany_IDintegerEmployee.Company_IDLink to Company
tiCostCentre_IDintegerEmployee.CostCentre_IDDefault Cost Center Code
tiCreditor_IDintegerEmployee.Creditor_IDSupplier Code
tiCurrency_IDintegerEmployee.Currency_IDRegistration Currency
tcCustomCombo0characterEmployee.CustomCombo0Custom Combo Field
tcCustomCombo1characterEmployee.CustomCombo1Custom Combo Field
tcCustomCombo2characterEmployee.CustomCombo2Custom Combo Field
tcCustomCombo3characterEmployee.CustomCombo3Custom Combo Field
tcCustomCombo4characterEmployee.CustomCombo4Custom Combo Field
tcCustomCombo5characterEmployee.CustomCombo5Custom Combo Field
tcCustomCombo6characterEmployee.CustomCombo6Custom Combo Field
tcCustomCombo7characterEmployee.CustomCombo7Custom Combo Field
tcCustomCombo8characterEmployee.CustomCombo8Custom Combo Field
tcCustomCombo9characterEmployee.CustomCombo9Custom Combo Field
ttCustomDate0dateEmployee.CustomDate0Custom Date Field
ttCustomDate1dateEmployee.CustomDate1Custom Date Field
ttCustomDate2dateEmployee.CustomDate2Custom Date Field
ttCustomDate3dateEmployee.CustomDate3Custom Date Field
ttCustomDate4dateEmployee.CustomDate4Custom Date Field
tdCustomDecimal0decimalEmployee.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalEmployee.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalEmployee.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalEmployee.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalEmployee.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerEmployee.CustomInteger0Custom Integer Field
tiCustomInteger1integerEmployee.CustomInteger1Custom Integer Field
tiCustomInteger2integerEmployee.CustomInteger2Custom Integer Field
tiCustomInteger3integerEmployee.CustomInteger3Custom Integer Field
tiCustomInteger4integerEmployee.CustomInteger4Custom Integer Field
tcCustomLong0characterEmployee.CustomLong0Custom Long Field
tcCustomLong1characterEmployee.CustomLong1Custom Long Field
tcCustomNotecharacterEmployee.CustomNoteCustom Note Field
tcCustomShort0characterEmployee.CustomShort0Custom Short Field
tcCustomShort1characterEmployee.CustomShort1Custom Short Field
tcCustomShort2characterEmployee.CustomShort2Custom Short Field
tcCustomShort3characterEmployee.CustomShort3Custom Short Field
tcCustomShort4characterEmployee.CustomShort4Custom Short Field
tcCustomShort5characterEmployee.CustomShort5Custom Short Field
tcCustomShort6characterEmployee.CustomShort6Custom Short Field
tcCustomShort7characterEmployee.CustomShort7Custom Short Field
tcCustomShort8characterEmployee.CustomShort8Custom Short Field
tcCustomShort9characterEmployee.CustomShort9Custom Short Field
tiDivision_IDintegerEmployee.Division_IDDefault Sub-Account 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.
tcEmployeeDepartmentCodecharacterEmployee.EmployeeDepartmentCodeDepartment Code: The department in which this employee normally works.
ttEmployeeEndDatedateEmployee.EmployeeEndDateEnd Date: The date when this employee terminated employment at your company.
This field is for reference and filtering report data.
tlEmployeeIsActivelogicalEmployee.EmployeeIsActiveActive: This field indicates if this is an active record.
api annotation:PartialUpdate = yes - defaults to true
tlEmployeeIsActiveExpNoteslogicalEmployee.EmployeeIsActiveExpNotesObsolete field
tlEmployeeIsActiveTimeReglogicalEmployee.EmployeeIsActiveTimeRegObsolete 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
tlEmployeeIsTravelOverSalarylogicalEmployee.EmployeeIsTravelOverSalaryInclude Travel Hours/Overtime
api annotation:PartialUpdate = yes - defaults to false
tlEmployeeIsUserlogicalEmployee.EmployeeIsUserUser: Indicate if this employee is also defined as a valid user in User Maintenance.
api annotation:PartialUpdate = yes - defaults to false
tcEmployeeJobTitlecharacterEmployee.EmployeeJobTitleJob Title: An optional job title for this employee.
This field is for reference only and useful in sorting browses.
ttEmployeeStartDatedateEmployee.EmployeeStartDateStart Date: The date this employee was hired. This field is for reference and filtering report data.
api annotation:PartialUpdate = yes - defaults to the date the record was created
tiExpenseCode_IDintegerEmployee.ExpenseCode_IDExpense Code
ttLastModifiedDatedateEmployee.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerEmployee.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterEmployee.LastModifiedUserLast Modified User
tiProject_IDintegerEmployee.Project_IDDefault Project
tiUsr_IDintegerEmployee.Usr_IDLogin
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Employee)


Internal usage


QadFinancials
method BEmployee.ApiLoadEmployee