Expense Preapproval Export

Export of these records is included as a Standard CSV Export.

Expense Preapproval

Field NameDescriptionField TypeRequired/UniquePossible Values
RecordTypeThe type of record type found in each rowNo/No
IDID for the expense preapprovalintegerNo/No
DescriptionThe description entered by the user often describing why they are requesting expense preapprovalstring(255)Yes/No
TypeThe type of form that the admin has configured for its users when requesting expense preapprovalsstring(255)No/No
Preapproved AmountTotal amount requested by the user on expense preapproval formNo/No
CurrencyCurrency code related to requested preapproval amountNo/No
Available AmountThe available amount left on a preapproval after a portion of the expense preapproval has been reconciled with an Expense ReportNo/No
Available Amount CurrencyCurrency code related to remaining requested preapproval amountNo/No
AvailableWhen Preapproval is archived then Available is set to No; however, when it is still active, is set to YesbooleanNo/No
Start DateThe start date entered by user on expense preapproval in the format YYYY-MM-DDTHH:MM:SS+HH:MMdatetimeNo/No
End DateThe end date entered by user on expense preapproval in the format YYYY-MM-DDTHH:MM:SS+HH:MMdatetimeNo/No
Preapproval User FullnameFull name of the user for whom the preapproval is createdNo/No
Created By FullnameFull name of the user who created the expense preapprovalNo/No
Updated By FullnameFull name of the user who updated the expense preapprovalNo/No
Created AtTime of record creation in the format YYYY-MM-DDTHH:MM:SS+HH:MMdatetimeNo/No
Updated AtTime that the record was updated in the format YYYY-MM-DDTHH:MM:SS+HH:MMdatetimeNo/No
Reporting TotalThe total expense preapproval amount requested in the company's dashboard currencydecimal(32,4)No/No
Form ResponseThe form response name set by the admin when publishing expense preapproval formNo/No
Expense ReportsOne or many expense reports that the expense preapproval is associated to[]No/No
Cash Advance Applied AmountThe total cash advance amount requested on expense preapproval formNo/No
Cash Advance Applied Amount CurrencyCurrency code related to requested cash advance amountNo/No
Cash Advance Outstanding AmountThe available cash advance amount left on a preapproval after a portion of the expense preapproval has been reconciled with an Expense ReportNo/No
Cash Advance Outstanding Amount CurrencyCurrency code related to remaining cash advance amount on expense preapprovalNo/No
Virtual Card Applied AmountThe total amount of the virtual card that was applied to the expense preapprovalNo/No
Virtual Card Applied Amount CurrencyCurrency code related to virtual card amount applied to the expense preapprovalNo/No
Virtual Card Outstanding AmountThe available virtual card amount left on a preapproval after a portion of the expense preapproval has been reconciled with an Expense ReportNo/No
Virtual Card Outstanding Amount CurrencyCurrency code related to remaining virtual card amount on expense preapprovalNo/No

Expense Preapproval Line

Field NameDescriptionField TypeRequired/UniquePossible Values
RecordTypeThe type of record type found in each rowNo/No
IDID for the expense preapproval lineintegerNo/No
Expense Preapproval IDID for the expense preapprovalintegerNo/No
TypeThe type of expense preapproval line: Flight, Hotel, Car Rental, Train, Transportation, or Nonestring(255)No/No
Estimated AmountThe estimated price of a segment predicted by Coupa's Community Intelligence Price PredictionNo/No
Estimated Amount CurrencyCurrency code related to the estimated amount requested on expense preapprovalNo/No
Requested AmountTotal amount requested by the user on expense preapproval formNo/No
Requested Amount CurrencyCurrency code related to the requested amount on expense preapproval lineNo/No
Account Type NameThe COA of the account selected in account codeNo/No
Account CodeThe accounting string that is assigned to the expense preapproval lineNo/No
Accounting TotalThe total expense preapproval amount requested in the COAs currencyNo/No
Accounting Total CurrencyCurrency code related to the accounting total on the expense preapproval lineNo/No
Created AtThe time of record creation in the format YYYY-MM-DDTHH:MM:SS+HH:MMdatetimeNo/No
Updated AtTime that the record was updated in the format YYYY-MM-DDTHH:MM:SS+HH:MMdatetimeNo/No