将文件拖动至此

SQL 上传 ( 0 ) x -

服务器: localhost »数据库: NorenAccordComapnyData »表: BalanceSheet
页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 用时
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :

编辑模式

自定义编辑模式。

文档 禁止编辑 BLOB 和 BINARY 类型字段。
文档 在编辑/插入模式中显示函数列.
文档 定义在编辑/插入模式中是否默认显示字段类型一列。
文档 一次可以插入的行数。
文档 外键下拉框中选项的排序顺序,content 为关联内容,id 为键值。
文档 下拉框将在选项少时使用。
文本字段

自定义文本输入框。

文档 当编辑 CHAR 和 VARCHAR 类型字段时所使用的控件;输入框(input) - 可以限制输入长度,文本框(textarea) - 可以输入多行数据。
文档 定义了当编辑 CHAR 和 VARCHAR 字段时所使用输入框的最小大小。
文档 定义了当编辑 CHAR 和 VARCHAR 字段时所使用输入框的最大大小。
文档 CHAR/VARCHAR 文本框的列数。
文档 CHAR/VARCHAR 文本框的行数。
文档 编辑模式的文本区大小 (列数),此值将用于 SQL 查询文本区 (*2)。
文档 编辑模式的文本区大小 (行数),此值将用于 SQL 查询文本区 (*2) 。
文档 将 LONGTEXT 字段的文本框放大一倍。
字段类型函数
fin_codeint(15)
Year_endint(15)
Typevarchar(1)
No_monthsint(15)
Unitint(15)
Share_Capitaldouble(20,2)
Shares_warrantsdouble(20,2)
Shares_application_moneydouble(20,2)
ESOP_Outstandingdouble(20,2)
Share_suspensedouble(20,2)
Reservedouble(20,2)
Sharehoders_fundsdouble(20,2)
Depositsdouble(20,2)
Borrowingsdouble(20,2)
Other_liabilitiesdouble(20,2)
Total_sounces_Fundsdouble(20,2)
Cash_balances_RBIdouble(20,2)
Bank_Call_moneydouble(20,2)
Investmentsdouble(20,2)
Advancesdouble(20,2)
Gross_blockdouble(20,2)
Acc_Depreciationdouble(20,2)
Impairment_assetsdouble(20,2)
Lease_adjdouble(20,2)
CWIPdouble(20,2)
Other_Assetsdouble(20,2)
Total_Applicationsdouble(20,2)
Contingent_liabilitiesdouble(20,2)
Bills_For_Collectiondouble(20,2)
Ltrm_Borrowingdouble(20,2)
Secured_Loansdouble(20,2)
Unsecured_Loans_Nfdouble(20,2)
Net_Def_Tax_Nfdouble(20,2)
Oth_Lt_Liabdouble(20,2)
Lt_Trade_Payablesdouble(20,2)
Lt_Provisionsdouble(20,2)
Total_Nonliabdouble(20,2)
Trade_Payablesdouble(20,2)
Current_Liabilities_Nfdouble(20,2)
St_Borrowingsdouble(20,2)
Provisionsdouble(20,2)
Current_Laib_Prov_Nfdouble(20,2)
Total_Sounces_Funds_Nfdouble(20,2)
Non_Current_Assetsdouble(20,2)
Loan_Non_Cuurent_Assetsdouble(20,2)
Net_Blockdouble(20,2)
Cwip_Nfdouble(20,2)
Intang_Assetunderdevdouble(20,2)
Pre_Operatieve_Expsdouble(20,2)
Assetsintransitdouble(20,2)
Investments_Nfdouble(20,2)
Lt_Loanadvdouble(20,2)
Other_Noc_Assetsdouble(20,2)
Total_Nonassetsdouble(20,2)
Current_Investmentsdouble(20,2)
Inventorydouble(20,2)
Debtorsdouble(20,2)
Cash_Bankdouble(20,2)
Other_Current_Nfdouble(20,2)
Loans_Advdouble(20,2)
Currant_Assets_Nfdouble(20,2)
Net_Current_Assets_Nfdouble(20,2)
Other_Crnt_Assetsdouble(20,2)
Misc_Exps_Not_Wodouble(20,2)
Total_Applications_Nfdouble(20,2)
Total_Debt_Inclst_Nfdouble(20,2)
Book_Nav_Sharedouble(20,2)
Adj_Bvdouble(20,2)
Minority_Interestdouble(20,2)
Equity_Authoriseddouble(20,2)
Equity_Issueddouble(20,2)
EQUITY_PAIDUPdouble(20,2)
Equity_Forfeiteddouble(20,2)
Adj_Equitydouble(20,2)
Preference_Capitaldouble(20,2)
FACE_VALUEdouble(20,2)
Share_Premiumdouble(20,2)
Capital_Reservedouble(20,2)
Profit_Lossdouble(20,2)
General_Reservedouble(20,2)
Reserve_Excl_Revaluationdouble(20,2)
Revaluation_Reservedouble(20,2)
Demand_Depositsdouble(20,2)
Saving_Depositsdouble(20,2)
Term_Fixed_Depositsdouble(20,2)
Current_Depositsdouble(20,2)
Recurring_Depositsdouble(20,2)
Borrowings_RBIdouble(20,2)
Borrowings_Banksdouble(20,2)
Borrowings_GOIdouble(20,2)
Borrowings_FIdouble(20,2)
Borrowings_Bondsdouble(20,2)
Borrowings_Otherdouble(20,2)
Borrowings_Outof_Indiadouble(20,2)
Bills_payabledouble(20,2)
Inter_oofice_adjustments_liabilitiesdouble(20,2)
Interest_accrueddouble(20,2)
Proposed_dividenddouble(20,2)
Corporate_dividend_taxdouble(20,2)
Cash_RBIdouble(20,2)
Cash_In_handdouble(20,2)
Investments_Indiadouble(20,2)
GOI_Securitiesdouble(20,2)
Equity_Shares_corporatedouble(20,2)
Debentures_Bondsdouble(20,2)
Subsidiaries_Joint_venturesdouble(20,2)
Mutual_Funds_insurance_Unitsdouble(20,2)
Investments_Outside_Indiadouble(20,2)
GOI_Securities_Outside_indiadouble(20,2)
Subsidiaries_Joint_ventures_outside_indiadouble(20,2)
Other_investments_outside_Indiadouble(20,2)
Dimunition_Investmentsdouble(20,2)
Bills_purchased_discounteddouble(20,2)
Cash_credit_overdraftdouble(20,2)
Term_Loansdouble(20,2)
Finance_Lease_Hire_purchasedouble(20,2)
Buildingsdouble(20,2)
Assets_desposedouble(20,2)
Other_fix_assetsdouble(20,2)
Inter_office_adjustments_Assetsdouble(20,2)
Interest_accrued_assetsdouble(20,2)
Advance_tax_TDSdouble(20,2)
Stationery_stampsdouble(20,2)
Non_banking_assetsdouble(20,2)
Deferred_tax_Assetsdouble(20,2)
Misc_expenditures_Not_writtoffdouble(20,2)
Claims_Not_acknowledge_debtdouble(20,2)
Outstanding_Forward_Exchange_Contractdouble(20,2)
Guarantees_Constituents_Indiadouble(20,2)
Guarantees_Constituents_Outside_Indiadouble(20,2)
Acceptances_Endorsements_Obligationsdouble(20,2)
Non_Convertible_Debenturedouble(20,2)
Conv_Debenture_Bndsdouble(20,2)
Packing_Creditdouble(20,2)
Intercorpsecdepositsdouble(20,2)
Term_Loan_Bankdouble(20,2)
Term_Loan_Instdouble(20,2)
Fixed_Depositsdouble(20,2)
Loans_Susidiariesdouble(20,2)
Inter_Corp_Depositsdouble(20,2)
Foreign_Curr_Convertible_Notesdouble(20,2)
Foreign_Curr_Long_Term_Loansdouble(20,2)
Loans_Bankdouble(20,2)
Loans_Govtdouble(20,2)
Loans_Othersdouble(20,2)
Def_Tax_Assetsdouble(20,2)
Def_Tax_Liabilitydouble(20,2)
Sundry_Crsdouble(20,2)
Acceptancesdouble(20,2)
Trade_Paysubsdouble(20,2)
Bank_Oddouble(20,2)
Adv_Customersdouble(20,2)
Interest_Not_Duedouble(20,2)
Share_Applicationdouble(20,2)
Cl_Curmat_Debdouble(20,2)
Cl_Curmat_Othersdouble(20,2)
Loansdouble(20,2)
Stbs_Sec_Loandemanddouble(20,2)
Stbs_Wcapdouble(20,2)
Stbu_Buycreditdouble(20,2)
Stbu_Commborrdouble(20,2)
Proposed_Divideddouble(20,2)
Prov_Corp_Taxdouble(20,2)
Prov_Taxdouble(20,2)
Prov_Retirementsdouble(20,2)
Prefence_Dividenddouble(20,2)
Long_Term_Investments_Nfdouble(20,2)
Long_Term_Quoteddouble(20,2)
Long_Term_Unquoteddouble(20,2)
CURRENT_QUOTEDdouble(20,2)
Raw_Materialdouble(20,2)
Wipdouble(20,2)
Fin_Goodsdouble(20,2)
Packing_Materials_Inventorydouble(20,2)
Store_Sparesdouble(20,2)
Drs_Six_Monthsdouble(20,2)
Drs_Othersdouble(20,2)
Cash_Handdouble(20,2)
Bank_Balancedouble(20,2)
Interest_Investmentsdouble(20,2)
Interest_Debenturesdouble(20,2)
Deposits_Govt_Otherdouble(20,2)
Interest_Accrued_Duedouble(20,2)
Prepaid_Expsdouble(20,2)
Adv_Cash_Kinddouble(20,2)
Adv_Taxdouble(20,2)
Due_Directordouble(20,2)
Due_Subsidiariesdouble(20,2)
Inter_Corporate_Depositsdouble(20,2)
Corporate_Depositsdouble(20,2)
FLAGvarchar(1)


字段类型函数
fin_codeint(15)
Year_endint(15)
Typevarchar(1)
No_monthsint(15)
Unitint(15)
Share_Capitaldouble(20,2)
Shares_warrantsdouble(20,2)
Shares_application_moneydouble(20,2)
ESOP_Outstandingdouble(20,2)
Share_suspensedouble(20,2)
Reservedouble(20,2)
Sharehoders_fundsdouble(20,2)
Depositsdouble(20,2)
Borrowingsdouble(20,2)
Other_liabilitiesdouble(20,2)
Total_sounces_Fundsdouble(20,2)
Cash_balances_RBIdouble(20,2)
Bank_Call_moneydouble(20,2)
Investmentsdouble(20,2)
Advancesdouble(20,2)
Gross_blockdouble(20,2)
Acc_Depreciationdouble(20,2)
Impairment_assetsdouble(20,2)
Lease_adjdouble(20,2)
CWIPdouble(20,2)
Other_Assetsdouble(20,2)
Total_Applicationsdouble(20,2)
Contingent_liabilitiesdouble(20,2)
Bills_For_Collectiondouble(20,2)
Ltrm_Borrowingdouble(20,2)
Secured_Loansdouble(20,2)
Unsecured_Loans_Nfdouble(20,2)
Net_Def_Tax_Nfdouble(20,2)
Oth_Lt_Liabdouble(20,2)
Lt_Trade_Payablesdouble(20,2)
Lt_Provisionsdouble(20,2)
Total_Nonliabdouble(20,2)
Trade_Payablesdouble(20,2)
Current_Liabilities_Nfdouble(20,2)
St_Borrowingsdouble(20,2)
Provisionsdouble(20,2)
Current_Laib_Prov_Nfdouble(20,2)
Total_Sounces_Funds_Nfdouble(20,2)
Non_Current_Assetsdouble(20,2)
Loan_Non_Cuurent_Assetsdouble(20,2)
Net_Blockdouble(20,2)
Cwip_Nfdouble(20,2)
Intang_Assetunderdevdouble(20,2)
Pre_Operatieve_Expsdouble(20,2)
Assetsintransitdouble(20,2)
Investments_Nfdouble(20,2)
Lt_Loanadvdouble(20,2)
Other_Noc_Assetsdouble(20,2)
Total_Nonassetsdouble(20,2)
Current_Investmentsdouble(20,2)
Inventorydouble(20,2)
Debtorsdouble(20,2)
Cash_Bankdouble(20,2)
Other_Current_Nfdouble(20,2)
Loans_Advdouble(20,2)
Currant_Assets_Nfdouble(20,2)
Net_Current_Assets_Nfdouble(20,2)
Other_Crnt_Assetsdouble(20,2)
Misc_Exps_Not_Wodouble(20,2)
Total_Applications_Nfdouble(20,2)
Total_Debt_Inclst_Nfdouble(20,2)
Book_Nav_Sharedouble(20,2)
Adj_Bvdouble(20,2)
Minority_Interestdouble(20,2)
Equity_Authoriseddouble(20,2)
Equity_Issueddouble(20,2)
EQUITY_PAIDUPdouble(20,2)
Equity_Forfeiteddouble(20,2)
Adj_Equitydouble(20,2)
Preference_Capitaldouble(20,2)
FACE_VALUEdouble(20,2)
Share_Premiumdouble(20,2)
Capital_Reservedouble(20,2)
Profit_Lossdouble(20,2)
General_Reservedouble(20,2)
Reserve_Excl_Revaluationdouble(20,2)
Revaluation_Reservedouble(20,2)
Demand_Depositsdouble(20,2)
Saving_Depositsdouble(20,2)
Term_Fixed_Depositsdouble(20,2)
Current_Depositsdouble(20,2)
Recurring_Depositsdouble(20,2)
Borrowings_RBIdouble(20,2)
Borrowings_Banksdouble(20,2)
Borrowings_GOIdouble(20,2)
Borrowings_FIdouble(20,2)
Borrowings_Bondsdouble(20,2)
Borrowings_Otherdouble(20,2)
Borrowings_Outof_Indiadouble(20,2)
Bills_payabledouble(20,2)
Inter_oofice_adjustments_liabilitiesdouble(20,2)
Interest_accrueddouble(20,2)
Proposed_dividenddouble(20,2)
Corporate_dividend_taxdouble(20,2)
Cash_RBIdouble(20,2)
Cash_In_handdouble(20,2)
Investments_Indiadouble(20,2)
GOI_Securitiesdouble(20,2)
Equity_Shares_corporatedouble(20,2)
Debentures_Bondsdouble(20,2)
Subsidiaries_Joint_venturesdouble(20,2)
Mutual_Funds_insurance_Unitsdouble(20,2)
Investments_Outside_Indiadouble(20,2)
GOI_Securities_Outside_indiadouble(20,2)
Subsidiaries_Joint_ventures_outside_indiadouble(20,2)
Other_investments_outside_Indiadouble(20,2)
Dimunition_Investmentsdouble(20,2)
Bills_purchased_discounteddouble(20,2)
Cash_credit_overdraftdouble(20,2)
Term_Loansdouble(20,2)
Finance_Lease_Hire_purchasedouble(20,2)
Buildingsdouble(20,2)
Assets_desposedouble(20,2)
Other_fix_assetsdouble(20,2)
Inter_office_adjustments_Assetsdouble(20,2)
Interest_accrued_assetsdouble(20,2)
Advance_tax_TDSdouble(20,2)
Stationery_stampsdouble(20,2)
Non_banking_assetsdouble(20,2)
Deferred_tax_Assetsdouble(20,2)
Misc_expenditures_Not_writtoffdouble(20,2)
Claims_Not_acknowledge_debtdouble(20,2)
Outstanding_Forward_Exchange_Contractdouble(20,2)
Guarantees_Constituents_Indiadouble(20,2)
Guarantees_Constituents_Outside_Indiadouble(20,2)
Acceptances_Endorsements_Obligationsdouble(20,2)
Non_Convertible_Debenturedouble(20,2)
Conv_Debenture_Bndsdouble(20,2)
Packing_Creditdouble(20,2)
Intercorpsecdepositsdouble(20,2)
Term_Loan_Bankdouble(20,2)
Term_Loan_Instdouble(20,2)
Fixed_Depositsdouble(20,2)
Loans_Susidiariesdouble(20,2)
Inter_Corp_Depositsdouble(20,2)
Foreign_Curr_Convertible_Notesdouble(20,2)
Foreign_Curr_Long_Term_Loansdouble(20,2)
Loans_Bankdouble(20,2)
Loans_Govtdouble(20,2)
Loans_Othersdouble(20,2)
Def_Tax_Assetsdouble(20,2)
Def_Tax_Liabilitydouble(20,2)
Sundry_Crsdouble(20,2)
Acceptancesdouble(20,2)
Trade_Paysubsdouble(20,2)
Bank_Oddouble(20,2)
Adv_Customersdouble(20,2)
Interest_Not_Duedouble(20,2)
Share_Applicationdouble(20,2)
Cl_Curmat_Debdouble(20,2)
Cl_Curmat_Othersdouble(20,2)
Loansdouble(20,2)
Stbs_Sec_Loandemanddouble(20,2)
Stbs_Wcapdouble(20,2)
Stbu_Buycreditdouble(20,2)
Stbu_Commborrdouble(20,2)
Proposed_Divideddouble(20,2)
Prov_Corp_Taxdouble(20,2)
Prov_Taxdouble(20,2)
Prov_Retirementsdouble(20,2)
Prefence_Dividenddouble(20,2)
Long_Term_Investments_Nfdouble(20,2)
Long_Term_Quoteddouble(20,2)
Long_Term_Unquoteddouble(20,2)
CURRENT_QUOTEDdouble(20,2)
Raw_Materialdouble(20,2)
Wipdouble(20,2)
Fin_Goodsdouble(20,2)
Packing_Materials_Inventorydouble(20,2)
Store_Sparesdouble(20,2)
Drs_Six_Monthsdouble(20,2)
Drs_Othersdouble(20,2)
Cash_Handdouble(20,2)
Bank_Balancedouble(20,2)
Interest_Investmentsdouble(20,2)
Interest_Debenturesdouble(20,2)
Deposits_Govt_Otherdouble(20,2)
Interest_Accrued_Duedouble(20,2)
Prepaid_Expsdouble(20,2)
Adv_Cash_Kinddouble(20,2)
Adv_Taxdouble(20,2)
Due_Directordouble(20,2)
Due_Subsidiariesdouble(20,2)
Inter_Corporate_Depositsdouble(20,2)
Corporate_Depositsdouble(20,2)
FLAGvarchar(1)

   然后   
按 TAB 键跳到下一个数值,或 CTRL+方向键 作随意移动.

继续插入