Skip to main content

 

 

Coupa Success Portal

Release 20 Flat File (CSV) Export Changes

All columns are new unless otherwise specified.

Contract

Column Name Details
Expires This column is now required

Expense Line

Column Name Description Req'd Unique Type Allowable Values Feature
Applied Expense Preapproval Id Applied Expense Preapproval Id FALSE FALSE   any Expense Pre-Approvals
Applied Expense Preapproval Description Applied Expense Preapproval Id FALSE FALSE   any Expense Pre-Approvals
Applied Expense Preapproval Amount Applied Expense Preapproval Amount FALSE FALSE   any Expense Pre-Approvals
Applied Expense Preapproval Currency Code Applied Expense Preapproval Currency Code FALSE FALSE   any Expense Pre-Approvals

Invoicing

Invoice Header

Column Name Description Req'd Unique Type Allowable Values Feature
payment-order-reference A code given by banks to use it instead of a bank account transfer. FALSE FALSE string(255) any
QST Registration Number The Registration Authority column was renamed  QST Registration Number Mexico Compliant Invoicing

Invoice Line

Column Name Description Req'd Unique Type Allowable Values Feature
unspsc UNSPSC FALSE FALSE string(255) any Mexico Compliant Invoicing

Tax Line

Column Name Description Req'd Unique Type Allowable Values Feature
Withholding Base Base indicates the base amount of the invoice or line item to which withholding tax was applied FALSE FALSE decimal(30,4) any Withholding Tax
Supplier Withholding Rate CFDI Withholding Rate FALSE FALSE decimal(30,4) any Mexico Compliant Invoicing
Supplier Withholding Amount CFDI Withholding Amount FALSE FALSE decimal(30,4) any Mexico Compliant Invoicing
Withholding Amount Withholding Amount FALSE FALSE decimal(30,4) any Withholding Tax
Direct/Withholding Tax WithholdingTaxLine or TaxLine FALSE FALSE string(255) any Withholding Tax

Withholding Tax Line (NEW)

Column Name Description Req'd Unique Type Allowable Values Feature
type Describes the type of row. Possible values are Header, Line, Line Split, Tax Line, Withholding Tax Line or Payment. FALSE FALSE string Withholding Tax Line Withholding Tax
invoice-id The unique identifier Coupa assigns to the invoice. FALSE FALSE integer(11) any Withholding Tax
invoice-number The user-created invoice number. FALSE FALSE string(255) any Withholding Tax
invoice-line-id The unique identifier Coupa assigns to the invoice line. FALSE FALSE integer(11) any Withholding Tax
invoice-line-number The line number of the corresponding purchase order line (if any). FALSE FALSE   any Withholding Tax
tax-line-number The line number of the corresponding of the tax line. FALSE FALSE integer(11) any Withholding Tax
tax-line-id The unique identifier Coupa assigns to the tax line. FALSE FALSE integer(11) any Withholding Tax
amount The amount of tax calculated on the line. FALSE FALSE decimal(32,4) any Withholding Tax
rate The tax rate indicated on the invoice line. FALSE FALSE float any Withholding Tax
code The tax rate code for the invoice line tax rate. Must match an existing tax rate code within Coupa. FALSE FALSE   Must match an existing tax rate code within Coupa. Withholding Tax
description The tax line description. FALSE FALSE string(255) any Withholding Tax
location The taxable location for this tax line. FALSE FALSE string(255) any Withholding Tax
date The tax line date in the format YYYY-MM-DDTHH:MM:SS+HH:MM. FALSE FALSE datetime any Withholding Tax
kind-of-factor Kind of Factor indicates the specific type of Withholding which applies to the line item FALSE FALSE string(255) any Withholding Tax
basis Basis indicates the CFDI base amount of the invoice or line item to which withholding tax was applied FALSE FALSE decimal(30,6) any Withholding Tax
Withholding Base Base indicates the base amount of the invoice or line item to which withholding tax was applied FALSE FALSE decimal(30,4) any Withholding Tax
Supplier Withholding Rate CFDI Withholding Rate FALSE FALSE decimal(30,4) any Withholding Tax
Supplier Withholding Amount CFDI Withholding Amount FALSE FALSE decimal(30,4) any Withholding Tax
nature-of-tax Nature of Tax indicates the specific type of tax which applies to the line item e.g. VAT or Withholding FALSE FALSE string(255) any Withholding Tax
Withholding Amount Withholding Amount FALSE FALSE decimal(30,4) any Withholding Tax
Direct/Withholding Tax WithholdingTaxLine or TaxLine FALSE FALSE string(255) WithholdingTaxLine or TaxLine Withholding Tax

User

Column Name Details
Default Locale New locales added: en-ME, en-PH,
  • Was this article helpful?