What can we help you find?
Products
Total Spend Management Platform
Integration Playbooks and Resources
Other Integration Playbooks
Additional CSV Exports
Addresses Export
Addresses Export
Revised: 28 May 2019
Overview
The addresses export file is placed into ./Outgoing/Addresses.
| Position | Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|---|
| 1 | Name | Nickname to help identify the address | FALSE | FALSE | string(255) | any |
| 2 | Location Code | External Address Id | FALSE | TRUE | string(255) | any |
| 3 | Line 1 | Street Line 1 of the address | TRUE | FALSE | string(255) | any |
| 4 | Line 2 | Street Line 2 of the address | FALSE | FALSE | string(255) | any |
| 5 | City | City of the address | TRUE | FALSE | string(255) | any |
| 6 | State | State of the address | FALSE | FALSE | string(255) | any |
| 7 | Postal Code | Zip code or postal code | TRUE | FALSE | string(255) | any |
| 8 | Country Code | ISO standard Country Code | FALSE | FALSE | string(6) | any |
| 9 | Attention | Attention | FALSE | FALSE | string(255) | any |
| 10 | Active | Active address? | FALSE | FALSE | boolean | any |
| 11 | Content Groups | List of content group names separated by semicolon | FALSE | FALSE | any | |
| 12 | VAT Number | VAT Number | FALSE | FALSE | string(255) | any |
| 13 | Local Tax Number | Local Tax Number | TRUE | FALSE | string(255) | any |
| 14 | VAT Country Code | VAT Country Code | FALSE | FALSE | string(6) | any |
| 15 | custom-field-1 | Integration Custom Field 1 | FALSE | FALSE | string(255) | any |
| 16 | custom-field-2 | Integration Custom Field 2 | FALSE | FALSE | string(255) | any |
| 17 | custom-field-3 | Integration Custom Field 3 | FALSE | FALSE | string(255) | any |
| 18 | custom-field-4 | Integration Custom Field 4 | FALSE | FALSE | string(255) | any |
| 19 | custom-field-5 | Integration Custom Field 5 | FALSE | FALSE | string(255) | any |
| 20 | custom-field-6 | Integration Custom Field 6 | FALSE | FALSE | string(255) | any |
| 21 | custom-field-7 | Integration Custom Field 7 | FALSE | FALSE | string(255) | any |
| 22 | custom-field-8 | Integration Custom Field 8 | FALSE | FALSE | string(255) | any |
| 23 | custom-field-9 | Integration Custom Field 9 | FALSE | FALSE | string(255) | any |
| 24 | custom-field-10 | Integration Custom Field 10 | FALSE | FALSE | string(255) | any |