approvals |
Approvals |
|
|
|
|
yes |
Approval
|
audit-score |
Coupa's Audit Score |
|
|
|
|
yes |
integer |
auditor-note |
Auditor Comments on Expense Report |
|
|
|
yes |
yes |
text |
comments |
Comments |
|
|
|
|
yes |
Comment
|
created-at |
Time of Record Creation |
|
|
|
|
yes |
datetime |
created-by |
User who created |
|
|
|
|
yes |
User
|
currency |
Currency Code |
|
|
|
|
yes |
Currency
|
end-date |
Return date |
|
|
|
yes |
yes |
date |
erp-document-id |
Expense document id on ERP side |
|
|
|
yes |
yes |
string(255) |
erp-document-status |
Expense document status on ERP side |
|
|
|
yes |
yes |
string(255) |
events |
Events |
|
|
|
|
yes |
ExpenseReportEventHistory |
expense-lines |
Expense lines |
|
|
|
yes |
yes |
ExpenseLine
|
expense-policy-violations |
Expense policy violations |
|
|
|
|
yes |
ExpensePolicyViolation |
expense-violations |
Expense violations |
|
|
|
|
yes |
ExpenseViolation
|
expensed-by |
Expensed by user |
|
|
|
yes |
yes |
User
|
exported |
Indicates if transaction has been exported |
|
|
|
|
yes |
boolean |
external-src-name |
External source name |
|
|
|
yes |
yes |
string(255) |
external-src-ref |
External source reference |
|
|
|
yes |
yes |
string(255) |
id |
Coupa's Expense Report ID |
|
|
|
|
yes |
integer |
is-trip |
Trip Report |
|
|
|
yes |
yes |
boolean |
last-exported-at |
Date and time transaction was last exported in the format
YYYY-MM-DDTHH:MM:SS+HH:MMZ |
|
|
|
|
yes |
datetime |
paid |
Has expense report been paid? |
|
|
|
yes |
yes |
boolean |
past-due |
Report has passed the due date in the format True or false |
|
|
true, false |
|
yes |
boolean |
payment |
Payment |
|
|
|
yes |
yes |
Payment |
payment-channel |
Channel used to pay the Reimbursable Total. |
|
|
|
|
yes |
string(255) |
reconciliation-lines |
Payments |
|
|
|
|
yes |
[] |
reimbursable-total-amount |
Amount reimbursable to the End User. |
|
|
|
|
yes |
decimal(32,4) |
reimbursable-total-currency |
Currency of Reimbursable Total. |
|
|
|
|
yes |
Currency
|
reject-reason |
Reason why report was rejected |
|
|
|
yes |
yes |
text |
report-due-date |
Due date before which report needs to be submitted in the format
YYYY-MM-DDTHH:MM:SS+HH:MMZ |
|
|
|
|
yes |
datetime |
start-date |
Departure date |
|
|
|
yes |
yes |
boolean |
status |
Current Expense Report Status |
|
|
|
|
yes |
string(255) |
submitted-at |
Date Expense Report was Submitted for Approval |
|
|
|
yes |
yes |
datetime |
submitted-by |
Submitted by user |
|
|
|
|
yes |
User
|
title |
Expense Report Title |
|
|
|
yes |
yes |
string(255) |
total |
Expense Report Total in Transactional Currency |
|
|
|
|
yes |
decimal(32,4) |
travel-trip |
Travel trip |
|
|
|
|
yes |
|
updated-at |
Time of Record Creation |
|
|
|
|
yes |
datetime |
updated-by |
User who updated |
|
|
|
|
yes |
User
|
report_warnings |
Report level warning messages |
|
|
|
|
yes |
string(255) |