Addresses Import

Last updated
Save as PDF

Overview

The Address Import process reads files from the ./Incoming/Addresses/ in the SFTP. These files are moved to the archive folder located at ./Incoming/Archive/Addresses/ before being processed in alphanumeric order.

You can perform an update only for an address record that is active in Coupa. An update on an inactive address results in a new record being created.

Keys

ID, Location Code, [Name, Line1, Line2, City, State, Postal Code, Country Code', Attention]

Validations

You can update anything using "ID". You can update every field (except for "ID") using "Location Code". If you don't have either "ID" or "Location Code", we use the combination of [Name, Line1, Line2, City, State, Postal Code, Country Code', Attention] to look up for an existing address; if not found, we create a new record.

Company Address Columns

Column Name	Description	Req'd	Unique	Type	Allowable Values
Name	Address "nickname"	Yes	No	string(255)
Id	This is the internal, unique Coupa database record identifier	No	Yes	integer(11)
Active	"No" will make the address inactive making it no longer available to users. "Yes" will make it active and available to users.	No	No	boolean	Yes,No/True,False/Y,N/T,F
Line 1	Address Line 1	Yes	No	string(100)
Line 2	Address Line 2	No	No	string(100)
City	City name	Yes	No	string(50)
State	State abbreviation	No	No	string(50)
Postal Code	Postal Code	Yes	No	string(50)
Country Code	ISO Country Code. Must Already Exist in Coupa.	Yes	No	string(4)	Any ISO3166-1 two letter country code
Attention	Address Default Attention Line	No	No	string(255)
Content Groups	If specifying more than one content group, use a comma to separate each content group name. Max 100 characters per content group name.	No	No	string(100)
Location Code	Optional Field for ERP Address Code	No	Yes	string(255)
VAT ID		No	No	string(47)
Local Tax Number		No	No	string(255)
Fiscal Representative Address		No	No