This article presents all the fields used in standard e-commerce tables with the Event structure (see how to generate this structure). This reference aims to provide a consistent view of the data model to simplify data integration, analysis, and use in Dialog Insight. For each table, you will find a list of the fields, including their code, label, type, and description.
Transaction
| Code | Label | DataType | Description |
|---|---|---|---|
| customer_id foreign key | Source Person ID | Depending on the primary key of the project:
| Identifier of the contact in the third-party solution. |
| idTransaction primary key | Unique transaction ID | NVarChar(500) (Not nullable) | Identifier of the transaction in the third-party solution. |
| idSendLog | Identifier of the sendlog linked ot the transaction | Bigint | Identifier of the sendlog (Google Analytics). |
| idBatch | Batch identifier linked to the transaction | Int | Identifier of the idBatch (Google Analytics). |
| Source | Transaction source | NVarChar(100) | Source of the transaction |
| Revenue | Transaction amount | Decimal | Gross revenue from the items sold. |
| Shipping | Shipping amount | Decimal | Shipping cost before taxes at the time the order was placed. |
| Tax | Tax amount | Decimal | Total tax amount at the time the order was placed. |
| dtTransactionCreatedAt | Date of creation of the transaction | DateTime | Creation date of the transaction in the store. |
| dtTransactionUpdatedAt | Transaction information update date | DateTime | Last modification date of the transaction in the store. |
| financialStatus | Financial status of the transaction | NVarChar(200) | Payment status of the order. |
| fulfillmentStatus | Order processing status | NVarChar(200) | Fulfillment status of the order. |
Item (Ticket)
| Code | Label | DataType | Description |
|---|---|---|---|
| idTransaction foreign key | Transaction ID | NVarChar (100) (not nullable) | Identifier of the transaction in the Transaction table. |
| idProduct | Event ID | NVarChar(100) (not nullable) | The event name. |
| itemStatus | Item status | NVarChar(50) | |
| itemCategory | Category ID | NVarChar(100) | |
| ticketCount | Nomber of tickets | Int | Number of tickets purchased. |
| Price_unit | Unit price per ticket | Decimal | Price per ticket. |
| Price_total | Total price | Decimal | Total ticket price. |
| isScan | If the ticket was scanned at the event | Bit | Was the ticket validated? |
Event (Product)
| Code | Label | DataType | Description |
|---|---|---|---|
| idProduct primary key | Event ID | NVarChar(500) (not nullable) | Identifier of the event. |
| ProductName | Event name | NVarChar(500) | The event name. |
| Description | Event description | NVarChar(500) | Description of the event. |
| Currency | Currency | NVarChar(5) | The currency selected in the E-commerce configuration. |
| RegularPrice | Regular price | Decimal | Price before discounts. |
| CurrentPrice | Current price | Decimal | Actual price in the store. |
| eventStartDateTime | Start date and hour of the event | DateTime | Event starting date. If there are several representations, the first one is used. |
| eventEndDateTime | End date and hour of the event | DateTime | Event ending date. If there are several representations, the last one is used. |
| UrlProduct | Event url on the main site | NVarChar(500) | Link to the main web page for the event. |
| UrlImageDefaut | Url to an image that represents the event | NVarChar(500) | Event default image. Only one image is supported. |
| eventLocation | Event locations | NVarChar(500) | Event locations. |
| Status | Event status | NVarChar(50) | Event status. |
| Source | Source from which the data retrieved from the event comes | NVarChar(500) | Data source. |
Representation
| Code | Label | DataType | Description |
|---|---|---|---|
| idRepresentation primary key | Representation ID | NVarChar(100) (non nullable) | Identifier of the representation. |
| dtRepresentation | Representation date and time | DateTime | Date and time of the representation. |
| Address | Representation location | NVarChar(100) | Address of the representation location. |
| Saison | Representation season | NVarChar(100) | Season during which the representation takes place. |
| representationInfo | Additional information | NVarChar(100) | Additional information about the representation. |
| idProduct | Event ID | NVarChar(500) (not nullable) | Identifier of the event associated with the representation. |
ProductCategory
| Code | Label | DataType | Description |
|---|---|---|---|
| idCategory primary key | Category identifier | NVarChar(100) | Client identifier of the category. |
| CategoryName | Category name | NVarChar(100) | Category name. |