Database Table "hyp_Suppliers"

Table Description

The supplier card in Hyper.
Due to optimization considerations, inactive or unnecessary suppliers cards, can be removed to the archive. These cards can be manually moved back to the normal table of suppliers.

Normal Storage

Normal.

Archive Storage

According to the system admin decision. Still, this data can be modified in the archive.

Deleted Storage(Recycle)

users with authorizations of CRM managers or higher can delete a supplier card and its sub-tables, as long as there are no orders or meetings in this card.
Field Name English Title Data Type Text Length Editor Attributes json
Supplier Number Integer 0 Edit Read Only
Key Field		 SupplierNumber
Role
Values List:
0 = Unclassified
1 = Middleman
2 = For P.O. module
3 = LP / Broker		 Status 0 Select Role
Title String 15 SelectEdit Title
Last Name Name 50 Edit Mandatory LastName
First Name Name 40 Edit FirstName
3rd Optional Name Name 60 Edit 3rdOptionalName
Supplier Full Name String 105 Edit Read Only SupplierFullName
Email String 100 Edit Mandatory /G:1 Email
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, 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 = Did NOT Passed Qualification
3 = Not Interested in working with us
4 = Approved Supplier
5 = Active Supplier
6 = InActive / Suspended (Read Notes)		 Status 0 Select Read Only HandlingStatus
Locked Name & ID Bool 0 Edit Hidden
Read Only		 LockedNameId
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
Created On FixDT 0 Edit Read Only CreatedOn
Created By String 40 Edit Read Only CreatedBy
Use Currency by Default String 5 Select Mandatory UseCurrencyByDefault
Committed to pay VAT Bool 0 Select CommittedToPayVat
Produce International Documents by Default Bool 0 Select ProduceInternationalDocumentsByDefault
Send Official Documents to Primary Email Bool 0 Select SendOfficialDocumentsToPrimaryEmail
Default Expense Account Integer 0 PopupList DefaultExpenseAccount
Default Payment Terms
Values List:
0 = Cash
1 = Standard Credit
2 = Extra Credit
3 = Monthly Payments
4 = Consignation
5 = None		 Status 0 Select DefaultPaymentTerms
Credit Months Integer 0 Edit CreditMonths
Credit Days Integer 0 Edit CreditDays
Export Account to 3rd party Integer 0 Edit ExportAccountTo3rdParty
Gov Tax Authorities ID String 20 Edit GovTaxAuthoritiesId
Money Laundering
Values List:
0 = Casual Customer
1 = Remote Detection
2 = Face-to-face Identification
3 = Back Account "Closed Circuit"
4 = Not Regulated		 Status 0 Select MoneyLaundering
Industry Classification Code Integer 0 Edit Read Only IndustryClassificationCode
Industry Classification String 100 PopupList IndustryClassification
Middleman Commission % Rate Real 0 Edit MiddlemanCommissionRate
Agency Status 0 Select Agency
GIS Latitude Real 0 Edit Read Only GisLatitude
GIS Longitude Real 0 Edit Read Only GisLongitude
Default Purchasing Agent String 40 PopupList DefaultPurchasingAgent
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
Only for Groups String 250 GroupSelect OnlyForGroups
Only for Agencies String 200 GroupSelect OnlyForAgencies
Popup Serious Note String 300 TextMemo PopupSeriousNote
Relationship Abstract String 1000 Memo Read Only RelationshipAbstract
Last Phone call On FixDT 0 Edit Read Only LastPhoneCallOn
Last Phone call By String 40 Edit Read Only LastPhoneCallBy
Last Phone call / Try to call Result
Values List:
0 = null, Empty
1 = No Answer
2 = Left a Message
3 = Short Conversation
4 = Long Conversation		 Status 0 Select Read Only LastPhoneCallTryToCallResult
Next Phone call On FixDT 0 SelectEdit Read Only NextPhoneCallOn
Next Phone call By String 40 Edit Read Only NextPhoneCallBy
Last Contact On FixDT 0 Edit Read Only LastContactOn
Last Meeting On FixDT 0 Edit Read Only LastMeetingOn
First Meeting On FixDT 0 Edit Read Only FirstMeetingOn
First Proposal / Quotation On FixDT 0 Edit Read Only FirstProposalQuotationOn
Supplier Approval Date Date 0 SelectEdit Read Only SupplierApprovalDate
First Transaction Date Date 0 SelectEdit Read Only FirstTransactionDate
Last Transaction Date Date 0 SelectEdit Read Only LastTransactionDate
Mandatory Documents
Values List:
0 = Not Tested Yet
1 = Empty
2 = Missing
3 = OK		 Status 0 Select Read Only MandatoryDocuments
Review Status
Values List:
0 = No Need
1 = Waiting
2 = Confirmed
3 = Denied / Wrong		 Status 0 Select Read Only ReviewStatus
Jump to tables index