| org_id |
int(11)
|
|
|
|
| org_full_name |
varchar(60)
|
utf8_general_ci
|
|
|
| org_short_name |
varchar(20)
|
utf8_general_ci
|
|
|
| org_address_line_1 |
varchar(150)
|
utf8_general_ci
|
|
|
| org_address_line_2 |
varchar(150)
|
utf8_general_ci
|
|
|
| org_division_unit |
varchar(150)
|
utf8_general_ci
|
|
|
| org_ph_no_1 |
varchar(15)
|
utf8_general_ci
|
|
|
| org_ph_no_2 |
varchar(15)
|
utf8_general_ci
|
|
|
| org_email |
varchar(60)
|
utf8_general_ci
|
|
|
| org_website |
varchar(60)
|
utf8_general_ci
|
|
|
| org_logo_path |
varchar(300)
|
utf8_general_ci
|
|
|
| org_certification_logo_path |
varchar(150)
|
utf8_general_ci
|
|
|
| org_iso_certified_title |
varchar(100)
|
utf8_general_ci
|
|
|
| org_gstin_no |
varchar(15)
|
utf8_general_ci
|
|
|
| org_pan_no |
varchar(12)
|
utf8_general_ci
|
|
|
| org_excise_no |
varchar(15)
|
utf8_general_ci
|
|
|
| org_services |
varchar(150)
|
utf8_general_ci
|
|
|
| org_products |
longtext
|
utf8_general_ci
|
|
|
| org_misc_details |
longtext
|
utf8_general_ci
|
|
|
| org_currency_full |
varchar(20)
|
utf8_general_ci
|
|
|
| org_currency_symbol |
varchar(10)
|
utf8_general_ci
|
|
|
| org_currecny_short |
varchar(4)
|
utf8_general_ci
|
|
|
| org_date_format |
varchar(15)
|
utf8_general_ci
|
|
|
| org_estd_date |
date
|
|
|
|
| org_active_status |
enum('Y', 'N', 'U', '')
|
utf8_general_ci
|
|
|
| org_bucket |
varchar(196)
|
utf8_general_ci
|
|
|
| hsn_code |
varchar(100)
|
utf8_general_ci
|
|
|
| sac_code |
varchar(100)
|
utf8_general_ci
|
|
|
