4 Importable Columns
The following section describes the standard set of columns that Data Import can get from any of the files described above.
Note:
All mandatory fields are bold and must be included in the setup for a successful import.Master Data (Guests) File (MASTER)
You must import the Guest Master file first before the other guest details like Amenity/Special request and other import fields became valid.
For Group Member, the import should be done through a standard Master Reservation with the RES_GRP value defined. Group must be already defined in the database or imported.
Table 4-1 Master Data (Guests) File (MASTER)
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) Or Numeric (20) |
Unique Guest Identifier, used to send account information back to shore systems. Should be unique for the lifetime of the system for every guest stay. Usually this is the number which is used in RES_BOARDCC starting with 99. |
PAX_NAME |
Text (40) |
Person Surname. |
PAX_FSTN |
Text (40) |
Person Forename. |
PAX_MNAME |
Text (20) |
Person Middle Name. |
PAX_OTHNAME |
Text (40) |
Person Non Latin Name. |
PAX_SALUT |
Text (20) |
Person Greeting. |
PAX_TITEL |
Text (20) |
Person Title , for example Dr. |
PAX_STREET |
Text (30) |
Person Address Street 1. |
PAX_STREET2 |
Text (30) |
Person Address Street 2. |
PAX_ZIP |
Text (10) |
Person Address Postal/Zip code. |
PAX_STATE |
Text (20) |
Person Address State. |
PAX_CITY |
Text (30) |
Person Address City. |
PAX_COUNTRY |
Text (6) |
Person Address Country (ISO Code). |
PAX_TELNO |
Text (30) |
Person Telephone Number. |
PAX_EMAIL |
Text (50) |
Person Primary Email Address. |
PAX_EMAIL2 |
Text (50) |
Person Secondary Email Address. |
PAX_CRELIM |
Numeric (22,4) |
Person preset Credit Limit to be spent onboard. |
PAX_POSTING |
Numeric (1) |
Person Posting Status (0-Off, 1-On). |
PAX_SEX |
Text (6) |
Gender (Male/Female/'M'/'F'). |
PAX_PASSNO |
Text (20) |
Person Passport Number. |
PAX_PASSDI |
Date |
Passport Date of Issue. |
PAX_PASSPI |
Text (30) |
Passport Place of Issue. |
PAX_PASSPI_COUNTRY |
Text (6) |
Passport Country of Issue (ISO Code). |
PAX_PASSEX |
Date |
Passport Expiry Date. |
PAX_BIRTHD |
Date |
Person Birth Date. |
PAX_BIRTHP |
Text (20) |
Person Birth Place. |
PAX_BIRTHNAT |
Text (3) |
Person Birth Nationality (ISO code). |
PAX_NATION |
Text (6) |
Person Current Nationality (ISO Code). |
PAX_LANG |
Text (6) |
Person Language (ISO Code). |
PAX_HAIR |
Text (20) |
Person Hair Color. |
PAX_EYES |
Text (20) |
Person Eyes Color. |
PAX_HEIGHT |
Numeric (8) |
Person Height. |
PAX_WEIGHT |
Numeric (8) |
Person Weight. |
PAX_SMOKE |
Numeric (1) |
Smoker (0-No, 1-Yes). |
PAX_PROFESSION |
Text (50) |
Person Profession. |
PAX_ROYALITY |
Text (20) |
Person Royal Title. |
PAX_NAT_ID |
Text (20) |
Person National Identification ID (IC Numeric). |
PAX_MARTIAL |
Text (1) |
Person Marital Status (M-Married, S-Single, N-Not Applicable). |
PAX_VISA_ADDRESS1 |
Text (30) |
Person Temporary Address 1. |
PAX_VISA_ADDRESS2 |
Text (30) |
Person Temporary Address 2. |
PAX_VISA_STREET |
Text (30) |
Person Temporary Address Street. |
PAX_VISA_ZIP |
Text (10) |
Person Temporary Address Postal/Zip Code. |
PAX_VISA_STATE |
Text (20) |
Person Temporary Address State. |
PAX_VISA_CITY |
Text (30) |
Person Temporary Address City. |
PAX_VISA_PHONE |
Text (30) |
Person Temporary Telephone Number. |
PAX_VISA_EMAIL |
Text (50) |
Person Temporary Email. |
PAX_CONT_NAME |
Text (40) |
Person Emergency Contact Name. |
PAX_CONT_STREET |
Text (30) |
Person Emergency Contact Address. |
PAX_CONT_STREET2 |
Text (30) |
Person Emergency Contact Street. |
PAX_CONT_ZIP |
Text (10) |
Person Emergency Contact Postal/Zip Code. |
PAX_CONT_CITY |
Text (30) |
Person Emergency Contact City. |
PAX_CONT_STATE |
Text (10) |
Person Emergency Contact State. |
PAX_CONT_COUNTRY |
Text (6) |
Person Emergency Contact Country (ISO Code). |
PAX_CONT_PHONE |
Text (30) |
Person Emergency Contact Phone. |
PAX_CONT_EMAIL |
Text (50) |
Person Emergency Contact Email. |
PAX_CONT_MOB_PHONE |
Text (30) |
Person Emergency Contact Mobile. |
PAX_RELATIONSHIP |
Text (30) |
Person Emergency Contact Relationship. |
PAX_PP_POSTING |
Numeric (1) |
Allow to change from Package posting to Normal posting (0-Not Allowed, 1-Allowed). |
PAX_A_FRQ_CARDNO |
Text (20) |
Frequent Cruiser's Card Number. |
PAX_A_TRAV_INSURE |
Text (6) |
Travel Insurance Code (TYP_TRV). |
PAX_A_INSURE_NR |
Text (30) |
Travel Insurance Number. |
PAX_LOYALTY |
Text (6) |
Discount Template (TYP_LYT). |
PAX_HANDICAPED |
Numeric (1) |
Handicapped (0-No, 1-Yes). |
PAX_INTOX |
Numeric (1) |
Intoxication (0-No, 1-Yes). |
PAX_STREET3 |
Text (30) |
Address street. |
RES_CAB |
Text (20) |
Cabin Number. |
RES_EMB_E |
Date |
Expected Embarkation Date. |
RES_DIS_E |
Date |
Expected Disembarkation Date. |
RES_SIGNON |
Text (20) |
Embarkation Port Comments. |
RES_SIGNOFF |
Text (20) |
Disembarkation Port Comments. |
RES_SIGNONPORT_ID |
Text (6) |
Embarkation Port Name. Port names must be preset onboard (TYP_HRB). |
RES_SIGNOFFPORT_ID |
Text (6) |
Disembarkation Port Name. Port names must be preset onboard (TYP_HRB). |
RES_GRP |
Number (38) |
Person Group Identifier (If belongs to any Group). This data should be RES_V_GUESTID that passed during group import and the import will convert this into internal ID recognize by the system. |
RES_DEP_PAY |
Text (10) |
Default to Ship Payment Type (Optional). |
RES_CANCEL |
Numeric (1) |
Only use to Cancel off existing reservation. |
RES_V_PRIMARY |
Text (1) |
Primary Payer (Null-Not Applicable, 1-Yes). |
RES_MANIFESTNOAUTO |
Text (20) |
Person Manifest Number. |
RES_AGENTID |
Text (20) |
Person Agent Identifier. |
RES_AGENTRERID |
Text (20) |
Person Reservation Agent Identifier. |
RES_AGENTBOOKINGID |
Text (20) |
Person Booking Agent Identifier. |
RES_PPN_ID |
Text (20) |
Person Package Plan external name (Import will convert this external name to package plan internal ID - provided package plan is setup onboard with the correct external name). |
RES_REST_SEATING |
Text (2) |
Person Dining Seating Type (Null-Reset, E-First/Early Seating, M-Second Seating, T-Third Seating). |
RES_SHOW_SEATING |
Text (2) |
Person Show Seating Number. |
RES_OTHR_SEATING |
Text (2) |
Person Others Seating Number. |
RES_REST_TABLE |
Text (3) |
Person Dining Table Number. |
RES_CLASSIFICATION |
Text (6) |
VIP Type (This VIP Code has to be preset onboard). |
RES_PIN_CODE |
Text (38) |
Internal PIN Code for guest. |
RES_PAXCLASS |
Text (20) |
Person Classification Remarks. |
RES_PRODUCT |
Text (20) |
Product Name/Identifier. |
RES_PROMOTION |
Text (30) |
Promotion Name/Identifier. |
RES_CHECKED_DOCUMENTS |
Text (1) |
Document Checked (0-Not Checked, 1-Checked). |
RES_COLLECTED_DOCUMENTS |
Text (1) |
Document Collected (0-Not Collected, 1-Collected) |
RES_GENERIC_DENY_BOARDING |
Text (1) |
Deny Person from Boarding the ship (0-Deny Yes, 1-Deny No, can board ship). |
RES_GENERIC_DENY_REASON |
Text (40) |
Deny Boarding Reasons. |
RES_EMAIL_SHIP |
Text (72) |
Guest Onboard E-mail Address. |
RES_BOOKNR |
Text (100) |
Guest's Reservation Booking Number. Also serves as a "party" number so that Cruise can group and display all persons with same booking number. Besides being named as booking number or party number, it is also known as "travel with" number. |
RES_REFERENZ |
Text (40) |
Guest's Reservation Booking Identifier. Usually from external reservation system. Combination with RES_V_GUESID for multiple reservation handling. |
RES_OWNER |
Number |
Special Guests (1-Residents, 0-Non-Residents). |
RES_SEAT_TOGETHER |
Text (1) |
SilverWhere Dining System Table number. |
RES_SEAT_AUTOMATIC |
Text (1) |
SilverWhere Dining System Table number. |
RES_PPD_TAG |
Text (6) |
Revenue Per Passenger Per Day. |
RES_CRUISE_FARE |
Number |
Cruise Fare. |
RES_OPERATOR |
Number |
Guest with air/sea program option. |
RES_SALES |
Number (22,4) |
Sales Amount (Decimal not needed if parameter “Data Import Implied Decimal” is set true). |
RES_CPP_TYPE |
Text (1) |
Cancellation Protection Plan Type. |
RES_CRUISE_DAYS |
Number |
Number of Cruise Days. |
RES_AWARD_LEVEL |
Text (4) |
Award Level. |
RES_TRAVEL_TYPE |
Text (1) |
Cruise/Tour Indicator. |
RES_CAB_SHARING |
Text (1) |
Cabin Sharing Indicator. |
RES_BOARDCC_EXT |
Text (30) |
External Board Card Number. |
RES_CC_NUM |
Text (20) |
Credit Card Number. |
RES_CC_EXP |
Text (5) |
Credit Card Expiry. |
RES_CC_NAME |
Text (40) |
Credit Card Name. |
RES_CC_TRACK1 |
Text (79) |
Credit Card Track1. |
RES_CC_TRACK2 |
Text (79) |
Credit Card Track2. |
RES_PR_ID |
Text (30) |
Permanent Resident Identifier. |
RES_NOOFCRUISES |
Text (10) |
Number of Cruises. |
RST_TRVLWITH1 |
Text (20) |
Although this is Dining table’s field, this is used as a part of the combination value for party number. This field is selected through the Travel ID checkbox. Combination of this field, RES_PRODUCT and RES_EMB_E will replace RES_BOOKNR as party number. |
Master Data – Crew File (MASTER)
Crew Master Data must be imported first before importing the crew details.
Table 4-2 Master Data (Crew) File (MASTER)
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Crew Identifier, used to send account information back to shore systems. Should be unique for the lifetime of the system for every crews stay. Usually this is the number which is used in RES_BOARDCC starting with 99. |
CRW_NAME |
Text (40) |
Person Surname. |
CRW_FSTN |
Text (40) |
Person Forename. |
CRW_MNAME |
Text (20) |
Person Middle Name. |
CRW_OTHNAME |
Text (40) |
Person Non-Latin Name. |
CRW_SALUT |
Text (20) |
Person Greeting. |
CRW_STREET |
Text (30) |
Person Address Street 1. |
CRW_STREET2 |
Text (30) |
Person Address Street 2. |
CRW_ZIP |
Text (10) |
Person Address Postal/Zip Code. |
CRW_STATE |
Text (20) |
Person Address State. |
CRW_CITY |
Text (30) |
Person Address City. |
CRW_COUNTRY |
Text (6) |
Person Address Country (ISO Code). |
CRW_TELNO |
Text (30) |
Person Telephone Number. |
CRW_EMAIL |
Text (50) |
Person Primary Email Address. |
CRW_EMAIL2 |
Text (50) |
Person Secondary Email Address. |
CRW_CRELIM |
Numeric (22,4) |
Person preset Credit Limit to be spent onboard. |
CRW_SEX |
Text (6) |
Gender (Male/Female/'M'/'F'). |
CRW_PASSNO |
Text (20) |
Person Passport Number. |
CRW_PASSDI |
Date |
Passport Date of Issue. |
CRW_PASSPI |
Text (30) |
Passport Place of Issue. |
CRW_PASSPI_COUNTRY |
Text (6) |
Passport Country of Issue (ISO Code). |
CRW_PASSEX |
Date |
Passport Expiry Date. |
CRW_BIRTHD |
Date |
Person Birth Date. |
CRW_BIRTHP |
Text (20) |
Person Birth Place. |
CRW_BIRTHNAT |
Text (3) |
Person Birth Nationality (ISO Code). |
CRW_NATION |
Text (6) |
Person Current Nationality (ISO Code). |
CRW_LANG |
Text (6) |
Person Language (ISO Code). |
CRW_LANG2 |
Text (6) |
Person Language 2 (ISO Code). |
CRW_LANG3 |
Text (6) |
Person Language 3 (ISO Code). |
CRW_HAIR |
Text (20) |
Person Hair Color. |
CRW_EYES |
Text (20) |
Person Eyes Color. |
CRW_HEIGHT |
Numeric (8) |
Person Height. |
CRW_WEIGHT |
Numeric (8) |
Person Weight. |
CRW_NAT_ID |
Text (20) |
Person National Identification ID (IC Number). |
CRW_MARTIAL |
Text (1) |
Person Marital Status (M-Married, S-Single, N-Not Applicable). |
CRW_DIV |
Text (6) |
Crew Department Code (Preset Code Onboard). |
CRW_STAFF_POS |
Text (6) |
Crew Staff Position Code (Preset Code Onboard). |
CRW_EXTERNALID |
Text (20) |
Crew External Identifier. |
CRW_INTERNALID |
Text (20) |
Crew Internal Identifier. |
CRW_BOOKNO |
Text (15) |
Crew Seamen Book no. |
CRW_BKDATE |
Date |
Crew Seamen Book Date. |
CRW_BKPASSPI |
Text (20) |
Crew Seamen Book Issue Place. |
CRW_BKPASSEX |
Date |
Crew Seamen Book Expiry. |
CRW_CONT_NAME |
Text (40) |
Crew Emergency Contact Name. |
CRW_RELATIONSHIP |
Text (30) |
Crew Emergency Contact Relationship (Related to Emergency Contact Name). |
CRW_CONT_STREET |
Text (30) |
Crew Emergency Contact Address. |
CRW_CONT_STREET2 |
Text (30) |
Crew Emergency Contact Street. |
CRW_CONT_ZIP |
Text (10) |
Crew Emergency Contact Postal/Zip Code. |
CRW_CONT_STATE |
Text (10) |
Crew Emergency Contact State. |
CRW_CONT_CITY |
Text (30) |
Crew Emergency Contact City. |
CRW_CONT_COUNTRY |
Text (6) |
Crew Emergency Contact Country (ISO Code). |
CRW_CONT_PHONE |
Text (30) |
Crew Emergency Contact Telephone Number. |
CRW_CONT_EMAIL |
Text (50) |
Crew Emergency Contact Email. |
CRW_CONTRACTTYPE |
Text (40) |
Crew Contract Type. |
CRW_CONTRACTSIGNON |
Date |
Crew Sign On Date. |
CRW_CONTRACTEXP |
Date |
Crew Contract Expiry. |
CRW_ORDER_EMP_NO |
Numeric |
Crew Incentive Program Employee Number. |
CRW_BKPASSPI_COUNTRY |
Text (6) |
Seaman Book Country of Issue. |
CRW_TRAV_INSURE |
Text (6) |
Travel Insurance Code (TYP_TRV). |
RES_CAB |
Text (20) |
Cabin Number. |
RES_EMB_E |
Date |
Expected Embarkation Date. |
RES_DIS_E |
Date |
Expected Disembarkation Date. |
RES_SIGNON |
Text (20) |
Embarkation Port Comments. |
RES_SIGNOFF |
Text (20) |
Disembarkation Port Comments. |
RES_SIGNONPORT_ID |
Text (6) |
Embarkation Port Name. Port names have to be preset onboard (TYP_HRB). |
RES_SIGNOFFPORT_ID |
Text (6) |
Disembarkation Port Name. Port names have to be preset onboard (TYP_HRB). |
RES_DEP_PAY |
Text (10) |
Default to Ship Payment Type (Optional). |
RES_CANCEL |
Numeric (1) |
Only use to cancel off existing reservation. |
RES_V_PRIMARY |
Text (1) |
Primary Payer (Null-Not Applicable, 1-Yes). |
RES_REFERENZ |
Text (40) |
Crew's Reservation Booking Identifier. Usually from external reservation system. Combination with RES_V_GUESID for multiple reservation handling. |
RES_MANIFESTNOAUTO |
Text (20) |
Person Manifest Number. |
RES_PIN_CODE |
Numeric(38) |
Person Unique PIN Number. (To use incorporating with PABX system). |
RES_REMARKS |
Text (100) |
Person Remarks. |
RES_INBOUNDDEPDATE |
Date |
Person Inbound Departure Date. |
RES_EMAIL_SHIP |
Text (72) |
Crew Onboard E-mail Address. |
RES_BOARDCC_EXT |
Text (30) |
External Board Card Number. |
RES_CC_NUM |
Text (20) |
Credit Card Number. |
RES_CC_EXP |
Text (5) |
Credit Card Expiry. |
RES_CC_NAME |
Text (40) |
Credit Card Name. |
RES_CC_TRACK1 |
Text (79) |
Credit Card Track1. |
RES_CC_TRACK2 |
Text (79) |
Credit Card Track2. |
CRW_STREET3 |
Text (30) |
Address street 3. |
CRW_INTOX |
Text (1) |
Intoxicated flag (1 –Yes, 0 – No) |
Group Details File (GROUP)
The Group Leader must already exist in the
database, and RES_GRP
will be used to identify a
group member. All group members should have RES_GRP
set to the same RES_V_GUESTID
that belongs to the
specific group. The related RES_V_GUESTID
can be
used as an external identifier/agent identifier when doing group member
import; the data import will convert this external identifier to a GRP_ID
that is recognized by the database. Group member
import should be treated like all ordinary guest imports with the
exception that it must have the RES_GRP
assigned. Groups must be imported first before group members are
to be imported.
Table 4-3 Group Details File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC / GRP_GROUPLEADER |
Text (50) or Numeric (20) |
Group Leader will be converted to UXP_A_ID from RES_V_GUESTID or RES_BOARDCC given. The reference setup will be RES reference as RES_V_GUESTID or other reference as s GRP_GROUPLEADER. |
GRP_NAME |
Text (40) |
Group First Name. |
GRP_NAME_N |
Text (40) |
Group Last Name. |
GRP_ADDRESS1 |
Text (30) |
Group Address 1. |
GRP_ADDRESS2 |
Text (30) |
Group Address 2. |
GRP_CITY |
Text (30) |
Group City. |
GRP_STATE |
Text (10) |
Group State. |
GRP_ZIP |
Text (10) |
Group Post Code/Zip Code. |
GRP_COUNTRY |
Text (6) |
Group Country (ISO Code). |
GRP_STREET |
Text (30) |
Group Street. |
GRP_CRELIM |
Numeric (22,4) |
Group Credit Limit. |
GRP_POSTING |
Numeric (1) |
Group Posting Enable (0-No, 1-Yes). |
GRP_TRAV_INSURE |
Text (6) |
Group Travel Insurance Code (TYP_TRV). |
GRP_INSURE_NR |
Text (30) |
Group Travel Insurance Number. |
RES_EMB_E |
Date |
Group Embarkation Date. |
RES_DIS_E |
Date |
Group Disembarkation Date. |
RES_V_GUESTID |
Text (50) |
Group External Identifier/Unique Group Identifier. |
RES_SHOREID |
Text (15) |
Shore side group reference, that is a number used to identify a particular group. |
RES_CC_NUM |
Text (20) |
Credit Card Number. |
RES_CC_EXP |
Text (5) |
Credit Card Expiry. |
RES_CC_NAME |
Text (40) |
Credit Card Name. |
RES_CC_TRACK1 |
Text (79) |
Credit Card Track1. |
RES_CC_TRACK2 |
Text (79) |
Credit Card Track2. |
Visitors Details File (VISITORS)
The Visitors file can be imported independent of the Master Guest/Group Reservation file. It is considered a group of its own. The following are the supported fields.
Table 4-4 Visitor Details File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Visitor's Identifier, used to send account information back to shore systems. Should be unique for the lifetime of the system for every visitor's visit. Usually this is the number that is used in RES_BOARDCC starting with 99. |
RES_BOARDCC_EXT |
Text (30) |
External Board Card Number. |
VTO_NAME |
Text (40) |
Visitor's First Name. |
VTO_FSTN |
Text (40) |
Visitor's First Name. |
VTO_SALUT |
Text (20) |
Visitor's Greeting. |
VTO_PASSNO |
Text (20) |
Visitor's Passport Number. |
VTO_POSTING |
Numeric (1) |
Visitor's posting status (0-Off, 1-On). |
VTO_BIRTHD |
Date |
Visitor’s Birth Date. |
RES_EMB_E |
Date |
Visitor's Embarkation Date. |
RES_DIS_E |
Date |
Visitor's Disembarkation Date. |
RES_QROUTE_ACC |
Numeric |
Route to System Account (RES_ACC). |
RES_VTYPE |
Text (6) |
Type of Visitors. |
Restaurant/Dining Assignment File (DINING)
Table 4-5 Visitor Details File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RST_ACC_ID |
Numeric (20) |
Unique Person Identifier, used to send account information back to shore systems. Should be unique for the lifetime of the system for every person’s stay. |
RST_SCR_ID |
Numeric (15) |
Shore system cruise identifier. Must be the same as entered in SCR_ITN_ID. Converted to internal SCR_ID upon import. |
RST_ASSIGN_LEVEL |
Text (2) |
How well the guest’s requests were met? |
RST_ASSIGNED_SEATING |
Text (3) |
Seating Number. |
RST_DINING_LOCKED |
Text (1) |
Change seating during assignment (Y-Yes, N-No)? |
RST_REST_ASSIGNED |
Text (3) |
Assigned Restaurant. |
RST_SEATING_CONFIRMED |
Text (1) |
Confirmed Seating (Y-Yes, N-No)? |
RST_DONT_SEAT |
Text (1) |
Assign seat automatically (Y-Yes, N-No)? |
RST_VIP_SEAT |
Text (1) |
Preferred Seat Privilege. |
RST_PARTY |
Numeric |
Party Link. |
RST_PRIORITY1 |
Text (30) |
Priority Information. |
RST_PRIORITY2 |
Text (30) |
Priority Information. |
RST_PRIORITY3 |
Text (30) |
Priority Information. |
RST_PRIORITY4 |
Text (30) |
Priority Information. |
RST_PRIORITY5 |
Text (30) |
Priority Information. |
RST_REQ_SEATING |
Text (3) |
Requested Seating. |
RST_REQ_REST |
Text (4) |
Requested Restaurant. |
RST_REQ_TABLE |
Text (4) |
Requested Table. |
RST_REQUEST_DATE |
Date |
Special Request Date. |
RST_RES_SEATING |
Text (3) |
Reservation Seating. |
RST_WHEELCHAIR |
Text (1) |
Wheelchair capable table required (Y-Yes, N-No)? |
RST_TABLE_LOC |
Text (4) |
Table Location. |
RST_TABLE_NO |
Text (10) |
Table Number. |
RST_TABLE_SIZE |
Text (3) |
Table Size. |
RST_TABLE_TYPE |
Text (4) |
Table Type (i.e. R-Round, S-Square, O-Oval, and so on). |
RST_WL_TYPE |
Text (1) |
Is it on Waiting List? |
RST_WL_ROOM |
Text (3) |
Waiting List Preferred Restaurant. |
RST_WL_SEATING |
Text (3) |
Waiting List Preferred Seating. |
RST_WL_TIME |
Date |
Waiting List Preferred Time. |
RST_AGE_GRP |
Number |
Age Group. |
Flight Details File (FLIGHT)
Table 4-6 Flight Details File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Guest Identifier. Should be unique for the lifetime of the systems for every guest stay. Usually this is the number used in RES_BOARDCC starting with 99. |
AIR_DIRECTION |
Text (1) |
Possible values are A and D. A is used for all arrival flights; D means departure flights from the ship. |
AIR_CONNECT |
Numeric (1) |
Connecting Flight (0-No, 1-Yes)? |
AIR_INTER |
Text (1) |
International Flight (Null-No, 'I'-Yes)? |
AIR_CARRIER |
Text (30) |
Flight Description/Name. |
AIR_FLIGHT |
Text (10) |
Flight Number. |
AIR_DEPARTURE |
Date |
Flight Departure Date/Time, required if AIR_ARRIVAL is empty. |
AIR_DEPARTURE_COUNTRY |
Text (30) |
Flight Departure Country. |
AIR_DEPARTCITY |
Text (30) |
Flight Departure City. |
AIR_DEPARTURE_AIRPORT |
Text (10) |
Flight Departure Airport. |
AIR_ARRIVAL |
Date |
Flight Arrival Date/Time, required if AIR_DEPARTURE is empty. |
AIR_ARRIVAL_COUNTRY |
Text (30) |
Flight Arrival Country. |
AIR_ARRIVALCITY |
Text (30) |
Flight Arrival City. |
AIR_ARRIVAL_AIRPORT |
Text (10) |
Flight Arrival Airport. |
AIR_BAG_LABEL |
Text (10) |
Bag Label assigned to the flight. |
AIR_HOTEL |
Text (20) |
Hotel the person would stay. |
AIR_HOTEL_ADDRESS |
Text (30) |
Hotel Address. |
AIR_HOTEL_CHECKIN |
Date |
Date/Time the person will check-in in to the hotel. |
AIR_HOTEL_CHECKOUT |
Date |
Date/Time the person will check-out from the hotel. |
AIR_CAPACITY |
Numeric (8) |
Flight Passenger Capacity. |
AIR_BAGS |
Numeric (2) |
Default number of bags declared per guest. |
AIR_TRANSF_PRICE |
Numeric |
Flight Transfer Price. |
AIR_VID |
Text (10) |
Flight Record Unique ID (Each different record should have a unique identifier to recognize a new record from an existing, and used to determine overwriting or add new in Data Import). |
AIR_DEPARTURE_TIME |
Text (5) |
Flight departure time. |
AIR_ARRIVAL_TIME |
Text (5) |
Flight arrival time. |
Amenity/Gift Orders File (GIFT)
Table 4-7 Amenity/Gift Orders File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Guest/Crew/Account Identifier, used to reference a row with rows from the Master Details file. During the import the identifier gets converted to internal SPMS identifier (AME_RESID). The “Delete existing before update” check box is available. |
AME_RESBOOKNR |
Text (20) |
Amenity Booking Numeric. |
AME_CODE |
Text (6) |
Amenity Code (Must be valid when check against the Amenity code preset onboard). |
AME_NOTE |
Text (100) |
Amenity Notes. |
AME_AMOUNT |
Numeric (22,4) |
Amenity Amount Cost (Decimal not needed if “Data Import Implied Decimal” parameter is set true). |
AME_QUANTITY |
Numeric (38) |
Amenity Quantity to deliver. |
AME_SENDER1 |
Text (255) |
Sender's Note 1. |
AME_SENDER2 |
Text (30) |
Sender's Note 2. |
AME_MESSAGE |
Text (255) |
Amenity Special Message. |
AME_DDATE |
Date |
Amenity Delivery Date. |
AME_LOCATION |
Text (30) |
Amenity Delivery Location. |
AME_OCCURRENCE |
Text (10) |
Amenity Occurrence. |
AME_EXT_CODE |
Text (15) |
Amenity External Code. |
AME_COST |
Numeric |
Amenity Cost. |
AME_COMMENTS |
Text (255) |
Amenity Other Comments. |
AME_VID |
Text (30) |
Amenity Record Unique ID (Each different records should have a unique identifier to recognize new record from existing, and used to determine overwriting or delete or add new in Data Import). |
AME_ODI_ID |
Text (10) |
Delivery Department (TYP_DIV). |
AME_CURR_ID |
Text (10) |
Currency Code (TYP_CUR). |
AME_FLG |
Text (1) |
Add/Change/Delete Flag. |
Document Details File (DOCUMENTS)
Table 4-8 Document Details File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Guest/Crew/Account identifier, used to reference a row with rows from Master Details file. During the import the identifier gets converted to internal SPMS identifier (VIS_PER). |
VIS_DOC_TYPE |
Text (1) |
Document Type. Code must be preset onboard (TYP_VIT). Defaults are: A=Alien Registration Number, B=Birth Certificate, D=Driver License, F=Refugee Permit, I=Ins Pass Document, M=Military ID, N=National ID, R=Residence Permit, S=Social Security Number, V=Visa. |
VIS_NUMBER |
Text (20) |
Document Number. |
VIS_PLACE |
Text (40) |
Document Place of Issue. |
VIS_COUNTRY |
Text (6) |
Document Country of Issue (ISO Code). |
VIS_DATE |
Date |
Document Date of Issue. |
VIS_EXPIRE |
Date |
Document Date of Expiry. |
VIS_TYPE |
Text (6) |
Document Visa Type. Code must be preset onboard (TYP_VIS). |
VIS_VID |
Text (10) |
Document Record Unique ID (Each different record should have a unique identifier to recognize new record from existing, and used to determine overwriting or delete or add new in Data Import). |
VIS_FSTN |
Text (40) |
Document first name. |
VIS_MNAME |
Text (20) |
Document middle name. |
VIS_ENTRY |
Numeric |
Number of entry. |
VIS_VALID_FROM |
Date |
Valid from date. |
VIS_DURATION_STAY |
Numeric |
Duration of stay. |
Special Request (SRT)
Table 4-9 Special Request File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Guest/Crew/Account identifier, used to reference a row with rows from Master Details file. During the import the identifier gets converted to internal SPMS identifier (SRT_RESID). The “Delete existing before update” check box is available. |
SRT_CODE |
Text (6) |
Special Request Action Code. |
SRT_ODI_ID |
Text (10) |
Special Request Delivery Department. |
SRT_DESCR |
Text (1000) |
Special Request Description. |
SRT_DONE_BY |
Numeric |
Special Request To be done by which user. |
SRT_EXT_CODE |
Text (15) |
Special Request External Code. |
SRT_QUANTITY |
Numeric |
Special Request Quantity. |
SRT_DDATE |
Date |
Special Request Done date. |
SRT_VID |
Text (30) |
Special Request Record Unique ID (Each different records should have a unique identifier to recognize new record from existing, is used to determine overwriting or delete or add new in Data Import). |
SRT_EVENTDATE |
Date |
Special Request Event Date. |
SRT_LOCATION |
Text (30) |
Special Request Location. |
Pre-Postings File (PPS)
Table 4-10 Pre-Postings File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Guest/Crew/Account identifier, used to reference a row with rows from Master Details file. During the import the identifier gets converted to internal SPMS identifier (PPS_ACC_ID). The “Delete existing before update” check box is available. |
PPS_DEP_ID |
Text (10) |
Pre-Postings Department Code. |
PPS_DISC_VAL |
Numeric (22,4) |
Pre-Postings Discount Value. |
PPS_TOTAL |
Numeric (22,4) |
Pre-Postings Total (Decimal not needed if “Data Import Implied Decimal” parameter is set true). |
PPS_PDAT |
Date |
Pre-Postings Actual Posting Date. |
PPS_NOTES1 |
Text (200) |
Pre-Postings Remarks. |
PPS_VID |
Text (10) |
Pre-Postings Record Unique ID (Each different records should have a unique identifier to recognize new record from existing, and used to determine overwriting or deleting pre-posting transaction add new in Data Import). |
PPS_SALES_CUR |
Text (6) |
Foreign Currency Type, linked to TYP_CUR.TYP_ART |
PPS_SALES_FOREX |
Numeric (22,4) |
Amount in foreign currency. |
Excursion Bookings File (EPO)
Table 4-11 Excursion Bookings File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Guest/Crew/Account identifier, used to reference a row with rows from Master Details file. During the import the identifier gets converted to internal SPMS identifier (EPO_ACC). The “Delete existing before update” check box is available. |
EPO_PDAT |
Date |
Excursions Actual Posting Date, System Date by Default. |
EPO_DISCOUNT |
Numeric (22, 4) |
Excursions Discount Value. |
EPO_SALESPRICE |
Numeric (22, 4) |
Excursions Sales Price (Decimal not needed if parameter “Data Import Implied Decimal” is set true). |
EPO_ESE_ID |
Numeric |
Excursions Preset Code, from reservation the value to be passed in should be ESE_NO and the Data Import will convert it to valid ESE_ID. |
EPO_HEIGHT |
Numeric |
Excursion Height. |
EPO_WEIGHT |
Numeric |
Excursion Weight. |
EPO_PRICE_TAG |
Text(1) |
Only 'A' or 'C' (A-Adult, C-Child). |
EPO_TICKET_PRINTED |
Numeric |
Number of Ticket Printed (Default=0). |
EPO_QUANT |
Numeric |
Tickets Bought (Default=1). If extra seats are required, value is defaulted to 2. |
EPO_LANGUAGE |
Text (6) |
Excursions Language (ISO Code required). |
EPO_VID |
Text (10) |
Excursions Record Unique ID (Each different records should have a unique identifier to recognize new record from existing, and used to determine overwriting or delete or add new in Data Import). |
EPO_NET |
Numeric (22,4) |
Net Price. |
EPO_TRANS_ID |
Numeric |
Transaction Identifier. |
EPO_PREPAID |
Text (1) |
Prepaid Flag (Y/N). Since this is pre-booked excursion, this should be default ignored or value to ‘N’. |
EPO_KIOSK |
Text (1) |
Kiosk Transaction Flag (Y/N). |
EPO_EXTRA_SEAT |
Text (1) |
Overweight Booking Flag (W-Overweight Booking, N-Non-Overweight Booking. This will flag for extra seats. |
ESE_DATE |
Date |
Bookable excursion date, not to insert into DB. Only for verification purposes if more than one bookable excursions with identical ESE_NO. For use in detecting a bookable excursion more accurately. If it does not exist in the file, record import is skipped because no matching bookable excursion can be found. |
EPO_POS_DEPT |
Text (10) |
Department Code to post the excursion to. Default is from bookable setup, if not set, will only default to SYS_EXC_DEP. |
EPO_TYPE |
Text (1) |
To differentiate between tour types “L” for Landex, “S” for Shore Excursion, for reporting purposes. |
EPO_GROUP_ID |
Text (50) |
Unique Group Account identifier (RES_V_GUESTID) that has been already imported separately using the Group Details File (GROUP). |
EPO_ESP_ID |
Text (10) |
Package Code, from reservation the value to be passed in should be ESP_NO and the data import will use it together with next field EPO_ESP_DATE to convert it to valid ESP_ID (epo_esp_id) |
EPO_ESP_DATE |
Date |
Package System Cruise Reference Date in order to identify the System Cruise ID this Package belongs to (should be any Date within the System Cruise that the Package is valid). |
EPO_SALES_CUR |
Text (6) |
Foreign Currency Type, linked to TYP_CUR.TYP_ART |
EPO_SALES_FOREX |
Numeric (22,4) |
Amount in foreign currency. |
Pre-Paid Excursions (EPO)
Table 4-12 Pre-Paid Excursion File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Guest/Crew/Account identifier, used to reference a row with rows from the Master Details file. During the import the identifier gets converted to an nternal SPMS identifier (EPO_ACC). The “Delete existing before update” check box is available. |
EPO_PDAT |
Date |
Excursions Actual Posting Date, System Date by Default. |
ESE_DATE |
Date |
Bookable excursion date, not to insert into DB. Only for verification purposes if more than one bookable excursions with identical ESE_NO. For use in detecting a bookable excursion more accurately. If it does exist in the file, record import is skipped because no matching bookable excursion can be found. |
EPO_ESE_ID |
Numeric |
Excursions Preset Code, From reservation the value to be passed in should be ESE_NO and the Data Import will convert it to valid ESE_ID. |
EPO_DISCOUNT |
Numeric (22, 4) |
Excursions Discount Value. |
EPO_SALESPRICE |
Numeric (22, 4) |
Excursions Sales Price (Decimal not needed if parameter “Data Import Implied Decimal” is set true). |
EPO_QUANT |
Numeric |
Tickets Bought (Default=1). If extra seats are required, value is defaulted to 2. |
EPO_LANGUAGE |
Text (6) |
Excursions Language (ISO Code required). |
EPO_WEIGHT |
Numeric |
Excursion Weight. |
EPO_HEIGHT |
Numeric |
Excursion Height. |
EPO_PRICE_TAG |
Text(1) |
Only 'A' or 'C' (A-Adult, C-Child). |
EPO_TICKET_PRINTED |
Numeric |
Number of Ticket Printed (Default=0). |
EPO_VID |
Text (10) |
Excursions record unique ID (Each different record should have a unique identifier to recognize new record from existing, is used to determine overwriting or delete or add new in Data Import). |
EPO_NET |
Numeric (22,4) |
Net Price. |
EPO_TRANS_ID |
Numeric |
Transaction Identifier. |
EPO_PREPAID |
Text (1) |
Prepaid Flag (Y/N). This is set to ‘Y’ since it is prepaid. Default is ‘Y’ as well |
EPO_KIOSK |
Text (1) |
Kiosk Transaction Flag (Y/N). |
EPO_EXTRA_SEAT |
Text (1) |
Overweight Booking Flag (W-Overweight Booking, N-Non-Overweight Booking). This will flag for extra seats. |
EPO_POS_DEPT |
Text (10) |
Department Code to post the excursion to. Default is from PAR (PPE Default POS Department). If not set, will take value from bookable setup, if this is not set, will only default to SYS_EXC_DEP. |
EPO_TYPE |
Text (1) |
To differentiate between tour types “L” for Landex, “S” for Shore Excursion, for reporting purposes. |
EPO_GROUP_ID |
Text (50) |
Unique Group Account Identifier (RES_V_GUESTID) that has been already imported separately using the Group Details File (GROUP) |
EPO_ESP_ID |
Text (10) |
Package Code, from reservation the value to be passed in should be ESP_NO and the Data Import will use it together with next field EPO_ESP_DATE to convert it to valid ESP_ID (epo_esp_id). |
EPO_ESP_DATE |
Date |
Package System Cruise Reference Date in order to identify the System Cruise ID this Package belongs to (should be any date within the System Cruise in which the Package is valid). |
EPO_SALES_CUR |
Text (6) |
Foreign Currency Type, linked to TYP_CUR.TYP_ART |
EPO_SALES_FOREX |
Numeric (22,4) |
Amount in foreign currency. |
Excursions Waitlist (EPW)
Table 4-13 Excursion Waitlist File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Guest/Crew/Account identifier, used to reference a row with rows from Master Details file. During the import the identifier gets converted to internal SPMS identifier (EPW_ACC). The “Delete existing before update” check box is available. |
EPW_PDAT |
Date |
Excursions Waitlist Actual Posting Date, System Date by Default. |
EPW_DISCOUNT |
Numeric (22, 4) |
Excursions Waitlist Discount Value. |
EPW_SALESPRICE |
Numeric (22, 4) |
Excursions Waitlist Sales Price (Decimal not needed if “Data Import Implied Decimal” parameter is set true). |
EPW_ESE_ID |
Numeric |
Excursions Preset Code, from reservation the value to be passed in should be ESE_NO and the Data Import will convert it to valid ESE_ID. |
EPW_QUANT |
Numeric |
Tickets bought (Default=1). If extra seats are required, value is defaulted to two. |
EPW_LANGUAGE |
Text (6) |
Excursions Waitlist Language (ISO Code required). |
EPW_WEIGHT |
Numeric |
Excursion Waitlist Weight. |
EPW_HEIGHT |
Numeric |
Excursion Waitlist Height. |
EPW_PRICE_TAG |
Text(1) |
Only 'A' or 'C' (A-Adult, C-Child). |
EPW_TICKET_PRINTED |
Numeric |
Number of Ticket Printed (Default=0). |
EPW_VID |
Text (10) |
Excursions Waitlist record unique ID (Each different record should have a unique identifier to recognize new record from existing, is used to determine overwriting or delete or add new in Data Import). |
EPW_NET |
Numeric (22,4) |
Net Price. |
EPW_PREPAID |
Text (1) |
Prepaid Flag. |
EPW_KIOSK |
Text (1) |
Kiosk Transaction Flag. |
EPW_EXTRA_SEAT |
Text (1) |
Overweight Booking Flag (W-Overweight Booking, N-Non-Overweight Booking). This will flag for extra seats. |
ESE_DATE |
Date |
Bookable excursion date, not to insert into database, only for verification purposes if more than one bookable excursions with identical ESE_NO. For user to be able to detect a bookable excursion more accurately. If it does not exist in file, record import is skipped because no matching bookable excursion can be found. |
EPW_TYPE |
Text (1) |
To differentiate between tour types “L” for Landex, “S” for Shore Excursion module, for reporting purposes. |
EPW_ESP_ID |
Text (10) |
Package Code, from reservation and the value to be passed in should be ESP_NO and the Data Import will use it together with the next field EPW_ESP_DATE to convert it to valid ESP_ID (epw_esp_id). |
EPW_ESP_DATE |
Date |
Package System Cruise Reference Date in order to identify the System Cruise ID this Package belongs to (should be any date within the system Cruise in which the package is valid). |
EPW_SALES_CUR |
Text (6) |
Foreign Currency Type, linked to TYP_CUR.TYP_ART |
EPW_SALES_FOREX |
Numeric (22,4) |
Amount in foreign currency. |
Courses/Certificates File (COURSE)
Table 4-14 Courses/Certificates File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Guest/Crew/Account identifier, used to reference a row with rows from the Master Details file. During the import the identifier gets converted to internal SPMS identifier (TAK_CRWID). |
TAK_COUID |
Numeric |
Course Certificates Code, must match COU_ID. |
TAK_DONEWHEN |
Date |
Course Taken Done Date. |
TAK_RENEWALWHEN |
Date |
Course Renewal Date. |
TAK_CERTNO |
Text (20) |
Course Number. |
TAK_DONEWHERE |
Text (30) |
Course Taken Place. |
TAK_VID |
Text (10) |
Course/Certificates Taken record unique ID (Each different records should have a unique identifier to recognize a new record from an existing record, is used to determine overwriting or delete or add new in Data Import). |
TAK_EXPIREUPONDEBARK |
Numeric |
Training Center where the courses/certificates are affiliated. |
Guest History File (GHI)
Table 4-15 Guest History File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Guest Account identifier, used to reference a row with rows from Master Details file. During the import the identifier gets converted to internal SPMS identifier (GHI_ACC_ID). |
GHI_EXT_ID |
Text (50) |
Guest External Identifier. |
GHI_EMB |
Date |
Last Embarkation Date. |
GHI_DIS |
Date |
Last Disembarkation Date. |
GHI_CABIN |
Text (6) |
Last Resided Cabin. |
GHI_COMMENTS |
Text (2000) |
Remarks/Comments. |
GHI_VID |
Text (30) |
Guest History Record Unique Identifier (Each different records should have a unique identifier to recognize new record from existing, is used to determine overwriting or delete or add new in Data Import). |
Crew History File (CHI)
Table 4-16 Crew History File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Crew Account identifier, used to reference a row with rows from Master Crew Details file. During the import the identifier gets converted to internal SPMS identifier (CHI_CRWID). |
CHI_FROM |
Date |
Date From. |
CHI_TO |
Date |
Date To. |
CHI_POSITION |
Text (6) |
Position Held. |
CHI_DIVISION |
Text (6) |
Division Held. |
CHI_REASON_SON |
Text (6) |
Reason for Signing On. |
CHI_REASON_SOFF |
Text (6) |
Reason for Signing Off. |
CHI_SAFETYPOS |
Number |
Safety Position Held. |
CHI_VID |
Text (30) |
Crew History Record Unique Identifier (Each different records should have a unique identifier to recognize new record from existing, is used to determine overwriting or delete or add new in Data Import). |
Discount Details
Table 4-17 Discount Details File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Account identifier, used to reference a row with rows from the Master Details file. During the import the identifier gets converted to internal SPMS identifier. This field will be mapped to DIS_FOR as account reference. |
DIS_WHAT OR DTG_NAME |
Text (10) Or Text (20) |
Revenue department code that is being Discounted. Alternatively, pre-defined department group name can be provided for multiple insert of the revenue department code. |
DIS_DIS |
Number |
Discount in Percentage (0 if DIS_AMOUNT is present). |
DIS_NOTE |
Text (50) |
Discount Remarks. |
DIS_AMOUNT |
Number |
Discount in Amount (0 if DIS_DIS is present). |
DIS_COUNT |
Number |
Discount Repetition. |
DIS_VID |
Text (30) |
Discount import record unique identifier. (Each different record should have a unique identifier to recognize new record from existing, is used to determine overwriting or delete or add new in Data Import). |
Routing Details
Table 4-18 Routing Details File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC / ROT_FROM |
Text (50) or Numeric (20) |
Unique Account identifier, used to reference a row with rows from the Master Details file. During the import the identifier gets converted to internal SPMS identifier. |
ROT_WHAT or DTG_NAME |
Text (10) or Text (20) |
Revenue department code that is having the routing. Alternatively, pre-defined department group name can be provided for multiple insert of the revenue department code. |
ROT_TO |
Number |
Routing-to-who account identifier. It will take value of RES_V_GUESTID from file to determine the account id of the person to route to. If ROT_WHAT is not setup or imported, this value will be imported into RES_QROUTE_ACC instead for general route. |
ROT_NOTE |
Text (50) |
Routing Remarks. |
ROT_VID |
Text (30) |
Routing import record unique identifier. (Each different records should have a unique identifier to recognize new record from existing, is used to determine overwriting or delete or add new in Data Import). |
Spa Retail Items (SPI)
Table 4-19 Spa Retail File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
SPI_CODE |
Text (20) |
Unique Identifier. |
SPI_NAME |
Text (50) |
The name displayed on the reservation form for this retail item. |
SPI_DESCRIPTION |
Text (255) |
A full description for this retail item. |
SPI_COMMENTS |
Text (255) |
Additional remarks for this item. |
SPI_ACTIVE |
Text (1) |
A switch to indicate whether this item is Active (Y) or not (N). |
SPI_MMS_CODE |
Text(20) |
Item code in MMS system. |
SPI_SRG_ID |
Text (6) |
Pointer to TYP_SRG that holds the Retail Groups. Please provide the retail group code value. |
SPI_SRL_ID |
Text (6) |
Pointer to TYP_SRL that holds the Retail Lines. Please provide the retail line code value. |
SPI_SIM_ID |
Text (6) |
Pointer to TYP_SIM that holds the itemizer for the Retail Item. Please provide the Retail itemizer code value. |
SPI_PREPAID_SIM_ID |
Text (6) |
Pointer to TYP_SIM that holds the Prepaid Itemizer for the Retail Item. Please provide the Retail Prepaid itemizer code value. |
SPI_SKU |
Text (20) |
Item’s Bar code (that will be recorded into SPU table). |
Spa Treatment Items (SPY)
Table 4-20 Spa Treatment Items File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
SPY_CODE |
Text (20) |
Unique Identifier. |
SPY_NAME |
Text (50) |
The name displayed on the reservation form for this treatment item. |
SPY_DESCRIPTION |
Text (255) |
A full description for this treatment item. |
SPY_COMMENTS |
Text (500) |
Additional remarks for this item. |
SPY_ACTIVE |
Text (1) |
A switch to indicate whether this item is Active (Y) or not (N). |
SPY_DURATION |
Number |
The default number of minutes of the therapy. |
SPY_ROOMS |
Text(100) |
All default rooms assigned to the treatment item, comma separated. |
SPY_PRINT_DURATION |
Number |
The number of minutes that should be printed on an appointment confirmation. |
SPY_STG_ID |
Text (6) |
Pointer to TYP_STG that holds the Therapy Groups. Please provide the therapy group code value. |
SPY_PACKAGE_ONLY |
Text (1) |
Indicator if this is sold as part of a package. Yes (Y) or No (N). |
SPY_SIM_ID |
Text (6) |
Pointer to TYP_SIM that holds the itemizer for the Treatment Item. Please provide the Treatment itemizer code value. |
SPY_PREPAID_SIM_ID |
Text (6) |
Pointer to TYP_SIM that holds the Prepaid Itemizer for the Treatment Item. Please provide the Treatment Prepaid itemizer code value. |
SPY_SKU |
Text (20) |
Item’s Bar code (that will be recorded into SPU table). |
Spa Packages/Combo (SPB)
Table 4-21 Spa Treatment Items File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
SPB_CODE |
Text (20) |
Unique Identifier. |
SPB_NAME |
Text (50) |
The name displayed on the reservation form for this package. |
SPB_DESCRIPTION |
Text (255) |
A full description for this package. |
SPB_COMMENTS |
Text (255) |
Additional remarks for this item. |
SPB_ACTIVE |
Text (1) |
A switch to indicate whether this item is Active (Y) or not (N). |
SPB_SIM_ID |
Text (6) |
Pointer to TYP_SIM that holds the itemizer for treatment. Please provide the treatment itemizer code value. |
Spa Items and Packages Pricing Definition (SPV)
Table 4-22 Spa Items and Packages Pricing File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
SPV_TYPE |
Text (1) |
Item type (R-Retail, T-Treatment, P-Package). |
SPV_REF_ID |
Number |
Pointer to either SPI_ID (Retail Items), SPY_ID (Treatment Items) or SPK_ID (If package, this will contain the package price definition linking table ID. This value will be auto inserted.). Please provide the code of the retail items or treatment items. With this column and item type combination, it will be used as the unique identifier for this record. |
SPV_FROM_DATE |
Date |
From date for the price period. |
SPV_TO_DATE |
Date |
To date for the price period. |
SPV_PRICE |
Number |
The price to charge for this item. |
SPV_SPB_ID |
Number |
Pointer to SPB_ID for package identifier. Please provide the package code (SPB_CODE). This value also indicates this is a price definition for a package. |
Spa Booking Details (SPA)
Table 4-23 Spa Booking Details File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
SPA_ITEM_TYPE |
Text (1) |
Item type (R-Retail, T-Treatment). |
SPA_SPI_ID |
Number |
Pointer to either SPI_ID (Retail Items). Please provide the code of the retail items. |
SPA_SPY_ID |
Number |
Pointer to either SPY_ID (Treatment Items). Please provide the code of the treatment items. |
SPA_SPB_ID |
Number |
Pointer to either SPB_ID (Packages). Please provide the code of the packages. |
RES_V_GUESTID or RES_BOARDCC / SPA_ACC_ID |
Number |
Unique Account identifier, used to reference a row with rows from the Master Details file. During the import the identifier gets converted to internal SPMS identifier. |
SPA_PREPAID |
Text (1) |
Prepaid flag (Y/N). |
SPA_VID |
Text (60) |
Spa Booking record unique identifier (Each different records should have a unique identifier to recognize new record from existing, is used to determine overwriting or delete or add new in Data Import). |
SPA_BOOKING_DATE |
Date |
Booking date/time stamp. |
SPA_DATE |
Date |
Appointment date. |
SPA_TIME |
Number |
Appointment time. |
SPA_PRICE |
Number |
Booking price, if it is different from price definition, maybe because of discount. |
SPA_WEB_COMMENTS |
Text (1000) |
Additional comments for imported bookings. |
SPA_SPL_ID |
Number |
Pointer to either SPL_ID (Location). Please provide the code of the location. |
SPA_SPS_ID |
Number |
Pointer to either SPS_ID (Schedule record). Please provide the code of the schedule record. |
SPA_SALES_CUR |
Text (6) |
Foreign Currency Type, linked to TYP_CUR.TYP_ART |
SPA_SALES_FOREX |
Numeric (22,4) |
Amount in foreign currency. |
User Definable Field Details
Table 4-24 User Definable Field File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
UDF_NAME |
Text (50) |
User definable field name. This should be unique and will be used as identifier for overwriting purposes. |
UDF_LABEL |
Text (30) |
Display Caption in Program. |
UDF_DEFAULT |
Text (100) |
Field Default Value. |
UDF_ACCESS |
Text (5) |
Determine to be shown at which account. Takes value of either 0-No Access or 1-Have Access. Position 1=Guest, 2=Crew, 3=Visitor, 4=Group, 5=System Account. For example, 10001 mean access to guest and system account. |
UDF_REMARKS |
Text (200) |
Other remarks. |
User Definable Data
Table 4-25 User Definable Data File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Account identifier, used to reference a row with rows from the Master Details file. During the import the identifier gets converted to internal SPMS identifier. This field will be mapped to UDD_ACC as account reference. |
UDD_UDF_ID |
Text (50) |
Takes value of UDF_NAME. Program will use UDF_NAME to refer to UDF_ID. Combination of this field and RES_V_GUESTID will be used as the identifier for overwriting purposes. |
UDD_VALUE |
Text (100) |
Custom Field Value. |
Gift Card Details
Table 4-26 Gift Card Details File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
GC_ENABLE_GCEL_ID_SPECIAL |
NUMBER(1) |
Enable usage for special department/family group. |
GC_GCTP_ID |
INTEGER |
Gift Card Template Link ID. Pointer to GCTP_ID. |
GC_PAX_ID |
INTEGER |
Gift Card Holder ID. Pointer to UXP_A_ID (for Personalized card type only). |
GC_PRICE |
NUMBER |
Gift Card Selling Price. |
GC_VALUE |
NUMBER |
Gift Card Value. |
GC_REMARKS |
CHAR(100) |
Reservation Comments. |
GC_V_GUESTID |
VARCHAR2(50) |
External System Reservation Identifier. |
GC_BOARDCC |
CHAR(20) |
Internal Onboard Card Number. |
Credit Card Details
Table 4-27 Credit Card Details File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
CRD_PAYER |
NUMBER |
Credit Card Owner Account Identifier. Pointer to CRD_ACC_ID. |
CRD_NO |
VARCHAR2(65) |
Credit Card Number. |
CRD_EXP_MMYY |
CHAR(0) |
Credit Card Expiration Date. |
CRD_EXP_YYMM |
CHAR(0) |
Credit Card Expiration Date. |
CRD_NAME |
VARCHAR2(40) |
Credit Card Holder Name. |
CRD_TRACK1 |
VARCHAR2(200) |
Credit Card Track 1 Data. |
CRD_TRACK2 |
VARCHAR2(200) |
Credit Card Track 2 Data. |
CRD_CTLNO |
VARCHAR2(40) |
Credit Card Control Number. |
CRD_LIMITS |
NUMBER(22,4) |
Credit Card Limit. |
CRD_REWARDS |
NUMBER(1) |
Card Rewards Balance. |
CRD_TRACK3 |
VARCHAR2(224) |
Credit Card Track 3 Data. |
CRD_INVOICE |
VARCHAR2(10) |
Invoice Number that Credit Card is Assigned To. |
CRD_BUYER |
NUMBER |
Guest (Buyer) having routing to CRD_PAYER. |
CRD_CARDTYPE |
CHAR(0) |
Dummy field. Compatible with HAL Credit Card Import. |
Pre-booked and Pre-paid Events Bookings Details (TKPO)
Table 4-28 Pre-Booked and Pre-Paid Event Bookings File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) or Numeric (20) |
Unique Guest/Crew/Account identifier, used to reference a row with rows from the Master Details file. During the import the identifier gets converted to internal SPMS identifier. (epo_acc). The ‘Delete existing before update’ check box is available. |
TKPO_PDAT |
Date |
Events Actual Posting Date, System Date by Default. |
TKBE_CODE |
Text (20) Unique |
Bookable Event preset Code. From reservation the value to be passed in should be TKBE_CODE and the Data Import will convert it to valid TKBE_ID. |
TKBE_DATE |
Date |
Bookable Event date, not to insert into database. Only for verification purposes if more than one bookable Events with identical TKBE_CODE. For use in detecting a Bookable Event more accurately. If it does not exist in a file, record import is skipped because no matching Bookable Event can be found. |
TKPB_PRICE_CATEGORY |
Text (6) |
Price Category Code Reference (TYP_TKP.TYP_ART). |
TKPB_PERSON_GROUP |
Text (6) |
Person Group Code Reference (TYP_TKG.TYP_ART). |
TKPO_PREPAID |
Text (1) |
Prepaid Flag. |
TKPO_PREBOOKED |
Text (1) |
Pre-booked Flag. |
TKPO_VID |
Text (10) |
Events record unique identifier (Each different records should have a unique identifier to recognize new record from existing, is used to determine overwriting/delete/add new in data import). |
TKPO_GROSS_SALESPRICE |
Numeric (22, 4) |
Events Gross Price (decimal not needed if Par-Data Import Implied Decimal is set true). |
TKPO_NET_SALESPRICE |
Numeric (22, 4) |
Events Net Price (decimal not needed if Par-Data Import Implied Decimal is set true). |
TKPO_QUANTITY |
Numeric |
Tickets bought (Default is 1). |
TKPO_TICKET_PRINTED |
Numeric |
Number of ticket printed (Default is 0). |
TKPO_POS_DEPT |
Text (10) |
Department code to post the Event to. If it does not exist in file, default is from Bookable Event setup, if not set, will only default to parameter "FCTICKET Posting Department Code". |
-
Gross Price or Net Price, value from the file is always a priority as compared to value from Bookable Event record (TKBE)
-
If no Gross Price from file, it is calculated from Net Price from file using tax found from TKBE.
-
If no Gross Price and Net Price from file, get it all from TKBE.
-
If no Net Price from file only but Sales Price is given in file, get Net Price from TKBE.
-
TKPO_PREPAID: pre-paid flag (Y/N)
-
TKPO_PREBOOKED: pre-booked flag (Y/N)
But during the actual import process, pre-booked tickets must be separated from the Pre-paid Tickets into different import files. This is similar for Excursions Pre-booked and Pre-paid Bookings.
Selecting the right menu option in the Data Import module will automatically update the above mentioned fields as necessary:
PRE-BOOKED EVENTS BOOKINGS:
-
TKPO_PREPAID: will be set to “N”
-
TKPO_PREBOOKED: will be set to “Y”
-
TKPO_PREPAID: will be set to “Y”
-
TKPO_PREBOOKED: will be set to “N”
All Events Bookings, whether pre-paid or pre-booked events, only are posted to the TKPO table. They are listed in the Unposted Bookings screen in the Ticket module, waiting to be posted to the rightful account.
-
If PAR “Prepaid Events All to System Account” is disabled, all posting are posted to the buyer’s group leader, if it exists.
-
If it does not exist or PAR “Prepaid Events All to System Account” is enabled, all postings are posted to the system account as configured in the PAR “Pre-Paid Events SYS ACC”.
-
If value for the configuration in PAR is null, it is posted to the System Error Account.
In overwriting cases, if prepaid is already posted to account, it will be voided from POS first. If PAR “Onboard Refund for Prepaids” is enabled, the prepaid is voided and refunded back to the onboard guest account. If disabled, it will be voided against the posted system account.
Event Waitlist (TKPW)
Table 4-29 Event Waitlist File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
RES_V_GUESTID or RES_BOARDCC |
Text (50) / Numeric (20) |
Unique Guest/Crew/Account identifier, used to reference a row with rows from the Master Details file. During the import the identifier gets converted to internal SPMS identifier (epo_acc). The ‘Delete existing before update’ check box is available. |
TKPW_PDAT |
Date |
Events Actual Posting Date, System Date by Default. |
TKBE_CODE |
Text (20) Unique |
Bookable Event preset Code. From reservation the value to be passed in should be TKBE_CODE, the Data Import will convert it to valid TKBE_ID. |
TKBE_DATE |
Date |
Bookable Event date, not to insert into the database. Only for verification purposes if more than one bookable Events with identical TKBE_CODE. Use for detecting a Bookable Event more accurately. If it does not exist in file, record import is skipped because no matching Bookable Event can be found. |
TKPB_PRICE_CATEGORY |
Text (6) |
Price Category Code Reference (TYP_TKP.TYP_ART). |
TKPB_PERSON_GROUP |
Text (6) |
Person Group Code Reference (TYP_TKG.TYP_ART). |
TKPW_VID |
Text (10) |
Events record unique identifier (Each different records should have a unique identifier to recognize new record from an existing; is used to determine overwriting/delete/add new in Data Import). |
TKPW_GROSS_SALESPRICE |
Numeric (22, 4) |
Events Gross Price (decimal not needed if Par-Data Import Implied Decimal is set true). |
TKPW_NET_SALESPRICE |
Numeric (22, 4) |
Events Net Price (decimal not needed if Par-Data Import Implied Decimal is set true). |
TKPW_QUANTITY |
Numeric |
Tickets bought (Default is 1). |
TKPW_TICKET_PRINTED |
Numeric |
Number of ticket printed (Default is 0). |
Comment Details
Table 4-30 Comment Details File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
CPL_LINK_ID |
NUMBER |
Identifier to linkage between Comments and Resolutions. |
CPL_ACC_ID |
NUMBER |
Reservation account identifier. Linked to RES.RES_ACC |
CPL_USR_ID |
NUMBER |
User to create comments/resolutions. Linked to USR.USR_ID |
CPL_TYPE |
VARCHAR2(1) |
Record type (C-Comment, R-Resolution). |
CPL_DATE |
DATE |
Record created date and time. |
CPL_EXT_ID |
VARCHAR2(20) |
Comments/Resolutions external code. |
CPL_DESCR_CODE |
VARCHAR2(6) |
Comment description code. Linked to TYP_CPL.TYP_ART. Resolution description code. Linked to TYP_RES.TYP_ART |
CPL_DESCR |
VARCHAR2(1500) |
Comment description. Predefined and linked to TYP_CPL.TYP_COMMENT. Resolution description. Predefined is linked to TYP_RES.TYP_COMMENT |
CPL_COMMENT |
VARCHAR2(1500) |
Comment/Resolutions remark. |
CPL_REQ_RES_DATE |
DATE |
Requested resolution date. |
CPL_RES_DONE |
NUMBER |
Resolution status. (0-Not Resolved, 1-Resolved). |
CPL_RES_BY |
VARCHAR2(50) |
Person who did the resolution. |
CPL_RES_DATE |
DATE |
Resolution resolved date. |
CPL_RES_COST |
NUMBER |
Comment/Resolution associate cost. |
CPL_REPORT_TYPE |
CHAR(6) |
Define comment/resolution reporting method. |
CPL_URGENT |
NUMBER |
To flag a comment if it is an urgent comment. |
CPL_CRW_ID |
NUMBER |
Link uxp_a_id if the user is linked to crew. |
CPL_SENSITIVE |
NUMBER |
Sensitive Flag. |
CPL_TYP_CMC |
CHAR(6) |
Comment Category. |
CPL_VID |
VARCHAR2(60) |
Unique Identifier (for import duplicate functionality). |
Mobile Key Details (RESMK)
Table 4-31 Mobile Key Details (RESMK) File
COLUMN NAME | DATA TYPE (LENGTH) | DESCRIPTION |
---|---|---|
ID |
Numeric (38) |
Mobile Key Unique ID. |
RES_ID |
Numeric (38,0) |
Guest account ID. Linked to Unique Account Reservation ID. |
MOBILE_KEY |
VARCHAR2 (2000) |
Mobile Key. |
VID |
VARCHAR (100) |
Mobile Key record unique identifier (Each different record should have a unique identifier to recognize new record from existing. It is used to determine overwriting or delete or add new in Data Import). |
RES_MOBILE_KEY_MODATE |
Date |
Last modified date. |