| part_recpt_id |
int(11)
|
|
|
|
| part_id |
int(11)
|
|
|
|
| os_planner |
varchar(50)
|
latin1_swedish_ci
|
|
|
| trgt_dt |
date
|
|
|
|
| vendor |
varchar(500)
|
latin1_swedish_ci
|
|
|
| vendor_po_no |
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_rcpt_dt |
date
|
|
|
|
| grn_no |
varchar(30)
|
latin1_swedish_ci
|
|
|
| grn_dt |
date
|
|
|
|
| grn_created_by |
varchar(100)
|
latin1_swedish_ci
|
|
|
| grn_status |
varchar(10)
|
latin1_swedish_ci
|
|
|
| grn_type |
varchar(11)
|
latin1_swedish_ci
|
|
|
| rework_rcpt_qty |
decimal(10,3)
|
|
|
|
| inward_invoice_no |
varchar(30)
|
latin1_swedish_ci
|
|
|
| inward_invoice_dt |
date
|
|
|
|
| inward_dc_no |
varchar(30)
|
latin1_swedish_ci
|
|
|
| inward_dc_dt |
date
|
|
|
|
| grn_closed_by |
varchar(100)
|
latin1_swedish_ci
|
|
|
| grn_notes |
varchar(500)
|
latin1_swedish_ci
|
|
|
| e_way_bill_no |
varchar(100)
|
latin1_swedish_ci
|
|
|
| part_rcpt_updated_by |
varchar(100)
|
latin1_swedish_ci
|
|
|
| part_rcpt_updated_dt |
date
|
|
|
|
| grn_value_adisc_before_gst |
decimal(10,3)
|
|
|
|
| grn_value_adisc_with_gst |
decimal(10,3)
|
|
|
|
| grn_cancel_reason |
varchar(500)
|
latin1_swedish_ci
|
|
|
| grn_cancel_req_by |
varchar(100)
|
latin1_swedish_ci
|
|
|
| grn_cancel_req_date |
date
|
|
|
|
| grn_cancel_req_status |
varchar(100)
|
latin1_swedish_ci
|
|
|
| grn_cancelled_by |
varchar(100)
|
latin1_swedish_ci
|
|
|
| grn_cancelled_date |
date
|
|
|
|
| request_cancel_by |
varchar(100)
|
latin1_swedish_ci
|
|
|
| request_cancel_date |
date
|
|
|
|
| cancel_request_status |
varchar(100)
|
latin1_swedish_ci
|
|
|
