Payables :: Expense
Coupa's Payables :: Expense Preapproval flat file integration object contains header columns.
| Column Name | Description | Req'd | Unique | Type | Allowable Values |
|---|---|---|---|---|---|
| type | Describes the type of row. Possible value is Expense | false | false | any | |
| id | The ID of the expense | false | false | integer | any |
| created-at | The date the expense was created on | false | false | datetime | any |
| updated-at | The date the expense was last updated on | false | false | datetime | any |
| status | The status of the expense | false | false | string(255) | any |
| paid-date | The date the expense was marked as fully paid | false | false | datetime | any |
| paid-total | The total amount paid | false | false | decimal | any |
| remaining-total | The total amount remaining to be paid | false | false | decimal | any |
| remittance-total | The total remittance amount required | false | false | decimal | any |
| accounting-total | The total of the expense in the CoA currency | false | false | decimal | any |
| exported | A flag indicating if the expense has been marked as exported | false | false | any | |
| last-exported-at | The date that the expense was last marked as exported | false | false | datetime | any |
| document-type | The type of expense | false | false | any | |
| payment-channel | The payment channel on the associated ExpenseReport | false | false | string(255) | any |
| payable-type | The type of associated payable. Value is ExpenseReport | false | false | any | |
| payable-id | The ID of the associated ExpenseReport | false | false | any | |
| chart-of-account-code | The Chart of Accounts name | false | false | any | |
| legal-entity-name | The Chart of Accounts Legal Entity name | false | false | any | |
| custom-field-1 | Integration Custom Field 1 | false | false | string(255) | any |
| custom-field-2 | Integration Custom Field 2 | false | false | string(255) | any |
| custom-field-3 | Integration Custom Field 3 | false | false | string(255) | any |
| custom-field-4 | Integration Custom Field 4 | false | false | string(255) | any |
| custom-field-5 | Integration Custom Field 5 | false | false | string(255) | any |
| custom-field-6 | Integration Custom Field 6 | false | false | string(255) | any |
| custom-field-7 | Integration Custom Field 7 | false | false | string(255) | any |
| custom-field-8 | Integration Custom Field 8 | false | false | string(255) | any |
| custom-field-9 | Integration Custom Field 9 | false | false | string(255) | any |
| custom-field-10 | Integration Custom Field 10 | false | false | string(255) | any |