| proj_detl_id |
int(11)
|
|
|
|
| oa_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| proj_no |
varchar(50)
|
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_drg_revision |
int(11)
|
|
|
|
| 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)
|
|
|
|
| reqd_total_qty |
decimal(10,3)
|
|
|
|
| bom_qty |
decimal(10,3)
|
|
|
|
| stages |
int(11)
|
|
|
|
| trgt_date |
date
|
|
|
|
| class_of_parts |
varchar(50)
|
latin1_swedish_ci
|
|
|
| raw_mat_spec |
varchar(300)
|
latin1_swedish_ci
|
|
|
| raw_mat_dimension |
varchar(500)
|
latin1_swedish_ci
|
|
|
| bom_upload_date |
date
|
|
|
|
| design_eng |
varchar(255)
|
latin1_swedish_ci
|
|
|
| part_drg_remarks |
varchar(255)
|
latin1_swedish_ci
|
|
|
| part_drg_release_by |
varchar(255)
|
latin1_swedish_ci
|
|
|
| drg_release_dt |
date
|
|
|
|
| type |
varchar(12)
|
latin1_swedish_ci
|
|
|
| revision |
int(11)
|
|
|
|
| revision_date |
date
|
|
|
|
| make |
varchar(30)
|
latin1_swedish_ci
|
|
|
| model |
varchar(30)
|
latin1_swedish_ci
|
|
|
| uom |
varchar(10)
|
latin1_swedish_ci
|
|
|
| website |
varchar(500)
|
latin1_swedish_ci
|
|
|
| hsn_code |
int(11)
|
|
|
|
| sac_code |
int(11)
|
|
|
|
| alternate_allow |
varchar(3)
|
latin1_swedish_ci
|
|
|
| week_lead_time |
varchar(10)
|
latin1_swedish_ci
|
|
|
| last_modified_date |
timestamp
|
|
|
|
| last_modified_by |
varchar(60)
|
latin1_swedish_ci
|
|
|
| part_drg_file |
varchar(200)
|
latin1_swedish_ci
|
|
|
| part_drg_file_flag |
int(11)
|
|
|
|
| sa_drg_file |
varchar(196)
|
latin1_swedish_ci
|
|
|
| sa_drg_file_flag |
int(11)
|
|
|
|
| remarks |
varchar(500)
|
latin1_swedish_ci
|
|
|
| status_flag |
varchar(10)
|
latin1_swedish_ci
|
|
|
