3.0计算现金流量表报错。提示不能插入NULL值。急!....
872次浏览
编辑于2014年12月19日 10:14:54
现金流量表初始数据导入期间是8,做第8期现金流量表时,提示“表页:现金流量表重算失败,详细信息:不能将NULL插入列‘FItemNumber’,表AIS20140715225812.TMP1102B6D7871811E4A6D1F8BC124’;列不允许有NULL值。INSERT失败。语句已终止。”
跟踪数据,经过分析,账簿 017 在现金流量表项目初始余额 T_GL_INITCASHFLOW 有49条记录,查询红色语句 ,t3表中只有27条记录,且没有CI01.01经营类现金流入项目。这样会有很多条FItemNumber是NULL的记录。 该问题有没有补丁解决?
INSERT INTO TMP1102B6D7871811E4A6D1F8BC124 (FBookNumber, FItemNumber, FItemParentId, FItemLevel, FItemIsDetail, FYEAR, FPERIOD,
FITEMDIRECTION, FCyNumber, FFexDetailId, FAMOUNT, FAMOUNTFOR)
SELECT T0.FITEMID,T2.FNUMBER, T3.FNUMBER, T3.FPARENTID, T3.FLEVEL, T3.FISDETAIL, 2014, 7, T3.FDIRECTION, T5.FNUMBER, 0, T0.FAMOUNT, FAMOUNTFOR
FROM T_GL_INITCASHFLOW T0
INNER JOIN (SELECT T2_0.FBOOKID, T2_0.FNUMBER FROM T_BD_ACCOUNTBOOK T2_0 WHERE T2_0.FNUMBER = '017') t2 ON T2.FBOOKID = T0.FACCOUNTBOOKID
LEFT OUTER JOIN (SELECT T3_0.FID, T3_0.FNUMBER, T3_0.FPARENTID, T3_0.FLEVEL, T3_0.FISDETAIL, T3_0.FDIRECTION
FROM T_GL_CASHFLOW T3_0 WHERE (((T3_0.FNUMBER >= 'CI01.01.01') AND (T3_0.FNUMBER <= 'CI03.02.03')) OR
(T3_0.FNUMBER LIKE 'CI03.02.03.%'))) t3 ON T3.FID = T0.FITEMID
INNER JOIN (SELECT T5_0.FCURRENCYID, T5_0.FNUMBER FROM T_BD_CURRENCY T5_0) t5 ON T5.FCURRENCYID = T0.FCURRENCYID
WHERE (T0.FITEMID<>0)
跟踪数据,经过分析,账簿 017 在现金流量表项目初始余额 T_GL_INITCASHFLOW 有49条记录,查询红色语句 ,t3表中只有27条记录,且没有CI01.01经营类现金流入项目。这样会有很多条FItemNumber是NULL的记录。 该问题有没有补丁解决?
INSERT INTO TMP1102B6D7871811E4A6D1F8BC124 (FBookNumber, FItemNumber, FItemParentId, FItemLevel, FItemIsDetail, FYEAR, FPERIOD,
FITEMDIRECTION, FCyNumber, FFexDetailId, FAMOUNT, FAMOUNTFOR)
SELECT T0.FITEMID,T2.FNUMBER, T3.FNUMBER, T3.FPARENTID, T3.FLEVEL, T3.FISDETAIL, 2014, 7, T3.FDIRECTION, T5.FNUMBER, 0, T0.FAMOUNT, FAMOUNTFOR
FROM T_GL_INITCASHFLOW T0
INNER JOIN (SELECT T2_0.FBOOKID, T2_0.FNUMBER FROM T_BD_ACCOUNTBOOK T2_0 WHERE T2_0.FNUMBER = '017') t2 ON T2.FBOOKID = T0.FACCOUNTBOOKID
LEFT OUTER JOIN (SELECT T3_0.FID, T3_0.FNUMBER, T3_0.FPARENTID, T3_0.FLEVEL, T3_0.FISDETAIL, T3_0.FDIRECTION
FROM T_GL_CASHFLOW T3_0 WHERE (((T3_0.FNUMBER >= 'CI01.01.01') AND (T3_0.FNUMBER <= 'CI03.02.03')) OR
(T3_0.FNUMBER LIKE 'CI03.02.03.%'))) t3 ON T3.FID = T0.FITEMID
INNER JOIN (SELECT T5_0.FCURRENCYID, T5_0.FNUMBER FROM T_BD_CURRENCY T5_0) t5 ON T5.FCURRENCYID = T0.FCURRENCYID
WHERE (T0.FITEMID<>0)
推荐阅读