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
|
|
|
|
|
|
|
|
|
|
|
|
|
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 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
|
|
|
|
|
|
|
|
|
|
|
|