• IT_NUMBER
• BEGIN_LOCATION
• CITY_CODE
• CONFIRMATION
• END_DATE_TIME
• END_LOCATION
• EXPANDED_VENDOR_CODE
• IT_NUMBER
• LINK_CODE
• NT_RATE_AMT
• NT_RATE_CURR_CODE
• NUMBER_IN_PARTY
• OCCUPANCY_CODE
• OVERRIDE_AMT
• OVERRIDE_CURR_CODE
• PNR_ID
• PNR_LAST_UPDATED_DATE
• SEGMENT_NUMBER
• SERVICE_INFORMATION
• STATUS
• TOUR_AMT
• TOUR_CURR_CODE
• TOUR_NAME
• TOUR_SEGMENT_ID
• TXFR_AMT
• TXFR_CURR_CODE
• XTRANT_AMT
• XTRANT_CURR_CODE

IT_NUMBER

Format DATE

Indexed? Yes

May be Null? Yes

BEGIN_LOCATION

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

CITY_CODE

Format VARCHAR2(30)

Indexed? Yes

May be Null? Yes

CONFIRMATION

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

END_DATE_TIME

Format DATE

Indexed? Yes

May be Null? Yes

END_LOCATION

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

EXPANDED_VENDOR_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

IT_NUMBER

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

LINK_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

NT_RATE_AMT

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

NT_RATE_CURR_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

NUMBER_IN_PARTY

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

OCCUPANCY_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

OVERRIDE_AMT

Format NUMBER

Indexed? No

May be Null? Yes

OVERRIDE_CURR_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

PNR_ID

Format VARCHAR2(16)

Indexed? Yes

May be Null? No

The Passenger Name Record (PNR) associated with this toursegment record. 

PNR_LAST_UPDATED_DATE

Format DATE

Indexed? Yes

May be Null? No

The the date that the Passenger Name Record (PNR) associated with this toursegment record was last updated. 

SEGMENT_NUMBER

Format NUMBER

Indexed? Yes

May be Null? No

A numeric value specifying the itinerary segment number for this toursegment. 

SERVICE_INFORMATION

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

STATUS

Format VARCHAR2(2)

Indexed? No

May be Null? Yes

The two character status code for this toursegment. Values: Unknown 

TOUR_AMT

Format NUMBER

Indexed? No

May be Null? Yes

TOUR_CURR_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

TOUR_NAME

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

TOUR_SEGMENT_ID

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

TXFR_AMT

Format NUMBER

Indexed? No

May be Null? Yes

TXFR_CURR_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

XTRANT_AMT

Format NUMBER

Indexed? No

May be Null? Yes

XTRANT_CURR_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes