(--取利润
SELECT
t3.fnumber 公司编码,t3.fname_l2 公司名称,t1.Fperiod 期间,
-- SUM(t1.FMonthPnLLocal) C,
-SUM(t1.FYearPnLLocal) Y,
-1 DC,
'410409' 明细科目编码,
'本年净利润' 明细科目名称,
'未分配利润' 报表项目
FROM T_GL_AccountBalance_5L t1
INNER JOIN T_BD_AccountView t2 ON t1.FAccountID = t2.FID
INNER JOIN T_ORG_BASEUNIT t3 ON t1.FOrgUnitID=t3.fid
WHERE
-- t1.FOrgUnitID = 'GUEAAAAAAELM567U' AND
-- AND t2.FAccountTableID = 'GUEAAAAARlsXaY5t' AND
t1.FPeriod IN (202412) AND
t2.FNumber >= '6001' AND
t2.FNumber <= '6901'AND
t2.FLevel = 1
GROUP BY t3.fnumber,t3.fname_l2,t1.FPeriod
)
UNION ALL
(--常规科目
SELECT
--SUM(t1.FBeginBalanceLocal) C,
t3.fnumber 公司编码,t3.fname_l2 公司名称,t1.FPeriod 期间,
CASE
WHEN t2.fnumber IN ('2001','2211','2231','2232','2601','2501','2701','4001','4002','4101','4102','4103') THEN -SUM(t1.FEndBalanceLocal)
WHEN t2.fnumber='2221' and SUM(t1.FEndBalanceLocal)<=0 THEN -SUM(t1.FEndBalanceLocal)
WHEN t2.fnumber='224199' and SUM(t1.FEndBalanceLocal)<=0 THEN -SUM(t1.FEndBalanceLocal)
WHEN t2.fnumber='121106' and SUM(t1.FEndBalanceLocal)<0 THEN -SUM(t1.FEndBalanceLocal)
ELSE SUM(t1.FEndBalanceLocal)
END Y,
t2.FDc DC,
t2.fnumber 明细科目编码,
t2.FNAME_L2 明细科目名称,
CASE
WHEN t2.fnumber IN ('101206','1002','1001','101205') THEN '货币资金'
WHEN t2.fnumber IN ('1101','101204') THEN '交易性金融资产'
WHEN t2.fnumber = '1111' THEN '应收票据'
WHEN t2.fnumber = '122101' THEN '应收账款'
WHEN t2.fnumber IN ('1401','1402','1403','1404','1405','1406','1407','1408','1409','1410','1411','5001') THEN '存货'
WHEN t2.fnumber IN ('1501','1502') THEN '持有至到期投资'
WHEN t2.fnumber IN ('1504','1505') THEN '长期股权投资'
WHEN t2.fnumber IN ('1506','1507','1508') THEN '投资性房地产'
WHEN t2.fnumber IN ('1601','1602','1603','1606') THEN '固定资产'
WHEN t2.fnumber IN ('1604','1605','1607') THEN '在建工程'
WHEN t2.fnumber IN ('1701','1702','1703') THEN '无形资产'
WHEN t2.fnumber ='1711' THEN '商誉'
WHEN t2.fnumber ='1804' THEN '长期待摊费用'
WHEN t2.fnumber ='1805' THEN '递延所得税资产'
WHEN t2.fnumber ='2001' THEN '短期借款'
WHEN t2.fnumber ='2201' THEN '应付票据'
WHEN t2.fnumber ='2211' THEN '应付职工薪酬'
WHEN t2.fnumber ='2601' THEN '长期借款'
WHEN t2.fnumber ='2411' THEN '预计负债'
WHEN t2.fnumber ='2501' THEN '递延收益'
WHEN t2.fnumber ='2701' THEN '递延所得税负债'
WHEN t2.fnumber ='4001' THEN '实收资本（或股本）'
WHEN t2.fnumber ='4002' THEN '资本公积'
WHEN t2.fnumber ='4003' THEN '减:库存股'
WHEN t2.fnumber ='4101' THEN '盈余公积'
WHEN t2.fnumber IN ('4102','4103') THEN '未分配利润'
WHEN t2.fnumber='2221' and SUM(t1.FEndBalanceLocal)>0 THEN '其他流动资产'
WHEN t2.fnumber='2221' and SUM(t1.FEndBalanceLocal)<=0 THEN '应交税费'
WHEN t2.fnumber IN ('2231','2232') THEN '其他应付款'
WHEN t2.fnumber IN ('224199') AND SUM(t1.FEndBalanceLocal)<=0 THEN '其他应付款'
WHEN t2.fnumber IN ('1114','1115','122102') THEN '其他应收款'
WHEN t2.fnumber IN ('224199') AND SUM(t1.FEndBalanceLocal)>0 THEN '其他应收款'
WHEN t2.fnumber IN ('1801','1802','1901') THEN '其他非流动资产'
WHEN t2.fnumber IN ('121106') AND SUM(t1.FEndBalanceLocal)>=0 THEN '其他应收款'
WHEN t2.fnumber IN ('121106') AND SUM(t1.FEndBalanceLocal)<0 THEN '其他应付款'
END 报表项目
FROM T_GL_AccountBalance_5L t1
INNER JOIN T_BD_AccountView t2 ON t1.FAccountID = t2.FID
INNER JOIN T_ORG_BASEUNIT t3 ON t1.FOrgUnitID=t3.fid
WHERE --t1.FOrgUnitID = 'GUEAAAAAAELM567U' AND
t1.FPeriod =202412 AND
t2.fnumber IN('121106','224199','122101','122102','101206','101205','101204','5001','4103','4102','4101','4003',
'4002','4001','2701','2601','2501','2232','2231','2221','2211','2001','1901','1805','1804','1802','1702','1701','1606',
'1604','1602','1601','1505','1504','1502','1501','1410','1408','1407','1406','1405','1404','1403','1401','1115','1114','1111','1101','1002','1001')
GROUP BY t3.fnumber,t3.fname_l2,t1.FPeriod,t2.fnumber,t2.FDC,t2.FNAME_L2
)报错ORA-12704: character set mismatch
最新发布
本文介绍了解决Oracle中因字段类型不匹配导致的ORA-12704:charactersetmismatch错误的方法。通过举例说明如何使用union all操作时确保字符集一致，并提供了一种通过创建临时表来简化复杂查询中类型匹配问题排查的有效手段。
扫一扫
1800
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
