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) |