Skip to main content

 

 

Coupa Success Portal

R16 Integration Changes: Flat File (CSV) Out

CSV Out

Object Field Name Description Change
ExpenseLine Transaction-Amount The amount paid when the transaction was made. Added
ExpenseLine Transaction-Currency The currency that the transaction was made in. Added
InvoiceCharge type Describes the type of row. Possible values are Header Line, Line Split, Charge, Charge Split, or Tax Line. Added in Summary Charges
InvoiceCharge invoice-id The unique identifier Coupa assigns to the invoice. Added in Summary Charges
InvoiceCharge invoice-charge-id The unique identifier Coupa assigns to the invoice cha Added in Summary Charges
InvoiceCharge created-at When the invoice charge was created at in the format YYYY-MM-DDTHH:MM:SS+HH:MM. Added in Summary Charges
InvoiceCharge updated-at When the invoice charge was last updated at in the for YYYY-MM-DDTHH:MM:SS+HH:MM. Added in Summary Charges
InvoiceCharge total The total amount of the charge. Added in Summary Charges
InvoiceCharge percent The percent value of this charge (only for percent-bas charges & allowances. Not yet used.) Added in Summary Charges
InvoiceCharge accounting-total The total amount of the invoice charge using the Chart Accounts currency. Added in Summary Charges
InvoiceCharge accounting-total-currency The currency code of the Chart of Accounts. Added in Summary Charges
InvoiceCharge line-num The line number of the invoice charge, as it appears o invoice. Line numbers aren't necessarily listed sequen but will appear sequentially on the invoice. Added in Summary Charges
InvoiceCharge description The invoice charge description. Added in Summary Charges
InvoiceCharge tax-rate The tax rate indicated on the invoice charge. Added in Summary Charges
InvoiceCharge tax-location The location for tax on this charge Added in Summary Charges
InvoiceCharge tax-code The tax rate code for the charge tax rate. Must match existing tax rate code within Coupa. Added in Summary Charges
InvoiceCharge tax-amount The amount of the tax on this charge Added in Summary Charges
InvoiceCharge tax-description The charge level tax description. Added in Summary Charges
InvoiceCharge tax-supply-date The charge level tax supply date in the format YYYY- DDTHH:MM:SS+HH:MM. Added in Summary Charges
InvoiceCharge account-code The account code from Coupa. All segments are concatenated with a hyphen ( - ). Added in Summary Charges
InvoiceCharge account-active A flag in Coupa to indicate if the account is active and be selected. True or False. Added in Summary Charges
InvoiceCharge billing-notes A text field for adding notes to a billing line. Added in Summary Charges
InvoiceCharge segment-1 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-2 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-3 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-4 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-5 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-6 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-7 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-8 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-9 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-10 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-11 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-12 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-13 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-14 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-15 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-16 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-17 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-18 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-19 Account segment within Coupa. Added in Summary Charges
InvoiceCharge segment-20 Account segment within Coupa. Added in Summary Charges
InvoiceCharge account-name The account name from Coupa. Added in Summary Charges
InvoiceCharge created-by-email The email address of the user who created the invoice Added in Summary Charges
InvoiceCharge created-by-employee-number The employee number of the user who created the inv Added in Summary Charges
InvoiceCharge created-by-login The username of the user who created the invoice. Added in Summary Charges
InvoiceCharge updated-by-email The email address of the user who last updated the in Added in Summary Charges
InvoiceCharge updated-by-employee-number The employee number of the user who last updated th invoice. Added in Summary Charges
InvoiceCharge updated-by-login The username of the user who last updated the invoic Added in Summary Charges
InvoiceCharge custom-field-1 Integration Custom Field 1 Added in Summary Charges
InvoiceCharge custom-field-2 Integration Custom Field 2 Added in Summary Charges
InvoiceCharge custom-field-3 Integration Custom Field 3 Added in Summary Charges
InvoiceCharge custom-field-4 Integration Custom Field 4 Added in Summary Charges
InvoiceCharge custom-field-5 Integration Custom Field 5 Added in Summary Charges
InvoiceCharge custom-field-6 Integration Custom Field 6 Added in Summary Charges
InvoiceCharge custom-field-7 Integration Custom Field 7 Added in Summary Charges
InvoiceCharge custom-field-8 Integration Custom Field 8 Added in Summary Charges
InvoiceCharge custom-field-9 Integration Custom Field 9 Added in Summary Charges
InvoiceCharge custom-field-10 Integration Custom Field 10 Added in Summary Charges
InvoiceChargeAllocation type Describes the type of row. Possible values are Header Line, or Line Split or Tax Line. Added in Summary Charges
InvoiceChargeAllocation invoice-id The unique identifier Coupa assigns to the invoice. Added in Summary Charges
InvoiceChargeAllocation invoice-charge-id The unique identifier Coupa assigns to the invoice cha Added in Summary Charges
InvoiceChargeAllocation line-num The line number of the invoice charge, as it appears o invoice. Line numbers aren't necessarily listed sequen but will appear sequentially on the invoice. Added in Summary Charges
InvoiceChargeAllocation account-allocation-id The unique identifier Coupa assigns to the account allocation. Split line accounting must be enabled. Added in Summary Charges
InvoiceChargeAllocation account-allocation-sequence The unique sequential counter Coupa assigns to the account allocation split. Split line accounting must be enabled. Added in Summary Charges
InvoiceChargeAllocation account-allocation-amount The dollar amount for this account allocation. Split line accounting must be enabled. Added in Summary Charges
InvoiceChargeAllocation account-allocation-percent The percentage of the total amount allocated to this sp Split line accounting must be enabled. Added in Summary Charges
InvoiceChargeAllocation account-code The account code from Coupa. All segments are concatenated with a hyphen ( - ). Added in Summary Charges
InvoiceChargeAllocation account-active A flag in Coupa to indicate if the account is active and be selected. True or False. Added in Summary Charges
InvoiceChargeAllocation billing-notes A note to capture any information on this account alloc split. Added in Summary Charges
InvoiceChargeAllocation segment-1 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-2 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-3 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-4 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-5 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-6 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-7 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-8 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-9 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-10 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-11 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-12 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-13 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-14 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-15 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-16 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-17 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-18 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-19 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation segment-20 Account segment within Coupa. Added in Summary Charges
InvoiceChargeAllocation account-name The account name from Coupa. Added in Summary Charges
InvoiceChargeAllocation currency_code The currency code of the transaction. Added in Summary Charges
InvoiceChargeAllocation accounting-total The total amount of the invoice using the Chart of Acc currency. Doesn't include line and summary amounts. Added in Summary Charges
InvoiceChargeAllocation accounting_currency The currency code of the Chart of Accounts. Added in Summary Charges
InvoiceChargeAllocation custom-field-1 Integration Custom Field 1 Added in Summary Charges
InvoiceChargeAllocation custom-field-2 Integration Custom Field 2 Added in Summary Charges
InvoiceChargeAllocation custom-field-3 Integration Custom Field 3 Added in Summary Charges
InvoiceChargeAllocation custom-field-4 Integration Custom Field 4 Added in Summary Charges
InvoiceChargeAllocation custom-field-5 Integration Custom Field 5 Added in Summary Charges
InvoiceChargeAllocation custom-field-6 Integration Custom Field 6 Added in Summary Charges
InvoiceChargeAllocation custom-field-7 Integration Custom Field 7 Added in Summary Charges
InvoiceChargeAllocation custom-field-8 Integration Custom Field 8 Added in Summary Charges
InvoiceChargeAllocation custom-field-9 Integration Custom Field 9 Added in Summary Charges
InvoiceChargeAllocation custom-field-10 Integration Custom Field 10 Added in Summary Charges
InvoiceHeader early-payment-provisions Early Payment Provisions Added for Compliant Invoicing
InvoiceHeader pre-payment-date Pre-Payment Date Added for Compliant Invoicing
InvoiceHeader registered-company-permit-number Permit number of the registered company Added for Compliant Invoicing
InvoiceHeader registered-company-permit-date Permit date of the registered company Added for Compliant Invoicing
InvoiceHeader registered-company-liquidator-name Liquidator name of the registered company Added for Compliant Invoicing
InvoiceHeader registered-company-share-capital Share capital of the registered company Added for Compliant Invoicing
InvoiceHeader registered-company-unique-shareholder Unique shareholder of the registered company Added for Compliant Invoicing
InvoiceHeader registered-company-liable-company Liable company of the registered company Added for Compliant Invoicing
InvoiceHeader registered-company-tax-regime Tax Regime of the registered company Added for Compliant Invoicing
InvoiceHeader registered-company-legal-status Legal status of the company (for tax and compliance purposes). Added for Compliant Invoicing
InvoiceHeader origin-currency-net Net Amount in local currency Added for Compliant Invoicing
InvoiceHeader taxes-in-origin-country-currency Tax Amount in local currency Added for Compliant Invoicing
InvoiceHeader origin-currency-gross Gross Amount in local currency Added for Compliant Invoicing
InvoiceHeader self-billing-reference Self billing reference - used for compliant countries lik Netherlands Added for Compliant Invoicing
InvoiceHeader registered-company-legal-type Legal type of the company (for tax and compliance purposes). Added for Compliant Invoicing
InvoiceHeader registered-company-registered-seat Registered seat of the company (for tax and complian purposes). Added for Compliant Invoicing
InvoiceHeader registered-company-chairman-of-the-board Name of the chairperson of the board (for tax and compliance purposes). Added for Compliant Invoicing
InvoiceHeader registered-company-court-of-registration Court where the company is registered (for tax and compliance purposes). Added for Compliant Invoicing
InvoiceHeader registered-company-liquidation-remark Remark if the company is in liquidation (for tax and compliance purposes). Added for Compliant Invoicing
OrderLine line-number integer => string(255) Changed
RequisitionHeader Approved By Employee Number Created By Employee Number => Approved By Emplo Number Changed
RequisitionHeader Approved by Login Created by Login => Approved by Login Changed
RequisitionHeader Approved by Email Created by Email => Approved by Email Changed