| vendor_po_id |
int(11)
|
|
|
|
| wo_no |
varchar(200)
|
latin1_swedish_ci
|
|
|
| mrn_no |
varchar(100)
|
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
|
|
|
| ship_to |
text
|
latin1_swedish_ci
|
|
|
| vendor_po_no |
varchar(50)
|
latin1_swedish_ci
|
|
|
| type |
varchar(10)
|
latin1_swedish_ci
|
|
|
| vendor_po_dt |
date
|
|
|
|
| validated_date |
date
|
|
|
|
| gst_type |
varchar(4)
|
latin1_swedish_ci
|
|
|
| gst_tax_prcnt |
int(11)
|
|
|
|
| gst_total |
decimal(10,2)
|
|
|
|
| with_without_raw |
varchar(200)
|
latin1_swedish_ci
|
|
|
| verified_date |
date
|
|
|
|
| terms_n_conditions |
varchar(800)
|
latin1_swedish_ci
|
|
|
| sub_total |
decimal(15,2)
|
|
|
|
| discount_amount |
decimal(10,2)
|
|
|
|
| subtotal_adisc |
decimal(10,3)
|
|
|
|
| sub_total_amount |
decimal(10,2)
|
|
|
|
| total_cost |
decimal(15,2)
|
|
|
|
| total_words |
varchar(500)
|
latin1_swedish_ci
|
|
|
| currency |
varchar(100)
|
utf8_general_ci
|
|
|
| rupees_per_doller |
int(11)
|
|
|
|
| currency_amount |
int(100)
|
|
|
|
| pf_prcnt |
decimal(10,2)
|
|
|
|
| freight |
decimal(10,0)
|
|
|
|
| insurance |
varchar(120)
|
latin1_swedish_ci
|
|
|
| dispatch |
varchar(120)
|
latin1_swedish_ci
|
|
|
| payment |
varchar(120)
|
latin1_swedish_ci
|
|
|
| incoterms |
varchar(100)
|
latin1_swedish_ci
|
|
|
| delivery |
varchar(250)
|
latin1_swedish_ci
|
|
|
| documents |
varchar(120)
|
latin1_swedish_ci
|
|
|
| prepared_by |
varchar(120)
|
latin1_swedish_ci
|
|
|
| verified_by |
varchar(120)
|
latin1_swedish_ci
|
|
|
| issued_date |
date
|
|
|
|
| poRemarks |
varchar(10000)
|
latin1_swedish_ci
|
|
|
| pack_instructions |
varchar(500)
|
latin1_swedish_ci
|
|
|
| po_validate_status |
varchar(10)
|
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(30)
|
latin1_swedish_ci
|
|
|
| po_amendment_req_reason |
varchar(500)
|
latin1_swedish_ci
|
|
|
| po_amendment_req_by |
varchar(60)
|
latin1_swedish_ci
|
|
|
| po_amendment_req_date |
date
|
|
|
|
| po_amendment_req_status |
varchar(40)
|
latin1_swedish_ci
|
|
|
| po_amendment_req_approve_by |
varchar(60)
|
latin1_swedish_ci
|
|
|
| po_amendment_req_approve_date |
date
|
|
|
|
| po_amendment_no |
varchar(2)
|
latin1_swedish_ci
|
|
|
| po_amendment_date |
date
|
|
|
|
| po_amended_by |
varchar(100)
|
latin1_swedish_ci
|
|
|
| quotation_ref |
varchar(100)
|
latin1_swedish_ci
|
|
|
| quotation_date |
date
|
|
|
|
| cancelled |
enum('Y', 'N')
|
latin1_swedish_ci
|
|
|
| po_cancel_reason |
varchar(500)
|
latin1_swedish_ci
|
|
|
| po_cancel_req_by |
varchar(60)
|
latin1_swedish_ci
|
|
|
| po_cancel_req_date |
date
|
|
|
|
| po_cancel_req_status |
varchar(40)
|
latin1_swedish_ci
|
|
|
| po_cancelled_by |
varchar(60)
|
latin1_swedish_ci
|
|
|
| po_cancelled_date |
date
|
|
|
|
| transportation_charge |
decimal(10,2)
|
|
|
|
| internal_comment |
varchar(500)
|
latin1_swedish_ci
|
|
|
| request_cancel_by |
varchar(200)
|
latin1_swedish_ci
|
|
|
| request_cancel_date |
date
|
|
|
|
| cancel_request_status |
varchar(100)
|
latin1_swedish_ci
|
|
|
| amend_request_cancel_by |
varchar(200)
|
latin1_swedish_ci
|
|
|
| amend_request_cancel_date |
date
|
|
|
|
| amend_request_status |
varchar(100)
|
latin1_swedish_ci
|
|
|
| transport_wotax |
decimal(10,3)
|
|
|
|
| insurance_wotax |
decimal(10,3)
|
|
|
|
| packing_wotax |
decimal(10,3)
|
|
|
|
| total_parts_count |
int(11)
|
|
|
|
| total_qty_count |
decimal(10,3)
|
|
|
|
| total_accepted_qty |
decimal(10,3)
|
|
|
|
| total_received_qty |
decimal(10,3)
|
|
|
|
| total_reject_qty |
decimal(10,3)
|
|
|
|
| total_rework_qty |
decimal(10,3)
|
|
|
|
| total_rwk_recv_qty |
decimal(10,3)
|
|
|
|
| total_rework_issue_qty |
decimal(10,3)
|
|
|
|
| total_issued_qty |
decimal(10,3)
|
|
|
|
