Skip to main content

 

 

Coupa Success Portal

Expense Preapproval Export

Expense Preapproval Header Columns

Column Name Description Req'd Unique Type Allowable Values
RecordType The type of record type found in each row FALSE FALSE   any
ID ID for the expense preapproval FALSE FALSE integer any
Description The description entered by the user often describing why they are requesting expense preapproval TRUE FALSE string(255) any
Type The type of form that the admin has configured for its users when requesting expense preapprovals FALSE FALSE string(255) any
Preapproved Amount Total amount requested by the user on expense preapproval form FALSE FALSE   any
Currency Currency code related to requested preapproval amount FALSE FALSE   any
Available Amount The available amount left on a preapproval after a portion of the expense preapproval has been reconciled with an Expense Report FALSE FALSE   any
Available Amount Currency Currency code related to remaining requested preapproval amount FALSE FALSE   any
Available When Preapproval is archived then Available is set to No; however, when it is still active, is set to Yes FALSE FALSE boolean any
Start Date The start date entered by user on expense preapproval in the format YYYY-MM-DDTHH:MM:SS+HH:MM FALSE FALSE datetime any
End Date The end date entered by user on expense preapproval in the format YYYY-MM-DDTHH:MM:SS+HH:MM FALSE FALSE datetime any
Preapproval User Fullname Full name of the user for whom the preapproval is created FALSE FALSE   any
Created By Fullname Full name of the user who created the expense preapproval FALSE FALSE   any
Updated By Fullname Full name of the user who updated the expense preapproval FALSE FALSE   any
Created At Time of record creation in the format YYYY-MM-DDTHH:MM:SS+HH:MM FALSE FALSE datetime any
Updated At Time that the record was updated in the format YYYY-MM-DDTHH:MM:SS+HH:MM FALSE FALSE datetime any
Reporting Total The total expense preapproval amount requested in the company's dashboard currency FALSE FALSE decimal(32,4) any
Form Response The form response name set by the admin when publishing expense preapproval form FALSE FALSE   any
Expense Reports One or many expense reports that the expense preapproval is associated to FALSE FALSE [] any
Cash Advance Applied Amount The total cash advance amount requested on expense preapproval form FALSE FALSE   any
Cash Advance Applied Amount Currency Currency code related to requested cash advance amount FALSE FALSE   any
Cash Advance Outstanding Amount The available cash advance amount left on a preapproval after a portion of the expense preapproval has been reconciled with an Expense Report FALSE FALSE   any
Cash Advance Outstanding Amount Currency Currency code related to remaining cash advance amount on expense preapproval FALSE FALSE   any
Virtual Card Applied Amount The total amount of the virtual card that was applied to the expense preapproval FALSE FALSE   any
Virtual Card Applied Amount Currency Currency code related to virtual card amount applied to the expense preapproval FALSE FALSE   any
Virtual Card Outstanding Amount The available virtual card amount left on a preapproval after a portion of the expense preapproval has been reconciled with an Expense Report FALSE FALSE   any
Virtual Card Outstanding Amount Currency Currency code related to remaining virtual card amount on expense preapproval FALSE FALSE   any
custom-field-1 Integration Custom Field 1 FALSE FALSE   any
custom-field-2 Integration Custom Field 2 FALSE FALSE   any
custom-field-3 Integration Custom Field 3 FALSE FALSE   any
custom-field-4 Integration Custom Field 4 FALSE FALSE   any
custom-field-5 Integration Custom Field 5 FALSE FALSE   any
custom-field-6 Integration Custom Field 6 FALSE FALSE   any
custom-field-7 Integration Custom Field 7 FALSE FALSE   any
custom-field-8 Integration Custom Field 8 FALSE FALSE   any
custom-field-9 Integration Custom Field 9 FALSE FALSE   any
custom-field-10 Integration Custom Field 10 FALSE FALSE   any

Expense Preapproval Line Columns

Column Name Description Req'd Unique Type Allowable Values
RecordType The type of record type found in each row FALSE FALSE   any
ID ID for the expense preapproval line FALSE FALSE integer any
Expense Preapproval ID ID for the expense preapproval FALSE FALSE integer any
Type The type of expense preapproval line: Flight, Hotel, Car Rental, Train, Transportation, or None FALSE FALSE string(255) any
Estimated Amount The estimated price of a segment predicted by Coupa's Community Intelligence Price Prediction FALSE FALSE   any
Estimated Amount Currency Currency code related to the estimated amount requested on expense preapproval FALSE FALSE   any
Requested Amount Total amount requested by the user on expense preapproval form FALSE FALSE   any
Requested Amount Currency Currency code related to the requested amount on expense preapproval line FALSE FALSE   any
Account Type Name The COA of the account selected in account code FALSE FALSE   any
Account Code The accounting string that is assigned to the expense preapproval line FALSE FALSE   any
Accounting Total The total expense preapproval amount requested in the COAs currency FALSE FALSE   any
Accounting Total Currency Currency code related to the accounting total on the expense preapproval line FALSE FALSE   any
Created At The time of record creation in the format YYYY-MM-DDTHH:MM:SS+HH:MM FALSE FALSE datetime any
Updated At Time that the record was updated in the format YYYY-MM-DDTHH:MM:SS+HH:MM FALSE FALSE datetime any
custom-field-1 Integration Custom Field 1 FALSE FALSE   any
custom-field-2 Integration Custom Field 2 FALSE FALSE   any
custom-field-3 Integration Custom Field 3 FALSE FALSE   any
custom-field-4 Integration Custom Field 4 FALSE FALSE   any
custom-field-5 Integration Custom Field 5 FALSE FALSE   any
custom-field-6 Integration Custom Field 6 FALSE FALSE   any
custom-field-7 Integration Custom Field 7 FALSE FALSE   any
custom-field-8 Integration Custom Field 8 FALSE FALSE   any
custom-field-9 Integration Custom Field 9 FALSE FALSE   any
custom-field-10 Integration Custom Field 10 FALSE FALSE   any

 

 

  • Was this article helpful?