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