| EXPORT_TR_HDR_iD
|
N/A
|
INT
|
N
|
A unique number (Bobid).
|
| EXPORT_HDR_STATUS
|
N/A
|
SMALLINT
|
N
|
Status of the export document. Export System
used values are 1, 2, 4 and 5. User defined values range is 100 or higher.
|
| EXPORT_HDR_STATUS_ DATETIME
|
N/A
|
DATETIME
|
N
|
This is the date/time that the
export_hdr_status col. is updated. The value equals export_create_date when
inserting a new row. The purge process to determine when to delete a document
from the export tables.
|
| EXPORT_CREATE_DATE
|
N/A
|
DATETIME
|
N
|
The date/time that the export form of the
document is created (i.e., row was inserted into this table). This is not to be
confused with the travel plan document create date.
|
| EXTR_WORK_ITEM_ID
|
alwf_work_item - work_item_id
|
INT
|
N
|
The ID of the work item that is associated
with this document.
|
| EXTR_TRACKING_NUMBER
|
alwf_work_item - document_id
|
VARCHAR (255)
|
Y
|
The document-identifying ID. This is the
same value found in the work_item col. document_id. Currently it consists of 10
characters formatted as follows: Pos 1-2: TP Pos 3_10: Eight digit sequence
number unique for the database.
|
| EXTR_TITLE
|
altr_travel_request - tr_title
|
VARCHAR (255)
|
Y
|
Title of the proposed trip.
|
| EXTR_PURPOSE
|
altr_travel_request - tr_purpose
|
VARCHAR (255)
|
Y
|
Identifies purpose (BOb) of the trip, like
"Sales Call."
|
| EXTR_NUM_GOING
|
altr_travel_request - tr_num_going
|
INT
|
Y
|
Number of people going on trip.
|
| EXTR_DATE_CREATED
|
altr_travel_request - tr_date_created
|
DATETIME
|
Y
|
Date travel request (travel plan) document
was created.
|
| EXTR_DATE_FILED
|
altr_travel_request - tr_date_filed
|
DATETIME
|
Y
|
Date document was submitted.
|
| EXTR_DATE_FROM
|
altr_travel_request - tr_date_from
|
DATETIME
|
Y
|
Trip starts on this date.
|
| EXTR_DATE_TO
|
altr_travel_request - tr_date_to
|
DATETIME
|
Y
|
Trip goes until this date.
|
| EXTR_DATE_APPROVED
|
altr_travel_request - tr_date_approved
|
DATETIME
|
Y
|
Date document was approved.
|
| EXTR_CURRENCY_ISO
|
|
CHAR (3)
|
Y
|
ISO code for currency used in amounts
(excluding native amounts).
|
| EXTR_TOT_AIR
|
altr_travel_request - tr_tot_air
|
NUMERIC (20, 10)
|
Y
|
Total airfare cost.
|
| EXTR_TOT_HOTEL
|
altr_travel_request - tr_tot_hotel
|
NUMERIC (20, 10)
|
Y
|
Total hotel cost.
|
| EXTR_TOT_HOTEL_TAX
|
altr_travel_request - tr_tot_htax
|
NUMERIC (20, 10)
|
Y
|
Total hotel tax.
|
| EXTR_TOT_CAR
|
altr_travel_request - tr_tot_car
|
NUMERIC (20, 10)
|
Y
|
Total car rental cost.
|
| EXTR_TOT_CAR_TAX
|
altr_travel_request - tr_tot_ctax
|
NUMERIC (20, 10)
|
Y
|
Total car tax.
|
| EXTR_TOT_MEALS
|
altr_travel_request - tr_tot_meals
|
NUMERIC (20, 10)
|
Y
|
Total meal cost.
|
| EXTR_TOT_OTHER
|
altr_travel_request - tr_tot_other
|
NUMERIC (20, 10)
|
Y
|
Total of misc. costs.
|
| EXTR_TOTAL_COST
|
altr_travel_request - tr_total_cost
|
NUMERIC (20, 10)
|
Y
|
Total cost of planned trip.
|
| EXTR_MAX_AIR_TICKET_ AMT
|
altr_travel_request - max_air_ticket_amt
|
NUMERIC (20, 10)
|
Y
|
Maximum airline ticket amount that the
approver is willing to spend for the itinerary associated with the travel plan.
|
| EXTR_TRIP_TYPE_LABEL
|
altr_travel_request - trip_type_id
|
VARCHAR (255)
|
Y
|
This is the label for trip type item
associated with this line item (example: international).
|
| EXTR_ORD_KEY
|
altr_travel_request - ord_key
|
VARCHAR (255)
|
Y
|
The order key. This is a unique key into
external system that identifies each itinerary.
|
| EXTR_INTEGRATION_PARTNER_NAME
|
altr_travel_request - integration_partner_
id
|
VARCHAR (255)
|
Y
|
Name of the integration partner associated
with this line item (from table alob_integration_partner).
|
| EXTR_USER_ID
|
altr_travel_request - user_id
|
INT
|
Y
|
Owner of document.
|
| EXTR_USER_LOGIN
|
alco_user - user_login
|
VARCHAR (255)
|
Y
|
User login of the owner of the travel plan.
|
| EXTR_USER_FULL_NAME
|
alco_user - user_full_name
|
VARCHAR (255)
|
Y
|
User full name.
|
| EXTR_EMPLOYEE_ NUMBER
|
alco_user - employee_number
|
VARCHAR (255)
|
Y
|
User employee number.
|
| EXTR_USER_EMAIL_ ADDRESS
|
alco_user - user_email_address
|
VARCHAR (255)
|
Y
|
User email address.
|
| EXTR_USER_LOCATION
|
alco_user - user_location
|
VARCHAR (255)
|
Y
|
User location.
|
| EXTR_USER_PAYROLL_ SYSTEM_CODE
|
alco_user - payroll_system_code
|
VARCHAR (255)
|
Y
|
User payroll system code.
|
| EXTR_USER_SSN
|
alco_user - user_ssn
|
VARCHAR (255)
|
Y
|
User social security number.
|
| EXTR_USER_COST_CENTER_NAME
|
alco_cost_center - cost_center_name
|
VARCHAR (255)
|
Y
|
User default cost center name.
|
| EXTR_USER_COST_CENTER_CODE
|
alco_cost_center - cost_center_code
|
VARCHAR (255)
|
Y
|
User default cost center code.
|
| EXTR_USER_DEPT_NAME
|
alco_department - department_name
|
VARCHAR (255)
|
Y
|
Department name of user's default cost
center.
|
| EXTR_USER_DIVISION_NAME
|
alco_division -division_name
|
VARCHAR (255)
|
Y
|
Division name of user's default cost center.
|
| EXTR_USER_DEPT_CODE
|
alco_department - department_code
|
VARCHAR (255)
|
Y
|
Department code of user's default cost
center.
|
| EXTR_USER_DIVISION_CODE
|
alco_division -division_code
|
VARCHAR (255)
|
Y
|
Division code of user's default cost center.
|
| EXTR_USER_COMPANY_NAME
|
alco_company -company_name
|
VARCHAR (255)
|
Y
|
Company name of user's default cost center.
|
| EXTR_USER_COMPANY_CODE
|
alco_company -company_code
|
VARCHAR (255)
|
Y
|
Company code of user's default cost center.
|
| PURPOSE_EKEY
|
altr_travel_request - tr_purpose
|
VARCHAR (255)
|
Y
|
External key identifying the purpose of the
travel plan.
|
| CURRENCY_EKEY
|
altr_travel_request - tr_total_cost_id
|
VARCHAR (255)
|
Y
|
External key identifying the currency used
for the amount fields.
|
| USER_EKEY
|
altr_travel_request - user_id
|
VARCHAR (255)
|
Y
|
External key identifying the user who is the
owner of the travel plan.
|
| ITINERARY_STATE
|
altr_travel_request - itinerary_state
|
INT
|
Y
|
-2 = queued -1 = canceled 0 = active but no
ticket 1 = confirmed 2 = ticketed
|
| EXTR_USER_SEGMENT1_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR(255)
|
Y
|
Segment 1 name of user default cost center
|
| EXTR_USER_SEGMENT1_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR(255)
|
Y
|
Segment 1 code of user default cost center
|
| EXTR_USER_SEGMENT2_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR(255)
|
Y
|
Segment 2 name of user default cost center
|
| EXTR_USER_SEGMENT2_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR(255)
|
Y
|
Segment 2 code of user default cost center
|
| EXTR_USER_SEGMENT3_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR(255)
|
Y
|
Segment 3 name of user default cost center
|
| EXTR_USER_SEGMENT3_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR(255)
|
Y
|
Segment 3 code of user default cost center
|
| EXTR_USER_SEGMENT4_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR(255)
|
Y
|
Segment 4 name of user default cost center
|
| EXTR_USER_SEGMENT4_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR(255)
|
Y
|
Segment 4 code of user default cost center
|
| EXTR_USER_SEGMENT5_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR(255)
|
Y
|
Segment 5 name of user default cost center
|
| EXTR_USER_SEGMENT5_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR(255)
|
Y
|
Segment 5 code of user default cost center
|
| EXTR_USER_SEGMENT6_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR(255)
|
Y
|
Segment 6 name of user default cost center
|
| EXTR_USER_SEGMENT6_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR(255)
|
Y
|
Segment 6 code of user default cost center
|
| EXTR_USER_SEGMENT7_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR(255)
|
Y
|
Segment 7 name of user default cost center
|
| EXTR_USER_SEGMENT7_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR(255)
|
Y
|
Segment 7 code of user default cost center
|
| EXTR_USER_SEGMENT8_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR(255)
|
Y
|
Segment 8 name of user default cost center
|
| EXTR_USER_SEGMENT8_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR(255)
|
Y
|
Segment 8 code of user default cost center
|
| EXTR_USER_SEGMENT9_NAME
|
alco_cost_center_segment - segment_name
|
VARCHAR(255)
|
Y
|
Segment 9 name of user default cost center
|
| EXTR_USER_SEGMENT9_CODE
|
alco_cost_center_segment - segment_code
|
VARCHAR(255)
|
Y
|
Segment 9 code of user default cost center
|
| SEGMENT_COUNT
|
alco_cost_center_config - segment_count
|
INTEGER
|
Y
|
The number of segments in this document
owner's cost center.
|
| EXTR_USER_REVIEW_SEGMENT_NAME
|
alco_cost_center_rev_segment - segment_name
|
VARCHAR(255)
|
Y
|
The review segment name of this document
owner's cost center.
|
| EXTR_USER_REVIEW_SEGMENT_CODE
|
alco_cost_center_rev_segment - segment_code
|
VARCHAR(255)
|
Y
|
The review segment code of this document
owner's cost center.
|