The Ticketline Taxes dataset contains information about the taxes applied to each ticketline in a transaction. It includes details about the ticket, store, and tax types.
Primary Key: org_id
, store_id
, ticket_id
, ticketline_id
, tax_id
, ticketline_tax_id
Column | Description |
---|---|
store_id | The unique identifier for each store. Each store is tied to exactly one org_id |
org_id | The unique identifier for each retail organization consisting of one or more stores operating with Treez |
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 where the sale was made |
store_state | The US state where the store is located, abbreviated (e.g., CA, CO) |
store_timezone | The timezone in which the store operates. This is returned in the Olson format (i.e., America/Los_Angeles) |
datalake_store_id | The store identifier used in a legacy Treez data system |
date_open | The timestamp indicating when a ticket was opened. This is used to track the start of a transaction. This timestamp is encoded in the store's local time zone |
date_close | The timestamp indicating when a transaction was closed. This is used to track the completion of a transaction. This timestamp is encoded in the store's local time zone |
store_tz_offset | This column represents the timezone offset of the store for the given ticket date. It is calculated as the difference in hours between UTC and the store's timezone at the time of ticket closure |
ticket_number | This is the alphanumeric identifier of a Ticket or Sale in Treez. It is a string value. (e.g., "NDLZEB") |
ticket_id | This is the unique identifier of a Ticket or Sale in Treez, and used primarily in the SellTreez Ticket API. It is a string value. (e.g., "c25809ca-e7c4-4adc-96b9-12af08482c64") |
ticketline_id | This column represents the unique identifier for the ticket line. Each ticket contains one or more ticket line items tied to a specific product, which may have one or more units sold or returned |
ticketline_tax_id | This column represents a unique identifier for the ticketline combined with the associated tax record to help form the primary key for the dataset |
order_channel | The channel through which the order was made (e.g., In Store, Pickup, Delivery, Express) |
revenue_source | The source of an eCommerce order (e.g., Treez eCommerce, Dutchie, WEEDMAPS, iheartjane) |
customer_type | Denotes whether the customer profile associated with the ticket is a medical or recreational customer. (e.g., ADULT, MEDICAL-REGULAR, MEDICAL-MMID) |
tax_id | The unique identifier for the specific tax applied to the ticket line |
tax_label | The name of the tax applied to the ticket line |
tax_category | The category of the tax applied to the ticket line. (e.g., Sales Tax, Custom Tax) |
tax_subcategory | The subcategory of the tax applied to the ticket line. (e.g., SALES, CUSTOM, DYNAMIC) |
taxable_amount | The net sales amount of the ticket line that is subject to the tax |
tax_rate | The rate of the tax applied to the ticket line |
total_tax_charged | The total amount of tax charged on the ticket line |
last_sync | A timestamp field that records the last time the data was synchronized into the Treez Data Warehouse. This is useful for tracking data changes and updates. To check for new or changed records, query for records where the last_sync timestamp is greater than the greatest timestamp in your data store |
record_loaded_at | This column represents the timestamp when the record in the database was last updated, encoded in the store's local time zone |