Domain - Link between operation and payment
Domain description
This domain contains the link between operation and payment and corresponds to the view D_PAYMENT_OPERATION_LINK_V1_0 in which:
1 record = 1 operation payed by a given payment for a given amount (one same payment can pay several operations) with information related to:
Operation
Payment
Amount
A record is identified in a unique way by means of all the following attributes : T_OPERATION_ID, T_PAYMENT_ID
This domain is available since Matterhorn V3.
Domain's columns description
The following link contains more information related on the data of the domain: D_PAYMENT_OPERATION_LINK
Domain - List of invoices
Domain description
This domain contains the list of invoices and payment tracking and corresponds to the view D_ACCOUNT_LIST_INVOICE_V1_0 in which:
1 record = 1 invoice with information related to:
Invoiced contact with his/her address and delivery method used
Information on the invoice itself (i.e. amount, date, etc.)
Invoice’s payment status
The order or the file linked to the invoice, including the purchase contact
Invoicing operator
A record is identified in a unique way by means of the attribute INVOICE_NUMBER or T_INVOICE_ID. The attribute T_INVOICE_ID must be used to make the link between domains.
This domain is available since Matterhorn V3.
Domain's columns description
The following link contains more information in the data of the domain: D_ACCOUNT_LIST_INVOICE
Domain - List of sales
Domain description
This domain contains detailed information on sales and corresponds to the view D_SALES_LIST_SALES_V1_0 in which:
1 record = sales, reservation or refund of a given product within a given operation (i.e. order line) with information related to:
The product
Product’s temporal validity
Price conditions (tariff, advantage)
Contingent
Sales amount (or reservation, refund) of the product and the linked fees
Sales executor (operator, sales channel,…)
Sales information (date, order number, purchase contact)
A record is identified in a unique way by means of the following attribute : T_OPERATION_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_SALES_LIST_SALES
Domain - Product revenue
Domain description
This domain contains the number of sales and revenue and corresponds to the view D_SALES_PROD_RECEIPT_V1_0 in which:
1 record = Total amount of the sale of a given product with given conditions and a given date with information related to:
Sales date
Sales channel
The product
Product’s temporal validity
Price conditions (tariff, advantage)
Sales amount (or booking, refund) of the product and the linked fees
A record is identified in a unique way by means of all the following attributes : AGENT_NUMBER, T_ADVANTAGE_ID, T_AUDIENCE_SUB_CAT_ID, T_CONTINGENT_ID, T_ITEM_ID, T_SALES_CHANNEL_ID, T_ORIGINATING_SALES_CHANNEL, T_TIMESLOT_ID, ORDER_DATE, T_P_PRODUCT_ID, T_SEAT_CAT_ID, T_SELLER_ORGANIZ_ID, TAX_RATE, T_VISITTHEME_ID. The following attributes can be null: AGENT_NUMBER, T_ADVANTAGE_ID, T_TIMESLOT_ID, T_P_PRODUCT_ID, T_SEAT_CAT_ID, T_VISITTHEME_ID. In case of a match,, T_ITEM_ID can be replaced by the couple (T_PERFORMANCE_ID, T_SEAT_CAT_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_SALES_PROD_RECEIPT
Domain - List of sales and matching payments
Domain description
This domain contains detailed information on sales and their payment and corresponds to the view D_SALES_PROD_PAYMENT_V1_0 in which:
1 record = sales or refund of a given product within a given operation (order line) payed with a given payment with information related to:
The product
Product’s temporal validity
Price conditions (tariff, advantage)
Sales amount (or refund) of the product and the linked fees
Sales executor (operator, sales channel,…)
Sales information (date, order number, purchase contact)
Payment method
A record is identified in a unique way by means of all the following attributes : T_OPERATION_ID, T_PAYMENT_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_SALES_PROD_PAYMENT
Domain - Summary of fees
Domain description
This domain contains revenue due to fees and corresponds to the view D_SALES_FEES_V1_0 in which:
1 record = Fees amount of a given type charged at the sale of a given product with a given validity date and tariff with information related to:
The product (only for fees linked to a product, not for general fees)
Product’s temporal validity (visit timeslot, match)
Financial information (tariff, amount)
Fees
A record is identified in a unique way by means of all the following attributes : T_AUDIENCE_SUB_CAT_ID, T_FEE_ID, T_ITEM_ID, T_SALCHAN_ID, T_TIMESLOT_ID, ORDER_DATE.
In case of a performance or a match, T_ITEM_ID can be replaced by the couple (T_PERFORMANCE_ID, T_SEAT_CAT_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_SALES_FEES
Domain - List of movements
Domain description
This domain contains detailed information on movements created during orders and corresponds to the view D_SALES_MOVEMENT_V1_0 in which:
1 record = 1 contact benefiting of a given product in the context of a given operation (sales or reservation) with information related to:
- Beneficiary (cultural contact) and his/her address
- Product (including price, tarriff, location in the room if it is a performance)
- Buyer (purchase contact and file number)
- Sales executor (operator)
A record is identified in a unique way by means of the following attribute: T_MOVEMENT_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_SALES_MOVEMENT_V1_0
