Skip to main content

 

 

Coupa Success Portal

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)  
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    
  • Was this article helpful?