| part_id |
int(11)
|
|
|
|
| oa_no |
varchar(25)
|
utf8mb4_general_ci
|
|
|
| proj_no |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| sa_name |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| assy_drg_no |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| sa_drg_no |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| sa_per_assy |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| part_name |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| part_drg_no |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| status |
decimal(10,2)
|
|
|
|
| start_dt |
date
|
|
|
|
| date_drg_issue |
date
|
|
|
|
| trgt_date |
date
|
|
|
|
| parts_per_assy |
decimal(10,3)
|
|
|
|
| reqd_total_qty |
decimal(10,3)
|
|
|
|
| class_of_parts |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| os_planner |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| no_of_stages |
int(11)
|
|
|
|
| mat_pr_no |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| mat_pr_dt |
date
|
|
|
|
| mat_req_qty |
decimal(32,3)
|
|
|
|
| mat_recd_qty |
decimal(32,3)
|
|
|
|
| mat_recvd_date |
date
|
|
|
|
| raw_mat_spec |
varchar(300)
|
utf8mb4_general_ci
|
|
|
| raw_mat_dimension |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| remarks |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| vendor |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| vendor_po_no |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| vendor_po_dt |
date
|
|
|
|
| vendor_order_qty |
decimal(10,3)
|
|
|
|
| vendor_trgt_date |
date
|
|
|
|
| no_of_days |
date
|
|
|
|
| stg_no |
int(11)
|
|
|
|
| insp_rep_no |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| mat_issue_qty |
decimal(32,3)
|
|
|
|
| mat_issue_dt |
date
|
|
|
|
| dc_no |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| part_rcpt_qty |
decimal(32,3)
|
|
|
|
| part_rcpt_dt |
date
|
|
|
|
| insp_qty_acpt |
decimal(32,3)
|
|
|
|
| insp_qty_rework |
decimal(32,3)
|
|
|
|
| insp_qty_rej |
decimal(32,3)
|
|
|
|
| insp_date |
date
|
|
|
|
| assmbly_issue_qty |
decimal(32,3)
|
|
|
|
| disp_issue_date |
date
|
|
|
|
| design_eng |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| part_drg_aprov_by |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| end_dt |
date
|
|
|
|
| bom_upload_date |
date
|
|
|
|
| ir_validate |
varchar(1)
|
utf8mb4_general_ci
|
|
|
| po_validate |
varchar(1)
|
utf8mb4_general_ci
|
|
|
