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 Storage

Normal

Archive Storage

According 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 Reason
1 = Duplicated Lead
2 = Fictive Contact
Status 0 Select Status
Fictive Contact Reason
Values List:
0 = null, Empty
1 = 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
Email String 100 Edit Email
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, Empty
1 = 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, Empty
1 = 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 = New
1 = 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 = Normal
1 = Newly Created
2 = HOT Lead
3 = Interested Again
Status 0 Select LeadStatus
Jump to tables index