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