| | 1 | Email | E-mail | Email | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Email | | GroupPrompt | | | HelpText | @SYS28179 (E-mail of contact person) | | Label | | | Mandatory | No | | Name | Email | | SaveContents | Yes | | StringSize | 80 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 2 | Telex | Telex number | Telex | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Telex | | GroupPrompt | | | HelpText | @SYS26097 (Telex number for contact person) | | Label | | | Mandatory | No | | Name | Telex | | SaveContents | Yes | | StringSize | 20 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 3 | CellularPhone | Mobile phone | PhoneMobile | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | PhoneMobile | | GroupPrompt | | | HelpText | @SYS21226 (Mobile phone number) | | Label | | | Mandatory | No | | Name | CellularPhone | | SaveContents | Yes | | StringSize | 20 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 4 | PhoneLocal | Extension | PhoneLocal | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | PhoneLocal | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | PhoneLocal | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 5 | Telefax | Fax | TeleFax | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | TeleFax | | GroupPrompt | | | HelpText | @SYS26098 (Fax number for contact person) | | Label | | | Mandatory | No | | Name | Telefax | | SaveContents | Yes | | StringSize | 20 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 6 | URL | WWW address | URL | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | URL | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | URL | | SaveContents | Yes | | StringSize | 255 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 7 | Phone | Telephone | Phone | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Phone | | GroupPrompt | | | HelpText | @SYS337 (Contact person's telephone number) | | Label | | | Mandatory | No | | Name | Phone | | SaveContents | Yes | | StringSize | 20 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| TR | 8 | State | State | StateId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | StateId | | GroupPrompt | | | HelpText | @SYS21815 (State in a country) | | Label | | | Mandatory | No | | Name | State | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| TR | 9 | County | County | CountyId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | CountyId | | GroupPrompt | | | HelpText | @SYS17939 (County pertaining to the address) | | Label | | | Mandatory | No | | Name | County | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| TR FK | 10 | Country | Country | CountryId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | CountryId | | GroupPrompt | | | HelpText | @SYS26099 (Country the address is attached to) | | Label | | | Mandatory | No | | Name | Country | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| FK | 11 | Zipcode | Postal (Zip) code | ZipCodeId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | ZipCodeId | | GroupPrompt | | | HelpText | @SYS17938 (Postal (Zip) code pertaining to the address) | | Label | | | Mandatory | No | | Name | Zipcode | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 12 | Address | Address | Addressing | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | Addressing | | GroupPrompt | | | HelpText | @SYS28178 (Address of contact person) | | Label | | | Mandatory | No | | Name | Address | | SaveContents | Yes | | StringSize | 250 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 13 | Name | Contact person | ContactPersonName | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | ContactPersonName | | GroupPrompt | | | HelpText | @SYS13368 (Name of contact person) | | Label | | | Mandatory | Yes | | Name | Name | | SaveContents | Yes | | StringSize | 30 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| X | PK | 14 | ContactPersonId | Contact ID | ContactPersonId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | ContactPersonId | | GroupPrompt | | | HelpText | @SYS16201 (Unique identification of contact person) | | Label | | | Mandatory | Yes | | Name | ContactPersonId | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | No |
|
| FK | 15 | Title | Title | PersonTitle | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | PersonTitle | | GroupPrompt | | | HelpText | @SYS26100 (Title of contact person) | | Label | | | Mandatory | No | | Name | Title | | SaveContents | Yes | | StringSize | 30 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 16 | WebEnabled | Access from Internet | WebEnabled | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | EnumType | NoYes | | ExtendedDataType | WebEnabled | | GroupPrompt | | | HelpText | @SYS26101 (Specifies whether contact person is allowed to access data via the Internet.) | | Label | | | Mandatory | No | | Name | WebEnabled | | SaveContents | Yes | | Table | ContactPerson | | Type | Enum | | Visible | Yes |
|
| | 17 | WebPassword | Password | WebPassword | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | WebPassword | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | WebPassword | | SaveContents | Yes | | StringSize | 20 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| TR FK | 18 | VendAccount | Vendor account | VendAccount | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | VendAccount | | GroupPrompt | | | HelpText | @SYS26104 (Contact person's attachment to a supplier) | | Label | | | Mandatory | No | | Name | VendAccount | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| TR FK | 19 | CustAccount | Customer account | CustAccount | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | CustAccount | | GroupPrompt | | | HelpText | @SYS26103 (Contact person's attachment to a customer) | | Label | | | Mandatory | No | | Name | CustAccount | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| TR FK | 20 | ProjId | Project | ProjId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | ProjId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ProjId | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| FK | 21 | WebLogin | Login name | WebLogin | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | WebLogin | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | WebLogin | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 22 | WebAdmin | Administrator | ECPContactAdmin | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | EnumType | NoYes | | ExtendedDataType | ECPContactAdmin | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | WebAdmin | | SaveContents | Yes | | Table | ContactPerson | | Type | Enum | | Visible | Yes |
|
| | 23 | City | City | City | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | City | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | City | | SaveContents | Yes | | StringSize | 30 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 24 | Street | Street name | AddressingStreet | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AddressingStreet | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Street | | SaveContents | Yes | | StringSize | 250 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 26 | SMS | SMS | SMS | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | SMS | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | SMS | | SaveContents | Yes | | StringSize | 80 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| TR | 27 | RefZipCode | Reference | RefRecId | Integer | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | RefRecId | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | RefZipCode | | SaveContents | Yes | | Table | ContactPerson | | Type | Integer | | Visible | Yes |
|
| | 28 | WebRequestAccess | Request internet access | WebRequestWebAccess | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | WebRequestWebAccess | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | WebRequestAccess | | SaveContents | Yes | | Table | ContactPerson | | Type | Enum | | Visible | Yes |
|
| | 29 | birthDate | Birthday | BirthDate | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | HRMAdministration | | ExtendedDataType | BirthDate | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | birthDate | | SaveContents | Yes | | Table | ContactPerson | | Type | Date | | Visible | Yes |
|
| FK | 30 | DEL_companyContactId | Company contact | DEL_HRMCompanyContactId | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | DEL_HRMCompanyContactId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_companyContactId | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| TR FK | 31 | RelAccount | Relation account | smmRelationAccount | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | smmRelationAccount | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | RelAccount | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 32 | DEL_SMS | SMS | smmSMS | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | SysDeletedObjects30 | | ExtendedDataType | smmSMS | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DEL_SMS | | SaveContents | Yes | | StringSize | 80 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 33 | firstName | First name | HRMFirstName | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | HRMFirstName | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | firstName | | SaveContents | Yes | | StringSize | 20 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 34 | middleName | Middle name | HRMMiddleName | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | HRMMiddleName | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | middleName | | SaveContents | Yes | | StringSize | 20 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 35 | lastName | Last name | HRMLastName | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | HRMLastName | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | lastName | | SaveContents | Yes | | StringSize | 20 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 36 | salutation | Salutation | HRMSalutation | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | HRMSalutation | | ExtendedDataType | | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | salutation | | SaveContents | Yes | | Table | ContactPerson | | Type | Enum | | Visible | Yes |
|
| | 37 | nameSuffix | Suffix | HRMNameSuffix | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | HRMNameSuffix | | ExtendedDataType | | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | nameSuffix | | SaveContents | Yes | | Table | ContactPerson | | Type | Enum | | Visible | Yes |
|
| FK | 38 | DEL_PBAUserProfile | User profile | PBAUserProfile | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | PBAUserProfile | | GroupPrompt | | | HelpText | @GLS42900 (User profile in the Product Builder) | | Label | | | Mandatory | No | | Name | DEL_PBAUserProfile | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 39 | Mainresponsible | Main contact | smmContactPersonMainResponsible | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | smmContactPersonMainResponsible | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Mainresponsible | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|
| | 40 | ContactPersonParentId | Superior | SmmContactPersonParentId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | SmmContactPersonParentId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ContactPersonParentId | | SaveContents | Yes | | StringSize | 10 | | Table | ContactPerson | | Type | String | | Visible | Yes |
|