business logic query EmployeeForExcelInteg

Parameters

iiCompanyId

integer

Company id

query condition

each Employee where

Employee.Company_Id = iiCompanyId AND

query resultset tqEmployeeForExcelInteg

field name	data type	db field	description
tiActivityCode_ID	integer	Employee.ActivityCode_ID	Activity Code
tiActivityCostPriceList_ID	integer	Employee.ObsoleteActCstPriceList_ID	Actual Costing Price List
tiBusinessRelation_ID	integer	Employee.BusinessRelation_ID	Business Relation
tiClaimPriceList_ID	integer	Employee.ObsoleteClaimPriceList_ID	Claim Price List
tiCompany_ID	integer	Employee.Company_ID	Link to Company
tiCostCentre_ID	integer	Employee.CostCentre_ID	Default Cost Center Code
tiCreditor_ID	integer	Employee.Creditor_ID	Supplier Code
tiCurrency_ID	integer	Employee.Currency_ID	Registration Currency
tcCustomCombo0	character	Employee.CustomCombo0	Custom Combo Field
tcCustomCombo1	character	Employee.CustomCombo1	Custom Combo Field
tcCustomCombo2	character	Employee.CustomCombo2	Custom Combo Field
tcCustomCombo3	character	Employee.CustomCombo3	Custom Combo Field
tcCustomCombo4	character	Employee.CustomCombo4	Custom Combo Field
tcCustomCombo5	character	Employee.CustomCombo5	Custom Combo Field
tcCustomCombo6	character	Employee.CustomCombo6	Custom Combo Field
tcCustomCombo7	character	Employee.CustomCombo7	Custom Combo Field
tcCustomCombo8	character	Employee.CustomCombo8	Custom Combo Field
tcCustomCombo9	character	Employee.CustomCombo9	Custom Combo Field
ttCustomDate0	date	Employee.CustomDate0	Custom Date Field
ttCustomDate1	date	Employee.CustomDate1	Custom Date Field
ttCustomDate2	date	Employee.CustomDate2	Custom Date Field
ttCustomDate3	date	Employee.CustomDate3	Custom Date Field
ttCustomDate4	date	Employee.CustomDate4	Custom Date Field
tdCustomDecimal0	decimal	Employee.CustomDecimal0	Custom Decimal Field
tdCustomDecimal1	decimal	Employee.CustomDecimal1	Custom Decimal Field
tdCustomDecimal2	decimal	Employee.CustomDecimal2	Custom Decimal Field
tdCustomDecimal3	decimal	Employee.CustomDecimal3	Custom Decimal Field
tdCustomDecimal4	decimal	Employee.CustomDecimal4	Custom Decimal Field
tiCustomInteger0	integer	Employee.CustomInteger0	Custom Integer Field
tiCustomInteger1	integer	Employee.CustomInteger1	Custom Integer Field
tiCustomInteger2	integer	Employee.CustomInteger2	Custom Integer Field
tiCustomInteger3	integer	Employee.CustomInteger3	Custom Integer Field
tiCustomInteger4	integer	Employee.CustomInteger4	Custom Integer Field
tcCustomLong0	character	Employee.CustomLong0	Custom Long Field
tcCustomLong1	character	Employee.CustomLong1	Custom Long Field
tcCustomNote	character	Employee.CustomNote	Custom Note Field
tcCustomShort0	character	Employee.CustomShort0	Custom Short Field
tcCustomShort1	character	Employee.CustomShort1	Custom Short Field
tcCustomShort2	character	Employee.CustomShort2	Custom Short Field
tcCustomShort3	character	Employee.CustomShort3	Custom Short Field
tcCustomShort4	character	Employee.CustomShort4	Custom Short Field
tcCustomShort5	character	Employee.CustomShort5	Custom Short Field
tcCustomShort6	character	Employee.CustomShort6	Custom Short Field
tcCustomShort7	character	Employee.CustomShort7	Custom Short Field
tcCustomShort8	character	Employee.CustomShort8	Custom Short Field
tcCustomShort9	character	Employee.CustomShort9	Custom Short Field
tiDivision_ID	integer	Employee.Division_ID	Default Sub-Account 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.
tcEmployeeDepartmentCode	character	Employee.EmployeeDepartmentCode	Department Code: The department in which this employee normally works.
ttEmployeeEndDate	date	Employee.EmployeeEndDate	End Date: The date when this employee terminated employment at your company. This field is for reference and filtering report data.
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
tlEmployeeIsActiveTimeReg	logical	Employee.EmployeeIsActiveTimeReg	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
tlEmployeeIsTravelOverSalary	logical	Employee.EmployeeIsTravelOverSalary	Include Travel Hours/Overtime
	api annotation:		PartialUpdate = yes - defaults to false
tlEmployeeIsUser	logical	Employee.EmployeeIsUser	User: Indicate if this employee is also defined as a valid user in User Maintenance.
	api annotation:		PartialUpdate = yes - defaults to false
tcEmployeeJobTitle	character	Employee.EmployeeJobTitle	Job Title: An optional job title for this employee. This field is for reference only and useful in sorting browses.
ttEmployeeStartDate	date	Employee.EmployeeStartDate	Start 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_ID	integer	Employee.ExpenseCode_ID	Expense Code
ttLastModifiedDate	date	Employee.LastModifiedDate	Last Modified Date
tiLastModifiedTime	integer	Employee.LastModifiedTime	Last Modified Time
tcLastModifiedUser	character	Employee.LastModifiedUser	Last Modified User
tiProject_ID	integer	Employee.Project_ID	Default Project
tiUsr_ID	integer	Employee.Usr_ID	Login
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Employee)

Internal usage

QadFinancials

method BEmployee.ApiLoadEmployee