NorenAccordComapnyData
BalanceSheet
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| fin_code (主键) | int(15) | 否 | ||||
| Year_end (主键) | int(15) | 否 | ||||
| Type (主键) | varchar(1) | 否 | ||||
| No_months | int(15) | 是 | NULL | |||
| Unit | int(15) | 是 | NULL | |||
| Share_Capital | double(20,2) | 是 | NULL | |||
| Shares_warrants | double(20,2) | 是 | NULL | |||
| Shares_application_money | double(20,2) | 是 | NULL | |||
| ESOP_Outstanding | double(20,2) | 是 | NULL | |||
| Share_suspense | double(20,2) | 是 | NULL | |||
| Reserve | double(20,2) | 是 | NULL | |||
| Sharehoders_funds | double(20,2) | 是 | NULL | |||
| Deposits | double(20,2) | 是 | NULL | |||
| Borrowings | double(20,2) | 是 | NULL | |||
| Other_liabilities | double(20,2) | 是 | NULL | |||
| Total_sounces_Funds | double(20,2) | 是 | NULL | |||
| Cash_balances_RBI | double(20,2) | 是 | NULL | |||
| Bank_Call_money | double(20,2) | 是 | NULL | |||
| Investments | double(20,2) | 是 | NULL | |||
| Advances | double(20,2) | 是 | NULL | |||
| Gross_block | double(20,2) | 是 | NULL | |||
| Acc_Depreciation | double(20,2) | 是 | NULL | |||
| Impairment_assets | double(20,2) | 是 | NULL | |||
| Lease_adj | double(20,2) | 是 | NULL | |||
| CWIP | double(20,2) | 是 | NULL | |||
| Other_Assets | double(20,2) | 是 | NULL | |||
| Total_Applications | double(20,2) | 是 | NULL | |||
| Contingent_liabilities | double(20,2) | 是 | NULL | |||
| Bills_For_Collection | double(20,2) | 是 | NULL | |||
| Ltrm_Borrowing | double(20,2) | 是 | NULL | |||
| Secured_Loans | double(20,2) | 是 | NULL | |||
| Unsecured_Loans_Nf | double(20,2) | 是 | NULL | |||
| Net_Def_Tax_Nf | double(20,2) | 是 | NULL | |||
| Oth_Lt_Liab | double(20,2) | 是 | NULL | |||
| Lt_Trade_Payables | double(20,2) | 是 | NULL | |||
| Lt_Provisions | double(20,2) | 是 | NULL | |||
| Total_Nonliab | double(20,2) | 是 | NULL | |||
| Trade_Payables | double(20,2) | 是 | NULL | |||
| Current_Liabilities_Nf | double(20,2) | 是 | NULL | |||
| St_Borrowings | double(20,2) | 是 | NULL | |||
| Provisions | double(20,2) | 是 | NULL | |||
| Current_Laib_Prov_Nf | double(20,2) | 是 | NULL | |||
| Total_Sounces_Funds_Nf | double(20,2) | 是 | NULL | |||
| Non_Current_Assets | double(20,2) | 是 | NULL | |||
| Loan_Non_Cuurent_Assets | double(20,2) | 是 | NULL | |||
| Net_Block | double(20,2) | 是 | NULL | |||
| Cwip_Nf | double(20,2) | 是 | NULL | |||
| Intang_Assetunderdev | double(20,2) | 是 | NULL | |||
| Pre_Operatieve_Exps | double(20,2) | 是 | NULL | |||
| Assetsintransit | double(20,2) | 是 | NULL | |||
| Investments_Nf | double(20,2) | 是 | NULL | |||
| Lt_Loanadv | double(20,2) | 是 | NULL | |||
| Other_Noc_Assets | double(20,2) | 是 | NULL | |||
| Total_Nonassets | double(20,2) | 是 | NULL | |||
| Current_Investments | double(20,2) | 是 | NULL | |||
| Inventory | double(20,2) | 是 | NULL | |||
| Debtors | double(20,2) | 是 | NULL | |||
| Cash_Bank | double(20,2) | 是 | NULL | |||
| Other_Current_Nf | double(20,2) | 是 | NULL | |||
| Loans_Adv | double(20,2) | 是 | NULL | |||
| Currant_Assets_Nf | double(20,2) | 是 | NULL | |||
| Net_Current_Assets_Nf | double(20,2) | 是 | NULL | |||
| Other_Crnt_Assets | double(20,2) | 是 | NULL | |||
| Misc_Exps_Not_Wo | double(20,2) | 是 | NULL | |||
| Total_Applications_Nf | double(20,2) | 是 | NULL | |||
| Total_Debt_Inclst_Nf | double(20,2) | 是 | NULL | |||
| Book_Nav_Share | double(20,2) | 是 | NULL | |||
| Adj_Bv | double(20,2) | 是 | NULL | |||
| Minority_Interest | double(20,2) | 是 | NULL | |||
| Equity_Authorised | double(20,2) | 是 | NULL | |||
| Equity_Issued | double(20,2) | 是 | NULL | |||
| EQUITY_PAIDUP | double(20,2) | 是 | NULL | |||
| Equity_Forfeited | double(20,2) | 是 | NULL | |||
| Adj_Equity | double(20,2) | 是 | NULL | |||
| Preference_Capital | double(20,2) | 是 | NULL | |||
| FACE_VALUE | double(20,2) | 是 | NULL | |||
| Share_Premium | double(20,2) | 是 | NULL | |||
| Capital_Reserve | double(20,2) | 是 | NULL | |||
| Profit_Loss | double(20,2) | 是 | NULL | |||
| General_Reserve | double(20,2) | 是 | NULL | |||
| Reserve_Excl_Revaluation | double(20,2) | 是 | NULL | |||
| Revaluation_Reserve | double(20,2) | 是 | NULL | |||
| Demand_Deposits | double(20,2) | 是 | NULL | |||
| Saving_Deposits | double(20,2) | 是 | NULL | |||
| Term_Fixed_Deposits | double(20,2) | 是 | NULL | |||
| Current_Deposits | double(20,2) | 是 | NULL | |||
| Recurring_Deposits | double(20,2) | 是 | NULL | |||
| Borrowings_RBI | double(20,2) | 是 | NULL | |||
| Borrowings_Banks | double(20,2) | 是 | NULL | |||
| Borrowings_GOI | double(20,2) | 是 | NULL | |||
| Borrowings_FI | double(20,2) | 是 | NULL | |||
| Borrowings_Bonds | double(20,2) | 是 | NULL | |||
| Borrowings_Other | double(20,2) | 是 | NULL | |||
| Borrowings_Outof_India | double(20,2) | 是 | NULL | |||
| Bills_payable | double(20,2) | 是 | NULL | |||
| Inter_oofice_adjustments_liabilities | double(20,2) | 是 | NULL | |||
| Interest_accrued | double(20,2) | 是 | NULL | |||
| Proposed_dividend | double(20,2) | 是 | NULL | |||
| Corporate_dividend_tax | double(20,2) | 是 | NULL | |||
| Cash_RBI | double(20,2) | 是 | NULL | |||
| Cash_In_hand | double(20,2) | 是 | NULL | |||
| Investments_India | double(20,2) | 是 | NULL | |||
| GOI_Securities | double(20,2) | 是 | NULL | |||
| Equity_Shares_corporate | double(20,2) | 是 | NULL | |||
| Debentures_Bonds | double(20,2) | 是 | NULL | |||
| Subsidiaries_Joint_ventures | double(20,2) | 是 | NULL | |||
| Mutual_Funds_insurance_Units | double(20,2) | 是 | NULL | |||
| Investments_Outside_India | double(20,2) | 是 | NULL | |||
| GOI_Securities_Outside_india | double(20,2) | 是 | NULL | |||
| Subsidiaries_Joint_ventures_outside_india | double(20,2) | 是 | NULL | |||
| Other_investments_outside_India | double(20,2) | 是 | NULL | |||
| Dimunition_Investments | double(20,2) | 是 | NULL | |||
| Bills_purchased_discounted | double(20,2) | 是 | NULL | |||
| Cash_credit_overdraft | double(20,2) | 是 | NULL | |||
| Term_Loans | double(20,2) | 是 | NULL | |||
| Finance_Lease_Hire_purchase | double(20,2) | 是 | NULL | |||
| Buildings | double(20,2) | 是 | NULL | |||
| Assets_despose | double(20,2) | 是 | NULL | |||
| Other_fix_assets | double(20,2) | 是 | NULL | |||
| Inter_office_adjustments_Assets | double(20,2) | 是 | NULL | |||
| Interest_accrued_assets | double(20,2) | 是 | NULL | |||
| Advance_tax_TDS | double(20,2) | 是 | NULL | |||
| Stationery_stamps | double(20,2) | 是 | NULL | |||
| Non_banking_assets | double(20,2) | 是 | NULL | |||
| Deferred_tax_Assets | double(20,2) | 是 | NULL | |||
| Misc_expenditures_Not_writtoff | double(20,2) | 是 | NULL | |||
| Claims_Not_acknowledge_debt | double(20,2) | 是 | NULL | |||
| Outstanding_Forward_Exchange_Contract | double(20,2) | 是 | NULL | |||
| Guarantees_Constituents_India | double(20,2) | 是 | NULL | |||
| Guarantees_Constituents_Outside_India | double(20,2) | 是 | NULL | |||
| Acceptances_Endorsements_Obligations | double(20,2) | 是 | NULL | |||
| Non_Convertible_Debenture | double(20,2) | 是 | NULL | |||
| Conv_Debenture_Bnds | double(20,2) | 是 | NULL | |||
| Packing_Credit | double(20,2) | 是 | NULL | |||
| Intercorpsecdeposits | double(20,2) | 是 | NULL | |||
| Term_Loan_Bank | double(20,2) | 是 | NULL | |||
| Term_Loan_Inst | double(20,2) | 是 | NULL | |||
| Fixed_Deposits | double(20,2) | 是 | NULL | |||
| Loans_Susidiaries | double(20,2) | 是 | NULL | |||
| Inter_Corp_Deposits | double(20,2) | 是 | NULL | |||
| Foreign_Curr_Convertible_Notes | double(20,2) | 是 | NULL | |||
| Foreign_Curr_Long_Term_Loans | double(20,2) | 是 | NULL | |||
| Loans_Bank | double(20,2) | 是 | NULL | |||
| Loans_Govt | double(20,2) | 是 | NULL | |||
| Loans_Others | double(20,2) | 是 | NULL | |||
| Def_Tax_Assets | double(20,2) | 是 | NULL | |||
| Def_Tax_Liability | double(20,2) | 是 | NULL | |||
| Sundry_Crs | double(20,2) | 是 | NULL | |||
| Acceptances | double(20,2) | 是 | NULL | |||
| Trade_Paysubs | double(20,2) | 是 | NULL | |||
| Bank_Od | double(20,2) | 是 | NULL | |||
| Adv_Customers | double(20,2) | 是 | NULL | |||
| Interest_Not_Due | double(20,2) | 是 | NULL | |||
| Share_Application | double(20,2) | 是 | NULL | |||
| Cl_Curmat_Deb | double(20,2) | 是 | NULL | |||
| Cl_Curmat_Others | double(20,2) | 是 | NULL | |||
| Loans | double(20,2) | 是 | NULL | |||
| Stbs_Sec_Loandemand | double(20,2) | 是 | NULL | |||
| Stbs_Wcap | double(20,2) | 是 | NULL | |||
| Stbu_Buycredit | double(20,2) | 是 | NULL | |||
| Stbu_Commborr | double(20,2) | 是 | NULL | |||
| Proposed_Divided | double(20,2) | 是 | NULL | |||
| Prov_Corp_Tax | double(20,2) | 是 | NULL | |||
| Prov_Tax | double(20,2) | 是 | NULL | |||
| Prov_Retirements | double(20,2) | 是 | NULL | |||
| Prefence_Dividend | double(20,2) | 是 | NULL | |||
| Long_Term_Investments_Nf | double(20,2) | 是 | NULL | |||
| Long_Term_Quoted | double(20,2) | 是 | NULL | |||
| Long_Term_Unquoted | double(20,2) | 是 | NULL | |||
| CURRENT_QUOTED | double(20,2) | 是 | NULL | |||
| Raw_Material | double(20,2) | 是 | NULL | |||
| Wip | double(20,2) | 是 | NULL | |||
| Fin_Goods | double(20,2) | 是 | NULL | |||
| Packing_Materials_Inventory | double(20,2) | 是 | NULL | |||
| Store_Spares | double(20,2) | 是 | NULL | |||
| Drs_Six_Months | double(20,2) | 是 | NULL | |||
| Drs_Others | double(20,2) | 是 | NULL | |||
| Cash_Hand | double(20,2) | 是 | NULL | |||
| Bank_Balance | double(20,2) | 是 | NULL | |||
| Interest_Investments | double(20,2) | 是 | NULL | |||
| Interest_Debentures | double(20,2) | 是 | NULL | |||
| Deposits_Govt_Other | double(20,2) | 是 | NULL | |||
| Interest_Accrued_Due | double(20,2) | 是 | NULL | |||
| Prepaid_Exps | double(20,2) | 是 | NULL | |||
| Adv_Cash_Kind | double(20,2) | 是 | NULL | |||
| Adv_Tax | double(20,2) | 是 | NULL | |||
| Due_Director | double(20,2) | 是 | NULL | |||
| Due_Subsidiaries | double(20,2) | 是 | NULL | |||
| Inter_Corporate_Deposits | double(20,2) | 是 | NULL | |||
| Corporate_Deposits | double(20,2) | 是 | NULL | |||
| FLAG | varchar(1) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | fin_code | 19127 | A | 否 | |
| Year_end | 57382 | A | 否 | |||||
| Type | 57382 | A | 否 |
BoardMaster
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| fin_code (主键) | int(10) | 否 | ||||
| yrc (主键) | int(10) | 否 | ||||
| serial_num (主键) | int(10) | 否 | ||||
| dir_type_id (主键) | int(10) | 否 | ||||
| srno | int(10) | 是 | NULL | |||
| effect_date | varchar(30) | 是 | NULL | |||
| dir_name | varchar(255) | 是 | NULL | |||
| dir_rem | float(12,2) | 是 | NULL | |||
| reported_dsg | varchar(255) | 是 | NULL | |||
| rem_unit | float(12,2) | 是 | NULL | |||
| independent | varchar(100) | 是 | NULL | |||
| director_id | int(10) | 是 | NULL | |||
| flag | varchar(1) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | fin_code | 22536 | A | 否 | |
| yrc | 22536 | A | 否 | |||||
| serial_num | 67610 | A | 否 | |||||
| dir_type_id | 67610 | A | 否 |
CashFlow
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| fin_code (主键) | int(15) | 否 | ||||
| year_end (主键) | int(15) | 否 | ||||
| type (主键) | varchar(1) | 否 | ||||
| No_Months | int(15) | 是 | NULL | |||
| Unit | int(15) | 是 | NULL | |||
| Profit_bef_tax | double(20,2) | 是 | NULL | |||
| Adjustment_total | double(20,2) | 是 | NULL | |||
| Change_WC_total | double(20,2) | 是 | NULL | |||
| Tax_paid | double(20,2) | 是 | NULL | |||
| Other_Dir_exps | double(20,2) | 是 | NULL | |||
| Cash_from_Operation | double(20,2) | 是 | NULL | |||
| Cash_from_Investment | double(20,2) | 是 | NULL | |||
| Cash_from_Financing | double(20,2) | 是 | NULL | |||
| FExchDiff | double(20,2) | 是 | NULL | |||
| Net_Cash_inflow_outflow | double(20,2) | 是 | NULL | |||
| Opening_cash | double(20,2) | 是 | NULL | |||
| Cash_amalgmation | double(20,2) | 是 | NULL | |||
| Cash_subsidiaries | double(20,2) | 是 | NULL | |||
| Traslation_adj_Subsidiaries | double(20,2) | 是 | NULL | |||
| Effect_foreign_exchange | double(20,2) | 是 | NULL | |||
| Closing_cash | double(20,2) | 是 | NULL | |||
| Cashflow_after_WC | double(20,2) | 是 | NULL | |||
| flag | varchar(1) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | fin_code | 115 | A | 否 | |
| year_end | 463 | A | 否 | |||||
| type | 463 | A | 否 |
CompanyEquity
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| fin_code (主键) | int(15) | 否 | ||||
| year_end | int(15) | 是 | NULL | |||
| num_of_shares_sub | double(20,0) | 是 | NULL | |||
| latest_eqty | double(20,2) | 是 | NULL | |||
| latest_reserv | double(20,2) | 是 | NULL | |||
| price | double(20,2) | 是 | NULL | |||
| mcap | double(20,2) | 是 | NULL | |||
| yield | double(20,2) | 是 | NULL | |||
| fv | double(20,2) | 是 | NULL | |||
| book_value | double(20,2) | 是 | NULL | |||
| ttm_year_end | int(15) | 是 | NULL | |||
| ttm_eps | double(20,2) | 是 | NULL | |||
| ttm_pe | double(20,2) | 是 | NULL | |||
| price_sales | double(20,2) | 是 | NULL | |||
| ev_sales | double(20,2) | 是 | NULL | |||
| mcap_sales | double(20,2) | 是 | NULL | |||
| enterprice_value | double(20,2) | 是 | NULL | |||
| price_bv | double(20,2) | 是 | NULL | |||
| ev_ebitda | double(20,2) | 是 | NULL | |||
| ttm_ceps | double(20,2) | 是 | NULL | |||
| price_ceps | double(20,2) | 是 | NULL | |||
| price_date | varchar(30) | 是 | NULL | |||
| stk_exchange | varchar(25) | 是 | NULL | |||
| flag | varchar(1) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | fin_code | 6938 | A | 否 |
CompanyMaster
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| fin_code (主键) | int(10) | 否 | ||||
| scrip_code | int(10) | 是 | NULL | |||
| scrip_name | varchar(35) | 是 | NULL | |||
| scrip_group | varchar(3) | 是 | NULL | |||
| co_name | varchar(255) | 是 | NULL | |||
| ind_code | int(10) | 是 | NULL | |||
| industry | varchar(100) | 是 | NULL | |||
| hse_code | int(10) | 是 | NULL | |||
| house | varchar(50) | 是 | NULL | |||
| symbol | varchar(20) | 是 | NULL | |||
| series | varchar(2) | 是 | NULL | |||
| isin | varchar(20) | 是 | NULL | |||
| co_short_name | varchar(100) | 是 | NULL | |||
| res_format | varchar(5) | 是 | NULL | |||
| fin_format | varchar(5) | 是 | NULL | |||
| chairman | varchar(50) | 是 | NULL | |||
| mdir | varchar(100) | 是 | NULL | |||
| co_sec | varchar(100) | 是 | NULL | |||
| inc_month | varchar(15) | 是 | NULL | |||
| inc_year | varchar(4) | 是 | NULL | |||
| fv | float(10,2) | 是 | NULL | |||
| status | varchar(15) | 是 | NULL | |||
| sub_listing | varchar(50) | 是 | NULL | |||
| bse_scrip_id | varchar(100) | 是 | NULL | |||
| sec_token | int(10) | 是 | NULL | |||
| cin | varchar(255) | 是 | NULL | |||
| bse_sub_list | varchar(50) | 是 | NULL | |||
| nse_sub_list | varchar(50) | 是 | NULL | |||
| flag | varchar(1) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | fin_code | 48209 | A | 否 |
FinanceRatios
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| fin_code (主键) | int(15) | 否 | ||||
| Year_end (主键) | int(15) | 否 | ||||
| Type (主键) | varchar(1) | 否 | ||||
| Reported_EPS | double(20,2) | 是 | NULL | |||
| Adjusted_EPS | double(20,2) | 是 | NULL | |||
| CEPS | double(20,2) | 是 | NULL | |||
| DPS | double(20,2) | 是 | NULL | |||
| Book_NAV_Share | double(20,2) | 是 | NULL | |||
| Tax_Rate | double(20,2) | 是 | NULL | |||
| Core_EBITDA_Margin | double(20,2) | 是 | NULL | |||
| EBIT_Margin | double(20,2) | 是 | NULL | |||
| Pre_Tax_Margin | double(20,2) | 是 | NULL | |||
| PAT_Margin | double(20,2) | 是 | NULL | |||
| Cash_Profit_Margin | double(20,2) | 是 | NULL | |||
| ROA | double(20,2) | 是 | NULL | |||
| ROE | double(20,2) | 是 | NULL | |||
| ROCE | double(20,2) | 是 | NULL | |||
| Asset_Turnover | double(20,2) | 是 | NULL | |||
| Sales_Fixed_Asset | double(20,2) | 是 | NULL | |||
| Working_Capital_Sales | double(20,2) | 是 | NULL | |||
| Fixed_Capital_Sales | double(20,2) | 是 | NULL | |||
| Receivable_days | double(20,2) | 是 | NULL | |||
| Inventory_Days | double(20,2) | 是 | NULL | |||
| Payable_days | double(20,2) | 是 | NULL | |||
| PER | double(20,2) | 是 | NULL | |||
| PCE | double(20,2) | 是 | NULL | |||
| Price_Book | double(20,2) | 是 | NULL | |||
| Yield | double(20,2) | 是 | NULL | |||
| EV_Net_Sales | double(20,2) | 是 | NULL | |||
| EV_Core_EBITDA | double(20,2) | 是 | NULL | |||
| EV_EBIT | double(20,2) | 是 | NULL | |||
| EV_CE | double(20,2) | 是 | NULL | |||
| MCap_Sales | double(20,2) | 是 | NULL | |||
| Net_Sales_Growth | double(20,2) | 是 | NULL | |||
| PBIDT_Excl_OI_Growth | double(20,2) | 是 | NULL | |||
| Core_EBITDA_Growth | double(20,2) | 是 | NULL | |||
| EBIT_Growth | double(20,2) | 是 | NULL | |||
| PAT_Growth | double(20,2) | 是 | NULL | |||
| Adj_PAT_Growth | double(20,2) | 是 | NULL | |||
| Adj_EPS_Growth | double(20,2) | 是 | NULL | |||
| Reported_EPS_Growth | double(20,2) | 是 | NULL | |||
| Total_Debt_Equity | double(20,2) | 是 | NULL | |||
| Current_Ratio | double(20,2) | 是 | NULL | |||
| Quick_Ratio | double(20,2) | 是 | NULL | |||
| Interest_Cover | double(20,2) | 是 | NULL | |||
| Total_Debt_Mcap | double(20,2) | 是 | NULL | |||
| Yield_Adv | double(20,2) | 是 | NULL | |||
| Yield_Inv | double(20,2) | 是 | NULL | |||
| Cost_Liab | double(20,2) | 是 | NULL | |||
| NIM | double(20,2) | 是 | NULL | |||
| Int_Spread | double(20,2) | 是 | NULL | |||
| Cost_IncRatio | double(20,2) | 是 | NULL | |||
| Core_Cost_IncRatio | double(20,2) | 是 | NULL | |||
| OpCost_Asset | double(20,2) | 是 | NULL | |||
| Adj_PER | double(20,2) | 是 | NULL | |||
| Tier1Ratio | double(20,2) | 是 | NULL | |||
| Tier2Ratio | double(20,2) | 是 | NULL | |||
| CAR | double(20,2) | 是 | NULL | |||
| CoreOpIncomeGrowth | double(20,2) | 是 | NULL | |||
| EPSGrowth | double(20,2) | 是 | NULL | |||
| BVPSGrowth | double(20,2) | 是 | NULL | |||
| Adv_Growth | double(20,2) | 是 | NULL | |||
| LoanDeposits | double(20,2) | 是 | NULL | |||
| CashDeposits | double(20,2) | 是 | NULL | |||
| InvestmentDeposits | double(20,2) | 是 | NULL | |||
| IncLoanDeposits | double(20,2) | 是 | NULL | |||
| GrossNPA | double(20,2) | 是 | NULL | |||
| NetNPA | double(20,2) | 是 | NULL | |||
| Ownersfund_total_Source | double(20,2) | 是 | NULL | |||
| Fixed_Assets_TA | double(20,2) | 是 | NULL | |||
| Inventory_TR | double(20,2) | 是 | NULL | |||
| Dividend_PR_NP | double(20,2) | 是 | NULL | |||
| Dividend_PR_CP | double(20,2) | 是 | NULL | |||
| Earning_Retention_Ratio | double(20,2) | 是 | NULL | |||
| Cash_Earnings_Retention | double(20,2) | 是 | NULL | |||
| Price_BV | double(20,2) | 是 | NULL | |||
| Return_Sales | double(20,2) | 是 | NULL | |||
| Debt_TA | double(20,2) | 是 | NULL | |||
| EV | double(20,2) | 是 | NULL | |||
| PriceSalesRatio | double(20,2) | 是 | NULL | |||
| EV_EBITA | double(20,2) | 是 | NULL | |||
| CF_PerShare | double(20,2) | 是 | NULL | |||
| PCF_RATIO | double(20,2) | 是 | NULL | |||
| FCF_Share | double(20,2) | 是 | NULL | |||
| PFCF_Ratio | double(20,2) | 是 | NULL | |||
| FCF_Yield | double(20,2) | 是 | NULL | |||
| SCF_Ratio | double(20,2) | 是 | NULL | |||
| GPM | double(20,2) | 是 | NULL | |||
| SalesToTotalAssets | double(20,2) | 是 | NULL | |||
| SalesToCurrentAssets | double(20,2) | 是 | NULL | |||
| Total_CAR_baseI | double(20,2) | 是 | NULL | |||
| TI_CAR_baseI | double(20,2) | 是 | NULL | |||
| TII_CAR_baseI | double(20,2) | 是 | NULL | |||
| Total_CAR | double(20,2) | 是 | NULL | |||
| TI_CAR | double(20,2) | 是 | NULL | |||
| TII_CAR | double(20,2) | 是 | NULL | |||
| NPA_Gross | double(20,2) | 是 | NULL | |||
| NPA_Net | double(20,2) | 是 | NULL | |||
| NPA_Advances | double(20,2) | 是 | NULL | |||
| NetProfit_To_PBT | double(20,2) | 是 | NULL | |||
| PBT_To_PBIT | double(20,2) | 是 | NULL | |||
| PBIT_To_Sales | double(20,2) | 是 | NULL | |||
| NetProfit_To_Sales | double(20,2) | 是 | NULL | |||
| NetSales_To_TotalAssets | double(20,2) | 是 | NULL | |||
| Return_On_Assets | double(20,2) | 是 | NULL | |||
| Assets_To_Equity | double(20,2) | 是 | NULL | |||
| Return_On_Equity | double(20,2) | 是 | NULL | |||
| Interest_To_Debt | double(20,2) | 是 | NULL | |||
| Debt_To_Assets | double(20,2) | 是 | NULL | |||
| Interest_To_Assets | double(20,2) | 是 | NULL | |||
| ROE_After_Interest | double(20,2) | 是 | NULL | |||
| Dividend_Payout_Per | double(20,2) | 是 | NULL | |||
| OtherIncome_To_NetWorth | double(20,2) | 是 | NULL | |||
| ROA_After_Interest | double(20,2) | 是 | NULL | |||
| ROE_Before_OtherInc | double(20,2) | 是 | NULL | |||
| ROE_After_OtherInc | double(20,2) | 是 | NULL | |||
| ROE_After_Tax_Rate | double(20,2) | 是 | NULL | |||
| Credit_Deposit | double(20,2) | 是 | NULL | |||
| InterestExpended_InterestEarned | double(20,2) | 是 | NULL | |||
| InterestIncome_TotalFunds | double(20,2) | 是 | NULL | |||
| InterestExpended_TotalFunds | double(20,2) | 是 | NULL | |||
| NetInterestIncome_TotalFunds | double(20,2) | 是 | NULL | |||
| CASA | double(20,2) | 是 | NULL | |||
| Inventory_Turnover | double(20,2) | 是 | NULL | |||
| Debtors_Turnover | double(20,2) | 是 | NULL | |||
| Adj_PE | double(20,2) | 是 | NULL | |||
| Adjusted_bv | double(20,2) | 是 | NULL | |||
| Adj_DPS | double(20,2) | 是 | NULL | |||
| Networth_Growth | double(20,2) | 是 | NULL | |||
| CE_Growth | double(20,2) | 是 | NULL | |||
| GB_Growth | double(20,2) | 是 | NULL | |||
| PBDT_Growth | double(20,2) | 是 | NULL | |||
| PBIT_Growth | double(20,2) | 是 | NULL | |||
| PBT_Growth | double(20,2) | 是 | NULL | |||
| CP_Growth | double(20,2) | 是 | NULL | |||
| Exports_Growth | double(20,2) | 是 | NULL | |||
| Imports_Growth | double(20,2) | 是 | NULL | |||
| MCap_Growth | double(20,2) | 是 | NULL | |||
| EBIDTAM | double(20,2) | 是 | NULL | |||
| PBDTM | double(20,2) | 是 | NULL | |||
| LT_Debt_Equity_Ratio | double(20,2) | 是 | NULL | |||
| ROIC | double(20,2) | 是 | NULL | |||
| Total_car_b | double(20,2) | 是 | NULL | |||
| TI_CAR_b | double(20,2) | 是 | NULL | |||
| TII_CAR_b | double(20,2) | 是 | NULL | |||
| FLAG | varchar(1) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | fin_code | 8435 | A | 否 | |
| Year_end | 16871 | A | 否 | |||||
| Type | 16871 | A | 否 |
IndustryMaster
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| ind_code (主键) | int(10) | 否 | ||||
| industry | varchar(100) | 是 | NULL | |||
| ind_short_name | varchar(100) | 是 | NULL | |||
| sector | varchar(100) | 是 | NULL | |||
| sector_code | int(10) | 是 | NULL | |||
| flag | varchar(1) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | ind_code | 129 | A | 否 |
ProfitAndLoss
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| fin_code (主键) | int(15) | 否 | ||||
| Year_end (主键) | int(15) | 否 | ||||
| Type (主键) | varchar(1) | 否 | ||||
| No_months | int(15) | 是 | NULL | |||
| Unit | int(15) | 是 | NULL | |||
| Interest_earned | double(20,2) | 是 | NULL | |||
| Other_income | double(20,2) | 是 | NULL | |||
| Total_income | double(20,2) | 是 | NULL | |||
| Interest | double(20,2) | 是 | NULL | |||
| Operating_expenses | double(20,2) | 是 | NULL | |||
| Provisions_contigency | double(20,2) | 是 | NULL | |||
| Tax | double(20,2) | 是 | NULL | |||
| Total | double(20,2) | 是 | NULL | |||
| Profit_after_tax | double(20,2) | 是 | NULL | |||
| extra_items | double(20,2) | 是 | NULL | |||
| Profit_Brought_forward | double(20,2) | 是 | NULL | |||
| Minority_interest | double(20,2) | 是 | NULL | |||
| Share_Associate | double(20,2) | 是 | NULL | |||
| Other_ConsItems | double(20,2) | 是 | NULL | |||
| Consolidated_NetProfit | double(20,2) | 是 | NULL | |||
| Adj_Net_profit | double(20,2) | 是 | NULL | |||
| Extr_Items | double(20,2) | 是 | NULL | |||
| PNLBF | double(20,2) | 是 | NULL | |||
| Profit_availble_appr | double(20,2) | 是 | NULL | |||
| Appropriation | double(20,2) | 是 | NULL | |||
| Dividend_perc | double(20,2) | 是 | NULL | |||
| Reported_EPS | double(20,2) | 是 | NULL | |||
| Gross_sales | double(20,2) | 是 | NULL | |||
| Net_sales | double(20,2) | 是 | NULL | |||
| Inc_Dec_Inventory | double(20,2) | 是 | NULL | |||
| Raw_matrs_consumed | double(20,2) | 是 | NULL | |||
| Employees | double(20,2) | 是 | NULL | |||
| Other_Mfg_Exps | double(20,2) | 是 | NULL | |||
| Sellg_Admn_Exps | double(20,2) | 是 | NULL | |||
| Misc_exps | double(20,2) | 是 | NULL | |||
| Pre_Op_exps | double(20,2) | 是 | NULL | |||
| Total_expendiure | double(20,2) | 是 | NULL | |||
| Operating_profit | double(20,2) | 是 | NULL | |||
| Depreciation | double(20,2) | 是 | NULL | |||
| Profit_before_exception | double(20,2) | 是 | NULL | |||
| ExceptionalIncome_Expenses | double(20,2) | 是 | NULL | |||
| Profit_before_tax | double(20,2) | 是 | NULL | |||
| Taxation | double(20,2) | 是 | NULL | |||
| Profit_available_appropriation | double(20,2) | 是 | NULL | |||
| Total_gross_sales | double(20,2) | 是 | NULL | |||
| Excise | double(20,2) | 是 | NULL | |||
| Power_Fuel | double(20,2) | 是 | NULL | |||
| Gross_profits | double(20,2) | 是 | NULL | |||
| inter_div_trf | double(20,2) | 是 | NULL | |||
| Sales_return | double(20,2) | 是 | NULL | |||
| Sellg_Exps | double(20,2) | 是 | NULL | |||
| Cost_SW | double(20,2) | 是 | NULL | |||
| Provision_investment | double(20,2) | 是 | NULL | |||
| Provision_advances | double(20,2) | 是 | NULL | |||
| Provision_other | double(20,2) | 是 | NULL | |||
| Curr_tax | double(20,2) | 是 | NULL | |||
| Def_tax | double(20,2) | 是 | NULL | |||
| Fringe_benefits | double(20,2) | 是 | NULL | |||
| Wealth_tax | double(20,2) | 是 | NULL | |||
| Interest_advances_Bills | double(20,2) | 是 | NULL | |||
| Job_works | double(20,2) | 是 | NULL | |||
| Service_income | double(20,2) | 是 | NULL | |||
| Opening_RM | double(20,2) | 是 | NULL | |||
| Purchases_RM | double(20,2) | 是 | NULL | |||
| Closing_RM | double(20,2) | 是 | NULL | |||
| Purchases_FG | double(20,2) | 是 | NULL | |||
| Electricity | double(20,2) | 是 | NULL | |||
| Oils_fuels | double(20,2) | 是 | NULL | |||
| Coals | double(20,2) | 是 | NULL | |||
| Salaries | double(20,2) | 是 | NULL | |||
| Providend_fund_contri | double(20,2) | 是 | NULL | |||
| Staff_welfare | double(20,2) | 是 | NULL | |||
| sub_contract | double(20,2) | 是 | NULL | |||
| processing_charges | double(20,2) | 是 | NULL | |||
| repairs_maintenance | double(20,2) | 是 | NULL | |||
| UpKeep_maintenance | double(20,2) | 是 | NULL | |||
| rent_rates_taxes | double(20,2) | 是 | NULL | |||
| Insurance | double(20,2) | 是 | NULL | |||
| priting_stationery | double(20,2) | 是 | NULL | |||
| professional_charges | double(20,2) | 是 | NULL | |||
| travelling | double(20,2) | 是 | NULL | |||
| Advertising | double(20,2) | 是 | NULL | |||
| Commission_incentives | double(20,2) | 是 | NULL | |||
| freight_forwardings | double(20,2) | 是 | NULL | |||
| Handling_clearing | double(20,2) | 是 | NULL | |||
| Bad_debts | double(20,2) | 是 | NULL | |||
| Prov_Doubtfull_debts | double(20,2) | 是 | NULL | |||
| Loss_Fixed_assets | double(20,2) | 是 | NULL | |||
| Loss_Foreign_exchange | double(20,2) | 是 | NULL | |||
| Loss_sale_Investment | double(20,2) | 是 | NULL | |||
| Interest_income | double(20,2) | 是 | NULL | |||
| Dividend_income | double(20,2) | 是 | NULL | |||
| Profit_FA | double(20,2) | 是 | NULL | |||
| Profit_Investment | double(20,2) | 是 | NULL | |||
| Prov_written_back | double(20,2) | 是 | NULL | |||
| Foreign_exchange_gain | double(20,2) | 是 | NULL | |||
| Interest_deb | double(20,2) | 是 | NULL | |||
| Interest_Term_loans | double(20,2) | 是 | NULL | |||
| Interest_fixed_deposits | double(20,2) | 是 | NULL | |||
| Bank_charges | double(20,2) | 是 | NULL | |||
| Appropriation_General_Reserve | double(20,2) | 是 | NULL | |||
| Proposed_Equity_devided | double(20,2) | 是 | NULL | |||
| Corp_Divd_tax | double(20,2) | 是 | NULL | |||
| EPS | double(20,2) | 是 | NULL | |||
| Adj_Eps | double(20,2) | 是 | NULL | |||
| Interest_RBI | double(20,2) | 是 | NULL | |||
| Interest_investment | double(20,2) | 是 | NULL | |||
| Income_JV_subs | double(20,2) | 是 | NULL | |||
| Rent_income | double(20,2) | 是 | NULL | |||
| Interest_RBI_borrowings | double(20,2) | 是 | NULL | |||
| Interest_other | double(20,2) | 是 | NULL | |||
| Depreciation_leased_assets | double(20,2) | 是 | NULL | |||
| Auditor_payment | double(20,2) | 是 | NULL | |||
| Telephone | double(20,2) | 是 | NULL | |||
| repairs_other_admin | double(20,2) | 是 | NULL | |||
| Statutory_reserve | double(20,2) | 是 | NULL | |||
| Appropriation_Revenue_Reserve | double(20,2) | 是 | NULL | |||
| Other_appropriation | double(20,2) | 是 | NULL | |||
| Sale_Shares_Units | double(20,2) | 是 | NULL | |||
| Interest_earned_loan | double(20,2) | 是 | NULL | |||
| Portfolio_mgt_income | double(20,2) | 是 | NULL | |||
| Dividend_earned | double(20,2) | 是 | NULL | |||
| Brokerage_commission | double(20,2) | 是 | NULL | |||
| Processing_fees | double(20,2) | 是 | NULL | |||
| Depository_charges | double(20,2) | 是 | NULL | |||
| Security_trasaction_tax | double(20,2) | 是 | NULL | |||
| Software_technical_charges | double(20,2) | 是 | NULL | |||
| Provision_contigency | double(20,2) | 是 | NULL | |||
| provision_NPA | double(20,2) | 是 | NULL | |||
| Other_interest_income | double(20,2) | 是 | NULL | |||
| Commision | double(20,2) | 是 | NULL | |||
| Discounts | double(20,2) | 是 | NULL | |||
| Other_Investmnet_income | double(20,2) | 是 | NULL | |||
| Sales | double(20,2) | 是 | NULL | |||
| Income_Diagnostic | double(20,2) | 是 | NULL | |||
| Cash_discount | double(20,2) | 是 | NULL | |||
| UpKeep_service | double(20,2) | 是 | NULL | |||
| Consultant_changes | double(20,2) | 是 | NULL | |||
| Packing_materials | double(20,2) | 是 | NULL | |||
| freight_outward | double(20,2) | 是 | NULL | |||
| Room_restaurents | double(20,2) | 是 | NULL | |||
| Communication_income | double(20,2) | 是 | NULL | |||
| Foods_beverage_Sales | double(20,2) | 是 | NULL | |||
| Linen_Room_supplies | double(20,2) | 是 | NULL | |||
| Catering_supplies | double(20,2) | 是 | NULL | |||
| Laundry_washing_expenses | double(20,2) | 是 | NULL | |||
| music_banquest_restaurants | double(20,2) | 是 | NULL | |||
| packing_expenses | double(20,2) | 是 | NULL | |||
| Sales_property_development | double(20,2) | 是 | NULL | |||
| Broadcasting_revenue | double(20,2) | 是 | NULL | |||
| Adverisement_revenue | double(20,2) | 是 | NULL | |||
| Licence_income | double(20,2) | 是 | NULL | |||
| Subscription_income | double(20,2) | 是 | NULL | |||
| Contents_film_income | double(20,2) | 是 | NULL | |||
| Program_production_exps | double(20,2) | 是 | NULL | |||
| Telecastin_expenses | double(20,2) | 是 | NULL | |||
| Programs_Films_right | double(20,2) | 是 | NULL | |||
| Transmission_EPC | double(20,2) | 是 | NULL | |||
| Wheeling_Transmission | double(20,2) | 是 | NULL | |||
| Power_Purchased | double(20,2) | 是 | NULL | |||
| Power_project_cost | double(20,2) | 是 | NULL | |||
| wheeling_charges | double(20,2) | 是 | NULL | |||
| Spare_consumed | double(20,2) | 是 | NULL | |||
| Sub_contract_charges | double(20,2) | 是 | NULL | |||
| Development_rights | double(20,2) | 是 | NULL | |||
| Development_charges | double(20,2) | 是 | NULL | |||
| Income_Investment_property | double(20,2) | 是 | NULL | |||
| Development_rights_cost | double(20,2) | 是 | NULL | |||
| Shipbuilding_income | double(20,2) | 是 | NULL | |||
| Charter_income | double(20,2) | 是 | NULL | |||
| freight_Income | double(20,2) | 是 | NULL | |||
| Stevedoreage_cargo_expenses | double(20,2) | 是 | NULL | |||
| Port_charges | double(20,2) | 是 | NULL | |||
| Sale_licenses | double(20,2) | 是 | NULL | |||
| Traded_sw | double(20,2) | 是 | NULL | |||
| Tech_fees | double(20,2) | 是 | NULL | |||
| Traing_exps | double(20,2) | 是 | NULL | |||
| Software_licences | double(20,2) | 是 | NULL | |||
| Travels_SW | double(20,2) | 是 | NULL | |||
| Insurance_SW | double(20,2) | 是 | NULL | |||
| Visa_charges | double(20,2) | 是 | NULL | |||
| Contract_Support_SW | double(20,2) | 是 | NULL | |||
| rates_taxes | double(20,2) | 是 | NULL | |||
| Sales_scrap | double(20,2) | 是 | NULL | |||
| Export_benefits | double(20,2) | 是 | NULL | |||
| Subsidy_incentives | double(20,2) | 是 | NULL | |||
| freight_inward | double(20,2) | 是 | NULL | |||
| Hire_charges_mfg | double(20,2) | 是 | NULL | |||
| Donation | double(20,2) | 是 | NULL | |||
| Interest_Other_income | double(20,2) | 是 | NULL | |||
| Commission | double(20,2) | 是 | NULL | |||
| Power_fuel_cost | double(20,2) | 是 | NULL | |||
| royalty | double(20,2) | 是 | NULL | |||
| Project_expenses | double(20,2) | 是 | NULL | |||
| FLAG | varchar(1) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | fin_code | 27212 | A | 否 | |
| Year_end | 54425 | A | 否 | |||||
| Type | 54425 | A | 否 |
Results
| 字段 | 类型 | 空 | 默认 | 链接到 | 注释 | 媒体（MIME） 类型 |
|---|---|---|---|---|---|---|
| fin_code (主键) | int(15) | 否 | ||||
| Result_Type (主键) | varchar(2) | 否 | ||||
| No_months | int(15) | 是 | NULL | |||
| Type (主键) | varchar(1) | 否 | ||||
| Date_End (主键) | int(15) | 否 | ||||
| Net_Sales | double(20,2) | 是 | NULL | |||
| Gross_Sale | double(20,2) | 是 | NULL | |||
| Excise_Duty | double(20,2) | 是 | NULL | |||
| Other_NetSales | double(20,2) | 是 | NULL | |||
| Job_Works | double(20,2) | 是 | NULL | |||
| Other_Income | double(20,2) | 是 | NULL | |||
| Dividend_Income | double(20,2) | 是 | NULL | |||
| Export_Incentives | double(20,2) | 是 | NULL | |||
| Foreign_exchange_gain | double(20,2) | 是 | NULL | |||
| Profit_Investment | double(20,2) | 是 | NULL | |||
| Other_Interest_income | double(20,2) | 是 | NULL | |||
| rental_income | double(20,2) | 是 | NULL | |||
| Sale_Shares_Units | double(20,2) | 是 | NULL | |||
| Prov_written_back | double(20,2) | 是 | NULL | |||
| Sale_Assets | double(20,2) | 是 | NULL | |||
| Other_Other_Income | double(20,2) | 是 | NULL | |||
| Total_Income | double(20,2) | 是 | NULL | |||
| Expenditure | double(20,2) | 是 | NULL | |||
| Inc_Dec_Inventory | double(20,2) | 是 | NULL | |||
| Excise | double(20,2) | 是 | NULL | |||
| Raw_Material_Cost | double(20,2) | 是 | NULL | |||
| PURCHASE_FIN_GOOD | double(20,2) | 是 | NULL | |||
| Mfg_Exps | double(20,2) | 是 | NULL | |||
| Electricity_Power_Fuel | double(20,2) | 是 | NULL | |||
| Exployee_Cost | double(20,2) | 是 | NULL | |||
| Interest | double(20,2) | 是 | NULL | |||
| Depreciation | double(20,2) | 是 | NULL | |||
| Gen_AdminExpenses | double(20,2) | 是 | NULL | |||
| Selling_Dist_Expenses | double(20,2) | 是 | NULL | |||
| Misc_Expenses | double(20,2) | 是 | NULL | |||
| Loss_Foreign_exchange | double(20,2) | 是 | NULL | |||
| LossForeignExchangeLoan | double(20,2) | 是 | NULL | |||
| Expence_Capitalised | double(20,2) | 是 | NULL | |||
| PB_ExItem_SATax | double(20,2) | 是 | NULL | |||
| Exception_Items | double(20,2) | 是 | NULL | |||
| Exc_foreign_exch_gain | double(20,2) | 是 | NULL | |||
| Exc_other | double(20,2) | 是 | NULL | |||
| PB_SATax | double(20,2) | 是 | NULL | |||
| Shares_Associate | double(20,2) | 是 | NULL | |||
| Pbt | double(20,2) | 是 | NULL | |||
| Tax | double(20,2) | 是 | NULL | |||
| Curr_tax | double(20,2) | 是 | NULL | |||
| Def_tax | double(20,2) | 是 | NULL | |||
| Fringe_benefits | double(20,2) | 是 | NULL | |||
| Prior_Period_Tax | double(20,2) | 是 | NULL | |||
| Mat_Credit | double(20,2) | 是 | NULL | |||
| Other_Tax | double(20,2) | 是 | NULL | |||
| Pat | double(20,2) | 是 | NULL | |||
| Pbt_DiscOperations | double(20,2) | 是 | NULL | |||
| TaxExp_DiscOperations | double(20,2) | 是 | NULL | |||
| Discontinued_Op | double(20,2) | 是 | NULL | |||
| Other_related_items | double(20,2) | 是 | NULL | |||
| Net_Profit | double(20,2) | 是 | NULL | |||
| Other_CompIncome | double(20,2) | 是 | NULL | |||
| Items_NotClassif_PL | double(20,2) | 是 | NULL | |||
| IT_Items_NotClassif_PL | double(20,2) | 是 | NULL | |||
| Items_Classif_PL | double(20,2) | 是 | NULL | |||
| IT_Items_Classif_PL | double(20,2) | 是 | NULL | |||
| MININT_COMPINCOME | double(20,2) | 是 | NULL | |||
| OthCinc_Other | double(20,2) | 是 | NULL | |||
| TOTAL_COMPINCOME | double(20,2) | 是 | NULL | |||
| NetProfit_OwnOfParent | double(20,2) | 是 | NULL | |||
| NetProfit_NonContInt | double(20,2) | 是 | NULL | |||
| Other_CompInc_OwnOfParent | double(20,2) | 是 | NULL | |||
| Other_CompInc_NonContInt | double(20,2) | 是 | NULL | |||
| TotalCompIncome_OwnOfParent | double(20,2) | 是 | NULL | |||
| Minority_interest | double(20,2) | 是 | NULL | |||
| Equity_Cap | double(20,2) | 是 | NULL | |||
| Fv | double(20,2) | 是 | NULL | |||
| Reserves | double(20,2) | 是 | NULL | |||
| EPSAbs | double(20,2) | 是 | NULL | |||
| EPSAnn | double(20,2) | 是 | NULL | |||
| Adj_eps_abs | double(20,2) | 是 | NULL | |||
| Adj_eps_ann | double(20,2) | 是 | NULL | |||
| eps_basic | double(20,2) | 是 | NULL | |||
| eps_diluted_extraord | double(20,2) | 是 | NULL | |||
| PBIDTMEXOI | double(20,2) | 是 | NULL | |||
| PBIDTM | double(20,2) | 是 | NULL | |||
| PBDTM | double(20,2) | 是 | NULL | |||
| PBTM | double(20,2) | 是 | NULL | |||
| PATM | double(20,2) | 是 | NULL | |||
| Rev_Div_Income | double(20,2) | 是 | NULL | |||
| Rev_Fee_Comm | double(20,2) | 是 | NULL | |||
| Rev_Gain_Fairvalue | double(20,2) | 是 | NULL | |||
| Rev_Gain_finassets | double(20,2) | 是 | NULL | |||
| Inc_Inv | double(20,2) | 是 | NULL | |||
| Int_Bal | double(20,2) | 是 | NULL | |||
| Int_Adv | double(20,2) | 是 | NULL | |||
| Int_Others | double(20,2) | 是 | NULL | |||
| Operating_Ex | double(20,2) | 是 | NULL | |||
| Prov_Emp | double(20,2) | 是 | NULL | |||
| Other_Exp | double(20,2) | 是 | NULL | |||
| Operating_Profit | double(20,2) | 是 | NULL | |||
| Pac | double(20,2) | 是 | NULL | |||
| EI | double(20,2) | 是 | NULL | |||
| PPI | double(20,2) | 是 | NULL | |||
| Govt_Percent_Of_Shares | double(20,2) | 是 | NULL | |||
| Cap_Ratio_Percent | double(20,2) | 是 | NULL | |||
| Cap_Ratio_Percent3 | double(20,2) | 是 | NULL | |||
| Tier1basel3 | double(20,2) | 是 | NULL | |||
| Tier2basel3 | double(20,2) | 是 | NULL | |||
| Gross_Net_Npa | double(20,2) | 是 | NULL | |||
| NPA_Gross | double(20,2) | 是 | NULL | |||
| NPA_Net | double(20,2) | 是 | NULL | |||
| Perc_Gross_Net_Npa | double(20,2) | 是 | NULL | |||
| NPA_Net_perc | double(20,2) | 是 | NULL | |||
| NPA_Gross_perc | double(20,2) | 是 | NULL | |||
| Roa | double(20,2) | 是 | NULL | |||
| Prom_No_Of_Shares | double(20,2) | 是 | NULL | |||
| Prom_Percent_Of_Shares | double(20,2) | 是 | NULL | |||
| eps_basic_extraord | double(20,2) | 是 | NULL | |||
| eps_diluted | double(20,2) | 是 | NULL | |||
| Promoter_NOS | double(20,2) | 是 | NULL | |||
| Encumbered_NOS | double(20,2) | 是 | NULL | |||
| percentage_pledgedpromoter | double(20,2) | 是 | NULL | |||
| Percentage_PledgedCapital | double(20,2) | 是 | NULL | |||
| NonPledgedEncum | double(20,2) | 是 | NULL | |||
| NonPledged_NOS | double(20,2) | 是 | NULL | |||
| Percentage_NonPledgedPromoter | double(20,2) | 是 | NULL | |||
| Percentage_NonPledgedCapital | double(20,2) | 是 | NULL | |||
| CASA | double(20,2) | 是 | NULL | |||
| CASA_AMOUNT | double(20,2) | 是 | NULL | |||
| NIM | double(20,2) | 是 | NULL | |||
| GROSS_PROFIT | double(20,2) | 是 | NULL | |||
| PREF_CAP | double(20,2) | 是 | NULL | |||
| Misc_expd_woff | double(20,2) | 是 | NULL | |||
| Consolidated_net_profit | double(20,2) | 是 | NULL | |||
| NOTES | mediumtext | 是 | NULL | |||
| Return on Capital Employed | double(20,2) | 是 | NULL | |||
| Debt/Equity Ratio | double(20,2) | 是 | NULL | |||
| Interest Coverage Ratio | double(20,2) | 是 | NULL | |||
| Inventory Turnover Ratio | double(20,2) | 是 | NULL | |||
| Debtor Turnover Ratio | double(20,2) | 是 | NULL | |||
| Dividend per share | double(20,2) | 是 | NULL | |||
| Dividend payout ratio | double(20,2) | 是 | NULL | |||
| Other_Adjustments | double(20,2) | 是 | NULL | |||
| pbidtxoi | double(20,2) | 是 | NULL | |||
| OPERATING_PROFIT_MARGIN | double(20,2) | 是 | NULL | |||
| NET_PROFIT_MARGIN | double(20,2) | 是 | NULL | |||
| Cash_bank | double(20,2) | 是 | NULL | |||
| Debtors | double(20,2) | 是 | NULL | |||
| Inventory | double(20,2) | 是 | NULL | |||
| Loans_adv | double(20,2) | 是 | NULL | |||
| nsGrandTotal | double(20,2) | 是 | NULL | |||
| nsTotalpublic | double(20,2) | 是 | NULL | |||
| tpTotalpublic | double(20,2) | 是 | NULL | |||
| Provisions_Coverage | double(20,2) | 是 | NULL | |||
| No_of_ATMs | double(20,2) | 是 | NULL | |||
| No_of_Branches | double(20,2) | 是 | NULL | |||
| Tier_I_Basel_II | double(20,2) | 是 | NULL | |||
| Tier_2_Basel_II | double(20,2) | 是 | NULL | |||
| No_of_Employes | double(20,2) | 是 | NULL | |||
| FLAG | varchar(1) | 是 | NULL |
索引
| 键名 | 类型 | 唯一 | 紧凑 | 字段 | 基数 | 排序规则 | 空 | 注释 |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | 是 | 否 | fin_code | 54360 | A | 否 | |
| Result_Type | 54360 | A | 否 | |||||
| Date_End | 108720 | A | 否 | |||||
| Type | 108720 | A | 否 |