Database Table "hyp_Bad Client Leads"
Table Description
This table contains the duplicate / fictitious customer information in the system and the summary of the contact with them.Normal StorageNormal |
Archive StorageAccording to the administrator's decision and can still be updated in the archive! |
Deleted Storage(Recycle)Users with CRM administrator privileges and above can delete a client card including all its sub-tables provided there are no appointments or orders on the card |
Field Name | English Title | Data Type | Text Length | Editor | Attributes | json |
---|---|---|---|---|---|---|
Bad Lead Number | Integer | 0 | Edit | Read Only Key Field |
BadLeadNumber | |
Bad Lead Record Created On - UTC | FixDT | 0 | Edit | Read Only | BadLeadRecordCreatedOn-Utc | |
Status | Values List: 0 = Unknown Reason1 = Duplicated Lead 2 = Fictive Contact |
Status | 0 | Select | Status | |
Fictive Contact Reason | Values List: 0 = null, Empty1 = Child / Too Old 2 = Applicant denies that he was interested 3 = Phone / Email does not exists 4 = Abnormal behavior |
Status | 0 | Select | FictiveContactReason | |
Original Client Account Number | Integer | 0 | Edit | Read Only | OriginalClientAccountNumber | |
Agency | Status | 0 | Select | Agency | ||
Title | String | 15 | SelectEdit | Title | ||
Last Name | Name | 50 | Edit | LastName | ||
First Name | Name | 40 | Edit | FirstName | ||
3rd Optional Name | Name | 60 | Edit | 3rdOptionalName | ||
Client Full Name | String | 105 | Edit | Read Only | ClientFullName | |
String | 100 | Edit | ||||
Web Page | String | 60 | Edit | WebPage | ||
1st Phone | Mobile Phone | Phone | 20 | Edit | 1stPhone | |
2nd Phone | Office Phone | Phone | 20 | Edit | 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 |
Status | 0 | Select | 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 |
Status | 0 | Select | IdDocType | |
ID Doc Valid Until | Month | 0 | SelectEdit | Spare Field | IdDocValidUntil | |
Country Issuing ID | String | 40 | Select | CountryIssuingId | ||
Docs & Forms Language | Status | 0 | Select | DocsFormsLanguage | ||
Handling Status | Values List: 0 = New1 = Follow up 2 = Follow up + Meeting / P.Offer 3 = Client Not Interested 4 = Real Client 5 = Real Client + Club / Contract 6 = Problematic (Read Notes) |
Status | 0 | Select | Read Only | HandlingStatus |
Created On | FixDT | 0 | Edit | Read Only | CreatedOn | |
Created By | String | 40 | Edit | Read Only | CreatedBy | |
Middleman Account | Integer | 0 | Edit | Read Only | MiddlemanAccount | |
Middleman Name | String | 105 | PopupList | MiddlemanName | ||
Use Currency by Default | String | 5 | Select | UseCurrencyByDefault | ||
Data Source | String | 2 | Edit | Read Only | DataSource | |
Default Sales Agent | String | 40 | PopupList | DefaultSalesAgent | ||
Default Relationship Manager | String | 40 | PopupList | DefaultRelationshipManager | ||
Spare Agent 1 | String | 40 | PopupList | SpareAgent1 | ||
Spare Agent 2 | String | 40 | PopupList | SpareAgent2 | ||
Spare Agent 3 | String | 40 | PopupList | SpareAgent3 | ||
Popup Serious Note | String | 300 | TextMemo | PopupSeriousNote | ||
Relationship Abstract | String | 1000 | Memo | Read Only | RelationshipAbstract | |
Lead Supplier | String | 60 | Select | LeadSupplier | ||
Lead Status | Values List: 0 = Normal1 = Newly Created 2 = HOT Lead 3 = Interested Again |
Status | 0 | Select | LeadStatus |