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 |