Skip to main content

 

 

Coupa Success Portal

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.

Coupa Pay Statement columns

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

Coupa Pay Charge columns

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. 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
25 custom-field-1   Integration Custom Field 1 No/No any
26 custom-field-2   Integration Custom Field 2 No/No any
27 custom-field-3   Integration Custom Field 3 No/No any
28 custom-field-4   Integration Custom Field 4 No/No any
29 custom-field-5   Integration Custom Field 5 No/No any
30 custom-field-6   Integration Custom Field 6 No/No any
31 custom-field-7   Integration Custom Field 7 No/No any
32 custom-field-8   Integration Custom Field 8 No/No any
33 custom-field-9   Integration Custom Field 9 No/No any
34 custom-field-10   Integration Custom Field 10 No/No any
35 accounting-total decimal Amount of charge in Chart Of Accounts Accounting Currency No/No any
36 accounting-currency   Currency Code for Accounting Total 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 custom-field-1   Integration Custom Field 1 No/No any
16 custom-field-2   Integration Custom Field 2 No/No any
17 custom-field-3   Integration Custom Field 3 No/No any
18 custom-field-4   Integration Custom Field 4 No/No any
19 custom-field-5   Integration Custom Field 5 No/No any
20 custom-field-6   Integration Custom Field 6 No/No any
21 custom-field-7   Integration Custom Field 7 No/No any
22 custom-field-8   Integration Custom Field 8 No/No any
23 custom-field-9   Integration Custom Field 9 No/No any
24 custom-field-10   Integration Custom Field 10 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. 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

 

  • Was this article helpful?