Importing Profiles and Relationships

The Keep History YN and ActiveYN fields for Individual/Contact profiles will be defaulted to Y for all the imported profiles.

Table 24-7 Guest (Individual) / Contact Profiles

Column	Description	Max Data Length	Sample Data	Mandatory
IC_Unique_ID_Ind_Contact (PK)	Unique ID value for Guest/Contact Profiles in the uploaded csv files for data type Guest/Contact Profiles within an import cycle. Primary Key	200	Ex: (30001, INC20001)
IC_Contact_YN	Y or N Y for contact; else N	N/A	Ex: (Y, N)
IC_Last_Name	The Last name of an Guest/Contact Profile name.	40	Ex: (Smith, Brown)
IC_Middle_Name	The Middle name of an Guest/Contact Profile name.	40	Ex: (David, James)
IC_First_Name	The First name of an Guest/Contact Profile name.	40	Ex: (Robert, John)
IC_Profile_Language	Primary language used for the profile. The language code needs to be pre-configured in OPERA Cloud.	20	Ex: (DE, E, RU)
IC_Title	The title of the Individual. The Title code needs to be pre-configured in OPERA Cloud.	20	Ex: (Mr., Mrs., Dr.)
IC_Nationality	Nationality of the Individual. The Title code needs to be pre-configured in OPERA Cloud.	20	Ex: (IND, US)
IC_Position	The business title for the Guest/Contact Profile.	60	Ex: (Director)
IC_Owner_Code	Owner Code associated with the Guest/Contact Profile. If blank value is provided, it will be defaulted to ALL.	10	Ex: (ALL)
IC_VIP_Code	VIP Code associated with the Guest/Contact Profile. The VIP code needs to be pre-configured in OPERA Cloud.	20	Ex: (VIP, VVIP)
IC_Address_Type	The address type code. The address code needs to be pre-configured in OPERA Cloud.	20	Ex: (HOME, BUSINESS)
IC_Address_Line1	The first line of street address.	80
IC_Address_Line2	The second line of street address.	80
IC_Address_Line3	The third line of street address.	80
IC_Address_Line4	The fourth line of street address.	80
IC_City	The City of this address.	40
IC_Postal_Code	The Postal Code of the address.	15
IC_Postal_Code_Ext	The Postal Code Extension of the address.	20
IC_Country	The Country code of the address; pre-configured in OPERA Cloud.	40
IC_State	The State code of the address; pre-configured in OPERA Cloud.	40
IC_Address_Language	The Language code used for the address; pre-configured in OPERA Cloud.	20
IC_Ref_Currency	Currency code to be used for the commission payment; pre-configured in OPERA Cloud.	20
IC_Communication_Type1	The Communication type code; pre-configured in OPERA Cloud.	4000
IC_Communication1	The value for the communication for IC_Communication_Type1.	4000
IC_Communication_Type2	The Communication type code; pre-configured in OPERA Cloud.	4000
IC_Communication2	The value for the communication for IC_Communication_Type2.	4000
IC_Communication_Type3	The Communication type code; pre-configured in OPERA Cloud.	4000
IC_Communication3	The value for the communication for IC_Communication_Type3.	4000	Ex: ([e-mail]) Code: EMAIL

Sales Account Profiles (Company/Agent/Source)

• Mandatory columns are marked in bold.

• The ActiveYN field for Accounts defaults to Y for all imported profiles.

Table 24-8 Sales Account Profiles (Company/Agent/Source)

Column Name	Description	Max Data Length	Sample Data	Mandatory
ACC_Unique_ID_Account (PK)	Unique ID value for Sales Account in the uploaded csv files for data type Accounts within an import cycle.		Ex: (40001, AC40001)
ACC_Profile_Type	The type of sales account. The account type can be TA, Source, and Company.		Ex: ( TA, Source, Company)
ACC_Name	Name of the account profile.	80	Ex: ( Company Name, Source Name)
ACC_Name2	Second name of the account profile.	80
ACC_Name3	Third name of the account profile.	80
ACC_Profile_Language	Primary language of the profile; pre-configured in OPERA Cloud.	20	Ex: (DE, E, RU)
ACC_Address_Type	The address type code; pre-configured in OPERA Cloud.	80	Ex: (HOME, BUSINESS)
ACC_Address_Type1	The first line of street address.	80	Ex: 100 West Monroe
ACC_Address_Type2	The second line of street address.		Ex: Suite 100
ACC_Address_Type3	The third line of street address.
ACC_Address_Type4	The fourth line of street address.
ACC_City	The City of this address.		Ex: (Chicago)
ACC_Postal_Code	The Postal Code of the address.		Ex: (60601)
ACC_Postal_Code_Ext	The Postal Code Extension of the address.		Ex: (0401)
ACC_Country	The Country code of the address; pre-configured in OPERA Cloud.		Ex: (US)
ACC_State	The State code of the address; pre-configured in OPERA Cloud.		Ex: (IL)
ACC_Address_Language	The Language code used for the address; pre-configured in OPERA Cloud.		Ex: (E, JPN, CHN)
ACC_Ref_Currency	Currency code to be used for the commission payment; pre-configured in OPERA Cloud.		Ex: (INR, USD)
ACC_Communication_Type1	The Communication type code; pre-configured in OPERA Cloud.	4000	Ex:  (MOBILE)
ACC_Communication1	The value for the communication for ACC_Communication_Type1.	4000	Ex: 9999999111
ACC_Communication_Type2	The Communication type code; pre-configured in OPERA Cloud.	4000	Ex:  (WEB)
ACC_Communication2	The value for the communication for ACC_Communication_Type2.	4000
ACC_Communication_Type3	The Communication type code; pre-configured in OPERA Cloud.	4000	Ex:  (EMAIL)
ACC_Communication3	The value for the communication for ACC_Communication_Type3.	4000	Ex: ([e-mail]: EMAIL
ACC_Owner_Code	Owner Code associated with the Guest/Contact Profile. If NULL, it will default to ALL.		Ex: (ALL , BB)
ACC_CORP_IATA_ID	Corp ID / IATA	20	76542389
ACC_TAX1_NO	Tax Number 1	30	28745623
ACC_TAX2_NO	Tax Number 2	30	9875437

Note:

The values for ACC_CORP_IATA_ID / ACC_TAX1_NO/ ACC_TAX2_NO columns in Account.csv should be as per your standards and conform to the following OPERA Controls.

• Pad Corporate Number Digits-> Pad Corporate Number Digits/ Pad IATA Number Digits

• Allow Duplicate IDs

• IATA Validation

• Bypass Corp Id Validation

• Tax ID Validation

Note:

The Import process does not perform any validations on these fields.

Relationships (Account/Contact)

• Records reference the ACC_Unique_ID_Account and IC_Unique_ID_Ind_Contact values from Sales Account and Guest/Contact data files respectively.

• The default relationship between the account and Guest/Contact profile will be Employer (Type: ACCOUNT) and Employee (Type: CONTACT) relationship.

Table 24-9 Relationships (Account/Contact)

Column Name	Description	Max Data Length	Sample Data	Mandatory
REL_Unique_ID_Relationship  (PK)	Unique ID value for Relationship in the uploaded csv files for Data type Relationships within an Import cycle.	200	Ex: (50001, RL50001)
ACC_Unique_ID_Account (FK)	Foreign Key: Linked Unique ID value of Sales Account Profile. Reference PK value from Sales Account data file within an import cycle.	200	Ex: (40004, AC40004)
IC_Unique_ID_Ind_Contact (FK)	Foreign Key: Linked Unique ID value of Guest/Contact Profile. Reference the PK value from Guest/Contact data file within an import cycle.	200	Ex: (30003, INC20003)