Skip to main content

 

 

Coupa Success Portal

Invoices Export

Overview

The Invoice Export process from Coupa uses the Coupa API to query for all Invoices that are approved and have NOT been exported. The frequency of the integration run is once every hour. The generated files will be placed into ./Outgoing/Invoices on the Standard SFTP setup. Once the files are successfully placed into the sFTP folder the invoices will be marked/flagged as exported.

Voids

Voided Invoices can also be exported and will be placed into ./Outgoing/Invoices/. Currently this is the only change to an Invoice that is captured in the integration.

Invoice Header Columns

Column Name Description Req'd Unique Type Allowable Values
type Describes the type of row. Possible values are Header, Line, or Line Split or Tax Line. FALSE FALSE - Header
id The unique identifier Coupa assigned to the invoice. FALSE FALSE integer(11) any
created-at When the invoice was created in the format YYYY-MM-DDTHH:MM:SS+HH:MMZ. FALSE FALSE datetime any
updated-at When the invoice was last updated in the format YYYY-MM-DDTHH:MM:SS+HH:MMZ. FALSE FALSE datetime any
status The current status of the invoice. Possible values are: new, ap_hold, draft, on_hold, pending_receipt, disputed, pending_approval, approved, voided, booking_hold, save_as_draft FALSE FALSE string(50) any
internal-note Text field for comments made by employees. Not visible to the supplier. FALSE FALSE text(65536) any
invoice-date The date of the invoice in the format YYYY-MM-DDTHH:MM:SS+HH:MMZ. TRUE FALSE datetime any
invoice-number The user-created invoice number. TRUE FALSE string(40) any
line-level-taxation Flag indicating if the invoice has taxes at the line level. True or False. If True, adds fourth header: Tax Line. TRUE FALSE boolean any
supplier-note Text field for comments from the supplier. Visible to both Coupa users and the supplier. FALSE FALSE text(65536) any
header-tax-amount The amount of tax calculated on the invoice summary. FALSE FALSE decimal any
header-tax-rate The tax rate indicated on the invoice summary. FALSE FALSE decimal any
header-tax-code The tax rate code for the invoice summary tax rate. Must match an existing tax rate code within Coupa. FALSE FALSE string(255) any
paid Flag indicating if the invoice was paid or not. Manually set. True or False. Default is False. FALSE FALSE boolean True/False
payment-date The date of the invoice was marked as paid in the format YYYY-MM-DDTHH:MM:SS+HH:MM. FALSE FALSE datetime any
payment-notes Text field for comments on the payment. Visible only to Coupa users. FALSE FALSE text any
exported Flag indicating if the invoice was exported to the ERP. True or False. FALSE FALSE boolean any
account-type-id The unique identifier Coupa assigned to the Chart of Accounts. FALSE FALSE integer any
account-type-name The name of the Chart of Accounts within Coupa. FALSE FALSE string(50) any
payment-term The payment term code on the invoice. FALSE FALSE string(255) any
handling-amount Summary handling amount added to the invoice by the supplier. FALSE FALSE decimal(32,4) any
misc-amount Summary charge added to the invoice by the supplier. FALSE FALSE decimal(32,4) any
shipping-amount Summary shipping charge added to the invoice by the supplier. FALSE FALSE decimal(32,4) any
total The total amount of the invoice, including all summary amounts. FALSE FALSE decimal any
currency The currency code of the transaction. FALSE FALSE string(6) any
accounting-total-amount The total amount of the invoice using the Chart of Accounts currency. Doesn't include line and summary amounts. FALSE FALSE decimal any
accounting-total-currency The currency code of the Chart of Accounts. FALSE FALSE string(6) any
supplier-id The unique identifier Coupa assigned to the supplier. TRUE FALSE integer any
supplier-name The name of the supplier. FALSE FALSE string(100) any
supplier-number The number of the supplier. FALSE FALSE string(255) any
created-by-email The email address of the user who created the invoice. FALSE FALSE string(255) any
created-by-employee-number The employee number of the user who created the invoice. FALSE FALSE string(255) any
created-by-login The login name of the user who created the invoice. FALSE FALSE string(255) any
updated-by-email The email address of the user who last updated the invoice. FALSE FALSE string(255) any
updated-by-employee-number The employee number of the user who last updated the invoice. FALSE FALSE string(255) any
updated-by-login The login name of the user who last updated the invoice. FALSE FALSE string(255) any
attachment-texts The URLs of the attached files. The files can be set to the supplier, but cannot be downloaded as part of the CSV export. FALSE FALSE   any
comments Not currently used. FALSE FALSE string(255) any
remit-to-address-code Remit to Address Code FALSE FALSE string(255) any
remit-to-address-attention Remit to Address Attention FALSE FALSE string(255) any
remit-to-address-street1 Remit to Address Line 1 FALSE FALSE string(100) any
remit-to-address-street2 Remit to Address Line 2 FALSE FALSE string(100) any
remit-to-address-city Remit to Address City FALSE FALSE string(50) any
remit-to-address-state Remit to Address State FALSE FALSE string(50) any
remit-to-address-postal-code Remit to Address Postal Code FALSE FALSE string(50) any
remit-to-address-country-code Remit to Address Country Code FALSE FALSE string(4) any
remit-to-address-country-name Remit To Address Country Name FALSE FALSE string(100) any
remit-to-address-name Remit To Address Name FALSE FALSE string(255) any
remit-to-address-vat-number The VAT number associated with the remit-to address (for tax and compliance purposes). FALSE FALSE string(255) any
remit-to-address-vat-country-code The country code for the remit-to address (for tax and compliance purposes). FALSE FALSE string(4) any
remit-to-address-vat-country-name The country name for the remit-to address (for tax and compliance purposes). FALSE FALSE string(100) any
supplier-vat-number The VAT number of the supplier. FALSE FALSE string(255) any
supplier-vat-country-code The VAT country code of the supplier. FALSE FALSE string(4) any
document-type The type of document. Possible values are Invoice or Credit Note FALSE FALSE   Invoice or Credit Note
original-invoice-number The credit note must refer to the original invoice. Required if document-type is set to Credit Note. TRUE FALSE string(40) any
original-invoice-date The date that the original invoice was issued. TRUE FALSE datetime any
bill-to-address-legal-entity-name The legal name of the bill-to address company. This is often different the then company name FALSE FALSE string(255) any
bill-to-address-attention The contact person at the bill-to address. FALSE FALSE string(255) any
bill-to-address-street1 The first bill-to address line. FALSE FALSE string(100) any
bill-to-address-street2 The second bill-to address line. FALSE FALSE string(100) any
bill-to-address-city The bill-to address city. FALSE FALSE string(50) any
bill-to-address-state The bill-to address state. FALSE FALSE string(50) any
bill-to-address-postal-code The bill-to address zip or postal code. FALSE FALSE string(50) any
bill-to-address-country-code The bill-to address country code. FALSE FALSE string(4) any
bill-to-address-country-name The bill-to address country name. FALSE FALSE string(100) any
bill-to-address-name The user-friendly name given to the bill-to address to make it more easily identifiable. FALSE FALSE string(255) any
ship-to-address-attention The contact person at the bill-to address. FALSE FALSE string(255) any
ship-to-address-street1 The first ship-to address line. FALSE FALSE string(100) any
ship-to-address-street2 The second ship-to address line. FALSE FALSE string(100) any
ship-to-address-city The ship-to address city. FALSE FALSE string(50) any
ship-to-address-state The ship-to address state or province. FALSE FALSE string(50) any
ship-to-address-postal-code The ship-to address zip or postal code. FALSE FALSE string(50) any
ship-to-address-country-code The ship-to address country code. FALSE FALSE string(4) any
ship-to-address-country-name The ship-to address country name. FALSE FALSE string(100) any
ship-to-address-name The user-friendly name given to the ship-to address to make it more easily identifiable. FALSE FALSE string(255) any
supplier-remit-to-code The name/code given to the supplier remit-to address by the supplier FALSE FALSE string(255) any
supplier-remit-to-supplier-name The user-friendly name given to the remit-to address by the supplier to make it more easily identifiable FALSE FALSE string(255) any
supplier-remit-to-street1 The supplier-created remit-to first address line. FALSE FALSE string(255) any
supplier-remit-to-street2 The supplier-created remit-to second address line. FALSE FALSE string(255) any
supplier-remit-to-city The supplier-created remit-to city. FALSE FALSE string(255) any
supplier-remit-to-state The supplier-created remit-to state. FALSE FALSE string(255) any
supplier-remit-to-postal-code The supplier-created remit-to zip or postal code. FALSE FALSE string(255) any
supplier-remit-to-country-code The supplier-created remit-to country code. FALSE FALSE string(4) any
supplier-remit-to-country-name The supplier-created remit-to country name. FALSE FALSE string(100) any
discount_due_date The date the invoice needs to be paid by in order to get the early-payment discount. Calculated by Coupa based on payment-term in the format YYYY-MM-DDTHH:MM:SS+HH:MM. FALSE FALSE datetime any
net_due_date The date the invoice needs to be paid by. Calculated by Coupa based payment-term in the format YYYY-MM-DDTHH:MM:SS+HH:MM. FALSE FALSE datetime any
discount_amount The value of the discount if the invoice is paid by the discount_due_date. Calculated by Coupa basedtotal and payment-term. FALSE FALSE decimal(32,4) any
late-payment-penalties Late Payment Penalties FALSE FALSE string(255) any
margin-scheme A reference to the margin scheme used FALSE FALSE string(255) any
cash-accounting-scheme-reference A reference to the cash accounting scheme used FALSE FALSE string(255) any
exchange-rate Exchange Rate FALSE FALSE decimal(30,9) any
early-payment-provisions Early Payment Provisions FALSE FALSE string(255) any
pre-payment-date Pre-Payment Date FALSE FALSE datetime any
reverse-charge-reference Reverse Charge Reference FALSE FALSE string(255) any
gross-total Gross Total FALSE FALSE decimal any
registered-company-registration-number Registration number of the registered company FALSE FALSE string(255) any
registered-company-place-of-registration Place of registration of the registered company FALSE FALSE string(255) any
registered-company-type The type of the registered company FALSE FALSE string(255) any
registered-company-managing-directors A list of managing directors of the registered company FALSE FALSE string(255) any
credit-reason The reason of creating the credit FALSE FALSE string(255) any
registered-company-permit-number Permit number of the registered company FALSE FALSE string(255) any
registered-company-permit-date Permit date of the registered company FALSE FALSE string(255) any
registered-company-liquidator-name Liquidator name of the registered company FALSE FALSE string(255) any
registered-company-share-capital Share capital of the registered company FALSE FALSE string(255) any
registered-company-unique-shareholder Unique shareholder of the registered company FALSE FALSE string(255) any
registered-company-liable-company Liable company of the registered company FALSE FALSE string(255) any
registered-company-tax-regime Tax Regime of the registered company FALSE FALSE string(255) any
registered-company-legal-status Legal status of the company (for tax and compliance purposes). FALSE FALSE string(255) any
origin-currency-net Net Amount in local currency TRUE FALSE decimal(32,4) any
taxes-in-origin-country-currency Tax Amount in local currency TRUE FALSE decimal(32,4) any
origin-currency-gross Gross Amount in local currency TRUE FALSE decimal(32,4) any
self-billing-reference Self billing reference - used for compliant countries like The Netherlands FALSE FALSE string(255) any
registered-company-legal-type Legal type of the company (for tax and compliance purposes). FALSE FALSE string(255) any
registered-company-registered-seat Registered seat of the company (for tax and compliance purposes). FALSE FALSE string(255) any
registered-company-chairman-of-the-board Name of the chairperson of the board (for tax and compliance purposes). FALSE FALSE string(255) any
registered-company-court-of-registration Court where the company is registered (for tax and compliance purposes). FALSE FALSE string(255) any
registered-company-liquidation-remark Remark if the company is in liquidation (for tax and compliance purposes). FALSE FALSE string(255) any
registered-company-commercial-register-number Commercial register number of the company (for tax and compliance purposes). FALSE FALSE string(255) any
custom-field-1 Integration Custom Field 1 FALSE FALSE string(255) any
custom-field-2 Integration Custom Field 2 FALSE FALSE string(255) any
custom-field-3 Integration Custom Field 3 FALSE FALSE string(255) any
custom-field-4 Integration Custom Field 4 FALSE FALSE string(255) any
custom-field-5 Integration Custom Field 5 FALSE FALSE string(255) any
custom-field-6 Integration Custom Field 6 FALSE FALSE string(255) any
custom-field-7 Integration Custom Field 7 FALSE FALSE string(255) any
custom-field-8 Integration Custom Field 8 FALSE FALSE string(255) any
custom-field-9 Integration Custom Field 9 FALSE FALSE string(255) any
custom-field-10 Integration Custom Field 10 FALSE FALSE string(255) any

Invoice Line Columns 

Column Name Description Req'd Unique Type Allowable Values
type Describes the type of row. Possible values are Header, Line, or Line Split or Tax Line. FALSE FALSE - Line
invoice-id The unique identifier Coupa assigns to the invoice. FALSE FALSE integer any
invoice-line-id The unique identifier Coupa assigns to the invoice line. FALSE FALSE integer any
created-at When the invoice line was created at in the format YYYY-MM-DDTHH:MM:SS+HH:MM. FALSE FALSE datetime any
updated-at When the invoice line was last updated at in the format YYYY-MM-DDTHH:MM:SS+HH:MM. FALSE FALSE datetime any
total The total amount of the invoice, including all distributed summary amounts. FALSE FALSE decimal(46,20) any
accounting-total The total amount of the invoice line using the Chart of Accounts currency. FALSE FALSE decimal(46,20) any
accounting-total-currency The currency code of the Chart of Accounts. FALSE FALSE string(6) any
line-num The line number of the invoice line, as it appears on the invoice. Line numbers aren't necessarily listed sequential, but will appear sequentially on the invoice. FALSE FALSE integer any
description The invoice line description, usually taken from the description of the item. TRUE FALSE string(1550) any
order-header-num The number given to the corresponding purchase order within Coupa (if any). FALSE FALSE integer any
order-header-requested-by-email The email address of the user who created the corresponding purchase order. FALSE FALSE string(255) any
order-header-requested-by-employee-number The employee number of the user who created the purchase order. FALSE FALSE string(255) any
order-header-requested-by-login the username of the person who created the purchase order. FALSE FALSE string(255) any
order-line-id The unique identifier Coupa assigns to the corresponding line on the purchase order (if any). FALSE FALSE integer any
order-line-num The line number of the corresponding purchase order line (if any). FALSE FALSE integer any
order-line-commodity The commodity ID of the line item on the purchase order (if any). FALSE FALSE string(255) any
price The price of the order line item. TRUE FALSE decimal(46,20) any
quantity The quantity of the order line item. FALSE FALSE decimal(30,6) any
uom The unit of measure code. it must already exist in Coupa. FALSE FALSE string(6) any
status The current status of the invoice line. Possible values are: new, ap_hold, draft, on_hold, pending_receipt, disputed, pending_approval, approved, voided, booking_hold, save_as_draft FALSE FALSE string(255) any
tax-rate The tax rate indicated on the invoice line. Only has a value if the header item line level taxation is set toTrue. FALSE FALSE float any
tax-location Only has a value if the header item line level taxation is set to True. FALSE FALSE string(255) any
tax-code The tax rate code for the line tax rate. Must match an existing tax rate code within Coupa. Only has a value if the header item line level taxation is set to True. FALSE FALSE string(255) any
tax-amount Only has a value if the header item line level taxation is set to True. FALSE FALSE decimal(32,4) any
tax-description The line level tax description. FALSE FALSE string(255) any
tax-supply-date The line level tax supply date in the format YYYY-MM-DDTHH:MM:SS+HH:MM. FALSE FALSE datetime any
account-code The account code from Coupa. All segments are concatenated with a hyphen ( - ). FALSE FALSE string(1024) any
account-active A flag in Coupa to indicate if the account is active and can be selected. True or False. FALSE FALSE boolean any
billing-notes A text field for adding notes to a billing line. FALSE FALSE text any
segment-1 Account segment within Coupa. FALSE FALSE string(100) any
segment-2 Account segment within Coupa. FALSE FALSE string(100) any
segment-3 Account segment within Coupa. FALSE FALSE string(100) any
segment-4 Account segment within Coupa. FALSE FALSE string(100) any
segment-5 Account segment within Coupa. FALSE FALSE string(100) any
segment-6 Account segment within Coupa. FALSE FALSE string(100) any
segment-7 Account segment within Coupa. FALSE FALSE string(100) any
segment-8 Account segment within Coupa. FALSE FALSE string(100) any
segment-9 Account segment within Coupa. FALSE FALSE string(100) any
segment-10 Account segment within Coupa. FALSE FALSE string(100) any
segment-11 Account segment within Coupa. FALSE FALSE string(100) any
segment-12 Account segment within Coupa. FALSE FALSE string(100) any
segment-13 Account segment within Coupa. FALSE FALSE string(100) any
segment-14 Account segment within Coupa. FALSE FALSE string(100) any
segment-15 Account segment within Coupa. FALSE FALSE string(100) any
segment-16 Account segment within Coupa. FALSE FALSE string(100) any
segment-17 Account segment within Coupa. FALSE FALSE string(100) any
segment-18 Account segment within Coupa. FALSE FALSE string(100) any
segment-19 Account segment within Coupa. FALSE FALSE string(100) any
segment-20 Account segment within Coupa. FALSE FALSE string(100) any
account-name The account name from Coupa. FALSE FALSE string(1024) any
created-by-email The email address of the user who created the invoice. FALSE FALSE string(255) any
created-by-employee-number The employee number of the user who created the invoice. FALSE FALSE string(255) any
created-by-login The username of the user who created the invoice. FALSE FALSE string(255) any
updated-by-email The email address of the user who last updated the invoice. FALSE FALSE string(255) any
updated-by-employee-number The employee number of the user who last updated the invoice. FALSE FALSE string(255) any
updated-by-login The username of the user who last updated the invoice. FALSE FALSE string(255) any
distributed-tax-amount The amount of tax for the line item based on weighted summary expense distribution. FALSE FALSE decimal(32,4) any
distributed-shipping-amount The amount of shipping for the line item based on weighted summary expense distribution. FALSE FALSE decimal(32,4) any
distributed-handling-amount The amount of handling for the line item based on weighted summary expense distribution. FALSE FALSE decimal(32,4) any
distributed-misc-amount The amount of misc for the line item based on weighted summary expense distribution. FALSE FALSE decimal(32,4) any
custom-field-1 Integration Custom Field 1 FALSE FALSE string(255) any
custom-field-2 Integration Custom Field 2 FALSE FALSE string(255) any
custom-field-3 Integration Custom Field 3 FALSE FALSE string(255) any
custom-field-4 Integration Custom Field 4 FALSE FALSE string(255) any
custom-field-5 Integration Custom Field 5 FALSE FALSE string(255) any
custom-field-6 Integration Custom Field 6 FALSE FALSE string(255) any
custom-field-7 Integration Custom Field 7 FALSE FALSE string(255) any
custom-field-8 Integration Custom Field 8 FALSE FALSE string(255) any
custom-field-9 Integration Custom Field 9 FALSE FALSE string(255) any
custom-field-10 Integration Custom Field 10 FALSE FALSE string(255) any

Invoice Line Allocation (Split) Columns

Column Name Description Req'd Unique Type Allowable Values
type Describes the type of row. Possible values are Header, Line, or Line Split or Tax Line. FALSE FALSE - Line Split
invoice-id The unique identifier Coupa assigns to the invoice. FALSE FALSE integer any
invoice-line-id The unique identifier Coupa assigns to the invoice line. FALSE FALSE integer any
line-num The line number of the invoice line, as it appears on the invoice. Line numbers aren't necessarily listed sequential, but will appear sequentially on the invoice. FALSE FALSE integer any
order-header-num The number given to the corresponding purchase order within Coupa (if any). FALSE FALSE integer any
order-line-id The unique identifier Coupa assigns to the corresponding line on the purchase order (if any). FALSE FALSE integer any
order-line-num The line number of the corresponding purchase order line (if any). FALSE FALSE integer any
account-allocation-id The unique identifier Coupa assigns to the account allocation. Split line accounting must be enabled. FALSE FALSE integer any
account-allocation-sequence The unique sequential counter Coupa assigns to the account allocation split. Split line accounting must be enabled. FALSE FALSE integer any
account-allocation-amount The dollar amount for this account allocation. Split line accounting must be enabled. FALSE FALSE decimal(32,4) any
account-allocation-percent The percentage of the total amount allocated to this split. Split line accounting must be enabled. TRUE FALSE decimal(16,10) any
account-code The account code from Coupa. All segments are concatenated with a hyphen ( - ). FALSE FALSE string(1024) any
account-active A flag in Coupa to indicate if the account is active and can be selected. True or False. FALSE FALSE boolean any
billing-notes A note to capture any information on this account allocation split. FALSE FALSE text(65535) any
segment-1 Account segment within Coupa. FALSE FALSE string(100) any
segment-2 Account segment within Coupa. FALSE FALSE string(100) any
segment-3 Account segment within Coupa. FALSE FALSE string(100) any
segment-4 Account segment within Coupa. FALSE FALSE string(100) any
segment-5 Account segment within Coupa. FALSE FALSE string(100) any
segment-6 Account segment within Coupa. FALSE FALSE string(100) any
segment-7 Account segment within Coupa. FALSE FALSE string(100) any
segment-8 Account segment within Coupa. FALSE FALSE string(100) any
segment-9 Account segment within Coupa. FALSE FALSE string(100) any
segment-10 Account segment within Coupa. FALSE FALSE string(100) any
segment-11 Account segment within Coupa. FALSE FALSE string(100) any
segment-12 Account segment within Coupa. FALSE FALSE string(100) any
segment-13 Account segment within Coupa. FALSE FALSE string(100) any
segment-14 Account segment within Coupa. FALSE FALSE string(100) any
segment-15 Account segment within Coupa. FALSE FALSE string(100) any
segment-16 Account segment within Coupa. FALSE FALSE string(100) any
segment-17 Account segment within Coupa. FALSE FALSE string(100) any
segment-18 Account segment within Coupa. FALSE FALSE string(100) any
segment-19 Account segment within Coupa. FALSE FALSE string(100) any
segment-20 Account segment within Coupa. FALSE FALSE string(100) any
account-name The account name from Coupa. FALSE FALSE string(1024) any
currency_code The currency code of the transaction. FALSE FALSE string(6) any
accounting-total The total amount of the invoice using the Chart of Accounts currency. Doesn't include line and summary amounts. FALSE FALSE decimal(32,4) any
accounting_currency The currency code of the Chart of Accounts. FALSE FALSE string(6) any
distributed-tax-amount The amount of tax for the line item based on weighted summary expense distribution. FALSE FALSE decimal(32,4) any
distributed-shipping-amount The amount of shipping for the line item based on weighted summary expense distribution. FALSE FALSE decimal(32,4) any
distributed-handling-amount The amount of handling for the line item based on weighted summary expense distribution. FALSE FALSE decimal(32,4) any
distributed-misc-amount The amount of misc for the line item based on weighted summary expense distribution. FALSE FALSE decimal(32,4) any

Invoice Charge Columns

Column Name Description Req'd Unique Type Allowable Values
type Describes the type of row. Possible values are Header, Line, Line Split, Charge, Charge Split, or Tax Line. FALSE FALSE - Charge
invoice-id The unique identifier Coupa assigns to the invoice. FALSE FALSE integer any
invoice-charge-id The unique identifier Coupa assigns to the invoice charge. FALSE FALSE integer any
type The kind of charge. Possible values are InvoiceShippingCharge, InvoiceHandlingCharge, or InvoiceMiscCharge. FALSE FALSE string(255) any
created-at When the invoice charge was created at in the format YYYY-MM-DDTHH:MM:SS+HH:MM. FALSE FALSE datetime any
updated-at When the invoice charge was last updated at in the format YYYY-MM-DDTHH:MM:SS+HH:MM. FALSE FALSE datetime any
total The total amount of the charge. FALSE FALSE decimal any
percent The percent value of this charge (only for percent-based charges & allowances. Not yet used.) FALSE FALSE decimal(16,10) any
accounting-total The total amount of the invoice charge using the Chart of Accounts currency. FALSE FALSE decimal(30,4) any
accounting-total-currency The currency code of the Chart of Accounts. FALSE FALSE string(6) any
line-num The line number of the invoice charge, as it appears on the invoice. Line numbers aren't necessarily listed sequential, but will appear sequentially on the invoice. FALSE FALSE integer any
description The invoice charge description. FALSE FALSE string(1550) any
tax-rate The tax rate indicated on the invoice charge. FALSE FALSE float any
tax-location The location for tax on this charge FALSE FALSE string(255) any
tax-code The tax rate code for the charge tax rate. Must match an existing tax rate code within Coupa. FALSE FALSE string(255) any
tax-amount The amount of the tax on this charge FALSE FALSE decimal(32, 4) any
tax-description The charge level tax description. FALSE FALSE string(255) any
tax-supply-date The charge level tax supply date in the format YYYY-MM-DDTHH:MM:SS+HH:MM. FALSE FALSE datetime any
account-code The account code from Coupa. All segments are concatenated with a hyphen ( - ). FALSE FALSE string(1024) any
account-active A flag in Coupa to indicate if the account is active and can be selected. True or False. FALSE FALSE boolean any
billing-notes A text field for adding notes to a billing line. FALSE FALSE text(65535) any
segment-1 Account segment within Coupa. FALSE FALSE string(100) any
segment-2 Account segment within Coupa. FALSE FALSE string(100) any
segment-3 Account segment within Coupa. FALSE FALSE string(100) any
segment-4 Account segment within Coupa. FALSE FALSE string(100) any
segment-5 Account segment within Coupa. FALSE FALSE string(100) any
segment-6 Account segment within Coupa. FALSE FALSE string(100) any
segment-7 Account segment within Coupa. FALSE FALSE string(100) any
segment-8 Account segment within Coupa. FALSE FALSE string(100) any
segment-9 Account segment within Coupa. FALSE FALSE string(100) any
segment-10 Account segment within Coupa. FALSE FALSE string(100) any
segment-11 Account segment within Coupa. FALSE FALSE string(100) any
segment-12 Account segment within Coupa. FALSE FALSE string(100) any
segment-13 Account segment within Coupa. FALSE FALSE string(100) any
segment-14 Account segment within Coupa. FALSE FALSE string(100) any
segment-15 Account segment within Coupa. FALSE FALSE string(100) any
segment-16 Account segment within Coupa. FALSE FALSE string(100) any
segment-17 Account segment within Coupa. FALSE FALSE string(100) any
segment-18 Account segment within Coupa. FALSE FALSE string(100) any
segment-19 Account segment within Coupa. FALSE FALSE string(100) any
segment-20 Account segment within Coupa. FALSE FALSE string(100) any
account-name The account name from Coupa. FALSE FALSE string(1024) any
created-by-email The email address of the user who created the invoice. FALSE FALSE string(255) any
created-by-employee-number The employee number of the user who created the invoice. FALSE FALSE string(255) any
created-by-login The username of the user who created the invoice. FALSE FALSE string(255) any
updated-by-email The email address of the user who last updated the invoice. FALSE FALSE string(255) any
updated-by-employee-number The employee number of the user who last updated the invoice. FALSE FALSE string(255) any
updated-by-login The username of the user who last updated the invoice. FALSE FALSE string(255) any
custom-field-1 Integration Custom Field 1 FALSE FALSE string(255) any
custom-field-2 Integration Custom Field 2 FALSE FALSE string(255) any
custom-field-3 Integration Custom Field 3 FALSE FALSE string(255) any
custom-field-4 Integration Custom Field 4 FALSE FALSE string(255) any
custom-field-5 Integration Custom Field 5 FALSE FALSE string(255) any
custom-field-6 Integration Custom Field 6 FALSE FALSE string(255) any
custom-field-7 Integration Custom Field 7 FALSE FALSE string(255) any
custom-field-8 Integration Custom Field 8 FALSE FALSE string(255) any
custom-field-9 Integration Custom Field 9 FALSE FALSE string(255) any
custom-field-10 Integration Custom Field 10 FALSE FALSE string(255) any

Invoice Charge Allocation (Split) Columns

Column Name Description Req'd Unique Type Allowable Values
type Describes the type of row. Possible values are Header, Line, or Line Split or Tax Line. FALSE FALSE - Charge Split
invoice-id The unique identifier Coupa assigns to the invoice. FALSE FALSE integer any
invoice-charge-id The unique identifier Coupa assigns to the invoice charge. FALSE FALSE integer any
line-num The line number of the invoice charge, as it appears on the invoice. Line numbers aren't necessarily listed sequential, but will appear sequentially on the invoice. FALSE FALSE integer any
account-allocation-id The unique identifier Coupa assigns to the account allocation. Split line accounting must be enabled. FALSE FALSE integer any
account-allocation-sequence The unique sequential counter Coupa assigns to the account allocation split. Split line accounting must be enabled. FALSE FALSE integer any
account-allocation-amount The dollar amount for this account allocation. Split line accounting must be enabled. FALSE FALSE decimal(30,4) any
account-allocation-percent The percentage of the total amount allocated to this split. Split line accounting must be enabled. TRUE FALSE decimal(16,10) any
account-code The account code from Coupa. All segments are concatenated with a hyphen ( - ). FALSE FALSE string(1024) any
account-active A flag in Coupa to indicate if the account is active and can be selected. True or False. FALSE FALSE boolean any
billing-notes A note to capture any information on this account allocation split. FALSE FALSE text(65535) any
segment-1 Account segment within Coupa. FALSE FALSE string(100) any
segment-2 Account segment within Coupa. FALSE FALSE string(100) any
segment-3 Account segment within Coupa. FALSE FALSE string(100) any
segment-4 Account segment within Coupa. FALSE FALSE string(100) any
segment-5 Account segment within Coupa. FALSE FALSE string(100) any
segment-6 Account segment within Coupa. FALSE FALSE string(100) any
segment-7 Account segment within Coupa. FALSE FALSE string(100) any
segment-8 Account segment within Coupa. FALSE FALSE string(100) any
segment-9 Account segment within Coupa. FALSE FALSE string(100) any
segment-10 Account segment within Coupa. FALSE FALSE string(100) any
segment-11 Account segment within Coupa. FALSE FALSE string(100) any
segment-12 Account segment within Coupa. FALSE FALSE string(100) any
segment-13 Account segment within Coupa. FALSE FALSE string(100) any
segment-14 Account segment within Coupa. FALSE FALSE string(100) any
segment-15 Account segment within Coupa. FALSE FALSE string(100) any
segment-16 Account segment within Coupa. FALSE FALSE string(100) any
segment-17 Account segment within Coupa. FALSE FALSE string(100) any
segment-18 Account segment within Coupa. FALSE FALSE string(100) any
segment-19 Account segment within Coupa. FALSE FALSE string(100) any
segment-20 Account segment within Coupa. FALSE FALSE string(100) any
account-name The account name from Coupa. FALSE FALSE string(1024) any
currency_code The currency code of the transaction. FALSE FALSE string(6) any
accounting-total The total amount of the invoice using the Chart of Accounts currency. Doesn't include line and summary amounts. FALSE FALSE decimal(30,4) any
accounting_currency The currency code of the Chart of Accounts. FALSE FALSE string(6) any

Invoice Tax Line Columns

Column Name Description Req'd Unique Type Allowable Values
type Describes the type of row. Possible values are Header, Line, or Line Split or Tax Line. FALSE FALSE - Tax Line
invoice-id The unique identifier Coupa assigns to the invoice. FALSE FALSE int(11) any
invoice-number The user-created invoice number. FALSE FALSE string(40) any
invoice-line-id The unique identifier Coupa assigns to the invoice line. FALSE FALSE int(11) any
invoice-line-number The line number of the corresponding purchase order line (if any). FALSE FALSE int(11) any
tax-line-number The line number of the corresponding of the tax line. FALSE FALSE integer any
tax-line-id The unique identifier Coupa assigns to the tax line. FALSE FALSE integer any
amount The amount of tax calculated on the line. FALSE FALSE decimal(32,4) any
rate The tax rate indicated on the invoice line. FALSE FALSE float any
code The tax rate code for the invoice line tax rate. Must match an existing tax rate code within Coupa. FALSE FALSE string(255) any
description The tax line description. FALSE FALSE string(255) any
location The taxable location for this tax line. FALSE FALSE string(255) any
date The tax line date in the format YYYY-MM-DDTHH:MM:SS+HH:MM. FALSE FALSE datetime any
  • Was this article helpful?