| id |
int(11)
|
|
|
|
| part_id |
int(11)
|
|
|
|
| os_planner |
varchar(255)
|
latin1_swedish_ci
|
|
|
| trgt_date |
date
|
|
|
|
| vendor |
varchar(500)
|
latin1_swedish_ci
|
|
|
| vendor_po_no |
varchar(255)
|
latin1_swedish_ci
|
|
|
| grn_no |
varchar(30)
|
latin1_swedish_ci
|
|
|
| dc_no |
varchar(255)
|
latin1_swedish_ci
|
|
|
| dc_type |
varchar(50)
|
latin1_swedish_ci
|
|
|
| no_of_stages |
int(11)
|
|
|
|
| stg_no |
int(11)
|
|
|
|
| reqd_total_qty |
decimal(10,3)
|
|
|
|
| vendor_order_qty |
decimal(10,3)
|
|
|
|
| part_rcpt_qty |
decimal(10,3)
|
|
|
|
| part_issue_qty |
decimal(10,3)
|
|
|
|
| part_issue_date |
date
|
|
|
|
| part_issue_by |
varchar(100)
|
latin1_swedish_ci
|
|
|
| vehicle_no |
varchar(200)
|
latin1_swedish_ci
|
|
|
| mode_of_dispatch |
varchar(200)
|
latin1_swedish_ci
|
|
|
| approximate_value |
varchar(100)
|
latin1_swedish_ci
|
|
|
| e_sugam_no |
varchar(100)
|
latin1_swedish_ci
|
|
|
| e_way_bill_no |
varchar(100)
|
latin1_swedish_ci
|
|
|
| notes |
varchar(500)
|
latin1_swedish_ci
|
|
|
| insp_rep_no |
varchar(200)
|
latin1_swedish_ci
|
|
|
| dc_value_with_out_tax |
decimal(10,3)
|
|
|
|
| dc_value_with_tax |
decimal(10,3)
|
|
|
|
