| CATEGORY_CLASS | Integer | 1 | An integer representing the expense type category. |
| CATEGORY_LABEL | Varchar | 31 | |
| CHANGE_TIMESTAMP | DateTime | 23 | |
| DESCRIPTION | Varchar | 43 | A description of the expense type. For example, airfare or car rental. |
| EXPENSE_SPECIAL_CODE | Integer | 2 | A code that defines the processing attributes of an expense type. Possible values for expense_special_code INTEGER Y, equivalent to a transaction code : • 1 (unknown) • 0 (other) • 1 (breakfast) • 2 (dinner) • 3 (lunch) • 4 (business meals) • 5 (entertainment) • 6 (gifts) • 7 (mileage) • 8 (charitable donations) • 9 (gifts logo) • 10 (promotional sponsorship) • 11 (spousal lodging) • 12 (spousal meals) • 13 (spousal travel) • 14 (entertainment, sports) • 15 (club membership) • 16 (cash advance) • 17 (airline ticket) • 21 (car rental) |
| EXPENSE_TYPE_ID | Integer | 11 | The primary key identifying each unique expense type. |
| EXTERNAL_SYSTEM_ID | Integer | 3 | |
| GL_CODE | Integer | 20 | The natural or short general ledger code for the expense type. |
| IS_PER_DIEM_TYPE | Integer | 1 | The per diem type status: • 1: Yes • 0: No |
| MAJOR_ACCOUNT | Integer | 10 | The major account. The accounting concept that is used by some companies. |
| TAX_DEDUCTABLE_PERCENT | Integer | 1 | The percentage of the tax-deductible amount charged to the expense type. |
| TRAVEL_CATEGORY | Varchar | 18 | The travel category associated with the expense type. |
| lastModified | DateTime | 24 | |
| VariationID | Integer | 13 | |
| ACTIVE_STATUS | Varchar | 4 | |