Skip to main content

 

 

Coupa Success Portal

Remit-to Addresses Import

Overview

The Remit To Address Import process read files from ./Incoming/RemitToAddresses/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/RemitToAddresses/ before being processed in alphanumeric order.

Keys

  • Id
  • Supplier Number
  • Remit To Code.

Validations

You can update any field if you specify Id. If there's no Id, then Coupa uses the combination of Supplier Number and Remit To Code to lookup an existing record.

Remit-to Address Columns

Column Name Description Req'd Unique Type Allowable Values
Name Nickname that will help users identify the address TRUE FALSE string(255) any
Id Coupa's unique ID for the remit-to address FALSE TRUE integer(11) any
Active Possible values are yes or no FALSE FALSE boolean Yes/No, True/False, Y/N, T/F
Line1* Street Line 1 of the address TRUE FALSE string(100) any
Line2 Street Line 2 of the address FALSE FALSE string(100) any
City* City of the address TRUE FALSE string(50) any
State State of the address FALSE FALSE string(255) any
Postal Code* Enter in the zip code or postal code TRUE FALSE string(50) any
Country Code* Enter in 2-digit ISO standard Country Code TRUE FALSE string(4) Any ISO3166-1 two letter country code
Attention Fill in if you want a specific person or group to be in the attention field on the address FALSE FALSE string(255) any
Address Type Indicates that this address is a remit to address or not. Should be RemitToAddress. TRUE FALSE string(255) RemitToAddress
Supplier Number Enter supplier number for remit to address TRUE FALSE string(255) Supplier Number for an existing supplier
Remit To Code* Unique identifying code per supplier TRUE TRUE string(255) any
Tax Number Remit To Address Tax Number FALSE FALSE string(255) any
Tax Country Code Remit To Address Tax Country Code FALSE FALSE string(4) any
Local Tax Number Local Tax Number FALSE FALSE string(255) any
  • Was this article helpful?