| id |
int(11)
|
|
|
|
| material |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| uom |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| description |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| buyer |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| vendor_code |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| vendor_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| group2 |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| category |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| avg_cost |
decimal(14,4)
|
|
|
|
| msp |
decimal(14,4)
|
|
|
|
| msp_gp |
decimal(10,6)
|
|
|
|
| pos |
decimal(14,4)
|
|
|
|
| pos_gp |
decimal(10,6)
|
|
|
|
| stock_qty |
decimal(14,3)
|
|
|
|
| stock_value |
decimal(16,2)
|
|
|
|
| avg_sale_qty_day |
decimal(10,3)
|
|
|
|
| max_qty |
decimal(14,3)
|
|
|
|
| last_grn_date |
date
|
|
|
|
| last_intercompany_date |
date
|
|
|
|
| aging_0_30 |
decimal(14,2)
|
|
|
|
| aging_30_60 |
decimal(14,2)
|
|
|
|
| aging_60_90 |
decimal(14,2)
|
|
|
|
| aging_90_plus |
decimal(14,2)
|
|
|
|
| movement_status |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| is_oos |
tinyint(1)
|
|
|
|
| inventory_bin |
decimal(14,3)
|
|
|
|
| damage_bin |
decimal(14,3)
|
|
|
|
