What can we help you find?
Products
Total Spend Management Platform
Integration Playbooks and Resources
Other Integration Playbooks
Additional CSV Exports
Coupa Pay Payments Export
Coupa Pay Payments Export
Revised: 26 August 2022
Exportable type is
CoupaPay::Payment
| Column Name | Type | Description | Req/Unique | Allowable Values |
|---|---|---|---|---|
| Type | Describes the type of row. Possible values are Payment, Payment Details or Payment Detail Allocation. | No/No | any | |
| Payment ID | integer | The ID of the payment | No/No | any |
| Payment Batch ID | integer | The ID of the Payment Batch the payment belongs to | Yes/No | any |
| Payment Batch Type | The type of Payment Batch the payment belongs to. It can be an Invoice Payment Batch or Expense Payment Batch | No/No | any | |
| Payment Batch Status | The status of the Payment Batch the payment belongs to | No/No | any | |
| Payment Status | string(255) | The status of the payment | No/No | any |
| Created At | datetime | The date the payment was created on | No/No | any |
| Updated At | datetime | The date the payment was last updated on | No/No | any |
| Exported | A flag to check if the payment was already exported | No/No | any | |
| Pay From Account Name | The company payment account name used for the payment | No/No | any | |
| Pay From Account Kind | The company payment account type used for the payment | No/No | any | |
| Pay From Account Currency | The company payment account currency used for the payment | No/No | any | |
| Pay From Account Total | The total amount to be used for the payment from the company payment account | No/No | any | |
| Pay To Account Name | The payee's payment account name | No/No | any | |
| Pay To Account Kind | The payee's payment account type | No/No | any | |
| Pay to Account Currency | The payee's payment account currency | No/No | any | |
| Pay To Account Total | The total amount the payee is to be paid in its account currency | No/No | any | |
| Reporting Pay To Currency | The reported currency for the payee | No/No | any | |
| Reporting Pay To Total | decimal | The reported total amount to be paid based on payee's currency | No/No | any |
| Exchange Rate | decimal(30,9) | The exchange rate used for the payment | No/No | any |
| Payee ID | integer | A unique number identifing the payee. This is unique within each source transaction type | Yes/No | any |
| Payee Name | string(255) | The name of the payee | No/No | any |
| Payee Display Name | A commonly used name for the payee | No/No | any | |
| Payee Login | The login ID used for employees. This is blank for suppliers | No/No | any | |
| Payee Email | The email used by the payee to receive payment notifications | No/No | any | |
| Payee Number | A unique number identifing the payee. This is unique within each source transaction type | No/No | any | |
| Pay To Total | decimal | The total amount to be paid | No/No | any |
| Error Text | string(255) | Error text on completed with error payments | No/No | any |
| Digital Check Number | The digital check number when there is one attached to the payment | No/No | any | |
| Estimated Pay From Total | decimal | The estimated pay from total based on exchange rates loaded in the system | No/No | any |
| custom-field-1 | Integration Custom Field 1 | No/No | any | |
| custom-field-2 | Integration Custom Field 2 | No/No | any | |
| custom-field-3 | Integration Custom Field 3 | No/No | any | |
| custom-field-4 | Integration Custom Field 4 | No/No | any | |
| custom-field-5 | Integration Custom Field 5 | No/No | any | |
| custom-field-6 | Integration Custom Field 6 | No/No | any | |
| custom-field-7 | Integration Custom Field 7 | No/No | any | |
| custom-field-8 | Integration Custom Field 8 | No/No | any | |
| custom-field-9 | Integration Custom Field 9 | No/No | any | |
| custom-field-10 | Integration Custom Field 10 | No/No | any |