Field mappings
Mappings for fields in Coupa and Global Tax Determination
| Coupa Field | Description | Data Type | Global Tax Determination Field | Required or Optional |
|---|---|---|---|---|
| ID | Unique identifier for the invoice in Coupa | Integer | trnDocNum | Required |
| Invoice-date | Date of invoice | DateTime | docDt | Required |
| Delivery-date | Date of delivery | DateTime | dlvrDt | Optional |
| paid | Indicates whether a transaction has been paid | Boolean | isAudit | Required if auditing |
| invoice-number | Unique number entered when creating the invoice | String | trnDocNum | Required |
| currency.code | String | currn | Required | |
| shipping-amount | Float | dlvrAmt | Optional | |
| misc-amount | Float | dlvrAmt | Optional | |
| handling-amount | Float | dlvrAmt | Optional | |
| document-type | Indicates whether a transaction is an invoice or a credit note | String | trnTp | Required |
| supplier.name | String | custVendName | Required | |
| supplier.number | String | custVendCd | Required | |
| bill-to-address. street1 | String | sFStNameNum | Optional | |
| bill-to-address. city | String | bTCity | Optional | |
| bill-to-address. state | String | bTStateProv | Optional | |
| bill-to-address. postal-code | String | bTPstlCd | Optional | |
| bill-to-address. country.code | String | bTCountry | Optional | |
| ship-from-address. street1 | String | sF StNameNum | Optional | |
| ship-from-address. city | String | sFCity | Optional | |
| ship-from-address. state | String | sFStateProv | Optional | |
| ship-from-address. postal-code | String | sFPstlCd | Optional | |
| ship-from-address. country.code | String | sFCountry | Optional | |
| ship-to-address. street1 | String | sT StNameNum | Required | |
| ship-to-address. city | String | sTCity | Required | |
| ship-to-address. state | String | sTStateProv | Required | |
| ship-to-address. postal-code | String | sTPstlCd | Required | |
| ship-to-address. country.code | String | sTCountry | Required | |
| invoice-line.line-num | Integer | lnItmNum | Required | |
| invoice-line. commodity.id | Integer | goodSrvCd | Optional | |
| invoice-line. description | String | goodSrvDesc | Optional | |
| invoice-line. quantity | Decimal | qnty | Required | |
| invoice-line. price | Decimal | grossAmt | Required | |
| type | Indicates whether a line item is based on quantity (product) or amount (service) | String | Required | |
| gtd_tax | Tax amount from Global Tax Determination | String | Optional | |
| Gtd_taxrate | Tax rate from Global Tax Determination | String | Optional | |
| Gtd_jurisdiction | Taxing jurisdictions from Global Tax Determination | String | Optional | |
| sovos-custom-field-1 | Custom fields used to store additional information about the transaction | String | SOVOS_CA_1 | Optional |
| sovos-custom-field-2 | String | SOVOS_CA_2 | Optional | |
| sovos-custom-field-3 | String | SOVOS_CA_3 | Optional | |
| sovos-custom-field-4 | String | SOVOS_CA_4 | Optional | |
| sovos-custom-field-5 | String | SOVOS_CA_5 | Optional | |
| sovos-custom-field-6 | String | SOVOS_CA_6 | Optional | |
| sovos-custom-field-7 | String | SOVOS_CA_7 | Optional | |
| sovos-custom-field-8 | String | SOVOS_CA_8 | Optional | |
| sovos-custom-field-9 | String | SOVOS_CA_9 | Optional | |
| sovos-custom-field-10 | String | SOVOS_CA_10 | Optional | |
| bypass-gtd | If true, Coupa will not send a tax calculation request to Global Tax Determination | Boolean | Required |