Expense Preapproval Export
Coupa's Expense Preapproval flat file integration object contains header and 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 | 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 |