Page History

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...

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

...

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

...

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

...

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

...

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