| row_id |
int(11)
|
|
|
|
| wo_no |
varchar(30)
|
latin1_swedish_ci
|
|
|
| sa_name |
varchar(100)
|
latin1_swedish_ci
|
|
|
| part_name |
varchar(200)
|
latin1_swedish_ci
|
|
|
| part_id |
int(11)
|
|
|
|
| stage_no |
int(11)
|
|
|
|
| stage_weightage |
decimal(10,2)
|
|
|
|
| part_approve |
decimal(10,3)
|
|
|
|
| mat_req |
decimal(10,3)
|
|
|
|
| mat_recpt |
decimal(10,3)
|
|
|
|
| vendor_po |
decimal(10,3)
|
|
|
|
| mat_issue |
decimal(10,3)
|
|
|
|
| mfg |
decimal(10,3)
|
|
|
|
| part_recpt |
decimal(10,3)
|
|
|
|
| part_issue |
decimal(10,3)
|
|
|
|
| reject |
decimal(10,3)
|
|
|
|
| rework |
decimal(10,3)
|
|
|
|
| accept |
decimal(10,3)
|
|
|
|
| assembly |
decimal(10,3)
|
|
|
|
| raw_mat_na |
int(11)
|
|
|
|
| mr_na |
int(11)
|
|
|
|
| multi_stage |
int(11)
|
|
|
|
| total_qty |
decimal(10,3)
|
|
|
|
| status |
decimal(10,2)
|
|
|
|
