Inventory Table

This report shows a snapshot of all your inventory. Inventory is aggregated by the Unique Product ID, Batch ID, and Location, which means it should reflect your inventory as it appears on the Inventory Control page of your portal.

Datetime Dataset Last Updated: last_retrieved_timestamp

Unique Composite Key(s): storeid, batch_id, location_id, product_id, state_tracking_id

Upsert Logic: Replace All

Column Name

Definition

Example Output

unit_of_measure

Unit of Measure

GRAMS

type

Inventory Type

ALL

storeid

Store ID

230

status

Inventory Status

AVAILABLE

start_date

If the invoice is still in draft state, this is the date that the invoiceline was created. If the invoice has been accepted, this is the date and time that inventory was accepted into the dispensary. This field changes only once after the invoice is accepted.

2020-11-06T16:12:19

source

Source of inventory creation

SELL_TREEZ

sold_units

Units Sold

64

returned_units

Units Returned

0

returned_from_pos

Units Returned from POS

0

reserved_units

Units Reserved

0

productname

Raw Product Name

THC DESIGN | 24K | 3.5G FLOWER | 27.07% THC

productbrand

Raw Brand Name

THC DESIGN

product_id

Product ID

0a1f5bf4-fc23-4f8b-95fc-f2155c00b9ac

packed_and_ready_units

Units Packed And Ready

0

package_id

Package ID

f247d6b7-f466-45e5-bcb8-2c1ff8754938

original_start_date

Date and time that invoiceline was created in the Purchasing module in draft state

2020-10-16T14:05:29

location_type

Location Type

LOCATION

location_name

Location Name

FRONT OF HOUSE

location_id

Location ID

2f3df669-a935-11e9-a749-02ba70ae261c

last_user_id

Last User ID

4748ee91-7ca2-4ab0-b2ba-06bea3a4038c

last_reconciliation_id

Reconciliation ID

57ebbc86-fb8f-489a-854f-6cb1a3c92012

last_location_id

Location ID

2f3e1d27-a935-11e9-a749-02ba70ae261c

last_inventory_id

Inventory ID

281d27fd-0340-489a-9c1b-4fb00c485fff

last_action

Last Action

COMPLETE_SALE

is_sellable

Is Sellable? (TRUE = Yes, FALSE = No)

TRUE

invoice_line_id

Invoice Line ID

dde92789-042f-4980-8431-9d79428b50f6

invoice_id

Invoice ID

2c7fcad9-2c27-42d0-902b-fd0cb1be9912

inventory_type

Inventory Type

ALL

id

Inventory ID

0ba4101c-08a5-4c48-88c6-b745a6d9fd27

expiration_date

Inventory Expiration Date

YYYY-MM-DD

excise_tax_per_unit

Excise Tax per Unit

4.918195

distributor_id

Distributor ID

c7d8b4ec-abf2-4482-a74d-0472bfbd6b3a

destroyed_units

Units Destroyed

0

decision_pending_units

Units Pending Decision

0

cost_per_unit

Cost Per Unit

18.215538

converted_units

Units Converted

0

change_quantity

Quantity Change

1

batch_id

Batch ID

0PAYR-001

available_units

Current Available Units

0

adjusted_units

Units Adjusted

0

producttype

Product Type

FLOWER

state_tracking_id

State Tracking ID

1A40603000067F9000016320

last_retrieved_timestamp

the Date–Time we last retrieved data from SellTreez

2021-06-09T14:18:30


Did this page help you?