ALTR_TRAVEL_PLAN_EXPORT_LINE (Attributes)

Column	Source	Data type	Null	Description
EXPORT_TR_LINE_ID	N/A	INT	N	A unique number that serves as the primary key of this table. This is not the extr_line_item_id of altr_line_item table.
EXPORT_TR_HDR_ID	N/A	INT	Y	The BOb ID (PK) of altr_travel_plan_export_ header row that is parent to the line items in this table.
EXTR_EXPORT_LINE_ STATUS	N/A	INT	Y	The export status of the line item.
EXTR_LINE_STATUS_ DATETIME	N/A	DATETIME	Y	The date and time when the status is last updated.
EXTR_TR_LINE_ITEM_ ID	altr_line_item - tr_line_item_id	INT	Y	Foreign key back to the source table, altr_line_item.
EXTRLI_ITEM_TYPE	altr_line_item - tr_item_type_id	VARCHAR (255)	Y	Identifies the type of travel cost for this line item, example "Hotel."
EXTRLI_PURPOSE	altr_line_item - purpose	VARCHAR (255)	Y	Identifies purpose of this item.
EXTRLI_FROM_DATE	altr_line_item - from_date	DATETIME	Y	Date of origin.
EXTRLI_FROM_TIME	altr_line_item - from_time	DATETIME	Y	Time of origin (start of trip).
EXTRLI_TO_DATE	altr_line_item - to_date	DATETIME	Y	Date of destination.
EXTRLI_TO_TIME	altr_line_item - to_time	DATETIME	Y	Time of destination.
EXTRLI_CURRENCY_ISO		CHAR (3)	Y	The ISO code for the base currency used in amounts (except native amounts).
EXTRLI_COST	altr_line_item - tax	NUMERIC (20, 10)	Y	Cost of this line item.
EXTRLI_TAX_COST	altr_line_item - tax_cost	NUMERIC (20, 10)	Y	Estimated tax associated with the cost of this line item.
EXTRLI_DAILY_RATE	altr_line_item - daily_rate	NUMERIC (20, 10)	Y	Daily rate for this item. Example: 29.95 for the car rental.
EXTRLI_NATIVE_ CURRENCY_ISO	altr_line_item - daily_rate_native_id	CHAR (3)	Y	The ISO code for native currency associated with native amounts.
EXTRLI_DAILY_RATE_ NATIVE	altr_line_item - daily_rate_native	NUMERIC (20, 10)	Y	Daily rate for this item, in currency local to where expense will be incurred.
EXTRLI_EXCHANGE_RATE	altr_line_item - exch_rate	NUMERIC (20, 10)	Y	Exchange rate between local and default currency.
EXTRLI_REIMBURSE_RATE	altr_line_item - reimburse_rate	NUMERIC (20, 10)	Y
EXTRLI_AVERAGE_COST	altr_line_item - average_cost	NUMERIC (20, 10)	Y
EXTRLI_MILES	altr_line_item - miles	INT	Y	Miles driven.
EXTRLI_DESCRIPTION_1	altr_line_item - description1	VARCHAR (255)	Y	For air segment, this field stores the "from airport" code and name. For car segment, this field stores the pickup location code.
EXTRLI_DESCRIPTION_2	altr_line_item - description2	VARCHAR (255)	Y	For air segment, this field stores the "to airport" code and name. For car segment, this field stores the drop-off location code.
EXTRLI_EXT_BOOKING_ KEY	altr_line_item - ext_booking_key	VARCHAR (255)	Y	For imported line items, this column may contain an external identifier for it into another system.
EXTRLI_CUST_DEF_1	altr_line_item - cust_def_1	VARCHAR (255)	Y	A customer defined field.
EXTRLI_CUST_DEF_2	altr_line_item - cust_def_2	VARCHAR (255)	Y	A customer defined field.
EXTRLI_CUST_DEF_3	altr_line_item - cust_def_3	VARCHAR (255)	Y	A customer defined field.
EXTRLI_CHARGE_TO_ STRING	altr_line_item_ allocation - charge_to_string	VARCHAR (255)	Y	Entity this item is charged to display string.
EXTRLI_CHARGE_TO_ CODE	altr_line_item_ allocation - charge_to_code	INT	Y	1 = Cost center 2 = Project code
EXTRLI_ALLOC_BASE_AMT	aler_line_allocation - base_amount	NUMERIC (20, 10)	Y	The base amount for the line allocation. This is the amount to be exported.
EXTRLI_ALLOC_BASE_AMT_ISO	aler_line_allocation - base_amount_id	VARCHAR (10)	Y	The ISO code of the currency used for the above base amount.
EXTRLI_ALLOC_NATIVE_ AMT	aler_line_allocation - native_amount	NUMERIC (20, 10)	Y	The amount for the allocation in its native currency.
EXTRLI_ALLOC_NATIVE_ AMT_ISO	aler_line_allocation - native_amount_id	VARCHAR (10)	Y	The ISO code of the currency used for the above native amount.
EXTRLI_ALLOC_EXCH_ RATE	altr_line_item - exch_rate	NUMERIC (20, 10)	Y	Exchange rate between local and default currency.
EXTRLI_ALLOC_PERCENT_ALLOTTED	aler_line_allocation - percent_allotted	NUMERIC (26, 16)	Y	Percentage accounted by this allocation for the parent expense line.
EXTRLI_ALLOC_COST_ CENTER_NAME	alco_cost_center - cost_center_name	VARCHAR (255)	Y	The cost center name for the allocation, if any. Derived from the alco_cost_center table.
EXTRLI_ALLOC_COST_ CENTER_CODE	aler_line_allocation - cost_center_id	VARCHAR (255)	Y	The cost center code for the allocation, if any. Derived from the alco_cost_center table.
EXTRLI_ALLOC_PROJECT_CODE	aler_line_allocation - project_number_id	VARCHAR (255)	Y	The project code for the allocation, if any. Derived from the table alco_project_number.
EXTRLI_ALLOC_PARENT_ PROJECT_CD	alco_project_number - parent_project_code	VARCHAR (255)	Y	The parent project code for the above project_code, if any. Derived from the table alco_project_number.
EXTRLI_ALLOC_TOP_ PROJECT_CODE	alco_project_number - top_project_code	VARCHAR (255)	Y	The top project code for the above project_code, if any. Derived from the table alco_project_number.
EXTRLI_ALLOC_PROJECT_NUM_BOBID	aler_line_allocation - project_number_id	INT	Y
EXTRLI_ALER_ALLOC_LINE_ID	aler_line_allocation - line_allocation_id	INT	Y	This is the BOb ID of the aler_line_allocation row for this line item. Note: Not the same as the one from altr_line_allocation, which may not be in use.
EXTRLI_EXPTYPE_SPECIAL_CODE	altr_line_item - tr_item_type_id	INT	Y	The special code value (See table alco_expense_ special_code for domain values) of the expense type associated with the travel line item. See EXLI_EXPENSE_SPECIAL_CODE column of Expense Report Line Export table for possible values of this field.
EXTRLI_FROM_STREET	altr__line_item - from_location	VARCHAR (255)	Y	Street.
EXTRLI_FROM_SUBURB	altr__line_item - from_location	VARCHAR (255)	Y	Suburb.
exTRli_FROM_city	altr__line_item - from_location	VARCHAR (255)	Y	City of the "from location."
exTRli_FROM_county	altr__line_item - from_location	VARCHAR (255)	Y	County of the "from location."
exTRli_FROM_state	altr__line_item - from_location	VARCHAR (255)	Y	State of the "from location."
exTRli_FROM_country	altr__line_item - from_location	VARCHAR (255)	Y	Country where "to location" exists.
EXTRLI_TO_STREET	altr__line_item - to_location	VARCHAR (255)	Y	"To location" street.
EXTRLI_TO_SUBURB	altr__line_item - to_location	VARCHAR (255)	Y	Suburb.
exTRli_TO_city	altr__line_item - to_location	VARCHAR (255)	Y	City of the "from location."
exTRli_TO_county	altr__line_item - to_location	VARCHAR (255)	Y	County of the "from location."
exTRli_TO_state	altr__line_item - to_location	VARCHAR (255)	Y	State of the "from location."
exTRli_TO_country	altr__line_item - to_location	VARCHAR (255)	Y	Country where "from location" exists.
exTRli_alloc_is_billable	aler_line_allocation - is_billable	smallint	Y	Determines if the allocated expense billable.
TRAVEL_ITEM_EKEY	altr_line_item - tr_item_type_id	VARCHAR (255)	Y	External key identifying the type of travel.
PURPOSE_EKEY	altr_line_item - purpose	VARCHAR (255)	Y	External key identifying the purpose.
CURRENCY_EKEY	altr_line_item - cost_id	VARCHAR (255)	Y	External key identifying the base amounts currency.
NATIVE_CURRENCY_EKEY	altr_line_item - daily_rate_native_id	VARCHAR (255)	Y	External key identifying the native amounts currency.
ALLOC_BASE_CURRENCY_EKEY	aler_line_allocation - base_amount_id	VARCHAR (255)	Y	External key identifying the base amount currency for the allocation.
ALLOC_NATIVE_CURRENCY_EKEY	aler_line_allocation - native_amount_id	VARCHAR (255)	Y	External key identifying the native amount currency for the allocation.
ALLOC_COST_CENTER_ EKEY	aler_line_allocation - cost_center_id	VARCHAR (255)	Y	External key identifying the cost center for the allocation.
ALLOC_PROJECT_EKEY	aler_line_allocation - project_number_id	VARCHAR (255)	Y	External key identifying the project for the allocation.
FROM_LOCATION_EKEY	altr_line_item - from_location	VARCHAR (255)	Y	External key identifying the "from location."
TO_LOCATION_EKEY	altr_line_item - to_location	VARCHAR (255)	Y	External key identifying the "to location."
TRIP_TYPE	altr_line_item - trip_type	CHAR (2)	Y	RT for round trip, OW for one way, MC for multi-city
FROM_AIRPORT_CODE	altr_line_item - from_airport_code	CHAR (3)	Y	Three character airport code for the part of this leg of the trip
TO_AIRPORT_CODE	altr_line_item - to_airport_code	CHAR (3)	Y	Three character airport code for part of trip
LOWEST_AIRFARE	altr_line_item - lowest_airfare	NUMBER (20, 10)	Y	The lowest airfare, typically coming from the imported itinerary
LOWEST_AIRFARE_ CURRENCY_ISO	altr_line_item - lowest_airfare_id	CHAR (3)	Y	ISO currency code associated with the lowest airfare
LOWEST_AIRFARE_ CURRENCY_EKEY	altr_line_item - lowest_airfare_id	VARCHAR (255)	Y	External key of the currency associated with the lowest airfare
LOWEST_HOTEL_RATE	altr_line_item - lowest_hotel_rate	NUMBER (20, 10)	Y	The lowest hotel, typically coming from the imported itinerary
LOWEST_HOTEL_RATE_ CURR_ISO	altr_line_item - lowest_hotel_rate	CHAR (3)	Y	ISO currency code associated with the lowest hotel rate
LOWEST_HOTEL_RATE_ CURR_EKEY	altr_line_item - lowest_hotel_rate	VARCHAR (255)	Y	External key of the currency associated with the lowest hotel rate
BOOKING_SOURCE	altr_line_item - booking_source	CHAR (2)	Y	ON for online-booked, OF for offline-booked
AGENCY_NAME	altr_line_item - agency_name	VARCHAR (40)	Y	The agency name for those travel plans not booked online
GUEST_COUNT	altr_line_item - guest_count	INT	Y	Line item total guest count
GUEST_ENTRY_MODE	altr_line_item - guest_entry_mode	SMALLINT	Y	The guest entry mode (Count, Guests, or Both)
GUEST_AMOUNTS_EQUAL	altr_line_item - guest_amounts_equal	SMALLINT	Y	Whether the line item amount is equally split across guests
GUEST_NO_SHOW_COUNT	Altr_line_item - guest_no_show_count	INT	Y	The guest no-show count
EXPORT_STATUS	altr_line_item – export_status	INT	Y	the export status (0=not exported, 1=exported, 2=marked for re-export)
VOID_STATUS	altr_line_item – void_status	INT	Y	the void status (0=not voided, 1=voided, 2=this is a reversal that cancels out a voided line item)
REVERSAL_LINE_ITEM_ID	altr_line_item – reversal_line_item_id	INT	Y	for voided/reversal line items, this is the matching reversal/voided line item
EXPORT_DATE	altr_line_item – export_date	DATETIME	Y	The date the item was first exported to the financial system

EXPORT_TR_LINE_ID

N/A

INT

N

A unique number that serves as the primary key of this table. This is not the extr_line_item_id of altr_line_item table.

EXPORT_TR_HDR_ID

N/A

INT

Y

The BOb ID (PK) of altr_travel_plan_export_ header row that is parent to the line items in this table.

EXTR_EXPORT_LINE_ STATUS

N/A

INT

Y

The export status of the line item.

EXTR_LINE_STATUS_ DATETIME

N/A

DATETIME

Y

The date and time when the status is last updated.

EXTR_TR_LINE_ITEM_ ID

altr_line_item - tr_line_item_id

INT

Y

Foreign key back to the source table, altr_line_item.

EXTRLI_ITEM_TYPE

altr_line_item - tr_item_type_id

VARCHAR (255)

Y

Identifies the type of travel cost for this line item, example "Hotel."

EXTRLI_PURPOSE

altr_line_item - purpose

VARCHAR (255)

Y

Identifies purpose of this item.

EXTRLI_FROM_DATE

altr_line_item - from_date

DATETIME

Y

Date of origin.

EXTRLI_FROM_TIME

altr_line_item - from_time

DATETIME

Y

Time of origin (start of trip).

EXTRLI_TO_DATE

altr_line_item - to_date

DATETIME

Y

Date of destination.

EXTRLI_TO_TIME

altr_line_item - to_time

DATETIME

Y

Time of destination.

EXTRLI_CURRENCY_ISO

CHAR (3)

Y

The ISO code for the base currency used in amounts (except native amounts).

EXTRLI_COST

altr_line_item - tax

NUMERIC (20, 10)

Y

Cost of this line item.

EXTRLI_TAX_COST

altr_line_item - tax_cost

NUMERIC (20, 10)

Y

Estimated tax associated with the cost of this line item.

EXTRLI_DAILY_RATE

altr_line_item - daily_rate

NUMERIC (20, 10)

Y

Daily rate for this item. Example: 29.95 for the car rental.

EXTRLI_NATIVE_ CURRENCY_ISO

altr_line_item - daily_rate_native_id

CHAR (3)

Y

The ISO code for native currency associated with native amounts.

EXTRLI_DAILY_RATE_ NATIVE

altr_line_item - daily_rate_native

NUMERIC (20, 10)

Y

Daily rate for this item, in currency local to where expense will be incurred.

EXTRLI_EXCHANGE_RATE

altr_line_item - exch_rate

NUMERIC (20, 10)

Y

Exchange rate between local and default currency.

EXTRLI_REIMBURSE_RATE

altr_line_item - reimburse_rate

NUMERIC (20, 10)

Y

EXTRLI_AVERAGE_COST

altr_line_item - average_cost

NUMERIC (20, 10)

Y

EXTRLI_MILES

altr_line_item - miles

INT

Y

Miles driven.

EXTRLI_DESCRIPTION_1

altr_line_item - description1

VARCHAR (255)

Y

For air segment, this field stores the "from airport" code and name. For car segment, this field stores the pickup location code.

EXTRLI_DESCRIPTION_2

altr_line_item - description2

VARCHAR (255)

Y

For air segment, this field stores the "to airport" code and name. For car segment, this field stores the drop-off location code.

EXTRLI_EXT_BOOKING_ KEY

altr_line_item - ext_booking_key

VARCHAR (255)

Y

For imported line items, this column may contain an external identifier for it into another system.

EXTRLI_CUST_DEF_1

altr_line_item - cust_def_1

VARCHAR (255)

Y

A customer defined field.

EXTRLI_CUST_DEF_2

altr_line_item - cust_def_2

VARCHAR (255)

Y

A customer defined field.

EXTRLI_CUST_DEF_3

altr_line_item - cust_def_3

VARCHAR (255)

Y

A customer defined field.

EXTRLI_CHARGE_TO_ STRING

altr_line_item_ allocation - charge_to_string

VARCHAR (255)

Y

Entity this item is charged to display string.

EXTRLI_CHARGE_TO_ CODE

altr_line_item_ allocation - charge_to_code

INT

Y

1 = Cost center 2 = Project code

EXTRLI_ALLOC_BASE_AMT

aler_line_allocation - base_amount

NUMERIC (20, 10)

Y

The base amount for the line allocation. This is the amount to be exported.

EXTRLI_ALLOC_BASE_AMT_ISO

aler_line_allocation - base_amount_id

VARCHAR (10)

Y

The ISO code of the currency used for the above base amount.

EXTRLI_ALLOC_NATIVE_ AMT

aler_line_allocation - native_amount

NUMERIC (20, 10)

Y

The amount for the allocation in its native currency.

EXTRLI_ALLOC_NATIVE_ AMT_ISO

aler_line_allocation - native_amount_id

VARCHAR (10)

Y

The ISO code of the currency used for the above native amount.

EXTRLI_ALLOC_EXCH_ RATE

altr_line_item - exch_rate

NUMERIC (20, 10)

Y

Exchange rate between local and default currency.

EXTRLI_ALLOC_PERCENT_ALLOTTED

aler_line_allocation - percent_allotted

NUMERIC (26, 16)

Y

Percentage accounted by this allocation for the parent expense line.

EXTRLI_ALLOC_COST_ CENTER_NAME

alco_cost_center - cost_center_name

VARCHAR (255)

Y

The cost center name for the allocation, if any. Derived from the alco_cost_center table.

EXTRLI_ALLOC_COST_ CENTER_CODE

aler_line_allocation - cost_center_id

VARCHAR (255)

Y

The cost center code for the allocation, if any. Derived from the alco_cost_center table.

EXTRLI_ALLOC_PROJECT_CODE

aler_line_allocation - project_number_id

VARCHAR (255)

Y

The project code for the allocation, if any. Derived from the table alco_project_number.

EXTRLI_ALLOC_PARENT_ PROJECT_CD

alco_project_number - parent_project_code

VARCHAR (255)

Y

The parent project code for the above project_code, if any. Derived from the table alco_project_number.

EXTRLI_ALLOC_TOP_ PROJECT_CODE

alco_project_number - top_project_code

VARCHAR (255)

Y

The top project code for the above project_code, if any. Derived from the table alco_project_number.

EXTRLI_ALLOC_PROJECT_NUM_BOBID

aler_line_allocation - project_number_id

INT

Y

EXTRLI_ALER_ALLOC_LINE_ID

aler_line_allocation - line_allocation_id

INT

Y

This is the BOb ID of the aler_line_allocation row for this line item. Note: Not the same as the one from altr_line_allocation, which may not be in use.

EXTRLI_EXPTYPE_SPECIAL_CODE

altr_line_item - tr_item_type_id

INT

Y

The special code value (See table alco_expense_ special_code for domain values) of the expense type associated with the travel line item. See EXLI_EXPENSE_SPECIAL_CODE column of Expense Report Line Export table for possible values of this field.

EXTRLI_FROM_STREET