| id |
int(11)
|
|
|
|
| item_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| item_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| item_part_no |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| item_material |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| item_drawing |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| heat_spec |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| surface |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| net_weight |
decimal(12,4)
|
|
|
|
| item_spec |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| item_model |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| item_brand |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| class_id |
int(11)
|
|
|
|
| class_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| item_type |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| unit |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| unit_purchase |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| unit_sales |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| conversion_rate |
decimal(10,4)
|
|
|
|
| cost_price |
decimal(12,2)
|
|
|
|
| sales_price |
decimal(12,2)
|
|
|
|
| last_purchase_price |
decimal(12,2)
|
|
|
|
| current_stock |
decimal(12,2)
|
|
|
|
| min_stock |
decimal(12,2)
|
|
|
|
| max_stock |
decimal(12,2)
|
|
|
|
| safe_stock |
decimal(12,2)
|
|
|
|
| warehouse_location |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| shelf_no |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| main_vendor_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| main_vendor_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| quality_level |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| quality_status |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| item_sta |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| is_active |
tinyint(4)
|
|
|
|
| has_bom |
tinyint(4)
|
|
|
|
| parent_item_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| parent_item_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| bom_level |
int(11)
|
|
|
|
| item_desc |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| remark |
text
|
utf8mb4_unicode_ci
|
|
|
| item_image |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| create_date |
datetime
|
|
|
|
| create_by |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| last_modify_date |
datetime
|
|
|
|
| last_modify_by |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| ext_field1 |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| ext_field2 |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| ext_field3 |
text
|
utf8mb4_unicode_ci
|
|
|
