Skip to main content

 

 

Coupa Success Portal

Coupa Pay Payments Export

Export of these records is included as a 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  

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 CoupaPay::Invoice or CoupaPay::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
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

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
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

 

  • Was this article helpful?