Visma – Import Suppliers
Stored procedures
esh_import_STAGING_SUPPLIER
Visma struct
ADK_DB_SUPPLIER
Field descriptions
Supplier
| Field no | Name | Field Name | Format | Table column | Comment |
|---|---|---|---|---|---|
| 1 | Company | - | Text | COMPANY | Set by installation |
| 2 | Department | - | Text | DEPT | Set by installation |
| 3 | Supplier number | ADK_SUPPLIER_NUMBER | Text | SUPPLIER_NO | |
| 4 | Supplier name | ADK_SUPPLIER_NAME | Text | SUPPLIER_NAME | |
| 5 | Email address | ADK_SUPPLIER_EMAIL | Text | ||
| 6 | Active | ADK_SUPPLIER_INACTIVE | Bool | ACTIVE | If inactive=1, Active=0 |
Supplier address
| Field no | Name | Field Name | Format | Table column | Comment |
|---|---|---|---|---|---|
| 1 | Address1 | ADK_SUPPLIER_MAILING_ADDRESS | Text | ADDRESS_1 | |
| 2 | Address2 | ADK_SUPPLIER_MAILING_ADDRESS2 | Text | ADDRESS_2 | |
| 3 | PostalCode | ADK_SUPPLIER_ZIPCODE | Text | POSTAL_CODE | |
| 4 | PostalDescription | ADK_SUPPLIER_CITY | Text | ||
| 5 | CountryCode | ADK_SUPPLIER_CODE_OF_COUNTRY | Text | COUNTRY | |
| 6 | PhoneNo | ADK_SUPPLIER_TELEPHONE | Text | PHONE_NO | |
| 7 | Use as mailing address | - | Bool | LETTER | Set by installation |
| 8 | Use as invoice address | - | Bool | INVOICE | Set by installation |
| 9 | AddressCode | - | Text | ADDRESS_CODE | Fixed Value "S" |