| id |
int(3) |
|
|
|
|---|
|
| client_code |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| c_name |
varchar(60) |
latin1_swedish_ci |
|
|
|---|
|
| short_name |
varchar(30) |
latin1_swedish_ci |
|
|
|---|
|
| tax |
int(8) |
|
|
|
|---|
|
| cust_cate |
int(10) |
|
|
|
|---|
|
| industry_type |
int(10) |
|
|
|
|---|
|
| payment_terms |
varchar(5) |
latin1_swedish_ci |
|
|
|---|
|
| salesman_id |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| ledger_id |
int(11) |
|
|
|
|---|
|
| ccategory |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| pre_address1 |
text |
latin1_swedish_ci |
|
|
|---|
|
| pre_address2 |
text |
latin1_swedish_ci |
|
|
|---|
|
| pre_address3 |
text |
latin1_swedish_ci |
|
|
|---|
|
| pre_area |
varchar(30) |
latin1_swedish_ci |
|
|
|---|
|
| pf_date |
date |
|
|
|
|---|
|
| fax |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| pre_country |
varchar(30) |
latin1_swedish_ci |
|
|
|---|
|
| pre_mobile |
varchar(15) |
latin1_swedish_ci |
|
|
|---|
|
| pre_state |
varchar(30) |
latin1_swedish_ci |
|
|
|---|
|
| pre_city |
varchar(30) |
latin1_swedish_ci |
|
|
|---|
|
| pre_pincode |
varchar(15) |
latin1_swedish_ci |
|
|
|---|
|
| per_email |
varchar(30) |
latin1_swedish_ci |
|
|
|---|
|
| lst_date |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| lst_no |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| cst_no |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| excies_no |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| pan_no |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| tin_no |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| Extension |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| pre_phone1 |
varchar(15) |
latin1_swedish_ci |
|
|
|---|
|
| pre_phone2 |
varchar(15) |
latin1_swedish_ci |
|
|
|---|
|
| cl_range |
varchar(15) |
latin1_swedish_ci |
|
|
|---|
|
| cl_division |
varchar(15) |
latin1_swedish_ci |
|
|
|---|
|
| Site |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| Zone |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| assigned_items |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| CompanyId |
int(11) |
|
|
|
|---|
|
| company_req_date |
date |
|
|
|
|---|
|
| termination_date |
date |
|
|
|
|---|
|
| Store |
int(10) |
|
|
|
|---|
|
| pnf_charges |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| discount |
double(10,2) |
|
|
|
|---|
|
| freight_charges |
double(10,2) |
|
|
|
|---|
|
| incidental_charges |
double(10,2) |
|
|
|
|---|
|
| service_tax_no |
double(10,2) |
|
|
|
|---|
|
| commisinerate |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| division |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| subzone |
int(25) |
|
|
|
|---|
|
| dealer |
int(25) |
|
|
|
|---|
|
| engineer |
int(25) |
|
|
|
|---|
|
| credit_limit |
double(10,2) |
|
|
|
|---|
|
| credit_days |
int(100) |
|
|
|
|---|
|
| comp_group |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| comodity |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| website |
varchar(30) |
latin1_swedish_ci |
|
|
|---|
|
| userid |
int(10) |
|
|
|
|---|
|
| status |
int(1) |
|
|
|
|---|
|
| dealerid |
int(10) |
|
|
|
|---|
|
