Skip to main content

 

 

Coupa Success Portal

R29 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 exports

These are new export formats that were added in R29.

Coupa Pay: Invoice

Added as part of CSV Export of Coupa Pay::Invoice.

Column Description Hidden Req'd Unique Type Allowable Values
type Describes the type of row. Possible value is Invoice false false false   any
id The ID of the invoice false false false integer any
created-at The date the invoice was created on false false false datetime any
updated-at The date the invoice was last updated on false false false datetime any
status The status of the invoice false false false string(255) any
paid-date The date the invoice was marked as fully paid false false false datetime any
paid-total The total amount paid false false false decimal any
remaining-total The total amount remaining to be paid false false false decimal any
remittance-total The total remittance amount required false false false decimal any
accounting-total The total of the invoice in the CoA currency false false false decimal any
exported A flag indicating if the invoice has been marked as exported false false false   any
last-exported-at The date that the invoice was last marked as exported false false false datetime any
discount-amount The discount amount taken false false false   any
discount-rate The discount rate taken false false false   any
document-type The type of invoice false false false   any
payment-channel The payment channel on the associated InvoiceHeader false false false   any
payable-type The type of associated payable. Value is InvoiceHeader false false false   any
payable-id The ID of the associated InvoiceHeader false false false   any
net-due-date The net due date of the invoice false false false   any
supplier-name The suppliers name from the associated InvoiceHeader false false false   any
supplier-number The suppliers number from the associated InvoiceHeader false false false   any
invoice-number The invoice number from the associated InvoiceHeader false false false   any
chart-of-account-code The Chart of Accounts name false false false   any
legal-entity-name The Chart of Accounts Legal Entity name false false false   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

Procurement Milestone

Added as part of Payment Agreements.

Column Description Hidden Req'd Unique Type Allowable Values
record-type Milestone false false false   any
type Type false false false string(255) any
status Status false false false string(255) any
percent Percent false false false decimal(30,6) any
amount Amount false false false decimal(30,6) any
description Description false false false text any
due-date Due date false false false date any
external-reference-code External reference code false false false string(255) any
payment-terms-code Payment Terms false false false   any
payment-terms-days-for-discount-payment Number of days to pay to receive discount false false false   any
payment-terms-days-for-net-payment Net Days for Payment false false false   any
payment-terms-discount-rate Discount Rate for payment within Discount Terms 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

Project

Added as part of Enhanced Task Management.

Column Description Hidden Req'd Unique Type Allowable Values
id Project ID false false false integer any
name Project Name false true true string(255) any
Mention Name Mention Name false false true string(255) any
Description Description false false false text any
Active Active false false false boolean any
Open Open false false false boolean any
Start date Start date false false false datetime any
End date End date false false false datetime any
Commodity ID Commodity ID the project is associated with false false false integer any
Created By ID The user ID that created the project false false false integer any
Created Date The date the user create the project false false false datetime any
Last Updated By ID The user ID that most recently updated the project false false false integer any
Last Updated Date The date the project was most recently updated false false false datetime 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

Project Link

Added as part of Enhanced Task Management.

Column Description Hidden Req'd Unique Type Allowable Values
id Project Link ID No No No integer any
Project ID The project to which it is linked to No No Yes integer any
Linked Object ID The object ID the project is linked to No No No integer any
Linked Object Type The object type the project is linked to No No No string(255) *See Linked Object Type values below
Created Date The date the user created the project link No No No datetime any
Last Updated Date The date the project link was most recently updated No No No datetime any

*Contract, QuoteRequest, Recommendation, RecommendationAssociation, Supplier, AmendmentContract, MasterContract, CsoEvent, DutchAuction, JapaneseAuction, ExpenseCategoryRecommendation, ExpenseMerchantRecommendation, BenchmarkRecommendation, CategoryRecommendation, CommodityRecommendation, SupplierRecommendation, InternalSupplier 

Updated exports

All columns have been added unless otherwise indicated.

Coupa Pay :: Payment Detail Allocation

Column Description Hidden Req'd Unique Type Allowable Values Feature
Reason Code The reason code for the most recent change to this allocation. false false false string(40) payment, auto_payment, epr, epr_rejected CSV Export of Coupa Pay::Invoice

Invoice Header

Changes made in support of Extended Invoicing API Coverage for Invoice Creation.

Fields added
Column Description Hidden Req'd Unique Type Allowable Values
permanent-account-number Permanent Account Number (PAN) false false false   any
Fields Changed
Field name Description
customs-declaration-number This type is now string(60)
series This type is now string(30)
folio-number This type is now string(20)
use-of-invoice This type is now string(10)
form-of-payment This type is now string(10)
type-of-receipt This type is now string(10)
payment-method This type is now string(10)
type-of-relationship This type is now string(10)
self-billing-reference This type is now string(191)
Channel This type is now string(80)
payment-channel This type is now string(40)
transaction-uuid This type is now string(50)
  • Was this article helpful?