Domain - List of ticket requests
Domain description
This domain contains detailed information on tickets requested
...
via a lottery and corresponds to the view D_LOTTERY_TICKET_
...
REQUEST_V1_0 in which :
1
...
- La lotterie depuis laquelle la demande a été effectuée
- L'identifiant du match souhaité
- L'identifiant de l'utilisateur (= futur contact) ayant fait la demande
- Informations sur la catégorie de place
- Informations sur les personnes qui assisteront au match
- Informations sur le paiement (qui sera uniquement effectué si la demande est tirée au sort)
- Informations sur l'état de la demande
...
record = 1 ticket request for a given match with information related to:
- Lottery used to perform the request
- ID of the selected match
- ID of user (= future contact) having performed the request
- Information on the seat category
- Information on persons who will assist to the match
- Information on the payment (which will be processed only if the request was drawn lots)
- Information on the request status
A record is identified in a unique way by means of the following attributes: : T_TICKET_REQUEST_ID
...
This domain is available since Whymper V1.
Description des colonnes du domaine
...
Domain's columns description
The following link contains more information on the data of the domain: D_LOTTERY_TICKET_
...
Domaine - Liste des utilisateurs de la lotterie
Description du domaine
...
Domain - List of lottery users
Domain description
This domain contains detailed information on users of the lottery and corresponds to the view D_LOTTERY_USERS_V1_0
...
in which:
1
...
- L'identité de l'utilisateur
- Les moyens de communication avec l'utilisateur
- Le numéro de contact correspondant à cet utilisateur. Ce numéro sera attribué lorsque l'utilisateur sera importé dans la billetterie sous forme de contact
- Loterie depuis laquelle l'utilisateur a été créé
...
record = 1 user of a lottery with information related to:
- ID of the user
- Means of communication with user
- Contact number corresponding to this user. This number will be assigned when the user will be imported in the ticketing system as a contact
- Lottery from where the user has been created
A record is identified in a unique way by means of all the following attributes: T_USER_ID
...
or EXTERNAL_CONTACT_NUMBER
...
This domain is available since Whymper V1.
Description des colonnes du domaine
Domain's columns description
The following link contains more information on the data of the domain: D_LOTTERY_USERS.
Domaine - Liste des tarifs demandés
Description du domaine
...
Domain - List of requested tariffs
Domain description
This domain contains details on tariffs mentioned in the ticket requests and corresponds to the view D_LOTTERY_TARIFF_DETAILS_V1_0
...
in which:
1
...
- Le tarif et le nombre de billets demandés
- La demande de billets concernée (identifiant)
...
record = 1 request for a given tariff inside a given ticket request with information related to:
- Tariff and number of requested tickets
- Concerned ticket request (ID)
A record is identified in a unique way by means of all the following attributes: T_TICKET_REQUEST_ID, T_AUDIENCE_CAT_ID, T_AUDIENCE_SUB_CAT_ID
...
This domain is available since Whymper V1.
Description des colonnes du domaine
...
Domain's columns description
The following link contains more information on the data of the domain: D_LOTTERY_TARIFF_DETAILS.
Domaine -
...
Description du domaine
...
List of guests
Domain description
This domain contains the list of guests planned for the requested tickets and corresponds to the view D_LOTTERY_GUESTS_V1_0
...
in which:
1
...
- La demande de billets (identifiant)
- Informations sur le bénéficiaire
...
record = 1 guest of a given ticket being part of a given ticket request with information related to:
- Ticket request (ID)
- Guest information
A record is identified in a unique way by means of all the following attributes: T_GUEST_ID or (T_TICKET_REQUEST_ID, TICKET_REQUEST_RANK)
...
This domain is available since Whymper V1.
Description des colonnes du domaine
...
Domain's columns description
The following link contains more information on the data of the domain: D_LOTTERY_GUESTS.