project QadFinancials > class BEmployee > dataset BEmployee

class dataset

object identification

primary key
Employee_ID
object identity
Employee_ID

table tEmployee

Description

Employee

field namedata typemnd.description
Employee_IDintegeryesRecord ID
Company_IDintegeryesLink to Company
Creditor_IDintegernoSupplier Code
Currency_IDintegernoRegistration Currency
Usr_IDintegernoLogin
BusinessRelation_IDintegeryesBusiness Relation
CostCentre_IDintegernoDefault Cost Center Code
Division_IDintegernoDefault Sub-Account Code
ActivityCode_IDintegernoActivity Code
ExpenseCode_IDintegernoExpense Code
Project_IDintegernoDefault Project
EmployeeCodecharacter(8)noEmployee 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.
EmployeeIsActivelogicalyesActive: This field indicates if this is an active record.
api annotation:PartialUpdate = yes - defaults to true
EmployeeIsActiveExpNoteslogicalyesObsolete field
EmployeeIsActiveTimeReglogicalyesObsolete field
EmployeeIsExternallogicalyesExternal Employee: Indicate if the employee is a contractor or not employed directly by your organization.
api annotation:PartialUpdate = yes - defaults to false
EmployeeIsUserlogicalyesUser: Indicate if this employee is also defined as a valid user in User Maintenance.
api annotation:PartialUpdate = yes - defaults to false
EmployeeStartDatedateyesStart 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
EmployeeEndDatedatenoEnd Date: The date when this employee terminated employment at your company.
This field is for reference and filtering report data.
EmployeeIsTravelOverSalarylogicalyesInclude Travel Hours/Overtime
api annotation:PartialUpdate = yes - defaults to false
EmployeeDepartmentCodecharacter(8)noDepartment Code: The department in which this employee normally works.
EmployeeJobTitlecharacter(24)noJob Title: An optional job title for this employee.
This field is for reference only and useful in sorting browses.
ObsoleteClaimPriceList_IDintegernoClaim Price List
ObsoleteActCstPriceList_IDintegernoActual Costing Price List
tcActivityCodeTypecharacter(20)no
tcExpenseCodeTypecharacter(20)no
tcCreditorCodecharacter(8)noSupplier Code
tcCurrencyCodecharacter(3)noRegistration Currency
tcBusinessRelationCodecharacter(20)yesBusiness Relation
tlBusinessRelationIsIntercologicalnoBusiness Relation Intercompany
tcCostCentreCodecharacter(4)noDefault Cost Center Code
tcActivityCodecharacter(20)noActivity Code
tcDivisionCodecharacter(8)noDefault Sub-Account Code
tcExpenseCodecharacter(20)noExpense Code
tcProjectCodecharacter(8)noDefault Project
tcUsrLogincharacter(20)noLogin
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter