The Current Inventory dataset provides a view of the current inventory levels at each store at the time of the last sync. It contains all relevant inventory batch and product information as well as relevant quantities.
Primary Key: org_id, store_id, batch_id, inventory_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 |
| 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 |
| store_tz_offset | The timezone offset of the store |
| batch_id | The human-readable batch identifier for the batch of inventory |
| inventory_id | The unique identifier for the inventory batch |
| inventory_type | The inventory type of the inventory batch |
| inventory_location_id | The unique identifier for the inventory location |
| inventory_location_name | The name of the inventory location |
| inventory_location_is_sellable | A boolean field indicating whether the inventory at the given location is sellable or not |
| product_id | The unique identifier for the product in inventory |
| 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_type | The type of the product |
| product_subtype | The Sub Type or Sub Category of the product |
| product_barcode_skus | The SKU numbers associated with the product barcodes |
| product_classification | The classification field of the product |
| product_amount | The amount field of the product |
| product_unitofmeasure | The unit of measure field of the product |
| product_size | The product size |
| product_size_formatted | A calculated field that combines Product Amount and Unit of Measure fields |
| product_internal_tags | Internal tags associated with the product in inventory |
| product_external_ids | External ID(s) associated with the product |
| units_available | The number of units currently available in inventory and ready for sale |
| units_reserved | The number of units currently reserved by online orders or saved sales |
| units_packed_and_ready | The number of units packed and ready for a pickup or delivery order |
| units_remaining | The total number of units remaining in inventory |
| units_sold | The number of units sold out of the inventory batch |
| invoice_id | The unique identifier for the invoice containing the original package of inventory |
| invoice_number | The numeric identifier assigned to the invoice |
| invoice_line_id | The unique identifier for each line item in an invoice |
| package_id | The unique identifier for the original package of inventory received |
| package_label | The package label of the original package containing the batch of inventory |
| package_manifest_number | The shipment manifest number associated with the package |
| distributor_id | The unique identifier for the distributor |
| distributor_name | The name of the distributor |
| cost_per_unit | The cost per unit paid to the distributor |
| excise_tax_per_unit | The excise tax portion of the cost on the invoice line |
| true_cost_per_unit | The true cost per unit paid to the distributor |
| harvest_date | The date when the units in the batch of inventory were harvested |
| packaged_date | The date when the units in the inventory batch were packaged |
| inventory_received_date | The date when the batch was received into inventory |
| expiration_date | The expiration date of the units in the batch of inventory |
| last_sync | A timestamp field that records the last time the data was synchronized into the Treez Data Warehouse |
| record_loaded_at | The timestamp when the record in the database was last updated |