Property starting with A |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
AccountAddressID
|
|
|
String
|
|
AccountAddressID
|
|
|
|
|
AccountContactID
|
|
|
GUID
|
|
AccountContactID
|
|
|
|
|
AccountID
|
|
|
GUID
|
|
AccountID
|
|
|
|
|
AccountPayable
|
A/P
|
A/P
|
String
|
|
AccountPayable
|
|
|
|
|
AccountPayableName
|
Name
|
Name
|
String
|
|
AccountPayableName
|
|
|
|
|
AccountPayableNumber
|
CreditorNumber
|
CreditorNumber
|
String
|
|
AccountPayableNumber
|
|
|
|
|
AddressHouseNumber
|
House no.
|
House no.
|
String
|
|
AddressHouseNumber
|
|
|
|
|
AddressLine1
|
Address
|
Address
|
String
|
|
AddressLine1
|
|
|
|
|
AddressLine2
|
Address 2
|
Address 2
|
String
|
|
AddressLine2
|
|
|
|
|
AdjustedHireDate
|
Adjusted hire date
|
Adjusted hire date
|
Date
|
|
AdjustedHireDate
|
|
|
|
|
ApplicationPhase
|
|
|
String
|
|
ApplicationPhase
|
|
|
|
|
AssistantFullName
|
Assistant name
|
Assistant name
|
String
|
|
AssistantFullName
|
|
|
|
|
AssistantID
|
Assistant ID
|
Assistant ID
|
Number
|
|
AssistantID
|
|
|
|
|
Property starting with B |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
BackOfficeBlocked
|
Back office
|
Back office
|
Boolean
|
|
BackOfficeBlocked
|
|
|
|
|
BankAccount1
|
Bank account 1
|
Bank account 1
|
String
|
|
BankAccount1
|
|
|
|
|
BankAccountType1
|
|
|
String
|
|
BankAccountType1
|
|
|
|
|
BirthDate
|
Birth date
|
Birth date
|
Date
|
|
BirthDate
|
|
|
|
|
BirthPrefix
|
Prefix
|
Prefix
|
String
|
|
BirthPrefix
|
|
|
|
|
Blocked
|
Access status
|
Access status
|
Boolean
|
|
Blocked
|
|
|
|
|
Property starting with C |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
CentralizationAccount
|
|
|
String
|
|
CentralizationAccount
|
|
|
|
|
City
|
City
|
City
|
String
|
|
City
|
|
|
|
|
Classification
|
Classification
|
Classification
|
String
|
|
Classification
|
|
|
|
|
ClassificationID
|
Classification
|
Classification
|
String
|
|
ClassificationID
|
|
|
|
|
CompanyCode
|
Division
|
Division
|
String
|
|
CompanyCode
|
|
|
|
|
CompanyName
|
Division description
|
Division description
|
String
|
|
CompanyName
|
|
|
|
|
ContractEnd
|
Contract end date
|
Contract end date
|
Date
|
|
ContractEnd
|
|
|
|
|
ContractLocation
|
Main Location
|
Main Location
|
String
|
|
ContractLocation
|
|
|
|
|
ContractLocationDescription
|
|
|
String
|
|
ContractLocationDescription
|
|
|
|
|
CostCenter
|
Cost center
|
Cost center
|
String
|
|
CostCenter
|
|
|
|
|
CostCenterDescription
|
Cost center description
|
Cost center description
|
String
|
|
CostCenterDescription
|
|
|
|
|
CostUnit
|
Cost unit
|
Cost unit
|
String
|
|
CostUnit
|
|
|
|
|
CostUnitDescription
|
Cost unit description
|
Cost unit description
|
String
|
|
CostUnitDescription
|
|
|
|
|
CountryCode
|
Country code
|
Country code
|
String
|
|
CountryCode
|
|
|
|
|
CountryDescription
|
Country description
|
Country description
|
String
|
|
CountryDescription
|
|
|
|
|
CreatedDate
|
Created
|
Created
|
Date
|
|
CreatedDate
|
|
|
|
|
Creator
|
Creator ID
|
Creator ID
|
Number
|
|
Creator
|
|
|
|
|
CreatorName
|
Creator
|
Creator
|
String
|
|
CreatorName
|
|
|
|
|
CreditLine
|
CreditLine
|
CreditLine
|
Number
|
|
CreditLine
|
|
|
|
|
CreditorID
|
|
|
GUID
|
|
CreditorID
|
|
|
|
|
Currency
|
Currency
|
Currency
|
String
|
|
Currency
|
|
|
|
|
CurrencyDescription
|
CurrencyDescription
|
CurrencyDescription
|
String
|
|
CurrencyDescription
|
|
|
|
|
Property starting with D |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
DateFreeField1
|
DateField1
|
DateField1
|
Date
|
|
DateFreeField1
|
|
|
|
|
DateFreeField2
|
DateField2
|
DateField2
|
Date
|
|
DateFreeField2
|
|
|
|
|
DateFreeField3
|
DateField3
|
DateField3
|
Date
|
|
DateFreeField3
|
|
|
|
|
DateFreeField4
|
DateField4
|
DateField4
|
Date
|
|
DateFreeField4
|
|
|
|
|
DateFreeField5
|
DateField5
|
DateField5
|
Date
|
|
DateFreeField5
|
|
|
|
|
DebtorCode
|
|
|
String
|
|
DebtorCode
|
|
|
|
|
DebtorNumber
|
Debtor number
|
Debtor number
|
String
|
|
DebtorNumber
|
|
|
|
|
Discount
|
Discount
|
Discount
|
Number
|
|
Discount
|
|
|
|
|
Property starting with E |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
EmailPersonal
|
|
|
String
|
|
EmailPersonal
|
|
|
|
|
EmailWork
|
e-mail address
|
e-mail address
|
String
|
|
EmailWork
|
|
|
|
|
EmploymentEndDate
|
Inactive
|
Inactive
|
Date
|
|
EmploymentEndDate
|
|
|
|
|
EmploymentStartDate
|
Start date
|
Start date
|
Date
|
|
EmploymentStartDate
|
|
|
|
|
Property starting with F |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Fax
|
Fax
|
Fax
|
String
|
|
Fax
|
|
|
|
|
FirstName
|
First name
|
First name
|
String
|
|
FirstName
|
|
|
|
|
FiscalCode
|
Fiscal code
|
Fiscal code
|
String
|
|
FiscalCode
|
|
|
|
|
Focus
|
Task
|
Task
|
String
|
|
Focus
|
|
|
|
|
FTE
|
FTE
|
FTE
|
Number
|
|
FTE
|
|
|
|
|
FullName
|
Fullname
|
Fullname
|
String
|
|
FullName
|
|
|
|
|
Property starting with G |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Gender
|
Gender
|
Gender
|
String
|
|
Gender
|
|
|
|
|
Property starting with H |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
HRContractID
|
|
|
GUID
|
|
HRContractID
|
|
|
|
|
Property starting with I |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
ID
|
ID
|
ID
|
Number
|
|
ID
|
|
|
|
|
Initials
|
Initials
|
Initials
|
String
|
|
Initials
|
|
|
|
|
InternalRate
|
Internal rate
|
Internal rate
|
Number
|
|
InternalRate
|
|
|
|
|
IsBinaryServiceEnabled
|
|
|
Boolean
|
|
IsBinaryServiceEnabled
|
|
|
|
|
ISPAccount
|
ISP Account
|
ISP Account
|
String
|
|
ISPAccount
|
|
|
|
|
ItemCode
|
Item code
|
Item code
|
String
|
|
ItemCode
|
|
|
|
|
Property starting with J |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
JobCategory
|
Job category
|
Job category
|
String
|
|
JobCategory
|
|
|
|
|
JobGroup
|
|
|
String
|
|
JobGroup
|
|
|
|
|
JobLevel
|
Scale
|
Scale
|
Number
|
|
JobLevel
|
|
|
|
|
JobTitle
|
Job title
|
Job title
|
String
|
|
JobTitle
|
|
|
|
|
JobTitleDescription
|
Job title
|
Job title
|
String
|
|
JobTitleDescription
|
|
|
|
|
JobTitleLevel
|
Job level
|
Job level
|
Number
|
|
JobTitleLevel
|
|
|
|
|
Property starting with L |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Language
|
Language code
|
Language code
|
String
|
|
Language
|
|
|
|
|
LanguageDescription
|
Language
|
Language
|
String
|
|
LanguageDescription
|
|
|
|
|
LastName
|
Last name
|
Last name
|
String
|
|
LastName
|
|
|
|
|
Property starting with M |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
MaidenName
|
Maiden name
|
Maiden name
|
String
|
|
MaidenName
|
|
|
|
|
ManagerFullName
|
Manager
|
Manager
|
String
|
|
ManagerFullName
|
|
|
|
|
ManagerID
|
Manager
|
Manager
|
Number
|
|
ManagerID
|
|
|
|
|
ManagerUserID
|
Manager ID
|
Manager ID
|
String
|
|
ManagerUserID
|
|
|
|
|
MaritalState
|
Marital state
|
Marital state
|
String
|
|
MaritalState
|
|
|
|
|
MaritalStateDate
|
Marital state since
|
Marital state since
|
Date
|
|
MaritalStateDate
|
|
|
|
|
MessageIDPicture
|
|
|
GUID
|
|
MessageIDPicture
|
|
|
|
|
MessageIDSignature
|
|
|
GUID
|
|
MessageIDSignature
|
|
|
|
|
MiddleName
|
Middle name
|
Middle name
|
String
|
|
MiddleName
|
|
|
|
|
ModifiedDate
|
Modified
|
Modified
|
Date
|
|
ModifiedDate
|
|
|
|
|
Modifier
|
Modifier ID
|
Modifier ID
|
Number
|
|
Modifier
|
|
|
|
|
ModifierName
|
Modifier
|
Modifier
|
String
|
|
ModifierName
|
|
|
|
|
MsnID
|
MsnID
|
MsnID
|
String
|
|
MsnID
|
|
|
|
|
Property starting with N |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Nationality
|
Nationality ID
|
Nationality ID
|
String
|
|
Nationality
|
|
|
|
|
NationalityDescription
|
Nationality
|
Nationality
|
String
|
|
NationalityDescription
|
|
|
|
|
NumberFreeField1
|
NumberField1
|
NumberField1
|
Number
|
|
NumberFreeField1
|
|
|
|
|
NumberFreeField2
|
NumberField2
|
NumberField2
|
Number
|
|
NumberFreeField2
|
|
|
|
|
NumberFreeField3
|
NumberField3
|
NumberField3
|
Number
|
|
NumberFreeField3
|
|
|
|
|
NumberFreeField4
|
NumberField4
|
NumberField4
|
Number
|
|
NumberFreeField4
|
|
|
|
|
NumberFreeField5
|
NumberField5
|
NumberField5
|
Number
|
|
NumberFreeField5
|
|
|
|
|
Property starting with O |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
OffSetAccount
|
OffSet G/L
|
OffSet G/L
|
String
|
|
OffSetAccount
|
|
|
|
|
OriginCountryCode
|
Country of origin
|
Country of origin
|
String
|
|
OriginCountryCode
|
|
|
|
|
OriginCountryDescription
|
|
|
String
|
|
OriginCountryDescription
|
|
|
|
|
Property starting with P |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
PayeeName
|
Payee Name
|
Payee Name
|
String
|
|
PayeeName
|
|
|
|
|
PaymentCondition
|
PaymentCondition
|
PaymentCondition
|
String
|
|
PaymentCondition
|
|
|
|
|
PaymentConditionDescription
|
|
|
String
|
|
PaymentConditionDescription
|
|
|
|
|
PaymentLimit
|
|
|
Number
|
|
PaymentLimit
|
|
|
|
|
PaymentMethod
|
PaymentMethod
|
PaymentMethod
|
String
|
|
PaymentMethod
|
|
|
|
|
PhonePersonal
|
Home telephone
|
Home telephone
|
String
|
|
PhonePersonal
|
|
|
|
|
PhonePersonalMobile
|
Private mobile
|
Private mobile
|
String
|
|
PhonePersonalMobile
|
|
|
|
|
PhoneWork
|
Telephone
|
Telephone
|
String
|
|
PhoneWork
|
|
|
|
|
PhoneWorkExtension
|
Extension
|
Extension
|
String
|
|
PhoneWorkExtension
|
|
|
|
|
PhoneWorkMobile
|
Mobile
|
Mobile
|
String
|
|
PhoneWorkMobile
|
|
|
|
|
PhoneWorkMobileExtension
|
Mobile shortcut
|
Mobile shortcut
|
String
|
|
PhoneWorkMobileExtension
|
|
|
|
|
PhysicalLocation
|
Location
|
Location
|
String
|
|
PhysicalLocation
|
|
|
|
|
PhysicalLocationDescription
|
Location
|
Location
|
String
|
|
PhysicalLocationDescription
|
|
|
|
|
PictureFilename
|
Picture filename
|
Picture filename
|
String
|
|
PictureFilename
|
|
|
|
|
PlaceOfBirth
|
|
|
String
|
|
PlaceOfBirth
|
|
|
|
|
PostalAddressLine1
|
Address
|
Address
|
String
|
|
PostalAddressLine1
|
|
|
|
|
PostalAddressLine2
|
Address
|
Address
|
String
|
|
PostalAddressLine2
|
|
|
|
|
PostalCity
|
City
|
City
|
String
|
|
PostalCity
|
|
|
|
|
PostalCountry
|
Country
|
Country
|
String
|
|
PostalCountry
|
|
|
|
|
PostalCountryDescription
|
Country description
|
Country description
|
String
|
|
PostalCountryDescription
|
|
|
|
|
PostalKeepSameAsVisit
|
Keep Same As Visit
|
Keep Same As Visit
|
Boolean
|
|
PostalKeepSameAsVisit
|
|
|
|
|
PostalPhone
|
Phone
|
Phone
|
String
|
|
PostalPhone
|
|
|
|
|
PostalPostCode
|
PostCode
|
PostCode
|
String
|
|
PostalPostCode
|
|
|
|
|
PostalStateCode
|
State
|
State
|
String
|
|
PostalStateCode
|
|
|
|
|
PostalStateDescription
|
|
|
String
|
|
PostalStateDescription
|
|
|
|
|
Postcode
|
Postcode
|
Postcode
|
String
|
|
Postcode
|
|
|
|
|
Prefix
|
Prefix
|
Prefix
|
String
|
|
Prefix
|
|
|
|
|
PrevRating
|
Previous rating
|
Previous rating
|
String
|
|
PrevRating
|
|
|
|
|
PriceList
|
|
|
String
|
|
PriceList
|
|
|
|
|
PurchaseCurrency
|
|
|
String
|
|
PurchaseCurrency
|
|
|
|
|
PurchaseLimit
|
Purchase limit
|
Purchase limit
|
Number
|
|
PurchaseLimit
|
|
|
|
|
Property starting with Q |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Qualifications
|
Qualifications
|
Qualifications
|
String
|
|
Qualifications
|
|
|
|
|
Property starting with R |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
Race
|
Race
|
Race
|
String
|
|
Race
|
|
|
|
|
Rating
|
Rating
|
Rating
|
String
|
|
Rating
|
|
|
|
|
ReasonResign
|
|
|
String
|
|
ReasonResign
|
|
|
|
|
ResourceType
|
Type
|
Type
|
String
|
|
ResourceType
|
|
|
|
|
RMALimit
|
RMA orders
|
RMA orders
|
Number
|
|
RMALimit
|
|
|
|
|
Room
|
Room
|
Room
|
String
|
|
Room
|
|
|
|
|
Property starting with S |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
SalesInvoiceLimit
|
Sales invoice
|
Sales invoice
|
Number
|
|
SalesInvoiceLimit
|
|
|
|
|
SalesOrderLimit
|
Sales orders
|
Sales orders
|
Number
|
|
SalesOrderLimit
|
|
|
|
|
SecurityLevel
|
Security level
|
Security level
|
Number
|
|
SecurityLevel
|
|
|
|
|
SignatureFile
|
|
|
String
|
|
SignatureFile
|
|
|
|
|
SkypeID
|
SkypeID
|
SkypeID
|
String
|
|
SkypeID
|
|
|
|
|
SocialSecurityNumber
|
Social security no.
|
Social security no.
|
String
|
|
SocialSecurityNumber
|
|
|
|
|
State
|
State
|
State
|
String
|
|
State
|
|
|
|
|
StateDescription
|
|
|
String
|
|
StateDescription
|
|
|
|
|
Status
|
Status
|
Status
|
String
|
|
Status
|
|
|
|
|
Suffix
|
Affix
|
Affix
|
String
|
|
Suffix
|
|
|
|
|
Property starting with s |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
sysguid
|
|
|
GUID
|
|
sysguid
|
|
|
|
|
Property starting with T |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
TextFreeField1
|
TextField1
|
TextField1
|
String
|
|
TextFreeField1
|
|
|
|
|
TextFreeField2
|
TextField2
|
TextField2
|
String
|
|
TextFreeField2
|
|
|
|
|
TextFreeField3
|
TextField3
|
TextField3
|
String
|
|
TextFreeField3
|
|
|
|
|
TextFreeField4
|
TextField4
|
TextField4
|
String
|
|
TextFreeField4
|
|
|
|
|
TextFreeField5
|
TextField5
|
TextField5
|
String
|
|
TextFreeField5
|
|
|
|
|
TimeZone
|
TimeZones
|
TimeZones
|
Number
|
|
TimeZone
|
|
|
|
|
TimeZoneDescription
|
Description
|
Description
|
String
|
|
TimeZoneDescription
|
|
|
|
|
Title
|
Title
|
Title
|
String
|
|
Title
|
|
|
|
|
TitleDescription
|
Title Description
|
Title Description
|
String
|
|
TitleDescription
|
|
|
|
|
Property starting with U |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
UserID
|
User Name
|
User Name
|
String
|
|
UserID
|
|
|
|
|
Property starting with V |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
VacancyStartDate
|
|
|
Date
|
|
VacancyStartDate
|
|
|
|
|
VacancyType
|
|
|
String
|
|
VacancyType
|
|
|
|
|
VatNumber
|
VAT Number
|
VAT Number
|
String
|
|
VatNumber
|
|
|
|
|
Property starting with Y |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
YesNoFreeField1
|
YesNoField1
|
YesNoField1
|
Boolean
|
|
YesNoFreeField1
|
|
|
|
|
YesNoFreeField2
|
YesNoField2
|
YesNoField2
|
Boolean
|
|
YesNoFreeField2
|
|
|
|
|
YesNoFreeField3
|
YesNoField3
|
YesNoField3
|
Boolean
|
|
YesNoFreeField3
|
|
|
|
|
YesNoFreeField4
|
YesNoField4
|
YesNoField4
|
Boolean
|
|
YesNoFreeField4
|
|
|
|
|
YesNoFreeField5
|
YesNoField5
|
YesNoField5
|
Boolean
|
|
YesNoFreeField5
|
|
|
|
|
Property starting with A |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
AccountAddressID
|
AssociateAddressID
|
String
|
|
8191
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountContactID
|
AssociateContactID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountID
|
AssociateID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountPayable
|
CreditorCode
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountPayableName
|
CreditorName
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountPayableNumber
|
CreditorNumber
|
String
|
|
6
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AddressHouseNumber
|
AddressHouseNumber
|
String
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AddressLine1
|
Address1
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AddressLine2
|
Address2
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AdjustedHireDate
|
AdjustedHireDate
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ApplicationPhase
|
ApplicationStage
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AssistantFullName
|
AssistantFullName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AssistantID
|
AssistantID
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with B |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
BackOfficeBlocked
|
BackOfficeBlocked
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
BankAccount1
|
BankAccount1
|
String
|
|
34
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BankAccountType1
|
BankAccountType1
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
AT,0,Austrian bank accounts | BE,0,Belgian bankaccounts | CZ,0,Czech account number | DE,0,German bankaccounts | DEF,0,Default bank account type | ES,0,Spanish bankaccounts | FR,0,French bankaccounts | GB,0,British bankaccounts | GNL,0,Blocked Dutch bank account | GPB,0,Blocked Postbank account | HU,0,Hungarian bank accounts | IBA,0,IBAN International Bank Account Number | IT,0,Italian bank accounts | LU,0,Luxemburg bankaccounts | NL,0,Dutch bankaccounts | PB,0,Postbankaccounts | RU,0,Russian bank accounts |
|
BirthDate
|
BirthDate
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
BirthPrefix
|
BirthPrefix
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Blocked
|
AccessStatus
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
Property starting with C |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
CentralizationAccount
|
CentralizationAccount
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
City
|
City
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Classification
|
Classification
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ClassificationID
|
ClassificationID
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CompanyCode
|
Company
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CompanyName
|
CompanyDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContractEnd
|
ContractEnd
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContractLocation
|
MainLocation
|
String
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContractLocationDescription
|
MainLocationDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CostCenter
|
Costcenter
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CostCenterDescription
|
CostcenterDescription
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CostUnit
|
CostUnit
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CostUnitDescription
|
CostunitDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CountryCode
|
CountryCode
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CountryDescription
|
CountryDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatedDate
|
Created
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Creator
|
Creator
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
CreatorName
|
CreatorName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreditLine
|
CreditLine
|
Number
|
|
10
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
CreditorID
|
Cmp_WWN
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Currency
|
Currency
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CurrencyDescription
|
CurrencyDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with D |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
DateFreeField1
|
DateField1
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DateFreeField2
|
DateField2
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DateFreeField3
|
DateField3
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DateFreeField4
|
DateField4
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DateFreeField5
|
DateField5
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DebtorCode
|
Debcode
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DebtorNumber
|
Debnr
|
String
|
|
6
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Discount
|
Discount
|
Number
|
|
6
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with E |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
EmailPersonal
|
EmailPersonal
|
String
|
|
128
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
EmailWork
|
EmailWork
|
String
|
|
128
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
EmploymentEndDate
|
EmploymentEnd
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
EmploymentStartDate
|
EmploymentStart
|
Date
|
|
8
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with F |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
Fax
|
Fax
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
FirstName
|
FirstName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
FiscalCode
|
FiscalCode
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Focus
|
Task
|
String
|
|
90
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
FTE
|
FTE
|
Number
|
|
3
|
6
|
1
|
|
|
|
|
|
|
|
|
|
|
|
FullName
|
FullName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with G |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
Gender
|
Gender
|
String
|
|
1
|
0
|
M
|
|
|
|
|
|
|
|
|
|
|
M,5155,Male | V,5156,Female | O,1067,Unknown |
|
Property starting with H |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
HRContractID
|
HRContractID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with I |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ID
|
ID
|
Number
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Initials
|
Initials
|
String
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
InternalRate
|
InternalRate
|
Number
|
|
16
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
IsBinaryServiceEnabled
|
IsBinaryServiceEnabled
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
ISPAccount
|
ISPAccount
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemCode
|
ItemCode
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with J |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
JobCategory
|
JobCategory
|
String
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
JobGroup
|
JobGroup
|
String
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
JobLevel
|
Scale
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
JobTitle
|
JobTitle
|
String
|
|
12
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
JobTitleDescription
|
JobTitleDescription
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
JobTitleLevel
|
JobTitleLevel
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with L |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
Language
|
Language
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LanguageDescription
|
LanguageDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LastName
|
LastName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with M |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
MaidenName
|
MaidenName
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ManagerFullName
|
ManagerFullName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ManagerID
|
ManagerID
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ManagerUserID
|
ManagerUserID
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MaritalState
|
MaritalState
|
String
|
|
1
|
0
|
S
|
|
|
|
|
|
|
|
|
|
|
S,29488,Single | M,29486,Married | D,29487,Divorced | W,15741,Widowed | L,29485,Living together | R,17990,Registered partnership | N,18145,Notarial act partnership |
|
MaritalStateDate
|
MaritalStateSince
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MessageIDPicture
|
MessageID_picture
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MessageIDSignature
|
MessageID_signature
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MiddleName
|
MiddleName
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ModifiedDate
|
Modified
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Modifier
|
Modifier
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
ModifierName
|
ModifierName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MsnID
|
MsnID
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with N |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
Nationality
|
Nationality
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
NationalityDescription
|
NationalityDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
NumberFreeField1
|
NumberField1
|
Number
|
|
16
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
NumberFreeField2
|
NumberField2
|
Number
|
|
16
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
NumberFreeField3
|
NumberField3
|
Number
|
|
16
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
NumberFreeField4
|
NumberField4
|
Number
|
|
16
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
NumberFreeField5
|
NumberField5
|
Number
|
|
16
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with O |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
OffSetAccount
|
OffSetAccount
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
OriginCountryCode
|
OriginCountryCode
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
OriginCountryDescription
|
OriginCountryDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with P |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
PayeeName
|
PayeeName
|
String
|
|
40
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PaymentCondition
|
PaymentCondition
|
String
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PaymentConditionDescription
|
PaymentConditionDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PaymentLimit
|
PaymentLimit
|
Number
|
|
16
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
PaymentMethod
|
PaymentMethod
|
String
|
|
1
|
0
|
B
|
|
|
|
|
|
|
|
|
|
|
A,34130,Automatic collection | B,833,On credit | C,5714,Cheque | D,0,Post dated cheque | E,0,EFT | F,2014,Factoring | H,0,Chipknip | I,6156,Collection | K,3704,Cash | L,34126,Factoring: Letter of credit | M,14794,Not accepted letter of credit | N,25384,Promissory note | O,834,Debt collection | P,835,Payment on delivery | Q,34128,Confirming: Cheque | R,29633,Credit card | S,3375,Settle | T,34127,Factoring: Collection | U,34129,Confirming: On credit | V,27075,ESR payments | W,870,Letter of credit | X,34438,Payments in CHF | Y,34439,Payments in FC | Z,34440,Payments abroad |
|
PhonePersonal
|
PhoneHome
|
String
|
|
15
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PhonePersonalMobile
|
PhoneMobilePrivate
|
String
|
|
15
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PhoneWork
|
PhoneWork
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PhoneWorkExtension
|
Extension
|
String
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PhoneWorkMobile
|
PhoneMobile
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PhoneWorkMobileExtension
|
PhoneMobileShort
|
String
|
|
15
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PhysicalLocation
|
Location
|
String
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PhysicalLocationDescription
|
LocationDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PictureFilename
|
PictureFilename
|
String
|
|
128
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PlaceOfBirth
|
PlaceOfBirth
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PostalAddressLine1
|
PostalAddressLine1
|
String
|
|
100
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PostalAddressLine2
|
PostalAddressLine2
|
String
|
|
100
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PostalCity
|
PostalCity
|
String
|
|
100
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PostalCountry
|
PostalCountry
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PostalCountryDescription
|
PostalCountryDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PostalKeepSameAsVisit
|
PostalKeepSameAsVisit
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
PostalPhone
|
PostalPhone
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PostalPostCode
|
PostalPostCode
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PostalStateCode
|
PostalStateCode
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PostalStateDescription
|
PostalStateDescription
|
String
|
|
100
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Postcode
|
Postcode
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Prefix
|
Prefix
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PrevRating
|
PrevRating
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
A,0,A | B,0,B | C,0,C | D,0,D | E,0,E |
|
PriceList
|
PriceList
|
String
|
|
15
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PurchaseCurrency
|
PurchaseCurrency
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PurchaseLimit
|
PurchaseLimit
|
Number
|
|
16
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with Q |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
Qualifications
|
Qualifications
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with R |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
Race
|
Race
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Rating
|
Rating
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
A,0,A | B,0,B | C,0,C | D,0,D | E,0,E |
|
ReasonResign
|
ReasonResign
|
String
|
|
128
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ResourceType
|
Type
|
String
|
|
1
|
0
|
E
|
|
|
|
|
|
|
|
|
|
|
C,24081,Contractor | E,9551,Employee | S,29493,Student | T,29542,Temporary |
|
RMALimit
|
RMALimit
|
Number
|
|
16
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Room
|
Room
|
String
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with S |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
SalesInvoiceLimit
|
SalesInvoiceLimit
|
Number
|
|
16
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
SalesOrderLimit
|
SalesOrderLimit
|
Number
|
|
16
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
SecurityLevel
|
JobLevel
|
Number
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SignatureFile
|
SignatureFile
|
String
|
|
128
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SkypeID
|
SkypeID
|
String
|
|
32
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SocialSecurityNumber
|
SocialSecurityNumber
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
State
|
State
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
StateDescription
|
StateDescription
|
String
|
|
100
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Status
|
Status
|
String
|
|
1
|
0
|
A
|
|
|
|
|
|
|
|
|
|
|
A,2212,Active | F,11158,Fulfilled | H,29541,Hired | I,29544,Inactive | R,17691,Rejected | T,47,Future |
|
Suffix
|
Affix
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with s |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
sysguid
|
sysguid
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with T |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
TextFreeField1
|
TextField1
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TextFreeField2
|
TextField2
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TextFreeField3
|
TextField3
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TextFreeField4
|
TextField4
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TextFreeField5
|
TextField5
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TimeZone
|
TimeZones
|
Number
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TimeZoneDescription
|
TimeZoneDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Title
|
Title
|
String
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
DHR,0,Dhr. | FRAU,0,Fr. | HERR,0,Hr. | LS,0,L.S. | MME,0,Mme. | MR,0,Mr. | MRS,0,Mrs. | MS,0,Ms. | MSR,0,Msr. | MVR,0,Mevr. | SR,0,Sr. | SRA,0,Mme. |
|
TitleDescription
|
TitleDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with U |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
UserID
|
UserID
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with V |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
VacancyStartDate
|
VacancyStartDate
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
VacancyType
|
VacancyType
|
String
|
|
1
|
0
|
I
|
|
|
|
|
|
|
|
|
|
|
I,6992,Internal | E,9031,External | B,5586,Both |
|
VatNumber
|
VatNumber
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with Y |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
YesNoFreeField1
|
YesNoField1
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
YesNoFreeField2
|
YesNoField2
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
YesNoFreeField3
|
YesNoField3
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
YesNoFreeField4
|
YesNoField4
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
YesNoFreeField5
|
YesNoField5
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|