Skip to main content

 

 

Coupa Success Portal

Release 23 Flat File (CSV) Export Changes

Introduction

This list shows the changes we've made to our flat file (CSV) exports across the Coupa platform. Unless otherwise stated, all columns are new.

If a column is shown as hidden, this means the column won't appear in the export unless it's populated.

New export objects

These are the new export formats in R23:

Addresses (New)

Column Name Description Hidden Req'd Unique Type Allowable Values Feature
Name Nickname to help identify the address false false false string(255) any  
Location Code External Address Id false false true string(255) any  
Line 1 Street Line 1 of the address false true false string(100) any  
Line 2 Street Line 2 of the address false false false string(100) any  
City City of the address false true false string(50) any  
State State of the address false false false string(50) any  
Postal Code Zip code or postal code false true false string(50) any  
Country Code ISO standard Country Code false false false   any  
Attention Attention false false false string(255) any  
Active Active address? false false false boolean any  
Content Groups List of content group names seperated by semicolon false false false [] any  
VAT Number VAT Number false false false string(47) any  
Local Tax Number Local Tax Number false true false string(255) any  
VAT Country Code VAT Country Code false false false   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  

Inventory transaction valuation (New)

Added as part of Added as part of Inventory Adjustment API.

Column Description Hidden Req'd Unique Type Allowable Values
Record Type Describes the type of row. Possible value is Line Split. false false false   any
Inventory Transaction Id Coupa's Inventory Transaction ID. false false false integer any
Quantity Quantity of Valuation false true false decimal(30,6) any
Uom Code Uom Code from Coupa false false false   any
Currency The currency code of the valuation. false false false   any
Price Price of Valuation false false false decimal(30,6) any
custom-field-1 Integration Custom Field 1 false false false   any
custom-field-2 Integration Custom Field 2 false false false   any
custom-field-3 Integration Custom Field 3 false false false   any
custom-field-4 Integration Custom Field 4 false false false   any
custom-field-5 Integration Custom Field 5 false false false   any
custom-field-6 Integration Custom Field 6 false false false   any
custom-field-7 Integration Custom Field 7 false false false   any
custom-field-8 Integration Custom Field 8 false false false   any
custom-field-9 Integration Custom Field 9 false false false   any
custom-field-10 Integration Custom Field 10 false false false   any

Updated export objects

These are existing export formats that were updated in R23:

Expense line

Column Name Description Hidden Req'd Unique Type Allowable Values Feature
Applied Expense Line Cash Advance Amount Applied Expense Line Cash Advance Amount false false false   any Cash Advance
Applied Expense Line Cash Advance Currency Code Applied Expense Line Cash Advance Currency Code false false false   any Cash Advance

Invoice header

Column Name Description Hidden Req'd Unique Type Allowable Values Feature
date-received The date when the invoice is received by enterprise via email false false false   any Add AP inbox email details to invoice records
sender-email The sender email who sent the invoice to enterprise via email false false false   any Add AP inbox email details to invoice records
inbox-name Inbox which the invoice was received into false false false   any Add AP inbox email details to invoice records
amount-due Amount due to the supplier - Invoice Total without withholding and customer accounting taxes false false false decimal(46,6) any Customer accounting rate for Singapore
tax-due-to-supplier Tax due to the supplier false false false decimal(46,6) any Customer accounting rate for Singapore
customer-accounting-tax Customer accounting tax false false false decimal(46,6) any Customer accounting rate for Singapore

User

Column Name Description Hidden Req'd Unique Type Allowable Values Feature
AI Classification License AI Classification License false false false boolean any AI Classification Spend Visualization in Coupa
Spend Guard License Spend Guard License false false false boolean any Entitlement, Licenses, and Roles
  • Was this article helpful?