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.
|
200 |
Ex: (30001, INC20001) |
|
|
IC_Contact_YN |
|
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: (xxx@xxxxx.xxx) 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: (xxxx@xxxxx.xxxCode: |
|
|
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) |
|
Parent topic: System Setup - Importing Data