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_TICKET_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

Browser not supported