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