Skip to main content

 

 

Coupa Success Portal

Charges Export

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

Charge columns

Position Column Name Type Description Req/Unique Allowable
1 type   Describes the type of row. Possible values are Statement, Charge, or ChargeAllocation. 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 Yes/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

 

  • Was this article helpful?