Domain - List of ticket requests
Domain description
This domain contains detailed information on tickets requested ticket via a lottery and corresponds to the view D_LOTTERY_TICKET_REQUESTSREQUEST_V1_0 in which :
1 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.
Domain's columns description
The following link contains more information on the data of the domain: D_LOTTERY_TICKET_REQUESTSREQUEST.
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 record = 1 usage 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 ou or EXTERNAL_CONTACT_NUMBER
This domain is available since Whymper V1.
Domain's columns description
The following link contains more information on the data of the domain: D_LOTTERY_USERS.
Domain - List of requested
...
tariffs
Domain description
This domain contains details on tariffs mentioned tariffs in the requested tickets ticket requests and corresponds to the view D_LOTTERY_TARIFF_DETAILS_V1_0 in which:
1 record = 1 request for a given tariff inside the request of 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.
Domain's columns description
The following link contains more information on the data of the domain: D_LOTTERY_TARIFF_DETAILS.
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 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 ou or (T_TICKET_REQUEST_ID, TICKET_REQUEST_RANK)
This domain is available since Whymper V1.
Domain's columns description
The following link contains more information on the data of the domain: D_LOTTERY_GUESTS.
Domaine - List of Lottery Operation request
Domain description
The new report has been renamed from "D_LOTTERY_OPERATION_REQUEST_V1_0" to "D_LOTTERY_OPERATION_REQUEST_V1_1" for the new version.
This domain contains detailed information on
1 record = 1 movement for a given lottery application with information related to:
Application Id, Request Id, Operation Id, Movement Id
Application state, Request state
ID of S360 File, S360 Order
ID package, performance, seatcat, tariff, contingent
Quantity and unit amount
Id of sales channel, point of sales
The contact who applied and their EPC alias
Rank & Rank priority
A record is identified in a unique way by means of the following attributes: : BALLOT_MOVEMENT_ID
Domain's columns description
The following link contains more information on the data of the domain: D_LOTTERY_OPERATION_REQUEST