| vendor_po_detl_id |
int(11)
|
|
|
|
| wo_no |
varchar(25)
|
latin1_swedish_ci
|
|
|
| part_id |
int(11)
|
|
|
|
| unit_price |
decimal(15,2)
|
|
|
|
| unit_of_measure |
varchar(8)
|
latin1_swedish_ci
|
|
|
| discount_prcnt |
decimal(10,2)
|
|
|
|
| total_single_part |
decimal(15,2)
|
|
|
|
| unit_cost_per_part_wdisc |
decimal(10,3)
|
|
|
|
| tax_unit_insurence_price |
decimal(10,3)
|
|
|
|
| tax_unit_transport_price |
decimal(10,3)
|
|
|
|
| tax_unit_packing_price |
decimal(10,3)
|
|
|
|
| unit_insurence_price |
decimal(10,3)
|
|
|
|
| unit_transport_price |
decimal(10,3)
|
|
|
|
| unit_packing_price |
decimal(10,3)
|
|
|
|
| unit_tax_price |
decimal(10,3)
|
|
|
|
| unit_total_price_before_gst |
decimal(10,3)
|
|
|
|
| unit_cost_per_part_adisc_wtax |
decimal(10,3)
|
|
|
|
| hsn_code |
varchar(12)
|
latin1_swedish_ci
|
|
|
| sac_code |
varchar(15)
|
latin1_swedish_ci
|
|
|
| mpn |
varchar(12)
|
latin1_swedish_ci
|
|
|
| vendor |
varchar(255)
|
latin1_swedish_ci
|
|
|
| vendor_id |
varchar(10)
|
latin1_swedish_ci
|
|
|
| vendor_address |
varchar(500)
|
latin1_swedish_ci
|
|
|
| vendor_gst |
varchar(15)
|
latin1_swedish_ci
|
|
|
| vendor_order_qty |
decimal(10,3)
|
|
|
|
| mat_issue_qty |
decimal(10,3)
|
|
|
|
| part_rcpt_qty |
decimal(10,3)
|
|
|
|
| accepted_qty |
decimal(10,3)
|
|
|
|
| rejected_qty |
decimal(10,3)
|
|
|
|
| rework_qty |
decimal(10,3)
|
|
|
|
| rework_issue_qty |
decimal(10,3)
|
|
|
|
| part_issue_qty |
decimal(10,3)
|
|
|
|
| insp_rep_no |
varchar(150)
|
latin1_swedish_ci
|
|
|
| vendor_po_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| vendor_po_dt |
date
|
|
|
|
| quotation_ref |
varchar(20)
|
latin1_swedish_ci
|
|
|
| quotation_date |
date
|
|
|
|
| vendor_trgt_date |
date
|
|
|
|
| os_planner |
varchar(50)
|
latin1_swedish_ci
|
|
|
| stg_no |
int(11)
|
|
|
|
| no_of_days |
date
|
|
|
|
| po_amendment_no |
varchar(2)
|
latin1_swedish_ci
|
|
|
| po_amendment_date |
timestamp
|
|
|
|
| po_amended_by |
varchar(100)
|
latin1_swedish_ci
|
|
|
| po_validate |
varchar(1)
|
latin1_swedish_ci
|
|
|
| po_validated_by |
varchar(50)
|
latin1_swedish_ci
|
|
|
| po_validated_date |
date
|
|
|
|
| po_prepared_date |
date
|
|
|
|
| po_validated_role |
varchar(20)
|
latin1_swedish_ci
|
|
|
| vendor_part_status |
varchar(15)
|
latin1_swedish_ci
|
|
|
| raw_mat_spec |
varchar(300)
|
utf8mb4_unicode_ci
|
|
|
| raw_mat_dimension |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| model |
varchar(30)
|
latin1_swedish_ci
|
|
|
| make |
varchar(30)
|
latin1_swedish_ci
|
|
|
| part_alternate_name |
varchar(196)
|
latin1_swedish_ci
|
|
|
| part_note |
varchar(500)
|
latin1_swedish_ci
|
|
|
| part_removed_by |
varchar(100)
|
latin1_swedish_ci
|
|
|
| part_removed_dt |
date
|
|
|
|
| reqd_total_qty |
int(11)
|
|
|
|
