Skip to main content

 

 

Coupa Success Portal

Coupa Pay Payments Export

Coupa Pay Payments Columns

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

  • Was this article helpful?