Coupa Pay Payments Export
Coupa's payments flat file integration object contains only a single set of header columns.
Export of these records is included as part of Standard CSV Export.
Coupa pay payment columns
Exportable type is CoupaPay::Payment
| Position | Column Name | Description | Type | Req/Unique | Allowable Values |
|---|---|---|---|---|---|
| 1 | Type | Describes the type of row. Possible values are Header, Line, Line Split, Tax Line, or Payment. | - | No/No | |
| 2 | Payment Date | The date the payment was made | datetime | No/No | |
| 3 | Payment Type | The type of payment that was made | string(255) | No/No | |
| 4 | Amount Paid | The total amount paid | decimal(32,4) | No/No | |
| 5 | Payable ID | The document ID that is being paid | integer(11) | No/No | |
| 6 | Created By ID | The user ID that created the payment | integer(11) | No/No | |
| 7 | Created By Login | The user login that created the invoice payment | string(255) | No/No | |
| 8 | Created Date | The date the payment initially drafted | datetime | No/No | |
| 9 | Updated By ID | The user ID that most recently updated the payment | integer(11) | No/No | |
| 10 | Updated By Login | Ther user login that most recently updated the invoice payment | string(255) | No/No | |
| 11 | Updated Date | The date the payment was most recently updated | datetime | No/No | |
| 12 | Notes | Notes associated with the payment | string(255) | No/No | |
| 13 | Payment Type | The payment type | No/No | any | |
| 14 | Description | Description provided describing the payment | string(255) | No/No | any |
| 15 | Payment Identifier | Payment Identifier provided used to reference the payment | string(255) | No/No | any |
Coupa pay payment detail columns
Exportable type is CoupaPay::PaymentDetail
| Column Name | Type | Description | Req/Unique | Allowable Values |
|---|---|---|---|---|
| Type | Describes the type of row. Possible values are Payment or Payment Details | No/No | any | |
| Payment Detail ID | integer | The ID of the payment detail | No/No | any |
| Payment ID | string(255) | The ID of the payment the payment detail belongs to | Yes/No | any |
| Payment Batch ID | The ID of the payment batch the payment detail belongs to | No/No | any | |
| Source Transaction ID | The ID of source for the payment detail | No/No | any | |
| Source Transaction Type | The type of source for the payment detail. Possible values are Payables::Invoice or Payables::Expense | No/No | any | |
| Source Transaction Number | The reference ID of the source for the payment detail | No/No | any | |
| Transaction Total | decimal | The total transaction amount for the payment detail | No/No | any |
| Discount Total | decimal | The total discount amount for the payment detail | No/No | any |
| Adjustment Total | decimal | The total adjusted amount for the payment detail | No/No | any |
| Currency Code | The currency of the payment to the recipient | No/No | any | |
| Payment Total | decimal | The total payment amount for the payment detail | No/No | any |
| Source | The source of this allocation. Possible values are coupa_pay. | No/No | any |
Coupa pay payment detail allocation columns
Exportable type is CoupaPay::PaymentDetailAllocation
| 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 Detail Allocation ID | integer | The ID of the payment detail allocation | No/No | any |
| Payment ID | The ID of the payment the payment detail belongs to | No/No | any | |
| Payment Detail ID | The ID of the payment detail the allocation belongs to | No/No | any | |
| Source Transaction From ID | The ID of the transaction that emitted the allocation | No/No | any | |
| Source Transaction From Type | The type of the transaction that emitted the allocation. Possible values are InvoiceHeader. | No/No | any | |
| Source Transaction From Number | The reference ID of the transaction that emitted the allocation | No/No | any | |
| Source Transaction From Amount | The amount sent by the transaction that emitted the allocation | No/No | any | |
| Source Transaction From Currency | The currency for the amount sent by the transaction that emitted the allocation | No/No | any | |
| Source Transaction To ID | The ID of the receiving transaction | No/No | any | |
| Source Transaction To Type | The type of the receiving transaction. Possible values are InvoiceHeader. | No/No | any | |
| Source Transaction To Number | The reference ID of the receiving transaction | No/No | any | |
| Source Transaction To Amount | The amount sent to the receiving transaction | No/No | any | |
| Source Transaction To Currency | The currency for the amount sent to the receiving transaction | No/No | any | |
| Source | string(255) | The source of this allocation. Possible values are coupa_pay. | No/No | coupa_pay, erp, ui, csv |
| Reason Code | string(40) | The reason code for the most recent change to this allocation. | No/No | payment, auto_payment, epr, epr_rejected, manual |