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