XM_EXPENSE_TYPE

Entity Name XM_EXPENSE_TYPE
Entity Type Independent
Definition This table identifies the valid expense types for an expense line item.

Attributes

Attribute Datatype Width Definition
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