Tax Code Export

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

Tax Line

Field NameDescriptionField TypeRequired/UniquePossible Values
typeDescribes the type of row. Possible values are Header, Line, Line Split, Tax Line, or Payment.No/No
invoice-idThe unique identifier Coupa assigns to the invoice.No/No
invoice-numberThe user-created invoice number.No/No
invoice-line-idThe unique identifier Coupa assigns to the invoice line.No/No
invoice-line-numberThe line number of the corresponding invoice line.No/No
invoice-charge-idThe unique identifier Coupa assigns to the invoice chargeNo/No
invoice-charge-numberThe line number of the invoice chargeNo/No
tax-line-numberThe line number of the corresponding of the tax line.integerNo/No
tax-line-idThe unique identifier Coupa assigns to the tax line.integerNo/No
amountThe amount of tax calculated on the line.decimal(32,4)No/No
rateThe tax rate indicated on the invoice line.floatNo/No
tax-rate-typeThe tax rate type description on the lineNo/No
codeThe tax rate code for the invoice line tax rate. Must match an existing tax rate code within Coupa.No/No
amount-engineAmount calculated by either Coupa Native or External Tax Engine based on configurationdecimal(32,4)No/No
code-engineCode returned by External Tax Engine based on configurationstring(255)No/No
rate-engineRate returned by External Tax Engine based on configurationdecimal(30,6)No/No
descriptionThe tax line description.string(255)No/No
locationThe taxable location for this tax line.string(255)No/No
dateThe tax line date in the format YYYY-MM-DDTHH:MM:SS+HH:MM.datetimeNo/No
kind-of-factorKind of Factor indicates the specific type of Withholding which applies to the line itemstring(255)No/No
basisBasis indicates the CFDI base amount of the invoice or line item to which withholding tax was applieddecimal(30,6)No/No
Base AmountBase indicates the base amount of the invoice or line item to which tax was applieddecimal(30,4)No/No
Supplier Withholding RateCFDI Withholding Ratedecimal(30,4)No/No
Supplier Withholding AmountCFDI Withholding Amountdecimal(30,4)No/No
nature-of-taxNature of Tax indicates the specific type of tax which applies to the line item e.g. VAT or Withholdingstring(255)No/No
Withholding AmountWithholding Amountdecimal(30,4)No/No
Direct/Withholding Tax/TCS TaxWithholdingTaxLine, TcsTaxLine or TaxLinestring(255)No/No
product-tax-classificationProduct Tax Classificationstring(255)No/No
product-tax-classification-cclasstribProduct Tax Classification(cClasTrib)string(255)No/No
amount-devtribTax Amount Returned(vDevTrib)decimal(30,4)No/No
amount-credpresPresumed Credit Amount(vCredPres)decimal(30,4)No/No
amount-deferredTax Amount Deferred(vDif)decimal(30,4)No/No

Withholding Tax Line

Field NameDescriptionField TypeRequired/UniquePossible Values
typeDescribes the type of row. Possible values are Header, Line, Line Split, Tax Line, or Payment.No/No
invoice-idThe unique identifier Coupa assigns to the invoice.No/No
invoice-numberThe user-created invoice number.No/No
invoice-line-idThe unique identifier Coupa assigns to the invoice line.No/No
invoice-line-numberThe line number of the corresponding purchase order line (if any).No/No
tax-line-numberThe line number of the corresponding of the tax line.integerNo/No
tax-line-idThe unique identifier Coupa assigns to the tax line.integerNo/No
amountThe amount of tax calculated on the line.decimal(32,4)No/No
rateThe tax rate indicated on the invoice line.floatNo/No
codeThe tax rate code for the invoice line tax rate. Must match an existing tax rate code within Coupa.No/No
descriptionThe tax line description.string(255)No/No
locationThe taxable location for this tax line.string(255)No/No
dateThe tax line date in the format YYYY-MM-DDTHH:MM:SS+HH:MM.datetimeNo/No
kind-of-factorKind of Factor indicates the specific type of Withholding which applies to the line itemstring(255)No/No
basisBasis indicates the CFDI base amount of the invoice or line item to which withholding tax was applieddecimal(30,6)No/No
Withholding BaseBase indicates the base amount of the invoice or line item to which withholding tax was applieddecimal(30,4)No/No
Supplier Withholding RateCFDI Withholding Ratedecimal(30,4)No/No
Supplier Withholding AmountCFDI Withholding Amountdecimal(30,4)No/No
nature-of-taxNature of Tax indicates the specific type of tax which applies to the line item e.g. VAT or Withholdingstring(255)No/No
Withholding AmountWithholding Amountdecimal(30,4)No/No
Direct/Withholding TaxWithholdingTaxLine or TaxLinestring(255)No/No