| vendor_detail_id |
int(11)
|
|
|
|
| vendor_id |
varchar(4)
|
latin1_swedish_ci
|
|
|
| org_id |
int(11)
|
|
|
|
| name |
varchar(255)
|
latin1_swedish_ci
|
|
|
| address |
varchar(255)
|
latin1_swedish_ci
|
|
|
| country |
varchar(100)
|
latin1_swedish_ci
|
|
|
| country_code |
varchar(10)
|
latin1_swedish_ci
|
|
|
| phone_no |
varchar(30)
|
latin1_swedish_ci
|
|
|
| mobile_no |
varchar(25)
|
latin1_swedish_ci
|
|
|
| email |
varchar(200)
|
latin1_swedish_ci
|
|
|
| website |
varchar(30)
|
latin1_swedish_ci
|
|
|
| products |
varchar(300)
|
latin1_swedish_ci
|
|
|
| services |
varchar(400)
|
latin1_swedish_ci
|
|
|
| contact_person |
varchar(30)
|
latin1_swedish_ci
|
|
|
| iso_9001_certified |
varchar(5)
|
latin1_swedish_ci
|
|
|
| vat_reg_no |
varchar(30)
|
latin1_swedish_ci
|
|
|
| service_tax |
varchar(30)
|
latin1_swedish_ci
|
|
|
| pan_no |
varchar(30)
|
latin1_swedish_ci
|
|
|
| tan_no |
varchar(30)
|
latin1_swedish_ci
|
|
|
| exercise_reg_no |
varchar(30)
|
latin1_swedish_ci
|
|
|
| job_approved_type |
varchar(200)
|
latin1_swedish_ci
|
|
|
| vendor_reg_no |
varchar(30)
|
latin1_swedish_ci
|
|
|
| os_planner |
varchar(200)
|
latin1_swedish_ci
|
|
|
| gst_no |
varchar(30)
|
latin1_swedish_ci
|
|
|
| vendor_active_status |
varchar(2)
|
latin1_swedish_ci
|
|
|
| comp_reg_type |
varchar(200)
|
latin1_swedish_ci
|
|
|
| gst_reg_type |
varchar(10)
|
latin1_swedish_ci
|
|
|
