Addresses Import
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) | |
| Line 3 | Street Line 3 of the address. (Hidden. Add manually to templates to use). | No | No | string(100) | |
| Line 4 | Street Line 4 of the address. (Hidden. Add manually to templates to use). | 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 |