Expense Reports Export

Expense report exports query all approved reports that are not yet exported. This process runs hourly. The application places generated files in the ./Outgoing/ExpenseReports folder. After the files are in the SFTP folder, the application marks the expense reports as exported. The application exports these records as a standard CSV file.

Expense Report

Field NameDescriptionField TypeRequired/UniquePossible Values
RecordTypeDescribes the type of row. Possible values are Header, Line, or Line Split.No/No
IDCoupa Generated Document IDintegerNo/No
Created-AtWhen the expense report was created in the format YYYY-MM-DDTHH:MM:SS+HH:MM.datetimeNo/No
Updated-AtWhen the expense report was last updated in the format YYYY-MM-DDTHH:MM:SS+HH:MMZdatetimeNo/No
TitleThe title of the expense report.string(255)No/No
StatusThe current status of the expense report. Possible values are: draft, working, pending_approval, pending_info, approved, accounting_review, approved_for_payment, scheduled_for_payment, paidstring(255)No/No
Submitted-atWhen the expense report was submitted for approval in the format YYYY-MM-DDTHH:MM:SS+HH:MMZ.datetimeNo/No
auditor-noteAuditor comments on the expense report.textNo/No
Rejection-ReasonThe reason why the expense report was rejected.textNo/No
PaidFlag to indicate if the expense report has been paid. True or False.booleanNo/No
totalThe total amount of the expense report in the transaction currency.decimal(32,4)No/No
currencyThe currency of the transaction.No/No
audit-scoreThe audit-score Coupa assigns to the expense report.integerNo/No
Accounting-TotalThe total amount of the expense report in the chart of accounts currency.decimalNo/No
Accounting-Total-CurrencyThe currency code of the chart of account for this expense reportNo/No
Expensed-By_emailThe email address of the user to be reimbursed.No/No
Expensed-By_employee_numberThe employee number of the user to be reimbursed.No/No
Expensed-By_idThe Coupa User ID of the user to be reimbursed.No/No
Expensed-By_loginThe username of the user to be reimbursed.No/No
Expensed-By_FullnameThe full name of the user to be reimbursed.No/No
Created-By_emailThe email address of the user who created the report.No/No
Created-By_employee_numberThe employee number of the user who created the report.No/No
Created-By_idThe Coupa User ID of the user who created the report.No/No
Created-By_loginThe username of the user who created the report.No/No
Created-By_Fullname,_FirstnameThe full name of the user who created the report.No/No
Updated-By_emailThe email address of the user who last updated the report.No/No
Updated-By_employee_numberThe employee number of the user who last updated the report.No/No
Updated-By_idThe Coupa User ID of the user who last updated the report.No/No
Updated-By_loginThe username of the user who last updated the report.No/No
Updated-By_FullnameThe full name of the user who last updated the report.No/No
Event_-_IDThe list of the event IDs.No/No
Event_-_StatusThe list of the event statusesNo/No
Event_-_Created_atThe list of event created dates in the format YYYY-MM-DDTHH:MM:SS+HH:MMZNo/No
Event_-_Updated_atThe list of event updated dates in the format YYYY-MM-DDTHH:MM:SS+HH:MMZNo/No
Event_-_Created-By_emailList of Email of user creating report eventNo/No
Event_-_Created-By_employee_numberList of Employee Number of user creating eventNo/No
Event_-_Created-By_idList of Internal Coupa User ID creating eventNo/No
Event_-_Created-By_loginList of Login of user creating eventNo/No
Event_-_Created-By_FullnameList of Employee Name of user creating eventNo/No
Event_-_Updated-By_emailList of Email of user who last updated eventNo/No
Event_-_Updated-By_employee_numberList of Employee Number of user who last updated eventNo/No
Event_-_Updated-By_idList of Internal Coupa User ID who last updated eventNo/No
Event_-_Updated-By_loginList of Login of user who last updated eventNo/No
Event_-By_FullnameList of Employee Name of user who last updated eventNo/No
Approval_Created-ATList of Approval Created-At Dates in the format YYYY-MM-DDTHH:MM:SS+HH:MMZNo/No
Approval_Updated-AtList of Approval Updated-At Dates in the format YYYY-MM-DDTHH:MM:SS+HH:MMZNo/No
PositionApproval OrderNo/No
approval-chain-idApproval Chain IDNo/No
Approval_statusApproval StatusNo/No
approval-dateApproval Date in the format YYYY-MM-DDTHH:MM:SS+HH:MMZNo/No
Approval_NotesApproval NotesNo/No
Approval_TypeType of Approval HierarchyNo/No
Approvable_TypeType of ApprovableNo/No
Approvable_IDID of ApprovableNo/No
Approver_-_Updated-By_emailList of Email of user who last updated eventNo/No
Approver_-_Updated-By_employee_numberList of Employee Number of user who last updated eventNo/No
Approver_-_Updated-By_idList of Internal Coupa User ID who last updated eventNo/No
Approver_-_Updated-By_loginList of Login of user who last updated eventNo/No
Approver_Updated-By_FullnameList of Employee Name of user who last updated eventNo/No
Reimburse-to-EmployeeTotal amount reimbursable to the employee.decimalNo/No
Reimburse-to-Employee-CurrencyThe currency code of the reimbursable amount.No/No
Payment ChannelThe payment channel used to reimburse the employee.string(255)No/No
ERP Document IDExpense document id on ERP side.string(255)No/No
ERP Document StatusExpense document status on ERP side.string(255)No/No

Expense Line

Field NameDescriptionField TypeRequired/UniquePossible Values
RecordTypeDescribes the type of row. Possible values are Header, Line, or Line Split.No/No
IDCoupa's Expense Report IDintegerNo/No
Line-IDCoupa's Expense Report Line IDintegerNo/No
Line-NumberLine NumberNo/No
PO-Order-Line-IDIf pre approved, Coupa Order Line IDintegerNo/No
Created-atTime of Record Creation in the format YYYY-MM-DDTHH:MM:SS+HH:MM.datetimeNo/No
Updated-AtTime Record was last updated in the format YYYY-MM-DDTHH:MM:SS+HH:MM.datetimeNo/No
DescriptionDescription of Expense Report Line Itemstring(1550)No/No
MerchantMerchant on linestring(255)No/No
ReasonReason for Expensestring(255)No/No
Transaction-AmountThe amount paid when the transaction was made.No/No
Transaction-CurrencyThe currency that the transaction was made in.No/No
AmountAmount in user's default currencyNo/No
CurrencyUser's default currencyNo/No
Account-TotalTotal of Amount in Chart of Accounts CurrencyNo/No
Accounting-CurrencyCurrency CodeNo/No
Expense-DateExpense Report Date in the format YYYY-MM-DDTHH:MM:SS+HH:MM.datetimeNo/No
Expense-Category-NameExpense Category NameNo/No
Account-CodeAccount CodeNo/No
Account-Segment-1Account Segment 1No/No
Account-Segment-2Account Segment 2No/No
Account-Segment-3Account Segment 3No/No
Account-Segment-4Account Segment 4No/No
Account-Segment-5Account Segment 5No/No
Account-Segment-6Account Segment 6No/No
Account-Segment-7Account Segment 7No/No
Account-Segment-8Account Segment 8No/No
Account-Segment-9Account Segment 9No/No
Account-Segment-10Account Segment 10No/No
Account-Segment-11Account Segment 11No/No
Account-Segment-12Account Segment 12No/No
Account-Segment-13Account Segment 13No/No
Account-Segment-14Account Segment 14No/No
Account-Segment-15Account Segment 15No/No
Account-Segment-16Account Segment 16No/No
Account-Segment-17Account Segment 17No/No
Account-Segment-18Account Segment 18No/No
Account-Segment-19Account Segment 19No/No
Account-Segment-20Account Segment 20No/No
Account TypeChart of AccountNo/No
Period NameBudget PeriodNo/No
External Source NameThe corp card template name like corporate_credit_card_amex etc.string(255)No/No
External Source DataThe file name of the credit card file that we received from cc company.string(255)No/No
External Source RefThe unique transaction identifier for each credit card transactionstring(255)No/Yes
Parent External Source NameThe corp card template name like corporate_credit_card_amex etc.No/No
Parent External Source DataThe file name of the credit card file that we received from cc company.No/No
Parent External Source RefThe unique transaction identifier for each credit card transactionNo/No
Imported-AmountImported AmountNo/No
Account NumberCredit Card Account numberNo/No
Employee NumberEmployee numberNo/No
First NameFirst NameNo/No
Last NameLast Name.No/No
Parent-Expense-Line-IdID of the expense line that was itemizedintegerNo/No
Supplier Reference NumberSupplier Reference NumberNo/No
Company Tax IdThe merchant ABN number or Federal Tax IDNo/No
Corp Card Integration NameThe integration name that is used received the transactionNo/No
Applied Expense Preapproval IdApplied Expense Preapproval IdNo/No
Applied Expense Preapproval DescriptionApplied Expense Preapproval DescriptionNo/No
Applied Expense Preapproval AmountApplied Expense Preapproval AmountNo/No
Applied Expense Preapproval Currency CodeApplied Expense Preapproval Currency CodeNo/No
Applied Expense Line Cash Advance AmountApplied Expense Line Cash Advance AmountNo/No
Applied Expense Line Cash Advance Currency CodeApplied Expense Line Cash Advance Currency CodeNo/No
Reimburse to EmployeeIs the Expense Line reimbursable to the employee?booleanNo/No

Expense Line Allocation

Field NameDescriptionField TypeRequired/UniquePossible Values
RecordTypeDescribes the type of row. Possible values are Header, Line, or Line Split.No/No
expense-idCoupa's Expense Report IDintegerNo/No
expense-line-idCoupa's Expense Report Line IDintegerNo/No
line-numLine NumberNo/No
order-header-numIf pre approved, Coupa's Order Header NumberNo/No
order-line-idIf pre approved, Coupa's Order Line IDNo/No
order-line-numIf pre approved, Coupa's Order Line NumberNo/No
account-allocation-idAccount Allocation IDintegerNo/No
account-allocation-sequencePosition in the Account Allocation SequenceNo/No
account-allocation-amountAmount allocated to the accountNo/No
account-allocation-percentPercentage allocated to the accountNo/No
account-codeThe whole account code of the accountNo/No
account-activeFlag indicating if the account is active. True or False.No/No
segment-1Account Segment 1No/No
segment-2Account Segment 2No/No
segment-3Account Segment 3No/No
segment-4Account Segment 4No/No
segment-5Account Segment 5No/No
segment-6Account Segment 6No/No
segment-7Account Segment 7No/No
segment-8Account Segment 8No/No
segment-9Account Segment 9No/No
segment-10Account Segment 10No/No
segment-11Account Segment 11No/No
segment-12Account Segment 12No/No
segment-13Account Segment 13No/No
segment-14Account Segment 14No/No
segment-15Account Segment 15No/No
segment-16Account Segment 16No/No
segment-17Account Segment 17No/No
segment-18Account Segment 18No/No
segment-19Account Segment 19No/No
segment-20Account Segment 20No/No
account-nameNickname for the accountNo/No
currency_codeCurrency CodeNo/No
accounting-totalTotal of Amount in Chart of Accounts Currencydecimal(32,4)No/No
accounting_currencyCurrency CodeNo/No

Expense Line Tax

Field NameDescriptionField TypeRequired/UniquePossible Values
RecordTypeExpense Line TaxNo/No
tax-line-idCoupa's Expense Line Tax IDintegerNo/No
expense-line-idCoupa's Expense Line IDintegerNo/No
expense-line-numberExpense Line NumberNo/No
expense-report-idCoupa's Expense Report IDNo/No
tax-codeThe Tax Code for the invoice line tax rate. Must match an existing tax rate code within Coupa.No/No
tax-type-descriptionThe Tax Rate Type description on the line.No/No
tax-rate-descriptionThe Tax Rate description on the line.No/No
tax-line-currencyTax Line CurrencyNo/No
country-codeCountry CodeNo/No
tax-rateTax Ratedecimal(8,3)No/No
tax-amountTax Amountdecimal(32,4)No/No
estimated-tax-amountEstimated Tax Amountdecimal(32,4)No/No

Expense Report Event History

Field NameDescriptionField TypeRequired/UniquePossible Values

Expense Reconciliation Line

Field NameDescriptionField TypeRequired/UniquePossible Values
TypeDescribes the type of row. Possible values are Header, Line, Line Split, Tax Line, or ReconciliationLine.No/No
Adjustment DateThe date the payment was madedatetimeYes/No
Type of documentThe type of document that was paidstringNo/No
Expense Report IDThe document ID that is being paidNo/No
AmountThe total amount paiddecimal(46,20)No/No
CurrencyUser's default currencyNo/No
Created By IDThe user ID that created the paymentintegerNo/No
Created By LoginThe user login that created the invoice paymentNo/No
Created DateThe date the payment initially drafteddatetimeNo/No
Updated By IDThe user ID that most recently updated the paymentintegerNo/No
Updated By LoginTher user login that most recently updated the invoice paymentNo/No
Updated DateThe date the payment was most recently updateddatetimeNo/No
NoteNote associated with the paymentstring(255)No/No

Expense To Pay

Field NameDescriptionField TypeRequired/UniquePossible Values
typeDescribes the type of row. Possible value is ExpenseNo/No
idThe ID of the expenseintegerNo/No
created-atThe date the expense was created ondatetimeNo/No
updated-atThe date the expense was last updated ondatetimeNo/No
statusThe status of the expensestring(255)No/No
paid-dateThe date the expense was marked as fully paiddatetimeNo/No
paid-totalThe total amount paiddecimalNo/No
remaining-totalThe total amount remaining to be paiddecimalNo/No
remittance-totalThe total remittance amount requireddecimalNo/No
accounting-totalThe total of the expense in the CoA currencydecimalNo/No
exportedA flag indicating if the expense has been marked as exportedNo/No
last-exported-atThe date that the expense was last marked as exporteddatetimeNo/No
expense-typeThe type of expensestring(255)No/No
payment-channelThe payment channel on the associated ExpenseReportstring(255)No/No
payable-typeThe type of associated payable. Value is ExpenseReportNo/No
payable-idThe ID of the associated ExpenseReportNo/No
chart-of-account-codeThe Chart of Accounts nameNo/No
legal-entity-nameThe Chart of Accounts Legal Entity nameNo/No