• ADDRESS_LINE_1
• ADDRESS_LINE_2
• ADDRESS_LINE_3
• APPROVER
• BOOKED_IATA
• CD_NUMBER
• CHAIN_CODE
• CHAIN_NAME
• CHECK_IN_DATE
• CHECK_OUT_DATE
• CITY_CODE
• CITY_NAME
• CONFIRMATION
• CORP_RATE
• COUNTRY
• COUNTRY_CODE
• CXL_POLICY
• DECLINED_PROPERTY_AMT
• DECLINED_PROPERTY_CODE
• DISCOUNT_TYPE
• EXCEPTION_CODE
• FAX_NUMBER
• FREQ_GUEST_ID
• HOTELSEGMENT_ID
• ID_NUMBER
• IN_POLICY
• MISC_1
• MISC_2
• MISC_3
• MISC_4
• MISC_5
• NAME
• NEG_RATE
• ORIG_RATE
• PERDIEM_RATE
• PHONE_NUMBER
• PNR_ID
• PNR_LAST_UPDATED_DATE
• POLICY_EXCEPTION_RMK
• POLICY_THRESHOLD
• POLICY_VIOLATION_CODE
• PREPAID_FOP
• PROPERTY_CODE
• RADIUS_RATE
• RATE_CODE
• RATE_CURR_CODE
• RATE_QUOTE
• REPORTING_TEXT_1
• ROOM_TYPE
• SEGMENT_NUMBER
• STATUS
• TAX_1_AMT
• TAX_1_CURR_CODE
• TAX_1_DESC
• TAX_2_AMT
• TAX_2_CURR_CODE
• TAX_2_DESC

ADDRESS_LINE_1

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

The hotel address line 1 for this hotel segment. 

ADDRESS_LINE_2

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

The hotel address line 3 for this hotel segment. 

ADDRESS_LINE_3

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

The hotel address line 3 for this hotel segment. 

APPROVER

Format VARCHAR2(8)

Indexed? No

May be Null? Yes

BOOKED_IATA

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

CD_NUMBER

Format VARCHAR2(10)

Indexed? No

May be Null? Yes

CHAIN_CODE

Format VARCHAR2(2)

Indexed? No

May be Null? Yes

The two character hotel chain code identifying the hotel chain asscoaietd with this hotel segment. 

CHAIN_NAME

Format VARCHAR2(35)

Indexed? No

May be Null? Yes

The two character hotel chain name associated with this hotel segment. 

CHECK_IN_DATE

Format DATE

Indexed? Yes

May be Null? Yes

The hotel check in date. 

CHECK_OUT_DATE

Format DATE

Indexed? Yes

May be Null? Yes

The hotel check out date. 

CITY_CODE

Format VARCHAR2(3)

Indexed? Yes

May be Null? Yes

The IATA code of the hotel city for this hotel segment. 

CITY_NAME

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

The hotel city name for this hotel segment. 

CONFIRMATION

Format VARCHAR2(15)

Indexed? No

May be Null? Yes

The confirmation number for this hotel reservation. 

CORP_RATE

Format NUMBER

Indexed? No

May be Null? Yes

COUNTRY

Format VARCHAR2(1000)

Indexed? No

May be Null? Yes

The hotel country name for this hotel segment. 

COUNTRY_CODE

Format VARCHAR2(2)

Indexed? Yes

May be Null? Yes

The two character hotel country code for this hotel segment. 

CXL_POLICY

Format VARCHAR2(34)

Indexed? No

May be Null? Yes

DECLINED_PROPERTY_AMT

Format NUMBER

Indexed? No

May be Null? Yes

DECLINED_PROPERTY_CODE

Format VARCHAR2(2)

Indexed? No

May be Null? Yes

DISCOUNT_TYPE

Format VARCHAR2(1)

Indexed? No

May be Null? Yes

EXCEPTION_CODE

Format VARCHAR2(2)

Indexed? No

May be Null? Yes

FAX_NUMBER

Format VARCHAR2(14)

Indexed? No

May be Null? Yes

FREQ_GUEST_ID

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

HOTELSEGMENT_ID

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

ID_NUMBER

Format VARCHAR2(16)

Indexed? No

May be Null? Yes

IN_POLICY

Format VARCHAR2(1)

Indexed? No

May be Null? Yes

MISC_1

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

MISC_2

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

MISC_3

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

MISC_4

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

MISC_5

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

NAME

Format VARCHAR2(23)

Indexed? No

May be Null? Yes

NEG_RATE

Format NUMBER

Indexed? No

May be Null? Yes

ORIG_RATE

Format NUMBER

Indexed? No

May be Null? Yes

PERDIEM_RATE

Format NUMBER

Indexed? No

May be Null? Yes

PHONE_NUMBER

Format VARCHAR2(15)

Indexed? No

May be Null? Yes

PNR_ID

Format VARCHAR2(16)

Indexed? Yes

May be Null? No

PNR_LAST_UPDATED_DATE

Format DATE

Indexed? Yes

May be Null? No

POLICY_EXCEPTION_RMK

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

POLICY_THRESHOLD

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

POLICY_VIOLATION_CODE

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

PREPAID_FOP

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

PROPERTY_CODE

Format VARCHAR2(6)

Indexed? No

May be Null? Yes

RADIUS_RATE

Format NUMBER

Indexed? No

May be Null? Yes

RATE_CODE

Format VARCHAR2(9)

Indexed? No

May be Null? Yes

RATE_CURR_CODE

Format VARCHAR2(3)

Indexed? No

May be Null? Yes

RATE_QUOTE

Format NUMBER

Indexed? No

May be Null? Yes

REPORTING_TEXT_1

Format VARCHAR2(200)

Indexed? No

May be Null? Yes

ROOM_TYPE

Format VARCHAR2(4)

Indexed? No

May be Null? Yes

SEGMENT_NUMBER

Format NUMBER

Indexed? Yes

May be Null? No

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

STATUS

Format VARCHAR2(2)

Indexed? No

May be Null? Yes

The two character status code for this cruise segment. Values: Unknown 

TAX_1_AMT

Format NUMBER

Indexed? No

May be Null? Yes

TAX_1_CURR_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

TAX_1_DESC

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

TAX_2_AMT

Format NUMBER

Indexed? No

May be Null? Yes

TAX_2_CURR_CODE

Format VARCHAR2(30)

Indexed? No

May be Null? Yes

TAX_2_DESC

Format VARCHAR2(30)

Indexed? No

May be Null? Yes