将文件拖动至此

SQL 上传 ( 0 ) x -

服务器: localhost »数据库: NorenAccordComapnyData »表: ProfitAndLoss
页面相关设置 点击以滚动到页面顶部
按 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)
Interest_earneddouble(20,2)
Other_incomedouble(20,2)
Total_incomedouble(20,2)
Interestdouble(20,2)
Operating_expensesdouble(20,2)
Provisions_contigencydouble(20,2)
Taxdouble(20,2)
Totaldouble(20,2)
Profit_after_taxdouble(20,2)
extra_itemsdouble(20,2)
Profit_Brought_forwarddouble(20,2)
Minority_interestdouble(20,2)
Share_Associatedouble(20,2)
Other_ConsItemsdouble(20,2)
Consolidated_NetProfitdouble(20,2)
Adj_Net_profitdouble(20,2)
Extr_Itemsdouble(20,2)
PNLBFdouble(20,2)
Profit_availble_apprdouble(20,2)
Appropriationdouble(20,2)
Dividend_percdouble(20,2)
Reported_EPSdouble(20,2)
Gross_salesdouble(20,2)
Net_salesdouble(20,2)
Inc_Dec_Inventorydouble(20,2)
Raw_matrs_consumeddouble(20,2)
Employeesdouble(20,2)
Other_Mfg_Expsdouble(20,2)
Sellg_Admn_Expsdouble(20,2)
Misc_expsdouble(20,2)
Pre_Op_expsdouble(20,2)
Total_expendiuredouble(20,2)
Operating_profitdouble(20,2)
Depreciationdouble(20,2)
Profit_before_exceptiondouble(20,2)
ExceptionalIncome_Expensesdouble(20,2)
Profit_before_taxdouble(20,2)
Taxationdouble(20,2)
Profit_available_appropriationdouble(20,2)
Total_gross_salesdouble(20,2)
Excisedouble(20,2)
Power_Fueldouble(20,2)
Gross_profitsdouble(20,2)
inter_div_trfdouble(20,2)
Sales_returndouble(20,2)
Sellg_Expsdouble(20,2)
Cost_SWdouble(20,2)
Provision_investmentdouble(20,2)
Provision_advancesdouble(20,2)
Provision_otherdouble(20,2)
Curr_taxdouble(20,2)
Def_taxdouble(20,2)
Fringe_benefitsdouble(20,2)
Wealth_taxdouble(20,2)
Interest_advances_Billsdouble(20,2)
Job_worksdouble(20,2)
Service_incomedouble(20,2)
Opening_RMdouble(20,2)
Purchases_RMdouble(20,2)
Closing_RMdouble(20,2)
Purchases_FGdouble(20,2)
Electricitydouble(20,2)
Oils_fuelsdouble(20,2)
Coalsdouble(20,2)
Salariesdouble(20,2)
Providend_fund_contridouble(20,2)
Staff_welfaredouble(20,2)
sub_contractdouble(20,2)
processing_chargesdouble(20,2)
repairs_maintenancedouble(20,2)
UpKeep_maintenancedouble(20,2)
rent_rates_taxesdouble(20,2)
Insurancedouble(20,2)
priting_stationerydouble(20,2)
professional_chargesdouble(20,2)
travellingdouble(20,2)
Advertisingdouble(20,2)
Commission_incentivesdouble(20,2)
freight_forwardingsdouble(20,2)
Handling_clearingdouble(20,2)
Bad_debtsdouble(20,2)
Prov_Doubtfull_debtsdouble(20,2)
Loss_Fixed_assetsdouble(20,2)
Loss_Foreign_exchangedouble(20,2)
Loss_sale_Investmentdouble(20,2)
Interest_incomedouble(20,2)
Dividend_incomedouble(20,2)
Profit_FAdouble(20,2)
Profit_Investmentdouble(20,2)
Prov_written_backdouble(20,2)
Foreign_exchange_gaindouble(20,2)
Interest_debdouble(20,2)
Interest_Term_loansdouble(20,2)
Interest_fixed_depositsdouble(20,2)
Bank_chargesdouble(20,2)
Appropriation_General_Reservedouble(20,2)
Proposed_Equity_devideddouble(20,2)
Corp_Divd_taxdouble(20,2)
EPSdouble(20,2)
Adj_Epsdouble(20,2)
Interest_RBIdouble(20,2)
Interest_investmentdouble(20,2)
Income_JV_subsdouble(20,2)
Rent_incomedouble(20,2)
Interest_RBI_borrowingsdouble(20,2)
Interest_otherdouble(20,2)
Depreciation_leased_assetsdouble(20,2)
Auditor_paymentdouble(20,2)
Telephonedouble(20,2)
repairs_other_admindouble(20,2)
Statutory_reservedouble(20,2)
Appropriation_Revenue_Reservedouble(20,2)
Other_appropriationdouble(20,2)
Sale_Shares_Unitsdouble(20,2)
Interest_earned_loandouble(20,2)
Portfolio_mgt_incomedouble(20,2)
Dividend_earneddouble(20,2)
Brokerage_commissiondouble(20,2)
Processing_feesdouble(20,2)
Depository_chargesdouble(20,2)
Security_trasaction_taxdouble(20,2)
Software_technical_chargesdouble(20,2)
Provision_contigencydouble(20,2)
provision_NPAdouble(20,2)
Other_interest_incomedouble(20,2)
Commisiondouble(20,2)
Discountsdouble(20,2)
Other_Investmnet_incomedouble(20,2)
Salesdouble(20,2)
Income_Diagnosticdouble(20,2)
Cash_discountdouble(20,2)
UpKeep_servicedouble(20,2)
Consultant_changesdouble(20,2)
Packing_materialsdouble(20,2)
freight_outwarddouble(20,2)
Room_restaurentsdouble(20,2)
Communication_incomedouble(20,2)
Foods_beverage_Salesdouble(20,2)
Linen_Room_suppliesdouble(20,2)
Catering_suppliesdouble(20,2)
Laundry_washing_expensesdouble(20,2)
music_banquest_restaurantsdouble(20,2)
packing_expensesdouble(20,2)
Sales_property_developmentdouble(20,2)
Broadcasting_revenuedouble(20,2)
Adverisement_revenuedouble(20,2)
Licence_incomedouble(20,2)
Subscription_incomedouble(20,2)
Contents_film_incomedouble(20,2)
Program_production_expsdouble(20,2)
Telecastin_expensesdouble(20,2)
Programs_Films_rightdouble(20,2)
Transmission_EPCdouble(20,2)
Wheeling_Transmissiondouble(20,2)
Power_Purchaseddouble(20,2)
Power_project_costdouble(20,2)
wheeling_chargesdouble(20,2)
Spare_consumeddouble(20,2)
Sub_contract_chargesdouble(20,2)
Development_rightsdouble(20,2)
Development_chargesdouble(20,2)
Income_Investment_propertydouble(20,2)
Development_rights_costdouble(20,2)
Shipbuilding_incomedouble(20,2)
Charter_incomedouble(20,2)
freight_Incomedouble(20,2)
Stevedoreage_cargo_expensesdouble(20,2)
Port_chargesdouble(20,2)
Sale_licensesdouble(20,2)
Traded_swdouble(20,2)
Tech_feesdouble(20,2)
Traing_expsdouble(20,2)
Software_licencesdouble(20,2)
Travels_SWdouble(20,2)
Insurance_SWdouble(20,2)
Visa_chargesdouble(20,2)
Contract_Support_SWdouble(20,2)
rates_taxesdouble(20,2)
Sales_scrapdouble(20,2)
Export_benefitsdouble(20,2)
Subsidy_incentivesdouble(20,2)
freight_inwarddouble(20,2)
Hire_charges_mfgdouble(20,2)
Donationdouble(20,2)
Interest_Other_incomedouble(20,2)
Commissiondouble(20,2)
Power_fuel_costdouble(20,2)
royaltydouble(20,2)
Project_expensesdouble(20,2)
FLAGvarchar(1)


字段类型函数
fin_codeint(15)
Year_endint(15)
Typevarchar(1)
No_monthsint(15)
Unitint(15)
Interest_earneddouble(20,2)
Other_incomedouble(20,2)
Total_incomedouble(20,2)
Interestdouble(20,2)
Operating_expensesdouble(20,2)
Provisions_contigencydouble(20,2)
Taxdouble(20,2)
Totaldouble(20,2)
Profit_after_taxdouble(20,2)
extra_itemsdouble(20,2)
Profit_Brought_forwarddouble(20,2)
Minority_interestdouble(20,2)
Share_Associatedouble(20,2)
Other_ConsItemsdouble(20,2)
Consolidated_NetProfitdouble(20,2)
Adj_Net_profitdouble(20,2)
Extr_Itemsdouble(20,2)
PNLBFdouble(20,2)
Profit_availble_apprdouble(20,2)
Appropriationdouble(20,2)
Dividend_percdouble(20,2)
Reported_EPSdouble(20,2)
Gross_salesdouble(20,2)
Net_salesdouble(20,2)
Inc_Dec_Inventorydouble(20,2)
Raw_matrs_consumeddouble(20,2)
Employeesdouble(20,2)
Other_Mfg_Expsdouble(20,2)
Sellg_Admn_Expsdouble(20,2)
Misc_expsdouble(20,2)
Pre_Op_expsdouble(20,2)
Total_expendiuredouble(20,2)
Operating_profitdouble(20,2)
Depreciationdouble(20,2)
Profit_before_exceptiondouble(20,2)
ExceptionalIncome_Expensesdouble(20,2)
Profit_before_taxdouble(20,2)
Taxationdouble(20,2)
Profit_available_appropriationdouble(20,2)
Total_gross_salesdouble(20,2)
Excisedouble(20,2)
Power_Fueldouble(20,2)
Gross_profitsdouble(20,2)
inter_div_trfdouble(20,2)
Sales_returndouble(20,2)
Sellg_Expsdouble(20,2)
Cost_SWdouble(20,2)
Provision_investmentdouble(20,2)
Provision_advancesdouble(20,2)
Provision_otherdouble(20,2)
Curr_taxdouble(20,2)
Def_taxdouble(20,2)
Fringe_benefitsdouble(20,2)
Wealth_taxdouble(20,2)
Interest_advances_Billsdouble(20,2)
Job_worksdouble(20,2)
Service_incomedouble(20,2)
Opening_RMdouble(20,2)
Purchases_RMdouble(20,2)
Closing_RMdouble(20,2)
Purchases_FGdouble(20,2)
Electricitydouble(20,2)
Oils_fuelsdouble(20,2)
Coalsdouble(20,2)
Salariesdouble(20,2)
Providend_fund_contridouble(20,2)
Staff_welfaredouble(20,2)
sub_contractdouble(20,2)
processing_chargesdouble(20,2)
repairs_maintenancedouble(20,2)
UpKeep_maintenancedouble(20,2)
rent_rates_taxesdouble(20,2)
Insurancedouble(20,2)
priting_stationerydouble(20,2)
professional_chargesdouble(20,2)
travellingdouble(20,2)
Advertisingdouble(20,2)
Commission_incentivesdouble(20,2)
freight_forwardingsdouble(20,2)
Handling_clearingdouble(20,2)
Bad_debtsdouble(20,2)
Prov_Doubtfull_debtsdouble(20,2)
Loss_Fixed_assetsdouble(20,2)
Loss_Foreign_exchangedouble(20,2)
Loss_sale_Investmentdouble(20,2)
Interest_incomedouble(20,2)
Dividend_incomedouble(20,2)
Profit_FAdouble(20,2)
Profit_Investmentdouble(20,2)
Prov_written_backdouble(20,2)
Foreign_exchange_gaindouble(20,2)
Interest_debdouble(20,2)
Interest_Term_loansdouble(20,2)
Interest_fixed_depositsdouble(20,2)
Bank_chargesdouble(20,2)
Appropriation_General_Reservedouble(20,2)
Proposed_Equity_devideddouble(20,2)
Corp_Divd_taxdouble(20,2)
EPSdouble(20,2)
Adj_Epsdouble(20,2)
Interest_RBIdouble(20,2)
Interest_investmentdouble(20,2)
Income_JV_subsdouble(20,2)
Rent_incomedouble(20,2)
Interest_RBI_borrowingsdouble(20,2)
Interest_otherdouble(20,2)
Depreciation_leased_assetsdouble(20,2)
Auditor_paymentdouble(20,2)
Telephonedouble(20,2)
repairs_other_admindouble(20,2)
Statutory_reservedouble(20,2)
Appropriation_Revenue_Reservedouble(20,2)
Other_appropriationdouble(20,2)
Sale_Shares_Unitsdouble(20,2)
Interest_earned_loandouble(20,2)
Portfolio_mgt_incomedouble(20,2)
Dividend_earneddouble(20,2)
Brokerage_commissiondouble(20,2)
Processing_feesdouble(20,2)
Depository_chargesdouble(20,2)
Security_trasaction_taxdouble(20,2)
Software_technical_chargesdouble(20,2)
Provision_contigencydouble(20,2)
provision_NPAdouble(20,2)
Other_interest_incomedouble(20,2)
Commisiondouble(20,2)
Discountsdouble(20,2)
Other_Investmnet_incomedouble(20,2)
Salesdouble(20,2)
Income_Diagnosticdouble(20,2)
Cash_discountdouble(20,2)
UpKeep_servicedouble(20,2)
Consultant_changesdouble(20,2)
Packing_materialsdouble(20,2)
freight_outwarddouble(20,2)
Room_restaurentsdouble(20,2)
Communication_incomedouble(20,2)
Foods_beverage_Salesdouble(20,2)
Linen_Room_suppliesdouble(20,2)
Catering_suppliesdouble(20,2)
Laundry_washing_expensesdouble(20,2)
music_banquest_restaurantsdouble(20,2)
packing_expensesdouble(20,2)
Sales_property_developmentdouble(20,2)
Broadcasting_revenuedouble(20,2)
Adverisement_revenuedouble(20,2)
Licence_incomedouble(20,2)
Subscription_incomedouble(20,2)
Contents_film_incomedouble(20,2)
Program_production_expsdouble(20,2)
Telecastin_expensesdouble(20,2)
Programs_Films_rightdouble(20,2)
Transmission_EPCdouble(20,2)
Wheeling_Transmissiondouble(20,2)
Power_Purchaseddouble(20,2)
Power_project_costdouble(20,2)
wheeling_chargesdouble(20,2)
Spare_consumeddouble(20,2)
Sub_contract_chargesdouble(20,2)
Development_rightsdouble(20,2)
Development_chargesdouble(20,2)
Income_Investment_propertydouble(20,2)
Development_rights_costdouble(20,2)
Shipbuilding_incomedouble(20,2)
Charter_incomedouble(20,2)
freight_Incomedouble(20,2)
Stevedoreage_cargo_expensesdouble(20,2)
Port_chargesdouble(20,2)
Sale_licensesdouble(20,2)
Traded_swdouble(20,2)
Tech_feesdouble(20,2)
Traing_expsdouble(20,2)
Software_licencesdouble(20,2)
Travels_SWdouble(20,2)
Insurance_SWdouble(20,2)
Visa_chargesdouble(20,2)
Contract_Support_SWdouble(20,2)
rates_taxesdouble(20,2)
Sales_scrapdouble(20,2)
Export_benefitsdouble(20,2)
Subsidy_incentivesdouble(20,2)
freight_inwarddouble(20,2)
Hire_charges_mfgdouble(20,2)
Donationdouble(20,2)
Interest_Other_incomedouble(20,2)
Commissiondouble(20,2)
Power_fuel_costdouble(20,2)
royaltydouble(20,2)
Project_expensesdouble(20,2)
FLAGvarchar(1)

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

继续插入