The Inventory Log dataset contains each inventory log entry for each batch of inventory along with the relevant attributes about the product, batch, employees, inventory locations, and more. The log action is used to denote the type of change that occurred in the inventory.
Primary Key: org_id, store_id, log_date, inventory_log_id, log_action
| 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. |
| log_date | This column represents the timestamp when the log was created. It is a timestamp with timezone value that follows the standard timestamp format |
| next_log_date | The timestamp of the next log entry in the inventory log. This field is useful for tracking the sequence of inventory changes |
| store_tz_offset | The timezone offset of the store. This is calculated as the difference in hours between UTC and the store's local timezone. This field is useful for converting timestamps to the store's local time |
| batch_id | The human-readable batch identifier for the batch of inventory from which the ticket line product was sold |
| inventory_id | The unique identifier for the inventory batch |
| inventory_log_id | A synthetic identifier for the specific log record |
| product_id | This column represents the unique identifier for the product in inventory |
| product_brand | The brand name from the product profile of the product in inventory |
| product_name | The name from the product profile of the product in inventory |
| product_menu_title | The menu title from the product profile of the product sold on the ticket line |
| product_type | This column represents the type of the product from the product profile. (e.g., FLOWER, CARTRIDGE, EDIBLE, PREROLL, EXTRACT, PILL, TINCTURE, TOPICAL, BEVERAGE, MERCH, CBD, PLANT, MISC, NON-INV) |
| product_subtype | This column represents the sub-type or sub-category of the product. Each sub-type is tied to a parent product type. (e.g., PRE-PACK, GUMMY, 510 THREAD, POD, SAUCE) |
| log_action | The action associated with the specific inventory log. (e.g., POS Sale, Abandon Ticket, Move, Count Adjustment, Invoice Received, Merge Product, Created From Batch Split) |
| quantity_before | This column represents the inventory quantity of the batch of inventory prior to the log action |
| quantity_changed | This column represents the inventory quantity of the batch of inventory that changed due to the associated log action |
| quantity_after | This column represents the inventory quantity of the batch of inventory after the log action |
| cost_per_unit | The cost per unit paid to the distributor |
| true_cost_per_unit | The true cost per unit paid to the distributor. This is calculated as the cost per unit minus any vendor discounts or credits |
| excise_tax_per_unit | If excise tax was paid to the distributor, this is the excise tax portion of the cost on the invoice line associated with the inventory batch |
| cost_of_change_with_excise | This column represents the cost of inventory impacted by the inventory action, including any excise tax paid to the distributor |
| cost_of_change_without_excise | This column represents the cost of inventory impacted by the inventory action, excluding any excise tax paid to the distributor |
| location_original | The name of the inventory location where the inventory batch was prior to the log action |
| location_new | The name of the inventory location where the inventory batch was after the log action |
| employee_id | The unique identifier for the employee who performed the log action |
| employee_name | The name of the employee who performed the log action |
| employee_number | The employee number on the employee profile associated with the employee who performed the log action |
| reason | The reason for the log action, as documented by the employee for specific log actions such as destroying inventory |
| invoice_id | This column represents the unique identifier for the invoice containing the original package of inventory associated with the inventory batch |
| invoice_number | This column represents the numeric identifier assigned to the invoice containing the package of inventory associated with the inventory batch |
| invoice_external_id | The external ID of the invoice associated with the inventory log. This ID is used for cross-referencing with external systems |
| invoice_line_id | The unique identifier for each line item in an invoice. This ID is used to track individual products or services listed on an invoice |
| credit_note_id | The unique identifier for the credit note associated with the inventory log. Note that this has not been enabled for all stores. Please reach out to [email protected] if you need this field |
| distributor_name | The name of the distributor on the distributor profile |
| package_label | The package label of the original package containing the batch of inventory. For METRC states, this is the package tag barcode or state tracking ID |
| package_manifest_number | The shipment manifest number associated with the package containing the batch of inventory from which the ticket line product was sold |
| dispensary_license | The dispensary state license associated with the inventory batch that was received. This may be different for states that do medical and adult-use sales |
| inventory_type | The inventory type of the batch in which the ticket line product was sold out of. (e.g., ADULT, MEDICAL, ALL) |
| packaged_date | The date when the units in the inventory batch were packaged |
| expiration_date | The expiration date of the units in the batch of inventory |
| harvest_date | The date when the units in the batch of inventory were harvested |
| inventory_barcodes | The barcodes associated with the batch of inventory as defined in Inventory Control |
| product_barcode_skus | This column represents the SKU numbers associated with the product barcodes on the product profile. If a product has multiple barcode SKUs, they will be separated by commas |
| product_classification | The classification field from the product profile of the product in inventory. (e.g., SATIVA, INDICA, HYBRID, S/I, I/S) |
| product_unit_price | The unit price associated with the product on the product profile at the time of the inventory log action |
| product_unit_total_flower_weight_grams | The total flower grams from the product profile of the product in inventory, typically used for purchase limit enforcement |
| product_amount | The amount field from the product profile of the product in inventory. This field is used in conjunction with the Unit of Measure field |
| product_unitofmeasure | The unit of measure field from the product profile of the product in inventory. This field is used in conjunction with the Amount field. (e.g., g, mg, ml, fl-oz, each) |
| product_size_formatted | This is a calculated field that combines Product Amount and Unit of Measure fields and formats them into rounded amounts and consistent unit of measures. (e.g., 1g, 100mg, 1ml, 1fl-oz, 1 each) |
| product_internal_tags | This column contains the internal tags associated with the product in inventory. These tags are used for internal categorization and tracking purposes |
| product_size | The product size from the product profile of the product in inventory |
| product_external_ids | The External ID(s) associated with the product on the product profile. This is a JSON field |
| product_unit_thc_mg | The amount of THC in milligrams of the product in inventory, typically used for purchase limit enforcement |
| product_unit_cbd_mg | The amount of CBD in milligrams of the product in inventory, typically used for purchase limit enforcement |
| product_extraction_method | The Extraction Method of the product on the product profile. This is typically used for cartridges and extracts |
| 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 |