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 |
AccountCode
|
cmp_Code
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountCompanyCode
|
cmp_Administration
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountID
|
CustomerID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountManagerID
|
AccAccountManager
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountManagerIDContact
|
AccountManager
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountManagerName
|
AccountManagerName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountManagerType
|
AccountManagerType
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
A,35,Applicant | C,24081,Contractor | E,9551,Employee | K,240,Customer | R,995,Partner | S,29493,Student | T,29542,Temporary | V,8148,Vacancy |
|
AccountName
|
cmp_Name
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountStatus
|
CustomerStatus
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountType
|
CustomerType
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountTypeDescription
|
CustomerTypeDescription
|
String
|
|
40
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Active
|
Active
|
Boolean
|
|
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 |
CompanyCode
|
Administration
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CompanyName
|
AdministrationDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContactID
|
ContactID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatedDate
|
DateCreated
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Creator
|
CreatedBy
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
CreatorName
|
CreatedByName
|
String
|
|
64
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
Directory
|
Directory
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
EmailAddress
|
Email
|
String
|
|
128
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ESFAddressID
|
ESFAddressID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
FaxNumber
|
Fax
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
FirstName
|
FirstName
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
FullName
|
FullName
|
String
|
|
100
|
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
|
O
|
|
|
|
|
|
|
|
|
|
|
M,5155,Male | O,1067,Unknown | V,5156,Female |
|
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 |
Initials
|
Initials
|
String
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
IsBinaryServiceEnabled
|
IsBinaryServiceEnabled
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
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 |
JobDescription
|
JobDescription
|
String
|
|
50
|
0
|
--
|
|
|
|
|
|
|
|
|
|
|
|
JobTitle
|
JobTitle
|
String
|
|
12
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
JobTitleDescription
|
JobTitleDescription
|
String
|
|
50
|
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
|
|
50
|
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 |
MainContact
|
MainContact
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
MessageID
|
MessageID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MiddleName
|
MiddleName
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MobileNumber
|
Mobile
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ModifiedDate
|
DateModified
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Modifier
|
ModifiedBy
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
ModifierName
|
ModifiedByName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Msn
|
msn
|
String
|
|
50
|
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 |
NumberFreeField1
|
NumberField1
|
Number
|
|
16
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
NumberFreeField2
|
NumberField2
|
Number
|
|
16
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
NumberFreeField3
|
NumberField3
|
Number
|
|
16
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
NumberFreeField4
|
NumberField4
|
Number
|
|
16
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
NumberFreeField5
|
NumberField5
|
Number
|
|
16
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
PhoneExtension
|
PhoneExtension
|
String
|
|
5
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PhoneNumber
|
Phone
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PictureFileName
|
PictureFileName
|
String
|
|
128
|
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 |
Remarks
|
Notes
|
String
|
|
8191
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ResourceID
|
Res_ID
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ResourceMsnID
|
Res_ID_Msn_ID
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ResourceSkypeID
|
Res_ID_Skype_ID
|
String
|
|
32
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ResourceStatus
|
Res_ID_status
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
A,2212,Active | F,11158,Fulfilled | H,29541,Hired | I,29544,Inactive | T,47,Future |
|
ResourceUserID
|
Res_ID_Usr_ID
|
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 |
Skype
|
skype
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SyncID
|
SyncID
|
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
|
|
80
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TextFreeField2
|
TextField2
|
String
|
|
80
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TextFreeField3
|
TextField3
|
String
|
|
80
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TextFreeField4
|
TextField4
|
String
|
|
80
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TextFreeField5
|
TextField5
|
String
|
|
80
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Title
|
Title
|
String
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TitleAbbreviation
|
TitleAbbreviation
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TitleDescription
|
TitleDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TitleHeading
|
TitleHeading
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with W |
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 |
WebAccess
|
WebAccess
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
WebAddress
|
WebAddress
|
String
|
|
128
|
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
|
|
|
|
|
|
|
|
|
|
|
|