| CompanyCode | double(20,2) |
|
|
|
| ParentCompanyCode | double(20,2) |
|
|
|
| CompanyName | varchar(75) |
|
|
|
| ShortCompanyName | varchar(40) |
|
|
|
| TickerName | varchar(40) |
|
|
|
| PersonDescription | varchar(30) |
|
|
|
| PersonName | varchar(100) |
|
|
|
| ExecutiveDescription | varchar(30) |
|
|
|
| ExecutiveName | varchar(100) |
|
|
|
| ExchangeCode | varchar(30) |
|
|
|
| ExchangeName | varchar(30) |
|
|
|
| ExchangeGroup | varchar(30) |
|
|
|
| Sourcetype | varchar(30) |
|
|
|
| IncorporationDate | varchar(30) |
|
|
|
| FirstPublicIssueDate | varchar(30) |
|
|
|
| Auditeddate | varchar(30) |
|
|
|
| FaceValue | double(20,2) |
|
|
|
| Marketlot | int(10) |
|
|
|
| IndustryCode | int(10) |
|
|
|
| IndustryName | varchar(256) |
|
|
|
| BusinessGroupCode | int(10) |
|
|
|
| BusinessGroupName | varchar(256) |
|
|
|
| MajorSector | int(10) |
|
|
|
| LatestFinYear | varchar(50) |
|
|
|
| ForemostFinYear | varchar(50) |
|
|
|
| LatestHalfYear | varchar(50) |
|
|
|
| ForemostHalfYear | varchar(50) |
|
|
|
| LatestQtrYear | varchar(50) |
|
|
|
| ForemostQtrYear | varchar(50) |
|
|
|
| ModifiedDate | varchar(40) |
|
|
|
