Entity Resource
Key property ID


Property starting with A
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
AccountAddressID String
AccountContactID GUID
AccountID GUID
AccountPayable A/P A/P String
AccountPayableName Name Name String
AccountPayableNumber CreditorNumber CreditorNumber String
AddressHouseNumber House no. House no. String
AddressLine1 Address Address String
AddressLine2 Address 2 Address 2 String
AdjustedHireDate Adjusted hire date Adjusted hire date Date
ApplicationPhase String
AssistantFullName Assistant name Assistant name String
AssistantID Assistant ID Assistant ID Number

Property starting with B
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
BackOfficeBlocked Back office Back office Boolean
BankAccount1 Bank account 1 Bank account 1 String
BirthDate Birth date Birth date Date
BirthPrefix Prefix Prefix String
Blocked Access status Access status Boolean

Property starting with C
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
CentralizationAccount String
City City City String
Classification Classification Classification String
ClassificationID Classification Classification String
CompanyCode Division Division String
CompanyName Division description Division description String
ContractEnd Contract end date Contract end date Date
ContractLocation Main Location Main Location String
ContractLocationDescription String
CostCenter Cost center Cost center String
CostCenterDescription Cost center description Cost center description String
CostUnit Cost unit Cost unit String
CostUnitDescription Cost unit description Cost unit description String
CountryCode Country code Country code String
CountryDescription Country description Country description String
CreatedDate Created Created Date
Creator Creator ID Creator ID Number
CreatorName Creator Creator String
CreditLine CreditLine CreditLine Number
CreditorID GUID
Currency Currency Currency String
CurrencyDescription CurrencyDescription CurrencyDescription String

Property starting with D
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
DateFreeField1 DateField1 DateField1 Date
DateFreeField2 DateField2 DateField2 Date
DateFreeField3 DateField3 DateField3 Date
DateFreeField4 DateField4 DateField4 Date
DateFreeField5 DateField5 DateField5 Date
DebtorCode String
DebtorNumber Debtor number Debtor number String
Discount Discount Discount Number

Property starting with E
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
EmailPersonal String
EmailWork e-mail address e-mail address String
EmploymentEndDate Inactive Inactive Date
EmploymentStartDate Start date Start date Date

Property starting with F
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Fax Fax Fax String
FirstName First name First name String
FiscalCode Fiscal code Fiscal code String
Focus Task Task String
FTE FTE FTE Number
FullName Fullname Fullname String

Property starting with G
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Gender Gender Gender String

Property starting with H
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
HRContractID GUID

Property starting with I
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ID ID ID Number
Initials Initials Initials String
InternalRate Internal rate Internal rate Number
IsBinaryServiceEnabled Boolean
ISPAccount ISP Account ISP Account String
ItemCode Item code Item code String

Property starting with J
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
JobCategory Job category Job category String
JobGroup String
JobLevel Scale Scale Number
JobTitle Job title Job title String
JobTitleDescription Job title Job title String
JobTitleLevel Job level Job level Number

Property starting with L
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Language Language code Language code String
LanguageDescription Language Language String
LastName Last name Last name String

Property starting with M
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
MaidenName Maiden name Maiden name String
ManagerFullName Manager Manager String
ManagerID Manager Manager Number
ManagerUserID Manager ID Manager ID String
MaritalState Marital state Marital state String
MaritalStateDate Marital state since Marital state since Date
MessageIDPicture GUID
MessageIDSignature GUID
MiddleName Middle name Middle name String
ModifiedDate Modified Modified Date
Modifier Modifier ID Modifier ID Number
ModifierName Modifier Modifier String
MsnID MsnID MsnID String

Property starting with N
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Nationality Nationality ID Nationality ID String
NationalityDescription Nationality Nationality String
NumberFreeField1 NumberField1 NumberField1 Number
NumberFreeField2 NumberField2 NumberField2 Number
NumberFreeField3 NumberField3 NumberField3 Number
NumberFreeField4 NumberField4 NumberField4 Number
NumberFreeField5 NumberField5 NumberField5 Number

Property starting with O
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
OffSetAccount OffSet G/L OffSet G/L String
OriginCountryCode Country of origin Country of origin String
OriginCountryDescription String

Property starting with P
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
PayeeName Payee Name Payee Name String
PaymentCondition PaymentCondition PaymentCondition String
PaymentConditionDescription String
PaymentLimit Number
PaymentMethod PaymentMethod PaymentMethod String
PhonePersonal Home telephone Home telephone String
PhonePersonalMobile Private mobile Private mobile String
PhoneWork Telephone Telephone String
PhoneWorkExtension Extension Extension String
PhoneWorkMobile Mobile Mobile String
PhoneWorkMobileExtension Mobile shortcut Mobile shortcut String
PhysicalLocation Location Location String
PhysicalLocationDescription Location Location String
PictureFilename Picture filename Picture filename String
PlaceOfBirth String
PostalAddressLine1 Address Address String
PostalAddressLine2 Address Address String
PostalCity City City String
PostalCountry Country Country String
PostalCountryDescription Country description Country description String
PostalKeepSameAsVisit Keep Same As Visit Keep Same As Visit Boolean
PostalPhone Phone Phone String
PostalPostCode PostCode PostCode String
PostalStateCode State State String
PostalStateDescription String
Postcode Postcode Postcode String
Prefix Prefix Prefix String
PrevRating Previous rating Previous rating String
PriceList String
PurchaseCurrency String
PurchaseLimit Purchase limit Purchase limit Number

Property starting with Q
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Qualifications Qualifications Qualifications String

Property starting with R
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Race Race Race String
Rating Rating Rating String
ReasonResign String
ResourceType Type Type String
RMALimit RMA orders RMA orders Number
Room Room Room String

Property starting with S
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
SalesInvoiceLimit Sales invoice Sales invoice Number
SalesOrderLimit Sales orders Sales orders Number
SecurityLevel Security level Security level Number
SignatureFile String
SkypeID SkypeID SkypeID String
SocialSecurityNumber Social security no. Social security no. String
State State State String
StateDescription String
Status Status Status String
Suffix Affix Affix String

Property starting with T
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
TextFreeField1 TextField1 TextField1 String
TextFreeField2 TextField2 TextField2 String
TextFreeField3 TextField3 TextField3 String
TextFreeField4 TextField4 TextField4 String
TextFreeField5 TextField5 TextField5 String
TimeZone TimeZones TimeZones Number
TimeZoneDescription Description Description String
Title Title Title String
TitleDescription Title Description Title Description String

Property starting with U
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
UserID User Name User Name String

Property starting with V
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
VacancyStartDate Date
VacancyType String
VatNumber VAT Number VAT Number String

Property starting with Y
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
YesNoFreeField1 YesNoField1 YesNoField1 Boolean
YesNoFreeField2 YesNoField2 YesNoField2 Boolean
YesNoFreeField3 YesNoField3 YesNoField3 Boolean
YesNoFreeField4 YesNoField4 YesNoField4 Boolean
YesNoFreeField5 YesNoField5 YesNoField5 Boolean

Detail information of properties

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
333,0,Default division
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