NorenDionNewsData
BackgroundInfo
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(20,2) | 否 | ||||
| ParentCompanyCode | double(20,2) | 否 | ||||
| CompanyName | varchar(75) | 否 | ||||
| ShortCompanyName | varchar(40) | 否 | ||||
| TickerName | varchar(40) | 是 | NULL | |||
| PersonDescription | varchar(30) | 是 | NULL | |||
| PersonName | varchar(100) | 是 | NULL | |||
| ExecutiveDescription | varchar(30) | 是 | NULL | |||
| ExecutiveName | varchar(100) | 是 | NULL | |||
| ExchangeCode | varchar(30) | 是 | NULL | |||
| ExchangeName | varchar(30) | 是 | NULL | |||
| ExchangeGroup | varchar(30) | 是 | NULL | |||
| Sourcetype | varchar(30) | 是 | NULL | |||
| IncorporationDate | varchar(30) | 是 | NULL | |||
| FirstPublicIssueDate | varchar(30) | 是 | NULL | |||
| Auditeddate | varchar(30) | 是 | NULL | |||
| FaceValue | double(20,2) | 是 | NULL | |||
| Marketlot | int(10) | 是 | NULL | |||
| IndustryCode | int(10) | 否 | ||||
| IndustryName | varchar(256) | 否 | ||||
| BusinessGroupCode | int(10) | 否 | ||||
| BusinessGroupName | varchar(256) | 否 | ||||
| MajorSector | int(10) | 否 | ||||
| LatestFinYear | varchar(50) | 是 | NULL | |||
| ForemostFinYear | varchar(50) | 是 | NULL | |||
| LatestHalfYear | varchar(50) | 是 | NULL | |||
| ForemostHalfYear | varchar(50) | 是 | NULL | |||
| LatestQtrYear | varchar(50) | 是 | NULL | |||
| ForemostQtrYear | varchar(50) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 4439 | A | 否 |
BlockDeals
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| SecurityCode (主键) | varchar(40) | 否 | ||||
| ExchangeCode (主键) | bigint(20) | 否 | ||||
| DealDate (主键) | varchar(40) | 否 | ||||
| DealType (主键) | varchar(10) | 否 | ||||
| ClientName (主键) | varchar(200) | 否 | ||||
| Quantity | bigint(10) | 是 | NULL | |||
| Price | double(20,2) | 是 | NULL | |||
| Remarks | varchar(100) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL | |||
| DeleteFlag | int(1) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | SecurityCode | 32 | A | 否 | |
| ExchangeCode | 32 | A | 否 | |||||
| DealDate | 32 | A | 否 | |||||
| DealType | 97 | A | 否 | |||||
| ClientName | 97 | A | 否 |
BulkDeals
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| SecurityCode (主键) | varchar(40) | 否 | ||||
| ExchangeCode (主键) | bigint(20) | 否 | ||||
| DealDate (主键) | varchar(40) | 否 | ||||
| DealType (主键) | varchar(10) | 否 | ||||
| ClientName (主键) | varchar(200) | 否 | ||||
| Quantity | bigint(10) | 是 | NULL | |||
| Price | double(20,2) | 是 | NULL | |||
| Remarks | varchar(100) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL | |||
| DeleteFlag | int(1) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | SecurityCode | 1059 | A | 否 | |
| ExchangeCode | 1059 | A | 否 | |||||
| DealDate | 1059 | A | 否 | |||||
| DealType | 1059 | A | 否 | |||||
| ClientName | 1059 | A | 否 |
CompanyMaster
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(12,2) | 否 | ||||
| CompanyName | varchar(255) | 否 | ||||
| ShortCompanyName | varchar(255) | 否 | ||||
| IndustryCode | int(10) | 否 | ||||
| IndustryName | varchar(255) | 否 | ||||
| BusinessGroupCode | int(10) | 否 | ||||
| BusinessGroupName | varchar(255) | 否 | ||||
| IncorporationDate | varchar(50) | 是 | NULL | |||
| IncorporationYear | varchar(100) | 是 | NULL | |||
| FirstPublicIssueDate | varchar(50) | 是 | NULL | |||
| FirstPublicIssueYear | varchar(100) | 是 | NULL | |||
| MajorSector | int(10) | 否 | ||||
| CINNo | varchar(30) | 是 | NULL | |||
| Remarks | varchar(2550) | 是 | NULL | |||
| ModifiedDate | varchar(50) | 否 | ||||
| DeleteFlag | int(1) | 否 |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 13754 | A | 否 |
FiiCashDetails
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| Date (主键) | varchar(20) | 否 | ||||
| Equity_Purchase_Primary | bigint(20) | 否 | ||||
| Equity_Sell_Primary | bigint(20) | 否 | ||||
| Equity_NetInvestment_Primary | bigint(20) | 否 | ||||
| Equity_Purchase_Secondary | bigint(20) | 否 | ||||
| Equity_Sell_Secondary | bigint(20) | 否 | ||||
| Equity_NetInvestment_Secondary | bigint(20) | 否 | ||||
| Debt_Purchase_Primary | bigint(20) | 否 | ||||
| Debt_Sell_Primary | bigint(20) | 否 | ||||
| Debt_NetInvestment_Primary | bigint(20) | 否 | ||||
| Debt_Purchase_Secondary | bigint(20) | 否 | ||||
| Debt_Sell_Secondary | bigint(20) | 否 | ||||
| Debt_NetInvestment_Secondary | bigint(20) | 否 | ||||
| ConversionValue | bigint(20) | 否 | ||||
| ModifiedDate | varchar(40) | 否 | ||||
| DeleteFlag | int(1) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | Date | 897 | A | 否 |
FiiDerivatives
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| FIIDate (主键) | varchar(20) | 否 | ||||
| InstrumentType (主键) | varchar(40) | 否 | ||||
| BuyNoOfContract | bigint(20) | 否 | ||||
| BuyValue | bigint(20) | 否 | ||||
| SellNoOfContract | bigint(20) | 否 | ||||
| SellValue | bigint(20) | 否 | ||||
| OpenInterestNoOfContract | bigint(20) | 否 | ||||
| OpenInterestValue | bigint(20) | 否 | ||||
| Denomination | bigint(20) | 否 | ||||
| ModifiedDate | varchar(40) | 否 |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | FIIDate | 2274 | A | 否 | |
| InstrumentType | 4549 | A | 否 |
FinanceBankingVI
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(20,2) | 否 | ||||
| YearEnding (主键) | varchar(40) | 否 | ||||
| Months | int(10) | 否 | ||||
| Type | varchar(10) | 否 | ||||
| FaceValue | double(20,2) | 是 | NULL | |||
| InterestDiscountOnAdvancesBills | double(20,2) | 是 | NULL | |||
| IncomeFromInvestments | double(20,2) | 是 | NULL | |||
| InterestOnBalanceWithRBIAndOtherInterBankFunds | double(20,2) | 是 | NULL | |||
| Others | double(20,2) | 是 | NULL | |||
| TotalInterestEarned | double(20,2) | 是 | NULL | |||
| OtherIncome | double(20,2) | 是 | NULL | |||
| TotalIncome | double(20,2) | 是 | NULL | |||
| InterestExpended | double(20,2) | 是 | NULL | |||
| PaymentsToAndProvisionsForEmployees | double(20,2) | 是 | NULL | |||
| Depreciation | double(20,2) | 是 | NULL | |||
| DepreciationOnLeasedAssets | double(20,2) | 是 | NULL | |||
| OperatingExpensesExcludesEmployeeCostAndDepreciation | double(20,2) | 是 | NULL | |||
| TotalOperatingExpenses | double(20,2) | 是 | NULL | |||
| ProvisionTowardsIncomeTax | double(20,2) | 是 | NULL | |||
| ProvisionTowardsDeferredTax | double(20,2) | 是 | NULL | |||
| ProvisionTowardsOtherTaxes | double(20,2) | 是 | NULL | |||
| OtherProvisionsAndContingencies | double(20,2) | 是 | NULL | |||
| TotalProvisionsAndContingencies | double(20,2) | 是 | NULL | |||
| TotalExpenditure | double(20,2) | 是 | NULL | |||
| NetProfitLossForTheYear | double(20,2) | 是 | NULL | |||
| PriorPeriodItems | double(20,2) | 是 | NULL | |||
| ExtraordinaryItems | double(20,2) | 是 | NULL | |||
| NetProfitLossForTheYearAfterEI | double(20,2) | 是 | NULL | |||
| ProfitLossBroughtForward | double(20,2) | 是 | NULL | |||
| TransferredOnAmalgamation | double(20,2) | 是 | NULL | |||
| TotalProfitLoss | double(20,2) | 是 | NULL | |||
| TransferToFromStatutoryReserve | double(20,2) | 是 | NULL | |||
| TransferToFromReserveFund | double(20,2) | 是 | NULL | |||
| TransferToFromSpecialReserve | double(20,2) | 是 | NULL | |||
| TransferToFromCapitalReserve | double(20,2) | 是 | NULL | |||
| TransferToFromGeneralReserve | double(20,2) | 是 | NULL | |||
| TransferToFromInvestmentReserve | double(20,2) | 是 | NULL | |||
| TransferToFromRevenueAndOtherReserves | double(20,2) | 是 | NULL | |||
| DividendForThePreviousYear | double(20,2) | 是 | NULL | |||
| EquityShareDividend | double(20,2) | 是 | NULL | |||
| PreferenceShareDividend | double(20,2) | 是 | NULL | |||
| TaxOnDividend | double(20,2) | 是 | NULL | |||
| BalanceCarriedOverToBalanceSheet | double(20,2) | 是 | NULL | |||
| TotalAppropriations | double(20,2) | 是 | NULL | |||
| EquityShares | double(20,2) | 是 | NULL | |||
| EquityCapital | double(20,2) | 是 | NULL | |||
| PreferenceCapital | double(20,2) | 是 | NULL | |||
| TotalShareCapital | double(20,2) | 是 | NULL | |||
| RevaluationReserves | double(20,2) | 是 | NULL | |||
| ReservesAndSurplus | double(20,2) | 是 | NULL | |||
| TotalReservesAndSurplus | double(20,2) | 是 | NULL | |||
| MoneyAgainstShareWarrants | double(20,2) | 是 | NULL | |||
| EmployeesStockOptions | double(20,2) | 是 | NULL | |||
| TotalShareHoldersFunds | double(20,2) | 是 | NULL | |||
| EquityShareApplicationMoney | double(20,2) | 是 | NULL | |||
| PrefShareApplicationMoney | double(20,2) | 是 | NULL | |||
| ShareCapitalSuspense | double(20,2) | 是 | NULL | |||
| Deposits | double(20,2) | 是 | NULL | |||
| Borrowings | double(20,2) | 是 | NULL | |||
| OtherLiabilitiesAndProvisions | double(20,2) | 是 | NULL | |||
| TotalCapitalAndLiabilities | double(20,2) | 是 | NULL | |||
| CashAndBalancesWithReserveBankOfIndia | double(20,2) | 是 | NULL | |||
| BalancesWithBanksMoneyAtCallAndShortNotice | double(20,2) | 是 | NULL | |||
| Investments | double(20,2) | 是 | NULL | |||
| Advances | double(20,2) | 是 | NULL | |||
| FixedAssets | double(20,2) | 是 | NULL | |||
| OtherAssets | double(20,2) | 是 | NULL | |||
| TotalAssets | double(20,2) | 是 | NULL | |||
| NetProfitLossBeforeExtraordinaryItemsAndTax | double(20,2) | 是 | NULL | |||
| NetCashFlowFromOperatingActivities | double(20,2) | 是 | NULL | |||
| NetCashUsedInInvestingActivities | double(20,2) | 是 | NULL | |||
| NetCashUsedFromFinancingActivities | double(20,2) | 是 | NULL | |||
| ForeignExchangeGainsLosses | double(20,2) | 是 | NULL | |||
| NetIncDecInCashAndCashEquivalents | double(20,2) | 是 | NULL | |||
| CashAndCashEquivalentBeginOfYear | double(20,2) | 是 | NULL | |||
| CashAndCashEquivalentEndOfYear | double(20,2) | 是 | NULL | |||
| BasicEPS | double(20,2) | 是 | NULL | |||
| DilutedEPS | double(20,2) | 是 | NULL | |||
| NumberOfBranches | double(20,2) | 是 | NULL | |||
| NumberOfEmployees | double(20,2) | 是 | NULL | |||
| CapitalAdequacyRatios | double(20,2) | 是 | NULL | |||
| KeyPerformanceTier1 | double(20,2) | 是 | NULL | |||
| KeyPerformanceTier2 | double(20,2) | 是 | NULL | |||
| GrossNPARs | double(20,2) | 是 | NULL | |||
| GrossNPAPercentage | double(20,2) | 是 | NULL | |||
| NetNPARs | double(20,2) | 是 | NULL | |||
| NetNPAPercentage | double(20,2) | 是 | NULL | |||
| NetNPAToAdvancesPercentage | double(20,2) | 是 | NULL | |||
| BillsForCollection | double(20,2) | 是 | NULL | |||
| ContingentLiabilities | double(20,2) | 是 | NULL | |||
| EquityDividendRate | double(20,2) | 是 | NULL | |||
| BonusEquityShareCapital | double(20,2) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 12 | A | 否 | |
| YearEnding | 12 | A | 否 |
FinanceConsolidatedBankingVI
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(20,2) | 否 | ||||
| YearEnding (主键) | varchar(40) | 否 | ||||
| Months | int(10) | 否 | ||||
| Type | varchar(10) | 否 | ||||
| FaceValue | double(20,2) | 是 | NULL | |||
| InterestDiscountOnAdvancesBills | double(20,2) | 是 | NULL | |||
| IncomeFromInvestments | double(20,2) | 是 | NULL | |||
| InterestOnBalanceWithRBIAndOtherInterBankFunds | double(20,2) | 是 | NULL | |||
| Others | double(20,2) | 是 | NULL | |||
| TotalInterestEarned | double(20,2) | 是 | NULL | |||
| OtherIncome | double(20,2) | 是 | NULL | |||
| TotalIncome | double(20,2) | 是 | NULL | |||
| InterestExpended | double(20,2) | 是 | NULL | |||
| PaymentsToAndProvisionsForEmployees | double(20,2) | 是 | NULL | |||
| Depreciation | double(20,2) | 是 | NULL | |||
| DepreciationOnLeasedAssets | double(20,2) | 是 | NULL | |||
| OperatingExpensesExcludesEmployeeCostAndDepreciation | double(20,2) | 是 | NULL | |||
| TotalOperatingExpenses | double(20,2) | 是 | NULL | |||
| ProvisionTowardsIncomeTax | double(20,2) | 是 | NULL | |||
| ProvisionTowardsDeferredTax | double(20,2) | 是 | NULL | |||
| ProvisionTowardsOtherTaxes | double(20,2) | 是 | NULL | |||
| OtherProvisionsAndContingencies | double(20,2) | 是 | NULL | |||
| TotalProvisionsAndContingencies | double(20,2) | 是 | NULL | |||
| TotalExpenditure | double(20,2) | 是 | NULL | |||
| NetProfitLossForTheYear | double(20,2) | 是 | NULL | |||
| PriorPeriodItems | double(20,2) | 是 | NULL | |||
| ExtraordinaryItems | double(20,2) | 是 | NULL | |||
| NetProfitLossForTheYearAfterEI | double(20,2) | 是 | NULL | |||
| IncomeMinorityInterest | double(20,2) | 是 | NULL | |||
| ShareOfProfitLossFromAssociate | double(20,2) | 是 | NULL | |||
| ProfitLossAfterMIAndAssociates | double(20,2) | 是 | NULL | |||
| ProfitLossBroughtForward | double(20,2) | 是 | NULL | |||
| TransferredOnAmalgamation | double(20,2) | 是 | NULL | |||
| TotalProfitLoss | double(20,2) | 是 | NULL | |||
| TransferToFromStatutoryReserve | double(20,2) | 是 | NULL | |||
| TransferToFromReserveFund | double(20,2) | 是 | NULL | |||
| TransferToFromSpecialReserve | double(20,2) | 是 | NULL | |||
| TransferToFromCapitalReserve | double(20,2) | 是 | NULL | |||
| TransferToFromGeneralReserve | double(20,2) | 是 | NULL | |||
| TransferToFromInvestmentReserve | double(20,2) | 是 | NULL | |||
| TransferToFromRevenueAndOtherReserves | double(20,2) | 是 | NULL | |||
| DividendForThePreviousYear | double(20,2) | 是 | NULL | |||
| EquityShareDividend | double(20,2) | 是 | NULL | |||
| PreferenceShareDividend | double(20,2) | 是 | NULL | |||
| TaxOnDividend | double(20,2) | 是 | NULL | |||
| BalanceCarriedOverToBalanceSheet | double(20,2) | 是 | NULL | |||
| TotalAppropriations | double(20,2) | 是 | NULL | |||
| EquityShares | double(20,2) | 是 | NULL | |||
| EquityCapital | double(20,2) | 是 | NULL | |||
| PreferenceCapital | double(20,2) | 是 | NULL | |||
| TotalShareCapital | double(20,2) | 是 | NULL | |||
| RevaluationReserves | double(20,2) | 是 | NULL | |||
| ReservesAndSurplus | double(20,2) | 是 | NULL | |||
| TotalReservesAndSurplus | double(20,2) | 是 | NULL | |||
| MoneyAgainstShareWarrants | double(20,2) | 是 | NULL | |||
| EmployeesStockOptions | double(20,2) | 是 | NULL | |||
| TotalShareHoldersFunds | double(20,2) | 是 | NULL | |||
| EquityShareApplicationMoney | double(20,2) | 是 | NULL | |||
| PrefShareApplicationMoney | double(20,2) | 是 | NULL | |||
| ShareCapitalSuspense | double(20,2) | 是 | NULL | |||
| LiabilityMinorityInterest | double(20,2) | 是 | NULL | |||
| PolicyHoldersFunds | double(20,2) | 是 | NULL | |||
| LiabilityGroupShareInJointVentures | double(20,2) | 是 | NULL | |||
| Deposits | double(20,2) | 是 | NULL | |||
| Borrowings | double(20,2) | 是 | NULL | |||
| OtherLiabilitiesAndProvisions | double(20,2) | 是 | NULL | |||
| TotalCapitalAndLiabilities | double(20,2) | 是 | NULL | |||
| CashAndBalancesWithReserveBankOfIndia | double(20,2) | 是 | NULL | |||
| BalancesWithBanksMoneyAtCallAndShortNotice | double(20,2) | 是 | NULL | |||
| Investments | double(20,2) | 是 | NULL | |||
| Advances | double(20,2) | 是 | NULL | |||
| FixedAssets | double(20,2) | 是 | NULL | |||
| OtherAssets | double(20,2) | 是 | NULL | |||
| AssetMinorityInterest | double(20,2) | 是 | NULL | |||
| AssetGroupShareInJointVentures | double(20,2) | 是 | NULL | |||
| TotalAssets | double(20,2) | 是 | NULL | |||
| NetProfitLossBeforeExtraordinaryItemsAndTax | double(20,2) | 是 | NULL | |||
| NetCashFlowFromOperatingActivities | double(20,2) | 是 | NULL | |||
| NetCashUsedInInvestingActivities | double(20,2) | 是 | NULL | |||
| NetCashUsedFromFinancingActivities | double(20,2) | 是 | NULL | |||
| ForeignExchangeGainsLosses | double(20,2) | 是 | NULL | |||
| NetIncDecInCashAndCashEquivalents | double(20,2) | 是 | NULL | |||
| CashAndCashEquivalentBeginOfYear | double(20,2) | 是 | NULL | |||
| CashAndCashEquivalentEndOfYear | double(20,2) | 是 | NULL | |||
| BasicEPS | double(20,2) | 是 | NULL | |||
| DilutedEPS | double(20,2) | 是 | NULL | |||
| NumberOfBranches | double(20,2) | 是 | NULL | |||
| NumberOfEmployees | double(20,2) | 是 | NULL | |||
| CapitalAdequacyRatios | double(20,2) | 是 | NULL | |||
| KeyPerformanceTier1 | double(20,2) | 是 | NULL | |||
| KeyPerformanceTier2 | double(20,2) | 是 | NULL | |||
| GrossNPARs | double(20,2) | 是 | NULL | |||
| GrossNPAPercentage | double(20,2) | 是 | NULL | |||
| NetNPARs | double(20,2) | 是 | NULL | |||
| NetNPAPercentage | double(20,2) | 是 | NULL | |||
| NetNPAToAdvancesPercentage | double(20,2) | 是 | NULL | |||
| BillsForCollection | double(20,2) | 是 | NULL | |||
| ContingentLiabilities | double(20,2) | 是 | NULL | |||
| BonusEquityShareCapital | double(20,2) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 0 | A | 否 | |
| YearEnding | 0 | A | 否 |
FinanceConsolidatedNonBankingVI
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(20,2) | 否 | ||||
| YearEnding (主键) | varchar(40) | 否 | ||||
| Months | int(10) | 否 | ||||
| Type | varchar(10) | 否 | ||||
| FaceValue | double(20,2) | 是 | NULL | |||
| RevenueFromOperationsGross | double(20,2) | 是 | NULL | |||
| LessExciseSeviceTaxOtherLevies | double(20,2) | 是 | NULL | |||
| RevenueFromOperationsNet | double(20,2) | 是 | NULL | |||
| OtherOperatingRevenues | double(20,2) | 是 | NULL | |||
| TotalOperatingRevenues | double(20,2) | 是 | NULL | |||
| OtherIncome | double(20,2) | 是 | NULL | |||
| GroupShareInJointVenturesInIncome | double(20,2) | 是 | NULL | |||
| TotalRevenue | double(20,2) | 是 | NULL | |||
| CostOfMaterialsConsumed | double(20,2) | 是 | NULL | |||
| PurchaseOfStockInTrade | double(20,2) | 是 | NULL | |||
| PurchaseOfCrudeOilAndOthers | double(20,2) | 是 | NULL | |||
| CostOfPowerPurchased | double(20,2) | 是 | NULL | |||
| CostOfFuel | double(20,2) | 是 | NULL | |||
| AircraftFuelExpenses | double(20,2) | 是 | NULL | |||
| AircraftLeaseRentals | double(20,2) | 是 | NULL | |||
| OperatingAndDirectExpenses | double(20,2) | 是 | NULL | |||
| ChangesIninventoriesOfFGWIPAndStockInTrade | double(20,2) | 是 | NULL | |||
| EmployeeBenefitExpenses | double(20,2) | 是 | NULL | |||
| FinanceCosts | double(20,2) | 是 | NULL | |||
| ProvisionsAndContingencies | double(20,2) | 是 | NULL | |||
| DepreciationAndAmortisationExpenses | double(20,2) | 是 | NULL | |||
| MiscExpensesWOff | double(20,2) | 是 | NULL | |||
| OtherExpenses | double(20,2) | 是 | NULL | |||
| LessInterUnitSegmentDivisionTransfer | double(20,2) | 是 | NULL | |||
| LessTransferToFromInvestmentFixedAssetsOthers | double(20,2) | 是 | NULL | |||
| LessAmountsTransferToCapitalAccounts | double(20,2) | 是 | NULL | |||
| LessShareOfLossFromPartnershipFirm | double(20,2) | 是 | NULL | |||
| GroupShareInJointVenturesInExpenditure | double(20,2) | 是 | NULL | |||
| TotalExpenses | double(20,2) | 是 | NULL | |||
| ProfitLossBeforeExceptionalExtraOrdinaryItemsAndTax | double(20,2) | 是 | NULL | |||
| ExceptionalItems | double(20,2) | 是 | NULL | |||
| ProfitLossBeforeTax | double(20,2) | 是 | NULL | |||
| CurrentTax | double(20,2) | 是 | NULL | |||
| LessMATCredit | double(20,2) | 是 | NULL | |||
| DeferredTax | double(20,2) | 是 | NULL | |||
| OtherDirectTaxes | double(20,2) | 是 | NULL | |||
| TaxForEarlierYears | double(20,2) | 是 | NULL | |||
| TotalTaxExpensesContinuedOperations | double(20,2) | 是 | NULL | |||
| ProfitLossAfterTaxAndBeforeExtraOrdinaryItems | double(20,2) | 是 | NULL | |||
| PriorPeriodItems | double(20,2) | 是 | NULL | |||
| ExtraordinaryItems | double(20,2) | 是 | NULL | |||
| ProfitLossFromContinuingOperations | double(20,2) | 是 | NULL | |||
| ProfitLossFromDiscontinuingOperations | double(20,2) | 是 | NULL | |||
| TotalTaxExpensesDiscontinuingOperations | double(20,2) | 是 | NULL | |||
| NetProfitLossFromDiscontinuingOperations | double(20,2) | 是 | NULL | |||
| ProfitLossForThePeriod | double(20,2) | 是 | NULL | |||
| IncomeMinorityInterest | double(20,2) | 是 | NULL | |||
| ShareOfProfitLossOfAssociates | double(20,2) | 是 | NULL | |||
| ProfitLossAfterMIAndAssociates | double(20,2) | 是 | NULL | |||
| EquityShares | double(20,2) | 是 | NULL | |||
| EquityCapital | double(20,2) | 是 | NULL | |||
| PreferenceCapital | double(20,2) | 是 | NULL | |||
| TotalShareCapital | double(20,2) | 是 | NULL | |||
| RevaluationReserves | double(20,2) | 是 | NULL | |||
| ReservesAndSurplus | double(20,2) | 是 | NULL | |||
| TotalReservesAndSurplus | double(20,2) | 是 | NULL | |||
| MoneyAgainstShareWarrants | double(20,2) | 是 | NULL | |||
| EmployeesStockOptions | double(20,2) | 是 | NULL | |||
| TotalShareHoldersFunds | double(20,2) | 是 | NULL | |||
| PrefSharesIssuedBySubsidiaryCos | double(20,2) | 是 | NULL | |||
| EquityShareApplicationMoney | double(20,2) | 是 | NULL | |||
| PreferenceShareApplicationMoney | double(20,2) | 是 | NULL | |||
| ShareCapitalSuspense | double(20,2) | 是 | NULL | |||
| HybridDebtOtherSecurities | double(20,2) | 是 | NULL | |||
| StatutoryConsumerReserves | double(20,2) | 是 | NULL | |||
| SpecialApprnTowardsProjectCost | double(20,2) | 是 | NULL | |||
| ServiceLineContributionFromConsumers | double(20,2) | 是 | NULL | |||
| GovernmentOtherGrants | double(20,2) | 是 | NULL | |||
| LiabilityMinorityInterest | double(20,2) | 是 | NULL | |||
| PolicyHoldersFunds | double(20,2) | 是 | NULL | |||
| LiabilityGroupShareInJointVentures | double(20,2) | 是 | NULL | |||
| LongTermBorrowings | double(20,2) | 是 | NULL | |||
| DeferredTaxLiabilities | double(20,2) | 是 | NULL | |||
| OtherLongTermLiabilities | double(20,2) | 是 | NULL | |||
| LongTermProvisions | double(20,2) | 是 | NULL | |||
| TotalNonCurrentLiabilities | double(20,2) | 是 | NULL | |||
| ForeignCurrencyMonetaryItemTranslationDifferenceLiabilityAccount | double(20,2) | 是 | NULL | |||
| ShortTermBorrowings | double(20,2) | 是 | NULL | |||
| TradePayables | double(20,2) | 是 | NULL | |||
| OtherCurrentLiabilities | double(20,2) | 是 | NULL | |||
| ShortTermProvisions | double(20,2) | 是 | NULL | |||
| TotalCurrentLiabilities | double(20,2) | 是 | NULL | |||
| TotalCapitalAndLiabilities | double(20,2) | 是 | NULL | |||
| TangibleAssets | double(20,2) | 是 | NULL | |||
| IntangibleAssets | double(20,2) | 是 | NULL | |||
| CapitalWorkInProgress | double(20,2) | 是 | NULL | |||
| IntangibleAssetsUnderDevelopment | double(20,2) | 是 | NULL | |||
| OtherAssets | double(20,2) | 是 | NULL | |||
| ConstructionStores | double(20,2) | 是 | NULL | |||
| MiningDevelopmentExpenditure | double(20,2) | 是 | NULL | |||
| AssetsHeldForSale | double(20,2) | 是 | NULL | |||
| TotalFixedAssets | double(20,2) | 是 | NULL | |||
| GoodwillOnConsolidation | double(20,2) | 是 | NULL | |||
| NonCurrentInvestments | double(20,2) | 是 | NULL | |||
| DeferredTaxAssets | double(20,2) | 是 | NULL | |||
| LongTermLoansAndAdvances | double(20,2) | 是 | NULL | |||
| OtherNonCurrentAssets | double(20,2) | 是 | NULL | |||
| TotalNonCurrentAssets | double(20,2) | 是 | NULL | |||
| AssetMinorityInterest | double(20,2) | 是 | NULL | |||
| AssetGroupShareInJointVentures | double(20,2) | 是 | NULL | |||
| ForeignCurrencyMonetaryItemTranslationDiffAcct | double(20,2) | 是 | NULL | |||
| CurrentInvestments | double(20,2) | 是 | NULL | |||
| Inventories | double(20,2) | 是 | NULL | |||
| TradeReceivables | double(20,2) | 是 | NULL | |||
| CashAndCashEquivalents | double(20,2) | 是 | NULL | |||
| ShortTermLoansAndAdvances | double(20,2) | 是 | NULL | |||
| OtherCurrentAssets | double(20,2) | 是 | NULL | |||
| TotalCurrentAssets | double(20,2) | 是 | NULL | |||
| TotalAssets | double(20,2) | 是 | NULL | |||
| NetProfitLossBeforeExtraordinaryItemsAndTax | double(20,2) | 是 | NULL | |||
| NetCashFlowFromOperatingActivities | double(20,2) | 是 | NULL | |||
| NetCashUsedInInvestingActivities | double(20,2) | 是 | NULL | |||
| NetCashUsedFromFinancingActivities | double(20,2) | 是 | NULL | |||
| ForeignExchangeGainsLosses | double(20,2) | 是 | NULL | |||
| AdjustmentsOnAmalgamationMergerDemergerOthers | double(20,2) | 是 | NULL | |||
| NetIncDecInCashAndCashEquivalents | double(20,2) | 是 | NULL | |||
| CashAndCashEquivalentBeginOfYear | double(20,2) | 是 | NULL | |||
| CashAndCashEquivalentEndOfYear | double(20,2) | 是 | NULL | |||
| BasicEPS | double(20,2) | 是 | NULL | |||
| DilutedEPS | double(20,2) | 是 | NULL | |||
| ContingentLiabilities | double(20,2) | 是 | NULL | |||
| CIFValueOfRawMaterials | double(20,2) | 是 | NULL | |||
| CIFValueOfStoresSparesAndLooseTools | double(20,2) | 是 | NULL | |||
| CIFValueOfOtherGoods | double(20,2) | 是 | NULL | |||
| CIFValueOfCapitalGoods | double(20,2) | 是 | NULL | |||
| ExpenditureInForeignCurrency | double(20,2) | 是 | NULL | |||
| DividendRemittanceInForeignCurrency | double(20,2) | 是 | NULL | |||
| ForeignExchangeFOB | double(20,2) | 是 | NULL | |||
| ForeignExchangeOtherEarnings | double(20,2) | 是 | NULL | |||
| ImportedRawMaterials | double(20,2) | 是 | NULL | |||
| IndigenousRawMaterials | double(20,2) | 是 | NULL | |||
| ImportedStoresAndSpares | double(20,2) | 是 | NULL | |||
| IndigenousStoresAndSpares | double(20,2) | 是 | NULL | |||
| EquityShareDividend | double(20,2) | 是 | NULL | |||
| PreferenceShareDividend | double(20,2) | 是 | NULL | |||
| TaxOnDividend | double(20,2) | 是 | NULL | |||
| BonusEquityShareCapital | double(20,2) | 是 | NULL | |||
| NonCurrentInvestmentsQuotedMarketValue | double(20,2) | 是 | NULL | |||
| NonCurrentInvestmentsUnquotedBookValue | double(20,2) | 是 | NULL | |||
| CurrentInvestmentsQuotedMarketValue | double(20,2) | 是 | NULL | |||
| CurrentInvestmentsUnquotedBookValue | double(20,2) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 615 | A | 否 | |
| YearEnding | 615 | A | 否 |
FinanceNonBankingVI
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(20,2) | 否 | ||||
| YearEnding (主键) | varchar(40) | 否 | ||||
| Months | int(10) | 否 | ||||
| Type | varchar(10) | 否 | ||||
| FaceValue | double(20,2) | 是 | NULL | |||
| RevenueFromOperationsGross | double(20,2) | 是 | NULL | |||
| LessExciseSeviceTaxOtherLevies | double(20,2) | 是 | NULL | |||
| RevenueFromOperationsNet | double(20,2) | 是 | NULL | |||
| OtherOperatingRevenues | double(20,2) | 是 | NULL | |||
| TotalOperatingRevenues | double(20,2) | 是 | NULL | |||
| OtherIncome | double(20,2) | 是 | NULL | |||
| TotalRevenue | double(20,2) | 是 | NULL | |||
| CostOfMaterialsConsumed | double(20,2) | 是 | NULL | |||
| PurchaseOfStockInTrade | double(20,2) | 是 | NULL | |||
| PurchaseOfCrudeOilAndOthers | double(20,2) | 是 | NULL | |||
| CostOfPowerPurchased | double(20,2) | 是 | NULL | |||
| CostOfFuel | double(20,2) | 是 | NULL | |||
| AircraftFuelExpenses | double(20,2) | 是 | NULL | |||
| AircraftLeaseRentals | double(20,2) | 是 | NULL | |||
| OperatingAndDirectExpenses | double(20,2) | 是 | NULL | |||
| ChangesIninventoriesOfFGWIPAndStockInTrade | double(20,2) | 是 | NULL | |||
| EmployeeBenefitExpenses | double(20,2) | 是 | NULL | |||
| FinanceCosts | double(20,2) | 是 | NULL | |||
| ProvisionsAndContingencies | double(20,2) | 是 | NULL | |||
| DepreciationAndAmortisationExpenses | double(20,2) | 是 | NULL | |||
| MiscExpensesWOff | double(20,2) | 是 | NULL | |||
| OtherExpenses | double(20,2) | 是 | NULL | |||
| LessInterUnitSegmentDivisionTransfer | double(20,2) | 是 | NULL | |||
| LessTransferToFromInvestmentFixedAssetsOthers | double(20,2) | 是 | NULL | |||
| LessAmountsTransferToCapitalAccounts | double(20,2) | 是 | NULL | |||
| LessShareOfLossFromPartnershipFirm | double(20,2) | 是 | NULL | |||
| TotalExpenses | double(20,2) | 是 | NULL | |||
| ProfitLossBeforeExceptionalExtraOrdinaryItemsAndTax | double(20,2) | 是 | NULL | |||
| ExceptionalItems | double(20,2) | 是 | NULL | |||
| ProfitLossBeforeTax | double(20,2) | 是 | NULL | |||
| CurrentTax | double(20,2) | 是 | NULL | |||
| LessMATCredit | double(20,2) | 是 | NULL | |||
| DeferredTax | double(20,2) | 是 | NULL | |||
| OtherDirectTaxes | double(20,2) | 是 | NULL | |||
| TaxForEarlierYears | double(20,2) | 是 | NULL | |||
| TotalTaxExpensesContinuedOperations | double(20,2) | 是 | NULL | |||
| ProfitLossAfterTaxAndBeforeExtraOrdinaryItems | double(20,2) | 是 | NULL | |||
| PriorPeriodItems | double(20,2) | 是 | NULL | |||
| ExtraordinaryItems | double(20,2) | 是 | NULL | |||
| ProfitLossFromContinuingOperations | double(20,2) | 是 | NULL | |||
| ProfitLossFromDiscontinuingOperations | double(20,2) | 是 | NULL | |||
| TotalTaxExpensesDiscontinuingOperations | double(20,2) | 是 | NULL | |||
| NetProfitLossFromDiscontinuingOperations | double(20,2) | 是 | NULL | |||
| ProfitLossForThePeriod | double(20,2) | 是 | NULL | |||
| EquityShares | double(20,2) | 是 | NULL | |||
| EquityCapital | double(20,2) | 是 | NULL | |||
| PreferenceCapital | double(20,2) | 是 | NULL | |||
| TotalShareCapital | double(20,2) | 是 | NULL | |||
| RevaluationReserves | double(20,2) | 是 | NULL | |||
| ReservesAndSurplus | double(20,2) | 是 | NULL | |||
| TotalReservesAndSurplus | double(20,2) | 是 | NULL | |||
| MoneyAgainstShareWarrants | double(20,2) | 是 | NULL | |||
| EmployeesStockOptions | double(20,2) | 是 | NULL | |||
| TotalShareHoldersFunds | double(20,2) | 是 | NULL | |||
| EquityShareApplicationMoney | double(20,2) | 是 | NULL | |||
| PreferenceShareApplicationMoney | double(20,2) | 是 | NULL | |||
| ShareCapitalSuspense | double(20,2) | 是 | NULL | |||
| HybridDebtOtherSecurities | double(20,2) | 是 | NULL | |||
| StatutoryConsumerReserves | double(20,2) | 是 | NULL | |||
| SpecialApprnTowardsProjectCost | double(20,2) | 是 | NULL | |||
| ServiceLineContributionFromConsumers | double(20,2) | 是 | NULL | |||
| GovernmentOtherGrants | double(20,2) | 是 | NULL | |||
| LongTermBorrowings | double(20,2) | 是 | NULL | |||
| DeferredTaxLiabilities | double(20,2) | 是 | NULL | |||
| OtherLongTermLiabilities | double(20,2) | 是 | NULL | |||
| LongTermProvisions | double(20,2) | 是 | NULL | |||
| TotalNonCurrentLiabilities | double(20,2) | 是 | NULL | |||
| ForeignCurrencyMonetaryItemTranslationDifferenceLiabilityAccount | double(20,2) | 是 | NULL | |||
| ShortTermBorrowings | double(20,2) | 是 | NULL | |||
| TradePayables | double(20,2) | 是 | NULL | |||
| OtherCurrentLiabilities | double(20,2) | 是 | NULL | |||
| ShortTermProvisions | double(20,2) | 是 | NULL | |||
| TotalCurrentLiabilities | double(20,2) | 是 | NULL | |||
| TotalCapitalAndLiabilities | double(20,2) | 是 | NULL | |||
| TangibleAssets | double(20,2) | 是 | NULL | |||
| IntangibleAssets | double(20,2) | 是 | NULL | |||
| CapitalWorkInProgress | double(20,2) | 是 | NULL | |||
| IntangibleAssetsUnderDevelopment | double(20,2) | 是 | NULL | |||
| OtherAssets | double(20,2) | 是 | NULL | |||
| ConstructionStores | double(20,2) | 是 | NULL | |||
| MiningDevelopmentExpenditure | double(20,2) | 是 | NULL | |||
| AssetsHeldForSale | double(20,2) | 是 | NULL | |||
| TotalFixedAssets | double(20,2) | 是 | NULL | |||
| NonCurrentInvestments | double(20,2) | 是 | NULL | |||
| DeferredTaxAssets | double(20,2) | 是 | NULL | |||
| LongTermLoansAndAdvances | double(20,2) | 是 | NULL | |||
| OtherNonCurrentAssets | double(20,2) | 是 | NULL | |||
| TotalNonCurrentAssets | double(20,2) | 是 | NULL | |||
| ForeignCurrencyMonetaryItemTranslationDiffAcct | double(20,2) | 是 | NULL | |||
| CurrentInvestments | double(20,2) | 是 | NULL | |||
| Inventories | double(20,2) | 是 | NULL | |||
| TradeReceivables | double(20,2) | 是 | NULL | |||
| CashAndCashEquivalents | double(20,2) | 是 | NULL | |||
| ShortTermLoansAndAdvances | double(20,2) | 是 | NULL | |||
| OtherCurrentAssets | double(20,2) | 是 | NULL | |||
| TotalCurrentAssets | double(20,2) | 是 | NULL | |||
| TotalAssets | double(20,2) | 是 | NULL | |||
| NetProfitLossBeforeExtraordinaryItemsAndTax | double(20,2) | 是 | NULL | |||
| NetCashFlowFromOperatingActivities | double(20,2) | 是 | NULL | |||
| NetCashUsedInInvestingActivities | double(20,2) | 是 | NULL | |||
| NetCashUsedFromFinancingActivities | double(20,2) | 是 | NULL | |||
| ForeignExchangeGainsLosses | double(20,2) | 是 | NULL | |||
| AdjustmentsOnAmalgamationMergerDemergerOthers | double(20,2) | 是 | NULL | |||
| NetIncDecInCashAndCashEquivalents | double(20,2) | 是 | NULL | |||
| CashAndCashEquivalentBeginOfYear | double(20,2) | 是 | NULL | |||
| CashAndCashEquivalentEndOfYear | double(20,2) | 是 | NULL | |||
| BasicEPS | double(20,2) | 是 | NULL | |||
| DilutedEPS | double(20,2) | 是 | NULL | |||
| ContingentLiabilities | double(20,2) | 是 | NULL | |||
| CIFValueOfRawMaterials | double(20,2) | 是 | NULL | |||
| CIFValueOfStoresSparesAndLooseTools | double(20,2) | 是 | NULL | |||
| CIFValueOfOtherGoods | double(20,2) | 是 | NULL | |||
| CIFValueOfCapitalGoods | double(20,2) | 是 | NULL | |||
| ExpenditureInForeignCurrency | double(20,2) | 是 | NULL | |||
| DividendRemittanceInForeignCurrency | double(20,2) | 是 | NULL | |||
| ForeignExchangeFOB | double(20,2) | 是 | NULL | |||
| ForeignExchangeOtherEarnings | double(20,2) | 是 | NULL | |||
| ImportedRawMaterials | double(20,2) | 是 | NULL | |||
| IndigenousRawMaterials | double(20,2) | 是 | NULL | |||
| ImportedStoresAndSpares | double(20,2) | 是 | NULL | |||
| IndigenousStoresAndSpares | double(20,2) | 是 | NULL | |||
| EquityShareDividend | double(20,2) | 是 | NULL | |||
| PreferenceShareDividend | double(20,2) | 是 | NULL | |||
| TaxOnDividend | double(20,2) | 是 | NULL | |||
| EquityDividendRate | double(20,2) | 是 | NULL | |||
| BonusEquityShareCapital | double(20,2) | 是 | NULL | |||
| NonCurrentInvestmentsQuotedMarketValue | double(20,2) | 是 | NULL | |||
| NonCurrentInvestmentsUnquotedBookValue | double(20,2) | 是 | NULL | |||
| CurrentInvestmentsQuotedMarketValue | double(20,2) | 是 | NULL | |||
| CurrentInvestmentsUnquotedBookValue | double(20,2) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 2907 | A | 否 | |
| YearEnding | 2907 | A | 否 |
HalfYearlyResults
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(20,2) | 否 | ||||
| YearEnding (主键) | varchar(40) | 否 | ||||
| Months | int(10) | 否 | ||||
| Half (主键) | int(10) | 否 | ||||
| OperatingIncome | double(20,2) | 是 | NULL | |||
| OtherOperatingIncome | double(20,2) | 是 | NULL | |||
| TotalIncomeFromOperations | double(20,2) | 是 | NULL | |||
| IntOrDiscOnAdvOrBills | double(20,2) | 是 | NULL | |||
| IncomeOnInvestment | double(20,2) | 是 | NULL | |||
| IntOnBalancesWithRBI | double(20,2) | 是 | NULL | |||
| Others | double(20,2) | 是 | NULL | |||
| OtherRecurringIncome | double(20,2) | 是 | NULL | |||
| StockAdjustment | double(20,2) | 是 | NULL | |||
| RawMaterialConsumed | double(20,2) | 是 | NULL | |||
| PurchaseOfTradedGoods | double(20,2) | 是 | NULL | |||
| PowerAndFuel | double(20,2) | 是 | NULL | |||
| EmployeeExpenses | double(20,2) | 是 | NULL | |||
| Excise | double(20,2) | 是 | NULL | |||
| AdminAndSellingExpenses | double(20,2) | 是 | NULL | |||
| ResearchAndDevlopmentExpenses | double(20,2) | 是 | NULL | |||
| ExpensesCapitalised | double(20,2) | 是 | NULL | |||
| OtherExpenses | double(20,2) | 是 | NULL | |||
| PL_Before_OtherInc_Int_ExcpItem_Tax | double(20,2) | 是 | NULL | |||
| PL_Before_Int_ExcpItem_Tax | double(20,2) | 是 | NULL | |||
| InterestCharges | double(20,2) | 是 | NULL | |||
| PL_Before_ExcpItem_Tax | double(20,2) | 是 | NULL | |||
| ExceptionalItems | double(20,2) | 是 | NULL | |||
| Depreciation | double(20,2) | 是 | NULL | |||
| OperatingProfitBeforeProvisionsAndContingencies | double(20,2) | 是 | NULL | |||
| BankProvisionsMade | double(20,2) | 是 | NULL | |||
| PL_Before_Tax | double(20,2) | 是 | NULL | |||
| TaxCharges | double(20,2) | 是 | NULL | |||
| PL_After_TaxFromOrdineryActivities | double(20,2) | 是 | NULL | |||
| ExtraOrdinaryItem | double(20,2) | 是 | NULL | |||
| ReportedPAT | double(20,2) | 是 | NULL | |||
| PriorYearAdj | double(20,2) | 是 | NULL | |||
| ReservesWrittenBack | double(20,2) | 是 | NULL | |||
| EquityCapital | double(20,2) | 是 | NULL | |||
| ReservesAndSurplus | double(20,2) | 是 | NULL | |||
| EqDividendRate | double(20,2) | 是 | NULL | |||
| AggregateofNonPromotoNoOfShares | double(20,2) | 是 | NULL | |||
| AggregateofNonPromotoHoldingPercent | double(20,2) | 是 | NULL | |||
| GovernmentShare | double(20,2) | 是 | NULL | |||
| CapitalAdequacyRatio | double(20,2) | 是 | NULL | |||
| CapitalAdequacyBaseII | double(20,2) | 是 | NULL | |||
| GrossNPA | double(20,2) | 是 | NULL | |||
| NetNPA | double(20,2) | 是 | NULL | |||
| Percentage_OfGrossNPA | double(20,2) | 是 | NULL | |||
| Percentage_OfNetNPA | double(20,2) | 是 | NULL | |||
| ReturnOnAssets_Per | double(20,2) | 是 | NULL | |||
| BeforeBasicEPS | double(20,2) | 是 | NULL | |||
| BeforeDilutedEPS | double(20,2) | 是 | NULL | |||
| AfterBasicEPS | double(20,2) | 是 | NULL | |||
| AfterDilutedEPS | double(20,2) | 是 | NULL | |||
| En_NumberOfShares | double(20,2) | 是 | NULL | |||
| En_Per_Share_As_Per_Of_Tot_Sh_Hol_of_Pro_And_Group | double(20,2) | 是 | NULL | |||
| En_Per_Share_As_Per_Of_Tot_Sh_Cap_of_Company | double(20,2) | 是 | NULL | |||
| NonEn_NumberOfShares | double(20,2) | 是 | NULL | |||
| NonEn_Per_Share_As_Per_Of_Tot_Sh_Hol_of_Pro_And_Group | double(20,2) | 是 | NULL | |||
| NonEn_Per_Share_As_Per_Of_Tot_Sh_Cap_of_Company | double(20,2) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 0 | A | 否 | |
| YearEnding | 0 | A | 否 | |||||
| Half | 0 | A | 否 |
IndustryMaster
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| IndustryCode (主键) | int(10) | 否 | ||||
| IndustryName | varchar(256) | 否 | ||||
| BroadIndustryCode | int(10) | 是 | NULL | |||
| BroadIndustryName | varchar(256) | 否 | ||||
| MajorSectorCode | int(10) | 否 | ||||
| MajorSectorName | varchar(256) | 否 | ||||
| ModifiedDate | varchar(40) | 否 | ||||
| DeleteFlag | int(1) | 否 |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | IndustryCode | 224 | A | 否 |
KeyExecutives
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(20,2) | 否 | ||||
| TitleDescription | varchar(40) | 是 | NULL | |||
| ExecutiveName | varchar(100) | 是 | NULL | |||
| DesignationDescription | varchar(100) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL | |||
| RowId | int(10) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 4954 | A | 否 |
ListingMaster
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| SecurityCode (主键) | varchar(40) | 否 | ||||
| ExchangeCode (主键) | int(10) | 否 | ||||
| ExchangeGroup | varchar(40) | 否 | ||||
| ScripCode1GivenByExchange | varchar(40) | 否 | ||||
| ScripCode2GivenByExchange | varchar(40) | 是 | NULL | |||
| DateOfListing | varchar(40) | 是 | NULL | |||
| DateOfDeListing | varchar(40) | 是 | NULL | |||
| DateOfReEnlisting | varchar(40) | 是 | NULL | |||
| FirstTradedDate | varchar(40) | 否 | ||||
| FirstTradedPrice | double(20,2) | 否 | ||||
| LastTradedDate | varchar(40) | 否 | ||||
| LastTradedPrice | double(20,2) | 否 | ||||
| FiftyTwoWeekHigh | double(20,2) | 是 | NULL | |||
| FiftyTwoWeekLow | double(20,2) | 是 | NULL | |||
| Highdate | varchar(40) | 是 | NULL | |||
| Lowdate | varchar(40) | 是 | NULL | |||
| CircuitLimit | int(10) | 是 | NULL | |||
| ReasonForModification | varchar(256) | 是 | NULL | |||
| DeleteFlag | int(1) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | ExchangeCode | 4 | A | 否 | |
| SecurityCode | 22196 | A | 否 |
ManagementTeam
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(20,2) | 否 | ||||
| TitleDescription | varchar(40) | 是 | NULL | |||
| PersonName | varchar(100) | 是 | NULL | |||
| DesignationDescription | varchar(100) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL | |||
| RowId | int(10) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 141 | A | 否 |
News
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| NewsId | int(10) | 否 | ||||
| DateTime | varchar(40) | 否 | ||||
| Headline | varchar(500) | 否 | ||||
| Category | varchar(100) | 否 | ||||
| CompanyCode | double(15,2) | 是 | NULL | |||
| CompanyName | varchar(256) | 是 | NULL | |||
| NewsText | varchar(10000) | 否 |
NineMonthsResults
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(20,2) | 否 | ||||
| YearEnding (主键) | varchar(40) | 否 | ||||
| Months | int(10) | 否 | ||||
| Nine | int(10) | 否 | ||||
| OperatingIncome | double(20,2) | 是 | NULL | |||
| OtherOperatingIncome | double(20,2) | 是 | NULL | |||
| TotalIncomeFromOperations | double(20,2) | 是 | NULL | |||
| IntOrDiscOnAdvOrBills | double(20,2) | 是 | NULL | |||
| IncomeOnInvestment | double(20,2) | 是 | NULL | |||
| IntOnBalancesWithRBI | double(20,2) | 是 | NULL | |||
| Others | double(20,2) | 是 | NULL | |||
| OtherRecurringIncome | double(20,2) | 是 | NULL | |||
| StockAdjustment | double(20,2) | 是 | NULL | |||
| RawMaterialConsumed | double(20,2) | 是 | NULL | |||
| PurchaseOfTradedGoods | double(20,2) | 是 | NULL | |||
| PowerAndFuel | double(20,2) | 是 | NULL | |||
| EmployeeExpenses | double(20,2) | 是 | NULL | |||
| Excise | double(20,2) | 是 | NULL | |||
| AdminAndSellingExpenses | double(20,2) | 是 | NULL | |||
| ResearchAndDevlopmentExpenses | double(20,2) | 是 | NULL | |||
| ExpensesCapitalised | double(20,2) | 是 | NULL | |||
| OtherExpenses | double(20,2) | 是 | NULL | |||
| PL_Before_OtherInc_Int_ExcpItem_Tax | double(20,2) | 是 | NULL | |||
| PL_Before_Int_ExcpItem_Tax | double(20,2) | 是 | NULL | |||
| InterestCharges | double(20,2) | 是 | NULL | |||
| PL_Before_ExcpItem_Tax | double(20,2) | 是 | NULL | |||
| ExceptionalItems | double(20,2) | 是 | NULL | |||
| Depreciation | double(20,2) | 是 | NULL | |||
| OperatingProfitBeforeProvisionsAndContingencies | double(20,2) | 是 | NULL | |||
| BankProvisionsMade | double(20,2) | 是 | NULL | |||
| PL_Before_Tax | double(20,2) | 是 | NULL | |||
| TaxCharges | double(20,2) | 是 | NULL | |||
| PL_After_TaxFromOrdineryActivities | double(20,2) | 是 | NULL | |||
| ExtraOrdinaryItem | double(20,2) | 是 | NULL | |||
| ReportedPAT | double(20,2) | 是 | NULL | |||
| PriorYearAdj | double(20,2) | 是 | NULL | |||
| ReservesWrittenBack | double(20,2) | 是 | NULL | |||
| EquityCapital | double(20,2) | 是 | NULL | |||
| ReservesAndSurplus | double(20,2) | 是 | NULL | |||
| EqDividendRate | double(20,2) | 是 | NULL | |||
| AggregateofNonPromotoNoOfShares | double(20,2) | 是 | NULL | |||
| AggregateofNonPromotoHoldingPercent | double(20,2) | 是 | NULL | |||
| GovernmentShare | double(20,2) | 是 | NULL | |||
| CapitalAdequacyRatio | double(20,2) | 是 | NULL | |||
| CapitalAdequacyBaseII | double(20,2) | 是 | NULL | |||
| GrossNPA | double(20,2) | 是 | NULL | |||
| NetNPA | double(20,2) | 是 | NULL | |||
| Percentage_OfGrossNPA | double(20,2) | 是 | NULL | |||
| Percentage_OfNetNPA | double(20,2) | 是 | NULL | |||
| ReturnOnAssets_Per | double(20,2) | 是 | NULL | |||
| BeforeBasicEPS | double(20,2) | 是 | NULL | |||
| BeforeDilutedEPS | double(20,2) | 是 | NULL | |||
| AfterBasicEPS | double(20,2) | 是 | NULL | |||
| AfterDilutedEPS | double(20,2) | 是 | NULL | |||
| En_NumberOfShares | double(20,2) | 是 | NULL | |||
| En_Per_Share_As_Per_Of_Tot_Sh_Hol_of_Pro_And_Group | double(20,2) | 是 | NULL | |||
| En_Per_Share_As_Per_Of_Tot_Sh_Cap_of_Company | double(20,2) | 是 | NULL | |||
| NonEn_NumberOfShares | double(20,2) | 是 | NULL | |||
| NonEn_Per_Share_As_Per_Of_Tot_Sh_Hol_of_Pro_And_Group | double(20,2) | 是 | NULL | |||
| NonEn_Per_Share_As_Per_Of_Tot_Sh_Cap_of_Company | double(20,2) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 0 | A | 否 | |
| YearEnding | 0 | A | 否 |
NseBseIndexConstituents
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| IndexName (主键) | varchar(40) | 否 | ||||
| CompanyCode (主键) | double(20,2) | 否 | ||||
| ISINCode | varchar(40) | 否 | ||||
| Weightage | double(20,2) | 否 | ||||
| Exch | varchar(40) | 否 |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | IndexName | 0 | A | 否 | |
| CompanyCode | 0 | A | 否 |
QuarterlyResults
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(20,2) | 否 | ||||
| YearEnding (主键) | varchar(40) | 否 | ||||
| Months | int(10) | 否 | ||||
| Quarter | int(10) | 否 | ||||
| OperatingIncome | double(20,2) | 是 | NULL | |||
| OtherOperatingIncome | double(20,2) | 是 | NULL | |||
| TotalIncomeFromOperations | double(20,2) | 是 | NULL | |||
| IntOrDiscOnAdvOrBills | double(20,2) | 是 | NULL | |||
| IncomeOnInvestment | double(20,2) | 是 | NULL | |||
| IntOnBalancesWithRBI | double(20,2) | 是 | NULL | |||
| Others | double(20,2) | 是 | NULL | |||
| OtherRecurringIncome | double(20,2) | 是 | NULL | |||
| StockAdjustment | double(20,2) | 是 | NULL | |||
| RawMaterialConsumed | double(20,2) | 是 | NULL | |||
| PurchaseOfTradedGoods | double(20,2) | 是 | NULL | |||
| PowerAndFuel | double(20,2) | 是 | NULL | |||
| EmployeeExpenses | double(20,2) | 是 | NULL | |||
| Excise | double(20,2) | 是 | NULL | |||
| AdminAndSellingExpenses | double(20,2) | 是 | NULL | |||
| ResearchAndDevlopmentExpenses | double(20,2) | 是 | NULL | |||
| ExpensesCapitalised | double(20,2) | 是 | NULL | |||
| OtherExpenses | double(20,2) | 是 | NULL | |||
| PL_Before_OtherInc_Int_ExcpItem_Tax | double(20,2) | 是 | NULL | |||
| PL_Before_Int_ExcpItem_Tax | double(20,2) | 是 | NULL | |||
| InterestCharges | double(20,2) | 是 | NULL | |||
| PL_Before_ExcpItem_Tax | double(20,2) | 是 | NULL | |||
| ExceptionalItems | double(20,2) | 是 | NULL | |||
| Depreciation | double(20,2) | 是 | NULL | |||
| OperatingProfitBeforeProvisionsAndContingencies | double(20,2) | 是 | NULL | |||
| BankProvisionsMade | double(20,2) | 是 | NULL | |||
| PL_Before_Tax | double(20,2) | 是 | NULL | |||
| TaxCharges | double(20,2) | 是 | NULL | |||
| PL_After_TaxFromOrdineryActivities | double(20,2) | 是 | NULL | |||
| ExtraOrdinaryItem | double(20,2) | 是 | NULL | |||
| ReportedPAT | double(20,2) | 是 | NULL | |||
| PriorYearAdj | double(20,2) | 是 | NULL | |||
| ReservesWrittenBack | double(20,2) | 是 | NULL | |||
| EquityCapital | double(20,2) | 是 | NULL | |||
| ReservesAndSurplus | double(20,2) | 是 | NULL | |||
| EqDividendRate | double(20,2) | 是 | NULL | |||
| AggregateofNonPromotoNoOfShares | double(20,2) | 是 | NULL | |||
| AggregateofNonPromotoHoldingPercent | double(20,2) | 是 | NULL | |||
| GovernmentShare | double(20,2) | 是 | NULL | |||
| CapitalAdequacyRatio | double(20,2) | 是 | NULL | |||
| CapitalAdequacyBaseII | double(20,2) | 是 | NULL | |||
| GrossNPA | double(20,2) | 是 | NULL | |||
| NetNPA | double(20,2) | 是 | NULL | |||
| Percentage_OfGrossNPA | double(20,2) | 是 | NULL | |||
| Percentage_OfNetNPA | double(20,2) | 是 | NULL | |||
| ReturnOnAssets_Per | double(20,2) | 是 | NULL | |||
| BeforeBasicEPS | double(20,2) | 是 | NULL | |||
| BeforeDilutedEPS | double(20,2) | 是 | NULL | |||
| AfterBasicEPS | double(20,2) | 是 | NULL | |||
| AfterDilutedEPS | double(20,2) | 是 | NULL | |||
| En_NumberOfShares | double(20,2) | 是 | NULL | |||
| En_Per_Share_As_Per_Of_Tot_Sh_Hol_of_Pro_And_Group | double(20,2) | 是 | NULL | |||
| En_Per_Share_As_Per_Of_Tot_Sh_Cap_of_Company | double(20,2) | 是 | NULL | |||
| NonEn_NumberOfShares | double(20,2) | 是 | NULL | |||
| NonEn_Per_Share_As_Per_Of_Tot_Sh_Hol_of_Pro_And_Group | double(20,2) | 是 | NULL | |||
| NonEn_Per_Share_As_Per_Of_Tot_Sh_Cap_of_Company | double(20,2) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 0 | A | 否 | |
| YearEnding | 0 | A | 否 |
RatiosBankingVI
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(20,2) | 否 | ||||
| YearEnding (主键) | varchar(40) | 否 | ||||
| Months | int(10) | 否 | ||||
| Type | varchar(10) | 否 | ||||
| FaceValue | double(20,2) | 是 | NULL | |||
| BasicEPS | double(20,2) | 是 | NULL | |||
| DilutedEPS | double(20,2) | 是 | NULL | |||
| CashEPS | double(20,2) | 是 | NULL | |||
| BVPerShareExclRevalReserve | double(20,2) | 是 | NULL | |||
| BVPerShareInclRevalReserve | double(20,2) | 是 | NULL | |||
| DividendPerShare | double(20,2) | 是 | NULL | |||
| OperatingRevenuePerShare | double(20,2) | 是 | NULL | |||
| NPPerShare | double(20,2) | 是 | NULL | |||
| InterestIncomePerEmployee | double(20,2) | 是 | NULL | |||
| NPPerEmployee | double(20,2) | 是 | NULL | |||
| BusinessPerEmployee | double(20,2) | 是 | NULL | |||
| InterestIncomePerBranch | double(20,2) | 是 | NULL | |||
| NPPerBranches | double(20,2) | 是 | NULL | |||
| BusinessPerBranches | double(20,2) | 是 | NULL | |||
| NPM | double(20,2) | 是 | NULL | |||
| OPM | double(20,2) | 是 | NULL | |||
| ROA | double(20,2) | 是 | NULL | |||
| ROE | double(20,2) | 是 | NULL | |||
| NIM | double(20,2) | 是 | NULL | |||
| CostToIncome | double(20,2) | 是 | NULL | |||
| InterestIncomeByEarningAssets | double(20,2) | 是 | NULL | |||
| NonInterestIncomeByEarningAssets | double(20,2) | 是 | NULL | |||
| OperatingProfitByEarningAssets | double(20,2) | 是 | NULL | |||
| OperatingExpensesByEarningAssets | double(20,2) | 是 | NULL | |||
| InterestExpensesByEarningAssets | double(20,2) | 是 | NULL | |||
| EnterpriseValue | double(20,2) | 是 | NULL | |||
| EVPerNetSales | double(20,2) | 是 | NULL | |||
| PriceToBV | double(20,2) | 是 | NULL | |||
| PriceToSales | double(20,2) | 是 | NULL | |||
| RetentionRatios | double(20,2) | 是 | NULL | |||
| EarningsYield | double(20,2) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 0 | A | 否 | |
| YearEnding | 0 | A | 否 |
RatiosNonBankingVI
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(20,2) | 否 | ||||
| YearEnding (主键) | varchar(40) | 否 | ||||
| Months | int(10) | 否 | ||||
| Type | varchar(10) | 否 | ||||
| FaceValue | double(20,2) | 是 | NULL | |||
| BasicEPS | double(20,2) | 是 | NULL | |||
| DilutedEPS | double(20,2) | 是 | NULL | |||
| CashEPS | double(20,2) | 是 | NULL | |||
| BVPerShareExclRevalReserve | double(20,2) | 是 | NULL | |||
| BVPerShareInclRevalReserve | double(20,2) | 是 | NULL | |||
| DividendPerShare | double(20,2) | 是 | NULL | |||
| OperatingRevenuePerShare | double(20,2) | 是 | NULL | |||
| PBDITPerShare | double(20,2) | 是 | NULL | |||
| PBITPerShare | double(20,2) | 是 | NULL | |||
| PBTPerShare | double(20,2) | 是 | NULL | |||
| NPperShare | double(20,2) | 是 | NULL | |||
| PBDITMargin | double(20,2) | 是 | NULL | |||
| PBITMargin | double(20,2) | 是 | NULL | |||
| PBTMargin | double(20,2) | 是 | NULL | |||
| NPMargin | double(20,2) | 是 | NULL | |||
| RONW | double(20,2) | 是 | NULL | |||
| ROCE | double(20,2) | 是 | NULL | |||
| ReturnOnAssets | double(20,2) | 是 | NULL | |||
| LongTermDebtEquity | double(20,2) | 是 | NULL | |||
| DebtEquity | double(20,2) | 是 | NULL | |||
| AssetTurnover | double(20,2) | 是 | NULL | |||
| CurrentRatio | double(20,2) | 是 | NULL | |||
| QuickRatio | double(20,2) | 是 | NULL | |||
| InventoryTurnoverRatio | double(20,2) | 是 | NULL | |||
| DividendPayoutNP | double(20,2) | 是 | NULL | |||
| DividendPayoutCP | double(20,2) | 是 | NULL | |||
| EarningRetention | double(20,2) | 是 | NULL | |||
| CashEarningRetention | double(20,2) | 是 | NULL | |||
| InterestCoverage | double(20,2) | 是 | NULL | |||
| InterestCoveragePostTax | double(20,2) | 是 | NULL | |||
| EnterpriseValue | double(20,2) | 是 | NULL | |||
| EVPerNetSales | double(20,2) | 是 | NULL | |||
| EVPerEBITDA | double(20,2) | 是 | NULL | |||
| MarketCapPerSales | double(20,2) | 是 | NULL | |||
| RetentionRatios | double(20,2) | 是 | NULL | |||
| PriceToBV | double(20,2) | 是 | NULL | |||
| PriceToSales | double(20,2) | 是 | NULL | |||
| EarningsYield | double(20,2) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 0 | A | 否 | |
| YearEnding | 0 | A | 否 |
SecurityMaster
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode | double(20,2) | 否 | ||||
| SecurityTypeCode | bigint(20) | 否 | ||||
| SecuritySubTypeCode | bigint(20) | 否 | ||||
| SerialNumber | int(10) | 否 | ||||
| SecurityCode (主键) | varchar(40) | 否 | ||||
| Ticker | varchar(40) | 否 | ||||
| IssuePrice | double(20,2) | 是 | NULL | |||
| Description | varchar(200) | 否 | ||||
| DateOfIssue | varchar(40) | 是 | NULL | |||
| DateOfExpiry | varchar(40) | 是 | NULL | |||
| FaceValue | double(20,2) | 是 | NULL | |||
| MarketLot | int(10) | 是 | NULL | |||
| ISINCode | varchar(30) | 是 | NULL | |||
| Remarks | varchar(500) | 是 | NULL | |||
| ReasonForModification | varchar(256) | 是 | NULL | |||
| IsItActiveSecurity | int(1) | 否 | ||||
| DeleteFlag | int(1) | 否 | ||||
| ModifiedDate | varchar(40) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | SecurityCode | 26906 | A | 否 |
ShareholdingDetails
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| CompanyCode (主键) | double(12,2) | 否 | ||||
| HoldingDate (主键) | varchar(40) | 否 | ||||
| InstrumentDescription | varchar(50) | 否 | ||||
| Category | varchar(254) | 是 | NULL | |||
| SubCategory | varchar(254) | 是 | NULL | |||
| Level | varchar(254) | 是 | NULL | |||
| ShareholderDescription | varchar(254) | 是 | NULL | |||
| NoOfshareholders | bigint(20) | 是 | NULL | |||
| FullyPaidUpShares | bigint(20) | 是 | NULL | |||
| PartlyPaidUpShares | bigint(20) | 是 | NULL | |||
| UnderlyingDR | bigint(20) | 是 | NULL | |||
| TotalShares | bigint(20) | 是 | NULL | |||
| PercentageSCRR | double(20,2) | 是 | NULL | |||
| UnderlyingOutstandingConvertibleSecurities | bigint(20) | 是 | NULL | |||
| PercentageFullConversionOfConvertibleSecurities | double(20,2) | 是 | NULL | |||
| LockedSharesNos | bigint(20) | 是 | NULL | |||
| LockedSharesPercentage | double(20,2) | 是 | NULL | |||
| PledgeSharesNos | bigint(20) | 是 | NULL | |||
| PledgeSharesPercentage | double(20,2) | 是 | NULL | |||
| NoOfSharesDemat | bigint(20) | 是 | NULL | |||
| NoOfVotingRightsClassX | bigint(20) | 是 | NULL | |||
| NoOfVotingRightsClassY | bigint(20) | 是 | NULL | |||
| NoOfVotingRightsTotal | bigint(20) | 是 | NULL | |||
| NoOfVotingRightsPercentage | double(20,2) | 是 | NULL | |||
| RowId | int(10) | 是 | NULL | |||
| ModifiedDate | varchar(40) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | CompanyCode | 541 | A | 否 | |
| HoldingDate | 1083 | A | 否 |