| inspection_id |
int(11)
|
|
|
|
| part_id |
int(11)
|
|
|
|
| vendor |
varchar(200)
|
latin1_swedish_ci
|
|
|
| vendor_po_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| insp_rep_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| grn_no |
varchar(30)
|
latin1_swedish_ci
|
|
|
| no_of_stg |
int(11)
|
|
|
|
| stg_no |
int(11)
|
|
|
|
| reqd_total_qty |
decimal(10,3)
|
|
|
|
| vendor_order_qty |
decimal(10,3)
|
|
|
|
| part_qty_recvd |
decimal(10,3)
|
|
|
|
| insp_qty_acpt |
decimal(10,3)
|
|
|
|
| insp_qty_rej |
decimal(10,3)
|
|
|
|
| insp_qty_rework |
decimal(10,3)
|
|
|
|
| rework_issue_qty |
decimal(10,3)
|
|
|
|
| remarks |
varchar(50)
|
latin1_swedish_ci
|
|
|
| insp_acpt_name |
varchar(50)
|
latin1_swedish_ci
|
|
|
| insp_person |
varchar(50)
|
latin1_swedish_ci
|
|
|
| insp_date |
date
|
|
|
|
| acpt_date |
date
|
|
|
|
| no_of_insp |
char(50)
|
latin1_swedish_ci
|
|
|
| flg_short_close |
char(50)
|
latin1_swedish_ci
|
|
|
| ir_validate |
varchar(1)
|
latin1_swedish_ci
|
|
|
| accept_with_out_tax |
decimal(10,3)
|
|
|
|
| accept_with_tax |
decimal(10,3)
|
|
|
|
| storage_location |
varchar(100)
|
latin1_swedish_ci
|
|
|
