用友ORACLE笔记

select 
to_date(nc_balance_sheet.keyword3,'yyyy-mm-dd') as currentMonth ,
nc_balance_sheet.*,nc_profit.*,nc_cash_flow.*,
(nc_cash_flow.m10068+ nc_cash_flow.m10056) as 本期现金流收入,

(nc_cash_flow.m10067+ nc_cash_flow.m10055) as 本年累计现金流收入,

(nc_cash_flow.M10002+nc_cash_flow.M10044+nc_cash_flow.M10062) as 本期现金流支出,

(nc_cash_flow.M10001+nc_cash_flow.M10043+nc_cash_flow.M10061) as 本年累计现金流支出,

(select sum(has_start)*10000 from odoo_project_back_money) as 到期应收款合计,
(select sum(can_cost)*10000 from odoo_project_back_money) as  满足支付条件未请款,
(select sum(due_payment)*10000 from odoo_due_payment) as 到期应付款合计,

(select execution_cost_total from odoo_budget_execution where YEAR=(select extract(year from now())))*10000 as 今年预算总收入,
(select year_net_profit from odoo_budget_execution where YEAR=(select extract(year from now())))*10000 as 今年预计净利润,
(select money_cost from odoo_budget_execution where YEAR=(select extract(year from now())))*10000 as 今年现金流支出预算,
(select money_get from odoo_budget_execution where YEAR=(select extract(year from now())))*10000 as 今年现金流收入预算
from 
nc_profit,nc_cash_flow,nc_balance_sheet
where nc_balance_sheet.alone_id=nc_cash_flow.alone_id
and   nc_balance_sheet.alone_id=nc_profit.alone_id