Share your thoughts about your self-service experience by completing this year’s survey.
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 |