| CompanyId |
int(11) |
|
|
|
|---|
|
| coycode |
int(11) |
|
|
|
|---|
|
| Identification |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| CompanyName |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| com_type |
enum('pr', 'gv', 'sg', 'ot') |
latin1_swedish_ci |
|
|
|---|
|
| com_process |
enum('m', 't', 'd', 'l', 'sp', 'sc') |
latin1_swedish_ci |
|
|
|---|
|
| commodity |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| group_id |
int(10) |
|
|
|
|---|
|
| companynumber |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| Address1 |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| Address2 |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| Address3 |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| regoffice1 |
varchar(40) |
latin1_swedish_ci |
|
|
|---|
|
| regoffice2 |
varchar(40) |
latin1_swedish_ci |
|
|
|---|
|
| regoffice3 |
varchar(40) |
latin1_swedish_ci |
|
|
|---|
|
| regoffice4 |
varchar(40) |
latin1_swedish_ci |
|
|
|---|
|
| regoffice5 |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| regoffice6 |
varchar(15) |
latin1_swedish_ci |
|
|
|---|
|
| telephone |
varchar(25) |
latin1_swedish_ci |
|
|
|---|
|
| City |
varchar(200) |
latin1_swedish_ci |
|
|
|---|
|
| State |
varchar(200) |
latin1_swedish_ci |
|
|
|---|
|
| Country |
varchar(200) |
latin1_swedish_ci |
|
|
|---|
|
| Zipcode |
varchar(80) |
latin1_swedish_ci |
|
|
|---|
|
| Phone |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| fax |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| PersonalAccountNo |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| TAN |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| TIN_STRegNo |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| DataBaseName |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| BookPeriodStart |
date |
|
|
|
|---|
|
| BookPeriodEnd |
date |
|
|
|
|---|
|
| AccountingYearStart |
date |
|
|
|
|---|
|
| AccountingYearEnd |
date |
|
|
|
|---|
|
| HomePage |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| email |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| currencydefault |
varchar(4) |
latin1_swedish_ci |
|
|
|---|
|
| debtorsact |
int(11) |
|
|
|
|---|
|
| pytdiscountact |
int(11) |
|
|
|
|---|
|
| creditorsact |
int(11) |
|
|
|
|---|
|
| payrollact |
int(11) |
|
|
|
|---|
|
| grnact |
int(11) |
|
|
|
|---|
|
| exchangediffact |
int(11) |
|
|
|
|---|
|
| purchasesexchangediffact |
int(11) |
|
|
|
|---|
|
| retainedearnings |
int(11) |
|
|
|
|---|
|
| gllink_debtors |
tinyint(1) |
|
|
|
|---|
|
| gllink_creditors |
tinyint(1) |
|
|
|
|---|
|
| gllink_stock |
tinyint(1) |
|
|
|
|---|
|
| freightact |
int(11) |
|
|
|
|---|
|
| Branch_Permission |
tinyint(4) |
|
|
|
|---|
|
| CompanyLogo |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| website |
varchar(30) |
latin1_swedish_ci |
|
|
|---|
|
| modules_allowed |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| coyname |
varchar(50) |
latin1_swedish_ci |
|
|
|---|
|
| gstno |
varchar(20) |
latin1_swedish_ci |
|
|
|---|
|
| company_code |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| cin_number |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
