Database Table "hyp_Client Contacts"
Table Description
In this table, the contacts linked to or working for the client are updatedNormal StorageReal customers and leads in care |
Archive StorageIrrelevant leads. Can be updated in the archive! |
Deleted Storage(Recycle)Depending on the permissions a client file can be deleted provided it has no meetings or sales documents |
| Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
|---|---|---|---|---|---|---|
| File Number | Integer | 0 | Edit | Hidden Read Only Key Field |
FileNumber | |
| Created On | FixDT | 0 | SelectEdit | Read Only Key Field |
CreatedOn | |
| Agency / Division Name | String | 40 | SelectEdit | AgencyDivisionName | ||
| Title | String | 15 | SelectEdit | Title | ||
| Last Name | Name | 50 | Edit | Mandatory /G:2 | LastName | |
| First Name | Name | 40 | Edit | Mandatory /G:2 | FirstName | |
| 3rd Optional Name | Name | 60 | Edit | 3rdOptionalName | ||
| Contact Full Name | String | 105 | Edit | Read Only | ContactFullName | |
| Job Title | String | 100 | Edit | Spare Field | JobTitle | |
| String | 100 | Edit | Mandatory /G:1 | |||
| Web Page | String | 60 | Edit | WebPage | ||
| 1st Phone | Mobile Phone | Phone | 20 | Edit | Mandatory /G:1 | 1stPhone |
| 2nd Phone | Office Phone | Phone | 20 | Edit | Mandatory /G:1 | 2ndPhone |
| 3rd Phone | Phone | 20 | Edit | 3rdPhone | ||
| Fax | Phone | 20 | Edit | Fax | ||
| Street Address | String | 80 | PopupEdit | StreetAddress | ||
| City | String | 40 | PopupEdit | City | ||
| Region | String | 40 | PopupEdit | Region | ||
| Country | String | 40 | Select | Country | ||
| Zip Code | String | 15 | Edit | ZipCode | ||
| Building / Apartment / Office Instructions | String | 80 | Edit | BuildingApartmentOfficeInstructions | ||
| Use a Different Mailing Address | String | 160 | TextMemo | UseADifferentMailingAddress | ||
| Gender | Values List: 0 = null, Empty1 = Male 2 = Female 3 = Private Company 4 = Public Company 5 = Branch / Office / Site |
Status | 0 | Select | Mandatory | Gender |
| Birthday | Date | 0 | SelectEdit | Birthday | ||
| ID Number | Serial | 20 | Edit | IdNumber | ||
| ID Doc Type | Values List: 0 = null, Empty1 = National ID 2 = National Passport 3 = Travel ID (certificate) 4 = ICA ID (certificate) 5 = Corporation ID 6 = Fellowship 7 = Foreign Company Registered Locally 8 = Self-Employed (National ID) |
Status | 0 | Select | Mandatory | IdDocType |
| ID Doc Valid Until | Month | 0 | SelectEdit | Spare Field | IdDocValidUntil | |
| Country Issuing ID | String | 40 | Select | CountryIssuingId | ||
| Title in English | Values List: Mr.Sir Miss Mrs. Ms. Doctor Professor Lord |
String | 15 | SelectEdit | TitleInEnglish | |
| Last Name in English | Name | 50 | Edit | LastNameInEnglish | ||
| First Name in English | Name | 40 | Edit | FirstNameInEnglish | ||
| Contact Full Name in English | String | 105 | Edit | Read Only | ContactFullNameInEnglish | |
| Marital Status | Values List: 0 = null, Empty1 = Single 2 = Married 3 = Divorced 4 = Widow / er 5 = Publicly Known |
Status | 0 | Select | Spare Field | MaritalStatus |
| ID Number 2 | Serial | 20 | Edit | IdNumber2 | ||
| ID Doc Type 2 | Values List: 0 = null, Empty1 = National ID 2 = National Passport 3 = Travel ID (certificate) 4 = ICA ID (certificate) 5 = Corporation ID 6 = Fellowship 7 = Foreign Company Registered Locally 8 = Driving License |
Status | 0 | Select | IdDocType2 | |
| ID Doc Valid Until 2 | Month | 0 | SelectEdit | Spare Field | IdDocValidUntil2 | |
| Country Issuing ID 2 | String | 40 | Select | CountryIssuingId2 | ||
| Legal Status / Role | Values List: Controlling ShareholderCommissioned Beneficiary Guarantor Account Partner 3rd Party Relative (3rd Party) Business Partner (3rd Party) |
String | 200 | GroupSelect | LegalStatusRole | |
| Allow to Receive Official Documents | Bool | 0 | Select | AllowToReceiveOfficialDocuments | ||
| Former - Disabled | Bool | 0 | Select | Former-Disabled | ||
| Sorter | Integer | 0 | Edit | Hidden Read Only |
Sorter | |
| Accept Commercial Info to Cell phone | FixDT | 0 | SelectEdit | Read Only | AcceptCommercialInfoToCellPhone | |
| Question to use cell phone | Values List: 0 = Not Asked Yet1 = Website Form 2 = Landing Page 3 = Phone Conversation 4 = Email 5 = Text Message 6 = Paper Form |
Status | 0 | Select | QuestionToUseCellPhone | |
| Accept Commercial Info to Email | FixDT | 0 | SelectEdit | Read Only | AcceptCommercialInfoToEmail | |
| Question to use Email | Values List: 0 = Not Asked Yet1 = Website Form 2 = Landing Page 3 = Phone Conversation 4 = Email 5 = Text Message 6 = Paper Form |
Status | 0 | Select | QuestionToUseEmail | |
| Partnership Hyper Client Account | Integer | 0 | PopupList | PartnershipHyperClientAccount | ||
| Percentage of Partnership in this Account | Real | 0 | Edit | PercentageOfPartnershipInThisAccount | ||
| AML Risk Management | Values List: 0 = Not Relevant - No Bank Account1 = Pending Decision 2 = Blocked 3 = Manual Confirm Every Trans. 4 = Allow All Transactions |
Status | 0 | Select | AmlRiskManagement | |
| Website Authorization | Values List: 0 = None1 = Readonly 2 = Closed Circuit 3 = Authorized Signatory |
Status | 0 | Select | WebsiteAuthorization | |
| Portal Password | String | 50 | Edit | Hidden Read Only |
PortalPassword | |
| Time Based OTP Token | String | 12 | Edit | Hidden Read Only |
TimeBasedOtpToken |