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 |
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 |
|
|
