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.
Note
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.
| Column Name |
Description |
Req'd |
Unique |
Type |
Allowable Values |
| Name |
Your business entity's address name |
Yes |
No |
string(255) |
|
| Id |
This is the unique identifier (database ID) Coupa assigns when a new Business Entity record is created. It can't be modified, but can be used to update the record. |
No |
Yes |
integer(11) |
None. Assigned by Coupa. |
| 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 |
Your business entity's address line 1 |
Yes |
No |
string(255) |
|
| Line 2 |
Your business entity's address line 2 |
No |
No |
string(255) |
|
| City |
Your business entity's address city name |
Yes |
No |
string(255) |
|
| State |
Your business entity's address state abbreviation |
No |
No |
string(255) |
|
| State ISO Code |
ISO Code for the State |
No |
No |
string(255) |
|
| Postal Code |
Your business entity's address postal code |
Yes |
No |
string(255) |
|
| Country Code |
Your business entity's 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 |
Field generally for supplier values which are synced from Coupa Supplier Portal into the tax registration table. Field not available in UI to reduce likelihood of manual change. |
No |
No |
string(255) |
|
| Local Tax Number |
Field generally for supplier values which are synced from Coupa Supplier Portal into the tax registration table. Field not available in UI to reduce likelihood of manual change. |
No |
No |
string(255) |
|
| Fiscal Representative Address |
|
No |
No |
|
|
