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.
|
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 |