Table containing detailed information for each of the products in the inventory
Data model
Fields
| Field |
Type |
Description |
| mea_id* |
INT |
Product measurement identifier. |
| prod_active* |
BIT |
Marking to know if this product is in an active or inactive state |
| prod_cost* |
DECIMAL |
Product Purchase Cost/Price |
| prod_description |
NVARCHAR (600) |
Product Description |
| prod_id* |
INT |
Unique identifier of the table |
| prod_min_amount* |
INT |
Minimum quantity of the product in inventory. It serves to notify when it is being carried at a minimum quantity in inventory. |
| prod_name* |
NVARCHAR (600) |
Product Name |
| prod_quantity* |
INT |
Quantity of product recorded in inventory |
| prod_sku |
NVARCHAR (256) |
Reference number/code or simply reference, also referred to as item code so that it can be identified in the physical inventory |
| prod_type* |
INT |
Marking to identify whether the product is of type quantity = 0 or single type = 1 |
| tent_id* |
INT |
Identifier of the corresponding Tenant |
Primary Key
| PK_AFLS_INVENTORY_PRODUCTS |
| prod_id |
References
