field name | data type | mnd. | description |
Employee_ID | integer | yes | Record ID |
Company_ID | integer | yes | Link to Company |
Creditor_ID | integer | no | Supplier Code |
Currency_ID | integer | no | Registration Currency |
Usr_ID | integer | no | Login |
BusinessRelation_ID | integer | yes | Business Relation |
CostCentre_ID | integer | no | Default Cost Center Code |
Division_ID | integer | no | Default Sub-Account Code |
ActivityCode_ID | integer | no | Activity Code |
ExpenseCode_ID | integer | no | Expense Code |
Project_ID | integer | no | Default Project |
EmployeeCode | character(8) | no | 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. |
EmployeeIsActive | logical | yes | Active: This field indicates if this is an active record. |
| api annotation: | | PartialUpdate = yes - defaults to true |
EmployeeIsActiveExpNotes | logical | yes | Obsolete field |
EmployeeIsActiveTimeReg | logical | yes | Obsolete field |
EmployeeIsExternal | logical | yes | External Employee: Indicate if the employee is a contractor or not employed directly by your organization. |
| api annotation: | | PartialUpdate = yes - defaults to false |
EmployeeIsUser | logical | yes | User: Indicate if this employee is also defined as a valid user in User Maintenance. |
| api annotation: | | PartialUpdate = yes - defaults to false |
EmployeeStartDate | date | yes | 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 |
EmployeeEndDate | date | no | End Date: The date when this employee terminated employment at your company. This field is for reference and filtering report data. |
EmployeeIsTravelOverSalary | logical | yes | Include Travel Hours/Overtime |
| api annotation: | | PartialUpdate = yes - defaults to false |
EmployeeDepartmentCode | character(8) | no | Department Code: The department in which this employee normally works. |
EmployeeJobTitle | character(24) | no | Job Title: An optional job title for this employee. This field is for reference only and useful in sorting browses. |
ObsoleteClaimPriceList_ID | integer | no | Claim Price List |
ObsoleteActCstPriceList_ID | integer | no | Actual Costing Price List |
tcActivityCodeType | character(20) | no | |
tcExpenseCodeType | character(20) | no | |
tcCreditorCode | character(8) | no | Supplier Code |
tcCurrencyCode | character(3) | no | Registration Currency |
tcBusinessRelationCode | character(20) | yes | Business Relation |
tlBusinessRelationIsInterco | logical | no | Business Relation Intercompany |
tcCostCentreCode | character(4) | no | Default Cost Center Code |
tcActivityCode | character(20) | no | Activity Code |
tcDivisionCode | character(8) | no | Default Sub-Account Code |
tcExpenseCode | character(20) | no | Expense Code |
tcProjectCode | character(8) | no | Default Project |
tcUsrLogin | character(20) | no | Login |
CustomShort0 | character(20) | no | Custom Short Field |
CustomShort1 | character(20) | no | Custom Short Field |
CustomShort2 | character(20) | no | Custom Short Field |
CustomShort3 | character(20) | no | Custom Short Field |
CustomShort4 | character(20) | no | Custom Short Field |
CustomShort5 | character(20) | no | Custom Short Field |
CustomShort6 | character(20) | no | Custom Short Field |
CustomShort7 | character(20) | no | Custom Short Field |
CustomShort8 | character(20) | no | Custom Short Field |
CustomShort9 | character(20) | no | Custom Short Field |
CustomCombo0 | character(20) | no | Custom Combo Field |
CustomCombo1 | character(20) | no | Custom Combo Field |
CustomCombo2 | character(20) | no | Custom Combo Field |
CustomCombo3 | character(20) | no | Custom Combo Field |
CustomCombo4 | character(20) | no | Custom Combo Field |
CustomCombo5 | character(20) | no | Custom Combo Field |
CustomCombo6 | character(20) | no | Custom Combo Field |
CustomCombo7 | character(20) | no | Custom Combo Field |
CustomCombo8 | character(20) | no | Custom Combo Field |
CustomCombo9 | character(20) | no | Custom Combo Field |
CustomLong0 | character(255) | no | Custom Long Field |
CustomLong1 | character(255) | no | Custom Long Field |
CustomNote | character(2000) | no | Custom Note Field |
CustomDate0 | date | no | Custom Date Field |
CustomDate1 | date | no | Custom Date Field |
CustomDate2 | date | no | Custom Date Field |
CustomDate3 | date | no | Custom Date Field |
CustomDate4 | date | no | Custom Date Field |
CustomInteger0 | integer | no | Custom Integer Field |
CustomInteger1 | integer | no | Custom Integer Field |
CustomInteger2 | integer | no | Custom Integer Field |
CustomInteger3 | integer | no | Custom Integer Field |
CustomInteger4 | integer | no | Custom Integer Field |
CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
LastModifiedDate | date | no | Last Modified Date |
LastModifiedTime | integer | no | Last Modified Time |
LastModifiedUser | character(20) | no | Last Modified User |
QADC01 | character(40) | no | unused QAD reserved field |
QADC02 | character | no | unused QAD reserved field |
QADT01 | date | no | unused QAD reserved field |
QADD01 | decimal(10) | no | unused QAD reserved field |
tc_Rowid | character | yes | primary index |
tc_ParentRowid | character | no | empty string |
tc_Status | character | no | update status |