What can we help you find? Products Coupa Product Documentation Integration Technical Documentation Coupa Core Flat Files (CSV) Flat File (CSV) Export Coupa Pay Statements Export

Coupa Pay Statements Export

The Coupa Pay Statements flat file integration object contains only a single set of header columns and charge lines.

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 .

Position	Column Name	Type	Description	Req/Unique	Allowable Values
1	type		Describes the type of row. Possible values are Statement, Charge, or ChargeAllocation. For this table the value of type would be: `Statement`	No/No	Statement, Charge, or ChargeAllocation
2	id	integer	Coupa internal ID for the statement	No/No	any
3	status	string(255)	The status of the charge	No/No	any
4	payment-partner-name		The name of the payment partner	No/No	any
5	payment-partner-issuing-bank		The issuing bank of the payment partner	No/No	any
6	payment-partner-supplier-name		The name of the supplier associated to the payment partner	No/No	any
7	payment-partner-supplier-number		The number of the supplier associated to the payment partner	No/No	any
8	external-ref-id	string(255)	Third party or partner document reference	Yes/No	any
9	coupa-pay-id	integer	Coupa Pay Internal ID of statement	No/No	any
10	name	string(255)	The name of the statement	No/Yes	any
11	statement-date	datetime	Date of statement	Yes/No	any
12	number-of-lines	integer	Number of charges in statement	No/No	any
13	amount	decimal(30,6)	Total amount of statement	No/No	any
14	currency		Currency of statement	No/No	any
15	unbacked-amount	decimal(30,6)	Sum of charges on statement that are not associated to a PO	No/No	any
16	number-of-unbacked-lines	integer	Number of charges that do not have an associated PO	No/No	any

Exportable type is Charge

Position	Column Name	Type	Description	Req/Unique	Allowable
1	type		Describes the type of row. Possible values are Statement, Charge, ChargeAllocation, or ChargeTaxLine. For this table the value of type would be: `Charge`	No/No	any
2	id	integer	Coupa internal ID for the charge	No/No	any
3	coupa-pay-statement-id	integer	Coupa Pay internal ID for the statement	No/No	any
4	statement-external-ref-id		A statement ID or Reference from the payment partner	No/No	any
5	statement-name		The name of the statement	No/No	any
6	coupa-pay-id	integer	Coupa Pay's Internal ID for the Statement	No/No	any
7	external-ref-id	string(255)	A charge ID or Reference from the payment partner	Yes/No	any
8	charge-date	datetime	Date of the charge	Yes/No	any
9	virtual-card-name		Name of the Virtual Card	No/No	any
10	virtual-card-coupa-pay-id		Coupa Pay internal ID of the virtual card	No/No	any
11	virtual-card-external-ref-id		A card ID or Reference from the payment partner	No/No	any
12	virtual-card-type		Type of the virtual card	No/No	any
13	virtual-card-order-header-po-number		PO number on the associated order header	No/No	any
14	virtual-card-po-id		Coupa internal ID of the associated order header	No/No	any
15	amount	decimal(30,6)	The amount in the credit card currency that was charged	No/No	any
16	currency		The currency the card card is issued in	Yes/No	any
17	merchant-amount	decimal(30,6)	The amount the merchant charged in the transaction	No/No	any
18	merchant-currency		The currency the merchant used in the transaction	No/No	any
19	mcc	string(255)	Merchant Category Code	No/No	any
20	supplier-name		The name from Coupa's supplier record for the supplier that charged the card	No/No	any
21	supplier-number		The number from Coupa's supplier record for the supplier that charged the card	No/No	any
22	merchant-reference	string(255)	The description provided by the credit card processor of who charged the card	No/No	any
23	tax-amount	decimal(30,6)	The tax amount charged in the transaction	No/No	any
24	tax-currency		The currency for the tax	No/No	any
26	accounting-total	decimal	Amount of charge in Chart Of Accounts Accounting Currency	No/No	any
27	accounting-currency		Currency Code for Accounting Total	No/No	any
28	virtual-card-document-id		The ID of the transactional document the card is associated with	No/No	any
29	issuer-bank-name		The name from Coupa's supplier record for the bank that issued the card	No/No	any
30	issuer-bank-number		The number from Coupa's supplier record for the bank that issued the card	No/No	any
31	issuer-reconciliation-id	string(255)	The charge reference as provided by the issuer bank	No/No	any
32	posting-date	datetime	Date the charge posted to the card's bank	No/No	any

Coupa Pay Charge Allocation columns

Exportable type is ChargeAllocation

Position	Column Name	Type	Description	Req/Unique	Allowable
1	type		Describes the type of row. Possible values are Statement, Charge, ChargeAllocation, or ChargeTaxLine. For this table the value of type would be: `ChargeAllocation` .	No/No	any
2	id	integer	Coupa internal ID for the charge allocation	No/No	any
3	statement-id		Coupa Pay internal ID for the associated Statement	No/No	any
4	statement-external-ref-id		A statement ID or Reference from the payment partner	No/No	any
5	statement-name		The name of the statement	No/No	any
6	charge-coupa-pay-id		Coupa Pay internal ID of the charge	No/No	any
7	charge-external-ref-id		External ref id of the charge	No/No	any
8	period-name		Name of the period	No/No	any
9	amount	decimal(30,6)	Amount of the charge allocation	No/No	any
10	currency		Currency of the charge allocation	Yes/No	any
11	pct	decimal(16,10)	The percentage of the total charge amount	Yes/No	any
12	account-name		The name of the account associated to the charge allocation	No/No	any
13	account-code		The code of the account associated to the charge allocation	No/No	any
14	account-type-name		The name of the COA associated to the charge allocation	No/No	any
15	charge-id	integer	The unique identifier Coupa assigns to the charge.	No/No	any

Charge Tax Line columns

Exportable type is ChargeTaxLine

Position	Column Name	Type	Description	Req/Unique	Allowable
1	type		Describes the type of row. Possible values are Statement, Charge, ChargeAllocation, or ChargeTaxLine. For this table the value of type would be: `ChargeTaxLine`	No/No	any
2	id	integer	The unique identifier Coupa assigns to the tax line.	No/Yes	any
3	charge-id	integer	The unique identifier Coupa assigns to the charge.	No/No	any
4	charge-coupa-pay-id	integer	Coupa Pay's Internal ID for the Statement	No/No	any
5	line-number	integer	The line number value corresponds to the CoupaPay Charge: id to which this tax line applies.	No/No	any
6	tax-amount		The amount of tax calculated on the line.	No/No	any
7	tax-currency		The currency of tax amount on the line.	No/No	any
8	tax-rate		The tax rate indicated on the line.	No/No	any
10	tax-code		The tax rate code for the line tax rate.	No/No	any
11	tax-code-country		The tax rate code country fo the line tax rate.	No/No	any
12	tax-code-description		The tax rate code description for the line tax rate.	No/No	any