Skip to main content

 

 

Coupa Success Portal

Release 19 Flat File (CSV) Export Changes

Expense Line

Column Name Description Hidden Required Unique Type Allowable Value
Corp Card Integration Name The integration name that is used received the transaction FALSE FALSE FALSE string(255) any

Invoice: Failed Tolerance (New)

Column Name Description Hidden Required Unique Type Allowable Value
code Code FALSE TRUE FALSE string(255) any
failable-id Failable ID FALSE FALSE FALSE integer any
failable-type Failable Type FALSE FALSE FALSE string(255) any
resolved Resolved FALSE FALSE FALSE boolean any
resolution-strategy Resolution Strategy FALSE FALSE FALSE string(25) any
breach-amount Breach Amount FALSE FALSE FALSE string(255) any
breach-limit Breach Limit FALSE FALSE FALSE string(255) any
breach-detail-1 Breach Detail 1 FALSE FALSE FALSE string(255) any
breach-detail-2 Breach Detail 2 FALSE FALSE FALSE string(255) any
breach-detail-3 Breach Detail 3 FALSE FALSE FALSE string(255) any

Invoice Header

Column Name Description Hidden Required Unique Type Allowable Value
series The serial number used by the Company for internal control of the information. FALSE FALSE FALSE string(255) any
folio-number The internal folio number used by the Company. FALSE FALSE FALSE string(255) any
use-of-invoice The purpose invoice is going to be used for. FALSE FALSE FALSE string(255) any
form-of-payment The specific code in accordance with a catalogue: cash, check, transfer of funds, etc. FALSE FALSE FALSE string(255) any
type-of-receipt Type of the invoice: income, expense, transfer, payroll or payment. FALSE FALSE FALSE string(255) any
payment-method Installments or lump sum payments. FALSE FALSE FALSE string(255) any
issuance-place Issuance Place FALSE FALSE FALSE string(255) any
confirmation This is a unique number provided by the Tax Authorities or the PAC. FALSE FALSE FALSE string(255) any
withholding-tax-override Withholding Tax Override FALSE FALSE FALSE decimal(30,3) any
Sole Registration Code Sole Registration Code FALSE FALSE FALSE string(255) any

 

Invoice Line

Column Name Description Hidden Required Unique Type Allowable Value
discount-amount Discount Amount FALSE FALSE FALSE decimal(30,3) any
company-uom The unit of measurement that the company uses internally (for comercial purposes). FALSE FALSE FALSE string(255) any
property-tax-account Property Tax Account FALSE FALSE FALSE string(255) any
commodity-name The Name of the Invoice Line Commodity FALSE FALSE FALSE string(255) any
supplier-part-number Part or identification number of the goods. FALSE FALSE FALSE string(255) any
customs-declaration-number Customs Declaration Number FALSE FALSE FALSE string(255) any

 

Matching Allocation (New)

Column Name Description Hidden Required Unique Type Allowable Value
type Describes the type of row FALSE FALSE FALSE MatchingAllocation' - String any
order-line-id The unique identifier Coupa assigns to the corresponding line on the purchase order (if any). FALSE FALSE FALSE integer any
order-header-number The order header number. FALSE FALSE FALSE string(20) any
order-line-num The order line number FALSE FALSE FALSE string(255) any
invoice-line-id The unique identifier Coupa assigns to the invoice line. FALSE FALSE FALSE integer any
receipt-id The unique identifier Coupa assigns to the receipt. FALSE FALSE FALSE integer any
match-reference-key The match reference key as described in the receipt used to trigger a match attempt to a candidate invoice line. FALSE FALSE FALSE string(255) any
quantity The quantity of the invoice line item. FALSE TRUE FALSE decimal(32,4) any
amount The total amount of the receipt allocation to this invoice line. FALSE TRUE FALSE decimal(32,4) any
uom The unit of measure code. It must already exist in Coupa. FALSE FALSE FALSE string(6) any
currency The currency code of the transaction. FALSE FALSE FALSE string(6) any
status Describes the current status of this allocation record, If the allocation described in this record is active or has been voided. Can have values in Void, Matched. FALSE FALSE FALSE string(50) any
custom-field-1 Integration Custom Field 1 FALSE FALSE FALSE string(255) any
custom-field-2 Integration Custom Field 2 FALSE FALSE FALSE string(255) any
custom-field-3 Integration Custom Field 3 FALSE FALSE FALSE string(255) any
custom-field-4 Integration Custom Field 4 FALSE FALSE FALSE string(255) any
custom-field-5 Integration Custom Field 5 FALSE FALSE FALSE string(255) any
custom-field-6 Integration Custom Field 6 FALSE FALSE FALSE string(255) any
custom-field-7 Integration Custom Field 7 FALSE FALSE FALSE string(255) any
custom-field-8 Integration Custom Field 8 FALSE FALSE FALSE string(255) any
custom-field-9 Integration Custom Field 9 FALSE FALSE FALSE string(255) any
custom-field-10 Integration Custom Field 10 FALSE FALSE FALSE string(255) any

 

Tag (New)

Column Name Description Hidden Required Unique Type Allowable Value
id ID FALSE FALSE FALSE integer any
name Name FALSE TRUE TRUE string(30) any
description Description FALSE FALSE FALSE text any
system-tag System Tag FALSE FALSE FALSE boolean any

 

Tagging (New)

Column Name Description Hidden Required Unique Type Allowable Value
id ID FALSE FALSE FALSE integer any
tag-id Tag ID FALSE FALSE FALSE integer any
taggable-id Taggable ID FALSE FALSE FALSE integer any
description Description FALSE FALSE FALSE text any
active Active FALSE FALSE FALSE boolean any

 

Tax Line

Column Name Description Hidden Required Unique Type Allowable Value
kind-of-factor Kind of Factor indicates the specific type of Withholding which applies to the line item FALSE FALSE FALSE string(255) any
basis Basis indicates the base amount of the invoice or line item to which you must apply the withholding tax FALSE FALSE FALSE decimal(30,6) any
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 FALSE string(255) any

 

User

Column Name Description Hidden Required Unique Type Allowable Value
Analytics User Analytics User License? FALSE FALSE FALSE boolean any
Default Locale Added new locales: de-BE, de-LU, en-HK, en-MY, en-NZ, fr-LU, ro, sr, de-BE, de-LU, en-HK, en-MY, en-NZ, fr-LU, ro, sr N/A de-BE, de-LU, en-HK, en-MY, en-NZ, fr-LU, ro, sr, de-BE, de-LU, en-HK, en-MY, en-NZ, fr-LU, ro, sr

 

  • Was this article helpful?