LINE_ITEM_ID |
Integer |
11 |
PK |
DOCUMENT_ID |
Integer |
11 |
Identifying the invoice that this line item is part of. |
TRAVEL_EXPENSE_TYPE_ID |
Integer |
11 |
Type of travel cost for this line item, eg 'Hotel' see |
COST_AMOUNT_CURRENCY |
Varchar |
3 |
Currency of amount |
COST_AMOUNT |
Float |
3 |
Cost of amount |
TAX_AMOUNT_CURRENCY |
Varchar |
3 |
Currency of Tax |
TAX_AMOUNT_CURRENCY |
Float |
|
Tax |
PURPOSE |
Varchar |
255 |
Purpose |
PURPOSE_USER_ID |
Integer |
|
Creater of user purpose |
VENDOR_NAME |
Varchar |
255 |
Vendor |
VENDOR_USER_ID |
Integer |
11 |
Creater of this vendor |
FROM_LOCATION_ID |
Integer |
|
Location of origin |
FROM_Date |
DateTime |
|
Date of origin |
From_time |
DateTime |
38 |
Time of origin |
TO_LOCATION_ID |
Integer |
38 |
Location of destination |
TO_DATE |
DateTime |
|
Date of destination |
TO_TIME |
DateTime |
|
Time of destination |
CLASS_OF_SERVICE |
Varchar |
255 |
Class of service |
DAILY_RATE_AMOUNT |
float |
3 |
daily rate for this item, like 29.95 for the car rental |
DAILY_RATE_AMOUNT_CURRENCY |
Varchar |
3 |
Currency of daily rate amount |
CUST_DEF_1 |
varchar |
255 |
Customer defined field |
|
|
|
|
CUST_DEF_2 |
Varchar |
255 |
Customer defined field |
CUST_DEF_3 |
Varchar |
255 |
Customer defined field |
DAILY_RATE_NATIVE_AMOUNT |
Float |
|
daily rate for this item, in currency local to where expense will be incurred
|
DAILY_RATE_NATIVE_AMOUNT_CURR |
Varchar |
3 |
Currency of daily rate amount |
EXCHANGE_RATE |
number |
28,10 |
exchange rate between local and default currency |
MILES |
Number |
|
Miles driven |
REIMBURSE_RATE |
Float |
|
Reimburse rate |
AVERAGE_COST_AMOUNT |
Float |
|
Average cost amount |
AVERAGE_COST_AMOUNT_CURRENCY |
Varchar |
3 |
Currency of average cost amount |
IS_IMPORTED |
Number |
5 |
F lag to indicate whether current line item is an imported line item 0 = no 1 =
yes |
DESCRIPTION1 |
Varchar |
255 |
For air segment, this field stores the from airport code and name. For car
segment, this field stores the pickup location code. |
DESCRIPTION2 |
Varchar |
255 |
For air segment, this field stores the to airport code and name. For car
segment, this field stores the dropoff location code |
EXT_BOOKING_KEY |
Varchar |
255 |
For imported line items, this column may contain an external identifier for it
into another system. |
EXCH_RATE_DEFAULT |
Number |
28 |
default foreign exchange rate |
TRIP_TYPE |
Varchar |
2 |
RT for round trip, OW for one way, MC for multi-city |
FROM_AIRPORT_CODE |
Varchar |
3 |
three character airport code for the part of this leg of the trip |
TO_AIRPORT_CODE |
Varchar |
3 |
three character airport code for part of trip |
LOWEST_AIRFARE_AMT |
Float |
|
the lowest airfare, typically coming from the imported itinerary |
LOWEST_AIRFARE_AMT_CURRENCY |
Varchar |
3 |
Currency of lowest air fair amount |
LOWEST_HOTEL_RATE_AMT |
Float |
|
the lowest Hotel fare, typically coming from the imported itinerary |
LOWEST_HOTEL_RATE_AMT_CURRENCY |
Varchar |
3 |
Currency of lowest hotel fair amount |
BOOKING_SOURCE |
Varchar |
2 |
ON for online-booked, OF for offline-booked |
AGENCY_NAME |
Varchar |
255 |
captures the agency name for those travel plans not booked online |
NUMBER_OF_GUESTS |
Number |
38 |
Number of guests |
CHANGE_TIMESTAMP |
DateTime |
|
|
GUEST_NO_SHOW_COUNT |
Number |
38 |
The guest no-show count |
CREATOR_CLIENT_TYPE |
Number |
38 |
the client that created the line item (1=HTML, 2=Mobile, 3=Voice,
4=DocumentImportBkg) |
EXPORT_STATUS |
Number |
38 |
the export status (0=not exported, 1=exported, 2=marked for re-export |
REVERSAL_LINE_ITEM_ID |
Number |
38 |
for voided/reversal line items, this is the matching reversal/ voided line item
|
Void_STATUS |
Number |
38 |
the void status (0=not voided, 1=voided, 2=this is a reversal that cancels out a
voided line item) |