Visma – Import Customers
Stored procedures
esh_import_STAGING_CUSTOMER
esh_import_STAGING_ADDRESS
Visma struct
ADK_DB_CUSTOMER
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 | Customer number | ADK_CUSTOMER_NUMBER | Text | CUSTOMER_NO | |
| 4 | Customer search name | ADK_CUSTOMER_SHORT_NAME | Text | SEARCH_NAME | |
| 5 | Customer name | ADK_CUSTOMER_NAME | Text | CUSTOMER_NAME | |
| 6 | Country | ADK_CUSTOMER_CODE_OF_COUNTRY | Text | COUNTRY | Phone country prefix |
| 7 | Salesman code | ADK_CUSTOMER_SELLER | Text | SALESMAN_CODE | Customer main sales person |
| 8 | Email address | ADK_CUSTOMER_EMAIL | Text | E_MAIL | |
| 9 | Phone | ADK_CUSTOMER_TELEPHONE | Text | PHONE_NO | |
| 10 | Fax | ADK_CUSTOMER_FAX | Text | FAX_NO | |
| 11 | Bank Id | ADK_CUSTOMER_BGIRO | Text | BANK_ID | |
| 12 | Organization number | ADK_CUSTOMER_ORGANISATION_NUMBER | Text | ORGANIZATION_NO | |
| 13 | Address line 1 | ADK_CUSTOMER_MAILING_ADDRESS | Text | ADDRESS1 | |
| 14 | Address line 2 | ADK_CUSTOMER_MAILING_ADDRESS2 | Text | ADDRESS2 | |
| 15 | Visit Address | ADK_CUSTOMER_VISITING_ADDRESS | Text | ADDRESS1 | |
| 16 | City | ADK_CUSTOMER_CITY | Text | POST_LOCATION | |
| 17 | Postcode | ADK_CUSTOMER_ZIPCODE | Text | POSTAL_CODE | |
| 18 | Sorting group 1 | ADK_CUSTOMER_CATEGORY | Text | SORTGROUP_1 | Sort groups for free use to categorize your customers |
| 19 | Credit terms | ADK_CUSTOMER_CODE_OF_TERMS_OF_PAYMENT | Text | CREDIT_TERM_CODE | |
| 20 | Delivery terms | ADK_CUSTOMER_CODE_OF_TERMS_OF_DELIVERY | Text | DELIVERY_TERM | |
| 21 | Means of delivery | ADK_CUSTOMER_CODE_OF_WAY_OF_DELIVERY | Text | MEANS_OF_DELIVERY | |
| 22 | Credit limit | ADK_CUSTOMER_CREDIT_LIMIT | Double | CREDIT_LIMIT | |
| 23 | Pricelist number | ADK_CUSTOMER_PRICE_LIST | Text | PRICE_LIST | Price used for the customer. Values 1-5 (linked to the sales prices in the article module) |
| 24 | Calculate tax | ADK_CUSTOMER_EXPORT | Bool | CALCULATE_VAT | 1 = Yes 0 = No |
| 25 | Customer reference | ADK_CUSTOMER_REFERENCE | Text | CONTACT_NAME | |
| 26 | Customer information | ADK_CUSTOMER_REMARK1 + ADK_CUSTOMER_REMARK2 | Text | INFORMATION | |
| 27 | Customer status | ADK_CUSTOMER_INACTIVE | Text | STATUS | 0 = Customer, 1 = Prospect |
| 28 | Delivery name | ADK_CUSTOMER_DELIVERY_NAME | Text | ADDRESS_NAME | |
| 29 | Delivery address 1 | ADK_CUSTOMER_DELIVERY_ADDRESS | Text | ADDRESS_1 | |
| 30 | Delivery address 2 | ADK_CUSTOMER_DELIVERY_ADDRESS2 | Text | ADDRESS_2 | |
| 31 | Delivery city | ADK_CUSTOMER_DELIVERY_CITY | Text | POST_LOCATION | |
| 32 | Delivery address zip code | ADK_CUSTOMER_DELIVERY_ZIPCODE | Text | POSTAL_CODE | |
| 33 | Delivery address country | ADK_CUSTOMER_DELIVERY_CODE_OF_COUNTRY | Text | COUNTRY | Phone country prefix |
| 34 | Use invoice fee | ADK_CUSTOMER_DISPATCH_FEE | Bool | INVOICE_FEE | up to 2 decimals |
| 35 | External number | Text | EXTERNAL_SYSTEM_KEY | ||
| 36 | Delivery address city/location | ADK_CUSTOMER_DELIVERY_EANLOC | Text | POST_LOCATION | Delivery address postal location |