Coupa Pay Statements Export

Export of CoupaPay Statements records is included as a Standard CSV Export.

CoupaPay Statements includes rows of types: Statement, Charge, ChargeAllocation, and ChargeTaxLine. The value of type in the first position determines what table of fields applies for that row.

Before publishing an integration format table you can rename most any field and reorder the fields, but it is probably best if you leave the type field in the first position because the value of type determines the structure for the row data that follows.

Exportable type is CoupaPay::Statement .

Statement

Field NameDescriptionField TypeRequired/UniquePossible Values
typeDescribes the type of row. Possible values are Statement, Charge, or ChargeAllocation.No/No
idCoupa internal ID for the statementintegerNo/No
statusThe status of thestring(255)No/No
payment-partner-nameThe name of the payment partnerNo/No
payment-partner-issuing-bankThe issuing bank of the payment partnerNo/No
payment-partner-supplier-nameThe name of the supplier associated to the payment partnerNo/No
payment-partner-supplier-numberThe number of the supplier associated to the payment partnerNo/No
external-ref-idThird party or partner document referencestring(255)Yes/No
coupa-pay-idCoupa Pay Internal ID of statementintegerNo/No
nameThe name of the statementstring(255)No/Yes
statement-dateDate of statementdatetimeYes/No
number-of-linesNumber of charges in statementintegerNo/No
amountTotal amount of statementdecimal(30,6)No/No
currencyCurrency of statementNo/No
unbacked-amountSum of charges on statement that are not associated to a POdecimal(30,6)No/No
number-of-unbacked-linesNumber of charges that do not have an associated POintegerNo/No