Coupa Pay Payments Export

Export of these records is included as part of Standard CSV Export.

Exportable type is CoupaPay::Payment.

Payment

Field NameDescriptionField TypeRequired/UniquePossible Values
TypeDescribes the type of row. Possible values are Payment, Payment Details or Payment Detail AllocationNo/No
Payment IDThe ID of the paymentintegerNo/No
Payment Batch IDThe ID of the Payment Batch the payment belongs tointegerNo/No
Payment Batch TypeThe type of Payment Batch the payment belongs to. It can be an Invoice Payment Batch or Expense Payment BatchNo/No
Payment Batch StatusThe status of the Payment Batch the payment belongs toNo/No
Payment StatusThe status of the paymentstring(255)No/No
Created AtThe date the payment was created ondatetimeNo/No
Updated AtThe date the payment was last updated ondatetimeNo/No
ExportedA flag to check if the payment was already exportedNo/No
Pay From Account NameThe company payment account name used for the paymentNo/No
Pay From Account KindThe company payment account type used for the paymentNo/No
Pay From Account CurrencyThe company payment account currency used for the paymentNo/No
Pay From Account TotalThe total amount to be used for the payment from the company payment accountNo/No
Pay To Account NameThe payee's payment account nameNo/No
Pay To Account KindThe payee's payment account typeNo/No
Pay to Account CurrencyThe payee's payment account currencyNo/No
Pay To Account TotalThe total amount the payee is to be paid in its account currencyNo/No
Reporting Pay To CurrencyThe reported currency for the payeeNo/No
Reporting Pay To TotalThe reported total amount to be paid based on payee's currencydecimalNo/No
Exchange RateThe exchange rate used for the paymentdecimal(30,9)No/No
Payee IDA unique number identifing the payee. This is unique within each source transaction typeintegerNo/No
Payee NameThe name of the payeestring(255)No/No
Payee Display NameA commonly used name for the payeeNo/No
Payee LoginThe login ID used for employees. This is blank for suppliersNo/No
Payee EmailThe email used by the payee to receive payment notificationsNo/No
Payee NumberA unique number identifing the payee. This is unique within each source transaction typeNo/No
Pay To TotalThe total amount to be paiddecimalNo/No
Error TextError text on completed with error paymentstextNo/No
Digital Check NumberThe digital check number when there is one attached to the paymentNo/No
Estimated Pay From TotalThe estimated pay from total based on exchange rates loaded in the systemdecimalNo/No
Source NameSource Name provided for payments loaded from external sourcestring(255)No/No
Source ReferenceSource Reference provided for payments in an external sourcestring(255)No/No
Payment TypeThe Payment TypeNo/No
DescriptionDescription provided describing the paymentstring(255)No/No
Payment IdentifierPayment Identifier provided used to reference the paymentstring(255)No/No
Legal Entity nameLegal Entity nameNo/No
Transfer TypeTransfer Type is used by the Bank or Payment Partner and defines how a payment will need to be processed (ACH, WIRE, Standard, Next Day, Same Day)string(255)No/No
Requested Execution DateWhen sending payment instructions to a bank, the Requested Execution Date can be used to request the bank to initiate a payment on a specific datedatetimeNo/No
Total Processed by PayeeAmount of total charges processed by payeeNo/No
Value DateValue DatedateNo/No

Coupa Pay-Payment Detail

Field NameDescriptionField TypeRequired/UniquePossible Values
TypeDescribes the type of row. Possible values are Payment, Payment Details or Payment Detail AllocationNo/No
Payment Detail IDThe ID of the payment detailintegerNo/No
Payment IDThe ID of the payment the payment detail belongs tostring(255)No/No
Payment Batch IDThe ID of the payment batch the payment detail belongs toNo/No
Source Transaction IDThe ID of source for the payment detailNo/No
Source Transaction TypeThe type of source for the payment detail. Possible values are Payables::Invoice or Payables::Expense. Legacy values are CoupaPay::Invoice or CoupaPay::ExpenseNo/No
Source Transaction NumberThe reference ID of the source for the payment detailNo/No
Transaction TotalThe total transaction amount for the payment detaildecimalNo/No
Discount TotalThe total discount amount for the payment detaildecimalNo/No
Adjustment TotalThe total adjusted amount for the payment detaildecimalNo/No
Currency CodeThe currency of the payment to the recipientNo/No
Payment TotalThe total payment amount for the payment detaildecimalNo/No

Payment Detail Allocation

Field NameDescriptionField TypeRequired/UniquePossible Values
TypeDescribes the type of row. Possible values are Payment, Payment Details or Payment Detail AllocationNo/No
Payment Detail Allocation IDThe ID of the payment detail allocationintegerNo/No
Payment IDThe ID of the payment the payment detail belongs toNo/No
Payment Detail IDThe ID of the payment detail the allocation belongs toNo/No
Source Transaction From IDThe ID of the transaction that emitted the allocationNo/No
Source Transaction From TypeThe type of the transaction that emitted the allocation. Possible values are InvoiceHeader.No/No
Source Transaction From NumberThe reference ID of the transaction that emitted the allocationNo/No
Source Transaction From AmountThe amount sent by the transaction that emitted the allocationNo/No
Source Transaction From CurrencyThe currency for the amount sent by the transaction that emitted the allocationNo/No
Source Transaction To IDThe ID of the receiving transactionNo/No
Source Transaction To TypeThe type of the receiving transaction. Possible values are InvoiceHeader.No/No
Source Transaction To NumberThe reference ID of the receiving transactionNo/No
Source Transaction To AmountThe amount sent to the receiving transactionNo/No
Source Transaction To CurrencyThe currency for the amount sent to the receiving transactionNo/No
SourceThe source of this allocation. Possible values are coupa_pay.string(255)No/Nocoupa_pay, erp, ui, api, csv, early_pay_discount
Reason CodeThe reason code for the most recent change to this allocation.string(40)No/Nopayment, auto_payment, epr, epr_rejected, manual