| DOCUMENT_ID |
Integer |
11 |
PK |
| TRACKING_NUMBER |
Varchar |
255 |
Tracking Number |
| DOCUMENT_STATUS |
Varchar |
10 |
Status of document |
| HAS_EXCEPTIONS |
Number |
5 |
1 if there are any exceptions, ie business rule violations |
| HAS_OVERRIDES |
Number |
5 |
1 if there are any overrides, ie the approved amount for an expense is |
| CURRENT_ACTIVITY_ID |
Integer |
11 |
id of current activity. activities are the nodes of work-flow, and documents are
routed from node to node. |
| CURRENT_ACTIVITY_ENTRY_DATE |
DateTime |
|
The date the item entered the queue, a queue holds items for an activity,
waiting to be checked out. |
| CREATOR_USER_ID |
Integer |
11 |
Creator of this document |
| OWNERR_USER_ID |
Integer |
11 |
Owner of this document |
| ACTIVITY_OWNER_ID |
Number |
38 |
Currency activity user |
| SUBMITTED_DATE |
DateTime |
|
The date the doc was submitted |
| APPROVED_DATE |
DateTime |
|
The date the document was approved |
| FROM_DATE |
DateTime |
|
The date the trip was started |
| TO_DATE |
DateTime |
|
The trip goes till this date |
| CREATE_DATE |
DateTime |
|
The date the doc was created |
| TITLE |
Varchar |
255 |
Title of proposed trip. |
| PURPOSE |
Varchar |
255 |
purpose |
| PURPOSE_USER_ID |
Number |
38 |
Creator of this purpose |
| TOTAL_CALCULATED_AMOUNT |
Float |
3 |
Total amount of the check request calculated by summing all line items |
| NUMBER_GOING |
Number |
38 |
Number of people going on trip |
| AIR_AMOUNT |
Float |
|
total airfare cost |
| AIR_AMOUNT_CURRENCY |
Varchar |
3 |
Currency of airfare amount |
| HOTEL_AMOUNT |
Float |
|
Total hotel cost |
| HOTEL_AMOUNT_CURRENCY |
Varchar |
3 |
Currency of hotel amount |
| HOTEL_TAX_AMOUNT |
Float |
|
Total hotel tax |
| HOTEL_TAX_AMOUNT_CURRENCY |
Varchar |
3 |
Currency of hotel tax |
| CAR_AMOUNT_CURRENCY |
Varchar |
3 |
Currency of car amount |
| CAR_AMOUNT |
Float |
|
Total car cost |
| INTEGRATION_PARTNER_NAME |
Varchar |
255 |
Integration partner name |
| CAR_TAX_AMOUNT |
Float |
|
Total car tax |
| CAR_TAX_AMOUNT_CURRENCY |
Varchar |
3 |
Currency of car tax amount |
| MEALS_AMOUNT |
float |
|
Toal meals cost |
| MEALS_AMOUNT_CURRENCY |
varchar |
3 |
Currency of meals amount |
| OTHER_AMOUNT |
Float |
|
Total of misc. cost |
| OTHER_AMOUNT_CURRENCY |
Varchar |
3 |
Currency of other amount |
| TOTAL_AMOUNT |
Float |
|
Total cost |
| TOTAL_AMOUNT_CURRENCY |
Varchar |
3 |
Currency of Total cost |
| EMPLOYEE_COMPANY |
Varchar |
255 |
employee company when document created |
| TRIP_TYPE |
Varchar |
255 |
Type of trip (eg:International) |
| ORD_KEY |
Varchar |
255 |
The order key. This is a unique key into external system that identifies each
itinerary. |
| MAX_AIR_TICKET_AMOUNT |
Float |
|
Maximum air line ticket amount that the approver is willing to spend for the
itinerary associated with the travel plan |
| MAX_AIR_TICKET_AMOUNT_CURRENCY |
Varchar |
3 |
Currency of ax air ticket amount |
| ITINERARY_STATE |
Number |
28 |
- 2 = queued, -1 = canceled, 0 = active but no ticket, 1 = confirmed, 2 =
ticketed |
| CREATE_LOCATION_ID |
Number |
38 |
The bob id of the location where the travel plan is created. |
| CREATOR_CLIENT_TYPE |
Number |
38 |
the client that created the document (1=HTML, 2=Mobile, 3=Voice,
4=DocumentImportBkg) |
| CHANGE_TIMESTAMP |
DateTime |
|
Change timestamp |