| 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: |
| 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 | |