| id |
int(11)
|
|
|
|
| division |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| material |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| description |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| uom |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| brand |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| category |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| sub_category |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| vendor_code |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| vendor_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| last_grn_date |
date
|
|
|
|
| avg_cost |
decimal(14,4)
|
|
|
|
| stock_qty |
decimal(14,3)
|
|
|
|
| stock_value |
decimal(16,2)
|
|
|
|
| damage_qty |
decimal(14,3)
|
|
|
|
| customer_sales_qty |
decimal(14,3)
|
|
|
|
| inter_company_sales_qty |
decimal(14,3)
|
|
|
|
| route_sales_qty |
decimal(14,3)
|
|
|
|
| three_month_sale_qty |
decimal(14,3)
|
|
|
|
| avg_sale_qty_day |
decimal(10,3)
|
|
|
|
| opening_stock |
decimal(14,3)
|
|
|
|
| in_qty |
decimal(14,3)
|
|
|
|
| out_qty |
decimal(14,3)
|
|
|
|
| closing_qty |
decimal(14,3)
|
|
|
|
| lead_days |
int(11)
|
|
|
|
| stock_required_quarter |
decimal(14,3)
|
|
|
|
| excess_short_qty |
decimal(14,3)
|
|
|
|
| excess_short_value |
decimal(16,2)
|
|
|
|
| aging_0_30_val |
decimal(16,2)
|
|
|
|
| aging_30_60_val |
decimal(16,2)
|
|
|
|
| aging_60_90_val |
decimal(16,2)
|
|
|
|
| aging_above_90_val |
decimal(16,2)
|
|
|
|
| is_zero_sale |
int(1)
|
|
|
|
| recent_30 |
int(1)
|
|
|
|
| recent_90 |
int(1)
|
|
|
|
| is_oos |
int(1)
|
|
|
|
| is_excess |
int(1)
|
|
|
|
| is_shortage |
int(1)
|
|
|
|
| movement_status |
varchar(7)
|
utf8mb4_general_ci
|
|
|
| overstock_qty |
decimal(14,3)
|
|
|
|
| overstock_value |
decimal(16,2)
|
|
|
|
| shortage_qty |
decimal(14,3)
|
|
|
|
| shortage_value |
decimal(16,2)
|
|
|
|
| damage_value |
decimal(24,2)
|
|
|
|
