Visma – Import Contacts
Stored procedure
esh_import_STAGING_CONTACT
Visma struct
ADK_DB_CONTACT
Field descriptions
| Field no | Name | Field Name | Format | Table column | Comment |
|---|---|---|---|---|---|
| 1 | Company | - | Text | COMPANY | Set by installation |
| 2 | Department | - | Text | DEPT | set by installation |
| 3 | Contact No | ADK_CONTACTS_ID | Double | CUSTOMER_NO | |
| 4 | Contact code | ADK_CONTACTS_SIGN | Text | CONTACT_CODE | |
| 5 | Contact name | ADK_CONTACTS_NAME | Text | CONTACT_NAME | |
| 6 | Phone | ADK_CONTACTS_TELEPHONE | Text | PHONE_NO | |
| 7 | Email address | ADK_CONTACTS_EMAIL | Text | E_MAIL_1 | |
| 8 | Contact job title | ADK_CONTACTS_TITLE | Text | JOB_TITLE | |
| 9 | Mobile phone | ADK_CONTACTS_MOBILEPHONE | Text | MOBILE_PHONE_NO | |
| 10 | Contact info | ADK_CONTACTS_NOTES | Text | CONTACT_INFO |