The Ticketline Sales dataset provides a comprehensive view of ticketline level sales data for all stores within a given organization. It includes information such as store details, ticket details, customer details, product details, and sales details.
Primary Key: org_id, store_id, ticket_id, ticketline_id
| Column | Description |
|---|---|
| store_id | The unique identifier for each store |
| org_id | The unique identifier for each retail organization |
| org_name | The name of the organization |
| store_name | The name of the store where the sale was made |
| selltreez_url | The URL of the SellTreez Point of Sale |
| store_state | The US state where the store is located |
| store_timezone | The timezone in which the store operates |
| datalake_store_id | The store identifier used in a legacy Treez data system |
| date_open | The timestamp indicating when a ticket was opened |
| date_close | The timestamp indicating when a transaction was closed |
| store_tz_offset | The timezone offset of the store for the given ticket date |
| ticket_number | The alphanumeric identifier of a Ticket or Sale |
| ticket_id | The unique identifier of a Ticket or Sale |
| sale_type | Denotes whether the ticket was sale or a return |
| order_channel | The channel through which the order was made |
| revenue_source | The source of an eCommerce order |
| ticket_notes | Any additional notes or comments associated with the ticket |
| cash_drawer_id | The unique identifier for the cash drawer associated with the ticket payment |
| cash_drawer_name | The name associated with the cash drawer |
| ticket_cashier_user_id | The unique identifier of the cashier |
| ticket_cashier_employee_number | The employee number of the cashier |
| ticket_cashier_shift_id | The unique identifier of the cashier’s shift |
| ticket_cashier_name | The name of the cashier |
| ticketline_created_user_id | The unique identifier of the user who created the ticket line |
| ticketline_created_employee_number | The employee number of the user who created the ticket line |
| ticketline_created_user | The name of the user who created the ticket line |
| customer_id | The numeric customer ID of the customer associated with the ticket |
| customer_type | Denotes whether the customer profile associated with the ticket is a medical or recreational customer |
| customer_first_name | The first name of the customer |
| customer_last_name | The last name of the customer |
| customer_date_of_birth | The date of birth of the customer |
| customer_age_years | The age of the customer in years at the time of the transaction |
| customer_gender | The gender of the customer |
| customer_source | The customer source field from the customer profile |
| customer_phone | The phone number of the customer |
| customer_email | The email address of the customer |
| customer_street_address | The street address of the customer |
| customer_address_city | The city of the customer’s address |
| customer_address_state | The state of the customer’s address |
| customer_address_zip | The ZIP code of the customer’s address |
| customer_address_longitude | The geographical longitude of the customer’s address |
| customer_address_latitude | The geographical latitude of the customer’s address |
| customer_groups | The groups that the customer belongs to on the customer profile |
| customer_opted_in | Indicates whether the customer has opted in for marketing communications |
| customer_medical_id | The medical customer’s state medical ID number |
| ticketline_id | The unique identifier for the ticket line |
| product_id | The unique identifier for the product sold on the ticket line |
| product_type | The type of the product |
| product_subtype | The Sub Type or Sub Category of the product |
| product_is_cannabis | Indicates whether the product is a cannabis product |
| product_brand | The brand name of the product |
| product_name | The name of the product |
| product_menu_title | The menu title of the product |
| product_size | The product size |
| product_unit_total_flower_weight_grams | The total flower grams of the product |
| product_amount | The amount field of the product |
| product_unitofmeasure | The unit of measure field of the product |
| product_size_formatted | A calculated field that combines Product Amount and Unit of Measure fields |
| product_classification | The classification field of the product |
| product_unit_cbd_mg | The amount of CBD in the product |
| product_unit_thc_mg | The amount of THC in the product |
| product_doses | The doses field of the product |
| product_thc_mg_per_dose | The amount of THC per dose of the product |
| product_barcode_skus | The SKU numbers associated with the product barcodes |
| product_extraction_method | The extraction method of the product |
| product_external_ids | The External ID(s) associated with the product |
| product_unit_price | The unit price of the product |
| product_sale_price | The unit sale price of the product |
| units_sold | The quantity of units sold or returned |
| gross_sales | The total sales generated from the sale of the product |
| discounts | The total amount of discounts applied |
| returns | The total amount of the refund for refunded ticket line items |
| net_sales | The net sales amount |
| taxes | The total amount of taxes applied |
| gross_receipts | The gross receipts value of the ticket line |
| cost_with_excise | The cost of goods sold on the ticket line, where the cost value includes excise tax paid to the distributor |
| cost_without_excise | The cost of goods sold on the ticket line, where the cost value does not include any excise tax paid to the distributor |
| gross_income_without_excise | The gross income without considering any excise tax |
| gross_income_with_excise | The gross income considering excise tax |
| returned_ticket_id | The unique identifier of the return ticket |
| inventory_location_id | The unique identifier for the inventory location |
| inventory_location_name | The name of the inventory location |
| batch_inventory_type | The inventory type of the batch |
| batch_inventory_id | The unique identifier for the batch |
| package_manifest_number | The shipment manifest number |
| package_label | The package label of the package |
| batch_id | The human-readable batch identifier |
| batch_harvest_date | The harvest date of the batch |
| batch_expiration_date | The expiration date of the batch |
| batch_inventory_received_date | The date when the batch was received |
| batch_packaged_date | The date when the batch was packaged |
| batch_inventory_barcodes | The barcodes associated with the batch |
| batch_cost_per_unit | The cost per unit paid to the distributor |
| batch_true_cost_per_unit | The true cost per unit paid to the distributor |
| batch_excise_tax_per_unit | The excise tax portion of the cost on the invoice line |
| invoice_number | The numeric identifier assigned to the invoice |
| invoice_id | The unique identifier for the invoice |
| invoice_line_id | The unique identifier for each line item in an invoice |
| distributor_id | The unique identifier for the distributor |
| distributor_name | The name of the distributor |
| distributor_is_arms_length | Indicates whether the distributor is at arm’s length |
| dispensary_license | The dispensary state license |
| last_sync | A timestamp field that records the last time the data was synchronized |
| ticketline_created_at | The timestamp when the ticket line was created |
| ticketline_updated_at | The timestamp when the ticket line was last updated |
| customer_updated_at | The timestamp when the customer’s information was last updated |
| product_updated_at | The timestamp when the product information was last updated |
| record_loaded_at | The timestamp when the record in the database was last updated |