| id |
int(11)
|
|
|
|
| item_id |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| item_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| unit |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| department |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| category |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| sub_category |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| brand |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| buyer |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| supplier_id |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| supplier_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| last_grn_date |
date
|
|
|
|
| last_intercompany_date |
date
|
|
|
|
| avg_cost |
decimal(14,4)
|
|
|
|
| selling_price |
decimal(14,4)
|
|
|
|
| loc_retail_plastic |
decimal(14,3)
|
|
|
|
| loc_showroom |
decimal(14,3)
|
|
|
|
| loc_wholesale_plastic |
decimal(14,3)
|
|
|
|
| loc_warehouse_1 |
decimal(14,3)
|
|
|
|
| loc_warehouse_2 |
decimal(14,3)
|
|
|
|
| loc_warehouse_3 |
decimal(14,3)
|
|
|
|
| loc_central_warehouse |
decimal(14,3)
|
|
|
|
| loc_shaharzad_warehouse |
decimal(14,3)
|
|
|
|
| loc_global_star |
decimal(14,3)
|
|
|
|
| loc_meena_port |
decimal(14,3)
|
|
|
|
| loc_delivery_warehouse_bounty |
decimal(14,3)
|
|
|
|
| loc_tr_in_progress |
decimal(14,3)
|
|
|
|
| stock_qty |
decimal(14,3)
|
|
|
|
| stock_value |
decimal(16,2)
|
|
|
|
| dmg_loc_s_plastic |
decimal(14,3)
|
|
|
|
| dmg_loc_shop |
decimal(14,3)
|
|
|
|
| dmg_loc_w1 |
decimal(14,3)
|
|
|
|
| dmg_loc_w2 |
decimal(14,3)
|
|
|
|
| dmg_loc_w3 |
decimal(14,3)
|
|
|
|
| dmg_loc_w4 |
decimal(14,3)
|
|
|
|
| dmg_stock_qty |
decimal(14,3)
|
|
|
|
| avg_sale_day |
decimal(10,3)
|
|
|
|
| opening_qty_3m |
decimal(14,3)
|
|
|
|
| three_month_sales |
decimal(14,3)
|
|
|
|
| intercompany_issue_3m |
decimal(14,3)
|
|
|
|
| adj_prctn_phycnt_3m |
decimal(14,3)
|
|
|
|
| purchase_3m |
decimal(14,3)
|
|
|
|
| opening_qty_2m |
decimal(14,3)
|
|
|
|
| two_month_sales |
decimal(14,3)
|
|
|
|
| intercompany_issue_2m |
decimal(14,3)
|
|
|
|
| adj_prctn_phycnt_2m |
decimal(14,3)
|
|
|
|
| purchase_2m |
decimal(14,3)
|
|
|
|
| lead_time |
int(11)
|
|
|
|
| lead_time_avg |
decimal(14,3)
|
|
|
|
| balance_stock |
decimal(14,3)
|
|
|
|
| excess_short_qty |
decimal(14,3)
|
|
|
|
| excess_short_value |
decimal(16,2)
|
|
|
|
| slow_qty_3m |
decimal(14,3)
|
|
|
|
| slow_val_3m |
decimal(24,2)
|
|
|
|
| slow_qty_2m |
decimal(14,3)
|
|
|
|
| slow_val_2m |
decimal(24,2)
|
|
|
|
