| id |
int(11)
|
|
|
|
| part_id |
int(11)
|
|
|
|
| raw_mat_spec |
varchar(300)
|
latin1_swedish_ci
|
|
|
| mat_req_qty |
decimal(10,3)
|
|
|
|
| mat_recd_qty |
decimal(10,3)
|
|
|
|
| raw_mat_dimension |
varchar(500)
|
latin1_swedish_ci
|
|
|
| mat_pr_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| mat_pr_dt |
date
|
|
|
|
| request_status |
varchar(20)
|
latin1_swedish_ci
|
|
|
| mat_rcpt_trgt_dt |
date
|
|
|
|
| os_planner |
varchar(50)
|
latin1_swedish_ci
|
|
|
| emp_id |
int(11)
|
|
|
|
| ir_validate |
varchar(1)
|
latin1_swedish_ci
|
|
|
| remarks |
varchar(300)
|
latin1_swedish_ci
|
|
|
| ir_validated_by |
varchar(50)
|
latin1_swedish_ci
|
|
|
| ir_validation_date |
date
|
|
|
|
| remarks_g |
varchar(500)
|
latin1_swedish_ci
|
|
|
| store_keeper |
varchar(100)
|
latin1_swedish_ci
|
|
|
| stock_update_date |
date
|
|
|
|
| received_by |
varchar(100)
|
latin1_swedish_ci
|
|
|
| approved_by |
varchar(100)
|
latin1_swedish_ci
|
|
|
