| Data element |
Definition |
ARRIVAL_DATE_TIME
Format DATE
Indexed? Yes
May be Null? Yes |
The arrival date/time for this cruise segment. |
ARRIVAL_PORT
Format VARCHAR2(30)
Indexed? Yes
May be Null? Yes |
The arrival port name for this cruise segment. |
ARRIVAL_PORT_COUNTRY
Format VARCHAR2(1000)
Indexed? No
May be Null? Yes |
The arrival port country for this cruise segment. |
ARRIVAL_PORT_COUNTRY_CODE
Format VARCHAR2(2)
Indexed? Yes
May be Null? Yes |
The two character arrival port country code for this cruise segment. |
CABIN
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
|
CONFIRMATION
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
|
CRUISE_AMT
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
The amount for this cruise segment. |
CRUISE_CURR_CODE
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
The currency code for this cruise segment. |
CRUISE_FERRY_SEGMENT_ID
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
|
DEPARTURE_DATE_TIME
Format DATE
Indexed? Yes
May be Null? Yes |
The departure date/time for this cruise segment. |
DEPARTURE_PORT
Format VARCHAR2(30)
Indexed? Yes
May be Null? Yes |
The departure port name for this cruise segment. |
DEPARTURE_PORT_COUNTRY
Format VARCHAR2(1000)
Indexed? No
May be Null? Yes |
The departure port country for this cruise segment. |
DEPARTURE_PORT_COUNTRY_CODE
Format VARCHAR2(2)
Indexed? Yes
May be Null? Yes |
The two character departure port country code for this cruise segment. |
FERRY_COMPANY
Format VARCHAR2(30)
Indexed? No
May be Null? Yes |
The ferry company associated with this cruise segment. |
FERRY_NAME
Format VARCHAR2(50)
Indexed? No
May be Null? Yes |
The ferry name associated with this cruise segment. |
PNR_ID
Format VARCHAR2(16)
Indexed? Yes
May be Null? No |
The Passenger Name Record (PNR) associated with this cruise segment 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 cruise segment record was last updated. |
SEAT
Format VARCHAR2(30)
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 |
VENDOR_TEXT
Format VARCHAR2(200)
Indexed? No
May be Null? Yes |
|
