|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ActivityCode_ID
|
Activity Code
|
|
9999999999
|
|
|
|
BusinessRelation_ID
|
Business Relation
|
|
9999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
9999999999
|
|
|
|
CostCentre_ID
|
Default Cost Center Code
|
Cost Center Code
|
9999999999
|
|
|
|
Creditor_ID
|
Supplier Code
|
Supplier
|
9999999999
|
|
|
|
Currency_ID
|
Registration Currency
|
Curr
|
9999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
Division_ID
|
Default Sub-Account Code
|
Sub-Acct
|
9999999999
|
|
|
|
Employee_ID
|
Record ID
|
|
9999999999
|
|
|
|
EmployeeCode
|
Employee Code
|
|
x(8)
|
|
|
|
EmployeeDepartmentCode
|
Department Code
|
|
x(8)
|
|
|
|
EmployeeEndDate
|
End Date
|
|
99/99/9999
|
|
|
|
EmployeeIsActive
|
Active
|
|
yes/no
|
|
|
|
EmployeeIsActiveExpNotes
|
Active Expense Notes
|
Expense Notes
|
yes/no
|
|
|
|
EmployeeIsActiveTimeReg
|
Active Activity Sheets
|
Activity Sheets
|
yes/no
|
|
|
|
EmployeeIsExternal
|
External Employee
|
|
yes/no
|
|
|
|
EmployeeIsTravelOverSalary
|
Include Travel Hours/Overtime
|
Traveling Hours/Overtime
|
yes/no
|
|
|
|
EmployeeIsUser
|
User
|
|
yes/no
|
|
|
|
EmployeeJobTitle
|
Job Title
|
|
x(24)
|
|
|
|
EmployeeStartDate
|
Start Date
|
|
99/99/9999
|
|
|
|
ExpenseCode_ID
|
Expense Code
|
|
9999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
ObsoleteActCstPriceList_ID
|
Actual Costing Price List
|
|
9999999999
|
|
|
|
ObsoleteClaimPriceList_ID
|
Claim Price List
|
|
9999999999
|
|
|
|
Project_ID
|
Default Project
|
|
9999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Usr_ID
|
Login
|
|
9999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ActCodeIdx
|
no
|
ActivityCode_ID
|
yes
|
no
|
|
|
Active
|
no
|
EmployeeIsActive
|
yes
|
no
|
|
|
BusRelIdx
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
CCIdx
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
Code
|
no
|
EmployeeCode
|
yes
|
no
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
CredIdx
|
no
|
Creditor_ID
|
yes
|
no
|
|
|
CurrIdx
|
no
|
Currency_ID
|
yes
|
no
|
|
|
DivIdx
|
no
|
Division_ID
|
yes
|
no
|
|
|
ExpCodeIdx
|
no
|
ExpenseCode_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Employee_ID
|
yes
|
no
|
|
|
PrjIdx
|
no
|
Project_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
EmployeeCode
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Usr_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
EmployeeIsActive
|
yes
|
no
|
|
|
|
|
EmployeeCode
|
yes
|
no
|