Name of the table: BIContacts
| Field names | Description |
| PK_BIContactID | Internal unique reference |
| FK_BICompanyID | Internal unique reference |
| PRI_CustomerID | Internal unique reference |
| AddressID | Contact address |
| AddressType |
0 = person 2 = anonymous 3 = internal 4 = anonymized |
| ContactNr | Contact number |
| Contact Type |
0 = Lead 1 = Prospect 2 = Client More details, please see Contact categorisation: Leads, Prospects and Customers |
| IsActive |
True = active False = inactive |
| IsRetailer |
True = retailer False = not retailer |
| Firstname | Contact's first name |
| Surname | Contact's surname |
| Initials | Contact's initials |
| TitleCode | Contact's title code |
|
TitleValue |
Contact's title value |
| ApproachCode | Contact's approach code |
|
ApproachValue |
Contact's approach value |
| GroupCode | Contact's group code |
| GroupValue | Contact's group value |
| MiscValue | Contact's miscellaneous value |
| MiscCode | Contact's miscellaneous code |
| Addr | Contact's address |
| ZipCode | Contact's zip code |
| City | Contact's city |
| DistrictCode | Contact's district code |
| DistrictValue | Contact's district value |
| CountryCode | Contact's country code |
| CountryValue | Contact's country value |
| PhoneWork | Contact's phone number |
| PhoneHome | Contact's home phone number |
| Mobile | Contact's mobile phone number |
| Fax | Contact's fax number |
| Contact's email address | |
| DateCreate | Date when the contact was created |
| DateBirth | Contact's date of birth |
| LanguageID | Language for the contact |
| ExternalReference | Contact's external reference |
| FK_AuthorLoginName | Internal unique reference |
| AuthorFirstname | First name of the user that created the contact |
| AuthorName | Name of the user that created the contact |
| MAXLastChangeProfile | Latest date when the profile was changed |
| MAXLastChangeProject | Latest date when a project was changed |
| MAXDateOffer | Latest offer date for this contact |
| MAXDateOrder | Latest order date for this contact |
| MAXDateApprovedForOrder | Latest date when a project was approved for order for this contact |
| MAXDateDelivery | Latest delivery date for this contact |
| MAXProjectID | Latest project created for this contact |
| MAXQuestionnaireAnswerID | Latest questionnaire answer for this contact |
| MAXDateOrderSign | Latest order signature date for this contact |
| MAXLastChangeShopEntry | Latest shop entry change date for this contact |
| DateUpdatedBISynch | Date of the last update of this record in the BI |
| DateCreatedBISynch | Date of creation of this record in the BI |
| BIDeleted | Date of deletion of this record in the BI |
| PRI_AddressID | Unique internal reference |
Comments
0 comments
Article is closed for comments.