Product With Actual Stock¶
Table name (referenced in Insights SQL queries): marts_mdc__product_with_actual_stock
The marts_mdc__product_with_actual_stock view shows products with actual inventory
Columns¶
| Column | Type | Description |
|---|---|---|
product_id |
number |
Unique identifier of the product |
account_id |
number |
Identifier for the account associated with this product |
product_sku |
varchar |
SKU for the product |
product_name |
varchar |
Name of the product |
product_description |
varchar |
Product description |
location_count |
number |
Count of locations where this product is |
actual_stock_quantity |
number |
Actual stock quantity of the product |
last_shipped_date |
timestamp_ntz |
Last date when this product was shipped |
shipped_days_ago |
number |
How many days ago it was shipped last time |