• Last edited on: 04 February 2019

Remit-to Addresses Import

The remit-to address integration loader uses only a single set of header columns.

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.

Column Name Description Req'd Unique Type Allowable Values
Name Nickname that will help users identify the address TRUE FALSE string(255) any
Id This is the unique identifier (database ID) Coupa assigns when a new record is created. It can’t be modified, but can be used to update the record. 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(255) any
Line2 Street Line 2 of the address FALSE FALSE string(255) any
City* City of the address TRUE FALSE string(255) any
State State of the address FALSE FALSE string(255) any
State ISO Code ISO Code for the State FALSE FALSE string(255) any
Postal Code* Enter in the zip code or postal code TRUE FALSE string(255) 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
External Src Ref External Src Ref FALSE FALSE string(255) any
External Src Name External Src Name FALSE FALSE string(255) any
custom-field-1 Integration Custom Field 1 false false string(255) any
custom-field-2 Integration Custom Field 2 false false string(255) any
custom-field-3 Integration Custom Field 3 false false string(255) any
custom-field-4 Integration Custom Field 4 false false string(255) any
custom-field-5 Integration Custom Field 5 false false string(255) any
custom-field-6 Integration Custom Field 6 false false string(255) any
custom-field-7 Integration Custom Field 7 false false string(255) any
custom-field-8 Integration Custom Field 8 false false string(255) any
custom-field-9 Integration Custom Field 9 false false string(255) any
custom-field-10 Integration Custom Field 10 false false string(255) any
custom-field-11 Integration Custom Field 11 false false string(255) any
custom-field-12 Integration Custom Field 12 false false string(255) any
custom-field-13 Integration Custom Field 13 false false string(255) any
custom-field-14 Integration Custom Field 14 false false string(255) any
custom-field-15 Integration Custom Field 15 false false string(255) any
custom-field-16 Integration Custom Field 16 false false string(255) any
custom-field-17 Integration Custom Field 17 false false string(255) any
custom-field-18 Integration Custom Field 18 false false string(255) any
custom-field-19 Integration Custom Field 19 false false string(255) any
custom-field-20 Integration Custom Field 20 false false string(255) any

Related Items


Budget Line Adjustment Import

01 February 2019

The Budget Line Adjustment integration loader uses only a single set of header columns.

Enterprise Import

03 February 2019

The Enterprises integration loader uses only a single set of header columns.

Exchange Rate Import

03 February 2019

The exchange rates integration loader uses only a single set of header columns.

Expense Category Import

03 February 2019

The Expense Category loader uses only a single set of header columns.