| part_id |
int(11)
|
|
|
|
| oa_no |
varchar(25)
|
latin1_swedish_ci
|
|
|
| proj_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| product_category |
varchar(200)
|
latin1_swedish_ci
|
|
|
| sa_name |
varchar(200)
|
latin1_swedish_ci
|
|
|
| assy_drg_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| sa_drg_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| sa_per_assy |
int(11)
|
|
|
|
| part_name |
varchar(200)
|
latin1_swedish_ci
|
|
|
| part_drg_no |
varchar(200)
|
latin1_swedish_ci
|
|
|
| batch_no |
int(11)
|
|
|
|
| parts_per_assy |
decimal(10,3)
|
|
|
|
| vendor_order_qty |
decimal(10,3)
|
|
|
|
| actual_qty |
decimal(10,3)
|
|
|
|
| reqd_total_qty |
decimal(10,3)
|
|
|
|
| mat_req_qty |
decimal(10,3)
|
|
|
|
| mat_recd_qty |
decimal(10,3)
|
|
|
|
| mat_issue_qty |
decimal(10,3)
|
|
|
|
| part_rcpt_qty |
decimal(10,3)
|
|
|
|
| accepted_qty |
decimal(10,3)
|
|
|
|
| rejected_qty |
decimal(10,3)
|
|
|
|
| rework_qty |
decimal(10,3)
|
|
|
|
| rework_issue_qty |
decimal(10,3)
|
|
|
|
| part_issue_qty |
decimal(10,3)
|
|
|
|
| trgt_date |
date
|
|
|
|
| class_of_parts |
varchar(50)
|
latin1_swedish_ci
|
|
|
| status |
decimal(10,2)
|
|
|
|
| os_planner |
varchar(50)
|
latin1_swedish_ci
|
|
|
| date_drg_issue |
date
|
|
|
|
| raw_mat_spec |
varchar(300)
|
utf8mb4_unicode_ci
|
|
|
| raw_mat_dimension |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| rev_del_dt |
date
|
|
|
|
| remarks |
varchar(500)
|
latin1_swedish_ci
|
|
|
| proj_remarks_by_date_time |
varchar(100)
|
latin1_swedish_ci
|
|
|
| bom_qty |
decimal(10,3)
|
|
|
|
| part_acpt_date |
date
|
|
|
|
| part_issue_assly_date |
date
|
|
|
|
| part_issue_assly_qty |
decimal(10,3)
|
|
|
|
| return_accept_qty |
decimal(10,3)
|
|
|
|
| no_of_stages |
int(11)
|
|
|
|
| status_flag |
varchar(5)
|
latin1_swedish_ci
|
|
|
| start_dt |
date
|
|
|
|
| end_dt |
date
|
|
|
|
| pending_assly_issue_qty |
decimal(10,3)
|
|
|
|
| bom_upload_date |
date
|
|
|
|
| design_eng |
varchar(50)
|
latin1_swedish_ci
|
|
|
| part_drg_remarks |
varchar(50)
|
latin1_swedish_ci
|
|
|
| part_drg_aprov_by |
varchar(50)
|
latin1_swedish_ci
|
|
|
| drg_release_dt |
date
|
|
|
|
| type |
varchar(50)
|
latin1_swedish_ci
|
|
|
| final_insp_dt |
date
|
|
|
|
| no_of_insp |
int(11)
|
|
|
|
| mr_na |
int(11)
|
|
|
|
| part_drg_release_by |
varchar(255)
|
latin1_swedish_ci
|
|
|
| hsn_code |
int(11)
|
|
|
|
| sac_code |
int(11)
|
|
|
|
| revision |
int(11)
|
|
|
|
| uom |
varchar(10)
|
latin1_swedish_ci
|
|
|
| model |
varchar(30)
|
latin1_swedish_ci
|
|
|
| make |
varchar(30)
|
latin1_swedish_ci
|
|
|
| website |
varchar(500)
|
latin1_swedish_ci
|
|
|
| alternate_allow |
varchar(3)
|
latin1_swedish_ci
|
|
|
| week_lead_time |
varchar(10)
|
latin1_swedish_ci
|
|
|
| part_drg_file |
varchar(200)
|
latin1_swedish_ci
|
|
|
| part_drg_file_flag |
int(11)
|
|
|
|
| sa_drg_file |
varchar(200)
|
latin1_swedish_ci
|
|
|
| sa_drg_file_flag |
int(11)
|
|
|
|
| qc_require |
int(11)
|
|
|
|
| inventory_id |
int(11)
|
|
|
|
| drawing_updated_by |
varchar(100)
|
latin1_swedish_ci
|
|
|
| drawing_updated_date |
date
|
|
|
|
| drg_update_status |
varchar(50)
|
latin1_swedish_ci
|
|
|
