XM_EXPENSE_REPORT_LINE_ITEM

Entity Name XM_EXPENSE_REPORT_LINE_ITEM
Entity Type Independent
Definition This table identifies each line item of an expense report.

Attributes

Attribute Datatype Width Definition
AIRLINE_CLASS_OF_SERVICE Varchar 27 The class of airline service if this transaction is for an air flight.
AIRLINE_CLASS_OF_SERVICE_CODE Varchar 1 Cabin type. Possible values for VAR- Y CHAR (255) airline_class_of_service_code: • F First class • B Business class
AIRLINE_DOMESTIC_OR_INTL Integer 1
APPROVED_AMT Float 7 The amount of an expense that is approved in the paid_in_amt currency.
APPROVED_AMT_CURRENCY Varchar 3 The three letter ISO code identifying the currency of the approved_amt
APPROVED_EXCHANGE_RATE Float 3 The exchange rate that is approved for the date of this expense.
BOOKING_AGENT_NAME Varchar 22
BREAKFAST_DEDUCTION Integer 1
CAR_CLASS_OF_SERVICE Varchar 24 The class of car service if the transaction is for a car.
CAR_CLASS_OF_SERVICE_CODE Varchar 2 Vehicle class code. (C: compact; E: Economy, ...)
CAR_RENTAL_AGREEMENT Varchar 20
CHANGE_TIMESTAMP DateTime 23
COMMUTE_MILES Float 4
CREATOR_CLIENT_TYPE Integer 1
CREDIT_CARD_TRANSACTION_ID Integer 7 A foreign key for the credit_card_transaction table identifying the transaction used to create this line item.
DEPARTURE_DATE DateTime 21
DESCRIPTION Varchar 12 A description of the expense.
DESTINATION_AIRPORT Varchar 3
DINNER_DEDUCTION Integer 1
DOCUMENT_ID Integer 11 A foreign key for the expense_report table identifying the line item that is a part of the expense report.
END_DATE DateTime 23
EXCHANGE_RATE Float 13 The exchange rate used when converting the amount from the transaction_amt to the paid_in_amt.
EXPENSE_TYPE_ID Integer 11 A foreign key for the expense_type table identifying the line item expense.
FIRST_DAY_DEDUCTION Integer 1
FLEX_FIELD_AMOUNT_1 Float 3 Flex Field for Currency.
FLEX_FIELD_AMOUNT_1_CURRENCY Varchar 3 Flex Field for Currency ID.
FLEX_FIELD_AMOUNT_2 Float 3 Flex Field for Currency.
FLEX_FIELD_AMOUNT_2_CURRENCY Varchar 3 Flex Field for Currency ID.
FLEX_FIELD_DATE_1 DateTime 23 Flex Field in Datetime type.
FLEX_FIELD_DATE_2 DateTime 23 Flex Field in Datetime type.
FLEX_FIELD_DDLB_1_CODE Varchar 10 Flex Field for DDLB.
FLEX_FIELD_DDLB_2_CODE Varchar 10 Flex Field for DDLB.
FLEX_FIELD_DDLB_3_CODE Varchar 8 Flex Field for DDLB.
FLEX_FIELD_DDLB_4_CODE Varchar 10 Flex Field for DDLB.
FLEX_FIELD_DDLB_5_CODE Varchar 10 Flex Field for DDLB.
FLEX_FIELD_INTEGER_1 Integer 1 Flex Field in Integer type.
FLEX_FIELD_INTEGER_2 Integer 1 Flex Field in Integer type.
FLEX_FIELD_LOCATION_1_ID Integer 1 Flex Field for Location.
FLEX_FIELD_STRING_1 Varchar 20 Flex Field in String type.
FLEX_FIELD_STRING_2 Varchar 20 Flex Field in String type.
FLEX_FIELD_STRING_3 Varchar 20 Flex Field in String type.
FLEX_FIELD_STRING_4 Varchar 20 Flex Field in String type.
GL_CODE Integer 20 The general ledger code used for the expense. Usually defined by the expense type, however, can be overridden.
GUEST_NO_SHOW_COUNT Integer 1
HAS_RECEIPT Integer 1 Availability of a receipt to submit for the expense.
HAVE_RECEIPTS_BEEN_CHECKED Integer 1
HOTEL_CLASS_OF_SERVICE Varchar 25
HOTEL_CLASS_OF_SERVICE_CODE Varchar 3 Room type code.
IS_APPROVED Integer 1 The approval status of the line item.
IS_OVERRIDDEN Integer 1 The overridden or modified status of the line item by a reviewer. Possible values for overridden SMALLINT Y: • 1: Yes • 0 or null: No
IS_PERSONAL Integer 1 The personal expense status.
ITEMIZATION_PARENT_ID Integer 11 Parent of this itemization line item.
ITEMIZATION_STATE Integer 11 The status of the itemization: • 0: No itemization • 1: Itemized • 2: I Itemization
LAST_DAY_DEDUCTION Integer 1
LINE_ITEM_DATE DateTime 21 The date of the expense.
LINE_ITEM_ID Integer 11 The primary key for this table defining an expense line item.
LOCATION_ID Integer 7 A foreign key for the location table identifying the place where the expense is incurred.
LONG_TERM_STAY_DEDUCTION Integer 1
LUNCH_DEDUCTION Integer 1
MANUAL_FOLIO_ITEMIZATION Integer 1 The manually created line item itemization with hotel folio credit card transaction. Possible values for manual_folio_itemization SMALLINT Y: • 1: Yes • 0 or null: No
MILEAGE_RATE Float 18 The mileage rate used for reimbursement.
MILEAGE_RATE_DESCRIPTION Varchar 25
MILEAGE_ROUTE_ID Integer 11 The mileage route ID.
MILES Float 5 The number of miles for a mileage expense.
NUMBER_OF_GUESTS Integer 1 Number of guests associated with a line item.
NUMBER_OF_PASSENGERS Integer 1 The number of passengers on a same rental vehicle.
ODOMETER_END Float 3
ODOMETER_START Float 3
OPTIONAL_DEDUCTION_1 Varchar 10 Optional deduction.
OPTIONAL_DEDUCTION_2 Varchar 10 Optional deduction.
OPTIONAL_DEDUCTION_3 Varchar 10 Optional deduction.
OPTIONAL_DEDUCTION_4 Varchar 10 Optional deduction.
OPTIONAL_DEDUCTION_5 Varchar 10 Optional deduction.
ORIGIN_AIRPORT Varchar 3
OVERNIGHT_STAY_DEDUCTION Integer 1
PAID_IN_AMT Float 7 The expense amount converted to the currency that can be reimbursed by the user.
PAID_IN_AMT_CURRENCY Varchar 3 The three letter ISO code identifying the currency of the paid_in_amt.
PASSENGER_NAME None 0
PAYMENT_TYPE_ID Integer 5 A foreign key for the payment_type table identifying the payment terms of a line item.
PERDIEM_AMOUNT Float 4
PERDIEM_AMOUNT_CURRENCY Varchar 3
PURPOSE Varchar 39 The purpose of the expense line item.
PURPOSE_CREATOR_ID Integer 11 A foreign key for the ext_user table identifying the creator of the purpurpose_creator_id INTEGER Y pose. If this purpose is created in SAT or imported, this value is null.
RECURRING_COUNT Integer 1 Number of times an expense is repeated.
RECURRING_ID Integer 10 ID that associates with a recurring expense.
TICKET_NUMBER Varchar 17
TICKET_STATUS Varchar 23
TRANSACTION_AMT Float 7 The expense amount currency accepted by the vendor.
TRANSACTION_AMT_CURRENCY Varchar 3 The three letter ISO code identifying the currency used in the transaction_amt.
VENDOR_CHAIN_CODE Varchar 20 The SIC chain code for a vendor.
VENDOR_CREATOR_USER_ID Integer 11 A foreign key for the ext_user table identifying the user who created this Vendor_creator_user_id INTEGER Y vendor in the application. If null, the vendor is created with SAT or imported.
VENDOR_GIVEN_SIC_CODE Integer 4 The SIC code for the vendor.
VENDOR_NAME Varchar 21 The name of the vendor who supplied goods or services and is paid for the line item.
lastModified DateTime 24
VariationID Integer 13
ACTIVE_STATUS Varchar 5