Domain - Contact information
Domain description
This domain contains the contact detailed information and corresponds to the view D_CONTACT_LIST_V1_0 in which:
1 record = 1 contact. Prospects are also included. Each record contains information related to:
The contact itself (e.g. first name, last name)
Postal address
Communications channel (email address, telephone number)
Information related to the structure if the contact is a structure’s relay
A record is identified in a unique way by means of the attribute T_CONTACT_ID. In case of relay, a first record describes the person and a second record describes the structure linked to the relay.
This domain is available since Piz Bernina V3.
Domain's columns description
The following link contains more information on the data of the domain: D_CONTACT_LIST
Domain - Contact criteria and other values
Domain description
This domain contains all information of a contact linked to an organization and corresponds to the view D_CONTACT_ORG_INFO_V1_0 in which:
1 record = 1 information linked to a given contact for a given organization with the information related to:
- Financial information
Communication authorizations
Contact criteria
Indicators
Personal data of a loyalty program
Notes about the contact
A record is identified in a unique way by means of the attributes: T_CONTACT_ID, ORGANIZATION, T_INFORMATION_KIND, T_INFORMATION_CODE, INFORMATION_RANK.
This domain is available since Piz Bernina V3.
Domain's columns description
The following link contains more information on the data of the domain: D_CONTACT_ORG_INFO
Domain - Cultural history
Domain description
This domain contains the cultural history of a contact and corresponds to the view D_CONCT_CULTURAL_HISTORY_V1_0 in which:
1 record = 1 contact benefiting of a given product as part of a given operation (sales or reservation) with information related to:
Beneficiary (cultural contact) and his/her address
The product (including its price, tariff and location in the seat map)
The buyer (purchase contact and file contact)
Order executor (operator)
A record is identified in a unique way by means of the attribute T_MOVEMENT_ID.
This domain is available since Matterhorn V3.
Domain's columns description
The following link contains more information on the data of the domain: D_CONCT_CULTURAL_HISTORY
Domain - Link between contacts
Domain description
This domain describes the link between contacts and corresponds to the view D_CONTACT_CONNECTION_V1_0 in which:
1 record = 1 link between two given contacts with information related to:
- ID of parent contact
- ID of child contact
- Link type (e.g. structure member, sponsor, belonging to the same group, etc.)
A record is identified in a unique way by means of the attribute T_CONNECTION_ID or all of the following attributes : T_PARENT_CONTACT_ID, T_CHILD_CONTACT_ID, T_TYPE.
This domain is available since Whymper V1.
Description des colonnes du domaine
The following link contains more information on the data of the domain: D_CONTACT_CONNECTION_V1_0