操作方式:在测试机上装完整安装CLOUD5.0
将数据库备份文件恢复进管理中心
打5.0补丁,补丁号PT092896、PT093058、PT093350、PT093366
升级数据中心,在升级过程中报错,请老师们指点 3.0环境下有过开发:主要功能如下
1、生产入库单审核自动生成生成补料单(转换流程) ,反审核做校验
2、付款申请单审核时根据付款方式,自动下推到付库单,反审核做校验
3、销售出库单审核根据仓库不同,分布插入到各子公司WISE销售出库单中,并作反审核校验
4、应付单列表做对等核销功能,并更新核销标识,核销单据号
5、二开采购暂估单,分组织,月份、将未生成发票,未核销的的应付单汇集,并生成凭证,限制应付单反审核
6、二开发货通知单变更功能,将通知数量=关联出库数,并更改销售订单关联通知单数量
7、退货单自动下推应付单
8、应收单下推红字应收单建转换关系
9、收款单、付款单列表做回单确认及反确认功能按钮
10、销售出库单详细收货地址及仓库录入,自动从物流系统取物流公司
11、银企互联,开发接口调用CLOUD WEBSERVICE 通过银行报文自动生成收款单
12、销售组织销售出库单审核、仓库为浩天时,调用WEBSERVICE 自动同步一张销售出库单到浩天组织
13、生成凭证,通过关系,将凭证号赋值到各单据上的凭证号字段
14、新增网上订货、排产、分配、下推到销售订单模块
15、核算后、将采购入库单上加工费与运费分离
16、新增、更改一些报表
日志文件信息如下:(附件在最后,日志涉及的字段都不关联开发字段)
Error: [2014-11-13 16:07:49] 执行脚本[PT093350_K3CloudV5.0_CN_Data.sql(FIN_DataModel_Public_V5)](HV:0.001,CHECK:0.0020001,RESULT:False,RUN:9.3425343,ERROR)
---脚本错误Begin---
SQL脚本错误:update T_CN_CASHBALINIT
set FMAINBOOKID = ISNULL((select DISTINCT a.FCURRENCYID
from T_FA_ACCTPOLICY a
inner join T_FA_ACCTPOLICYORG b
on b.FACCTPOLICYID = a.FACCTPOLICYID
INNER JOIN T_ORG_ACCOUNTSYSTEM c
on b.facctsystemid = c.facctsystemid
inner join T_ORG_ACCTSYSENTRY d
on c.facctsystemid = d.facctsystemid
inner join T_ORG_ACCTSYSDETAIL e
on d.fentryid = e.fentryid
where a.FDOCUMENTSTATUS = 'C'
and a.FFORBIDSTATUS = 'A'
and b.FACCTORGID = d.fmainorgid
and b.FISDEFAULT = '1'
and c.FISDEFAULT='1'
AND (D.FMAINORGID =
T_CN_CASHBALINIT.FPAYORGID OR
e.FSUBORGID =
T_CN_CASHBALINIT.FPAYORGID)),
0)
where fmainbookid = 0
列名 'fmainbookid' 无效。
SQL脚本错误:update T_CN_CASHBALINIT
set FEXCHANGETYPE = ISNULL((select DISTINCT a.FRATETYPEID
from T_FA_ACCTPOLICY a
inner join T_FA_ACCTPOLICYORG b
on b.FACCTPOLICYID = a.FACCTPOLICYID
INNER JOIN T_ORG_ACCOUNTSYSTEM c
on b.facctsystemid = c.facctsystemid
inner join T_ORG_ACCTSYSENTRY d
on c.facctsystemid = d.facctsystemid
inner join T_ORG_ACCTSYSDETAIL e
on d.fentryid = e.fentryid
where a.FDOCUMENTSTATUS = 'C'
and a.FFORBIDSTATUS = 'A'
and b.FACCTORGID = d.fmainorgid
and b.FISDEFAULT = '1'
and c.FISDEFAULT='1'
AND (D.FMAINORGID =
T_CN_CASHBALINIT.FPAYORGID OR
e.FSUBORGID =
T_CN_CASHBALINIT.FPAYORGID)),
0)
where fexchangetype = 0
列名 'fexchangetype' 无效。
SQL脚本错误:UPDATE T_CN_CASHBALINITENTRY
SET FEXCHANGERATE = ISNULL((Select A.FExchangeRate
from T_BD_RATE A
INNER JOIN T_CN_CASHBALINIT B
ON A.FRATETYPEID = B.FEXCHANGETYPE
AND A.FENDDATE >= B.FDATE
AND A.FBEGDATE <= B.FDATE
where FForbidderID = 0
and ((FCYForID =
T_CN_CASHBALINITENTRY.FCURRENCYID and
B.FMAINBOOKID = FCYTOID) OR
(FCYTOID =
T_CN_CASHBALINITENTRY.FCURRENCYID and
B.FMAINBOOKID = FCYFORID))
and FFORBIDSTATUS = 'A'
and A.FDOCUMENTSTATUS = 'C'
AND B.FID = T_CN_CASHBALINITENTRY.FID),
0)
where FEXCHANGERATE = 0
列名 'FEXCHANGERATE' 无效。
SQL脚本错误:UPDATE T_CN_CASHBALINITENTRY
SET FEXCHANGERATE = 1
WHERE EXISTS
(SELECT 1
FROM T_CN_CASHBALINIT
WHERE T_CN_CASHBALINIT.fmainbookid =
T_CN_CASHBALINITENTRY.FCURRENCYID
AND T_CN_CASHBALINIT.FID = T_CN_CASHBALINITENTRY.FID)
列名 'fmainbookid' 无效。
SQL脚本错误:UPDATE T_CN_CASHBALINITENTRY SET FYEARDEBITAMOUNTLOC = FYEARDEBITAMOUNT * FEXCHANGERATE where FYEARDEBITAMOUNTLOC=0
列名 'FYEARDEBITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_CASHBALINITENTRY SET FYEARCREDITAMOUNTLOC = FYEARCREDITAMOUNT * FEXCHANGERATE where FYEARCREDITAMOUNTLOC=0
列名 'FYEARCREDITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_CASHBALINITENTRY SET FAMOUNTLOC = FAMOUNT * FEXCHANGERATE where FAMOUNTLOC=0
列名 'FAMOUNTLOC' 无效。
SQL脚本错误:update T_CN_BANKACNTBALINIT
set FMAINBOOKID = ISNULL((select DISTINCT a.FCURRENCYID
from T_FA_ACCTPOLICY a
inner join T_FA_ACCTPOLICYORG b
on b.FACCTPOLICYID = a.FACCTPOLICYID
INNER JOIN T_ORG_ACCOUNTSYSTEM c
on b.facctsystemid = c.facctsystemid
inner join T_ORG_ACCTSYSENTRY d
on c.facctsystemid = d.facctsystemid
inner join T_ORG_ACCTSYSDETAIL e
on d.fentryid = e.fentryid
where a.FDOCUMENTSTATUS = 'C'
and a.FFORBIDSTATUS = 'A'
and b.FACCTORGID = d.fmainorgid
and b.FISDEFAULT = '1'
and c.FISDEFAULT='1'
AND (D.FMAINORGID =
T_CN_BANKACNTBALINIT.FPAYORGID OR
e.FSUBORGID =
T_CN_BANKACNTBALINIT.FPAYORGID)),
0)
where fmainbookid = 0
列名 'fmainbookid' 无效。
SQL脚本错误:update T_CN_BANKACNTBALINIT
set FEXCHANGETYPE = ISNULL((select DISTINCT a.FRATETYPEID
from T_FA_ACCTPOLICY a
inner join T_FA_ACCTPOLICYORG b
on b.FACCTPOLICYID = a.FACCTPOLICYID
INNER JOIN T_ORG_ACCOUNTSYSTEM c
on b.facctsystemid = c.facctsystemid
inner join T_ORG_ACCTSYSENTRY d
on c.facctsystemid = d.facctsystemid
inner join T_ORG_ACCTSYSDETAIL e
on d.fentryid = e.fentryid
where a.FDOCUMENTSTATUS = 'C'
and a.FFORBIDSTATUS = 'A'
and b.FACCTORGID = d.fmainorgid
and b.FISDEFAULT = '1'
and c.FISDEFAULT='1'
AND (D.FMAINORGID =
T_CN_BANKACNTBALINIT.FPAYORGID OR
e.FSUBORGID =
T_CN_BANKACNTBALINIT.FPAYORGID)),
0)
where fexchangetype = 0
列名 'fexchangetype' 无效。
SQL脚本错误:UPDATE T_CN_BANKACNTBALINITENTRY
SET FEXCHANGERATE = ISNULL((Select A.FExchangeRate
from T_BD_RATE A
INNER JOIN T_CN_BANKACNTBALINIT B
ON A.FRATETYPEID = B.FEXCHANGETYPE
AND A.FENDDATE >= B.FDATE
AND A.FBEGDATE <= B.FDATE
where FForbidderID = 0
and ((FCYForID =
T_CN_BANKACNTBALINITENTRY.FCURRENCYID and
B.FMAINBOOKID = FCYTOID) OR
(FCYTOID =
T_CN_BANKACNTBALINITENTRY.FCURRENCYID and
B.FMAINBOOKID = FCYFORID))
and FFORBIDSTATUS = 'A'
and A.FDOCUMENTSTATUS = 'C'
AND B.FID = T_CN_BANKACNTBALINITENTRY.FID),
0)
where FEXCHANGERATE = 0
列名 'FEXCHANGERATE' 无效。
SQL脚本错误:UPDATE T_CN_BANKACNTBALINITENTRY
SET FEXCHANGERATE = 1
WHERE EXISTS
(SELECT 1
FROM T_CN_BANKACNTBALINIT
WHERE T_CN_BANKACNTBALINIT.fmainbookid =
T_CN_BANKACNTBALINITENTRY.FCURRENCYID
AND T_CN_BANKACNTBALINIT.FID = T_CN_BANKACNTBALINITENTRY.FID)
列名 'fmainbookid' 无效。
SQL脚本错误:UPDATE T_CN_BANKACNTBALINITENTRY SET FYEARDEBITAMOUNTLOC = FYEARDEBITAMOUNT * FEXCHANGERATE where FYEARDEBITAMOUNTLOC=0
列名 'FYEARDEBITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_BANKACNTBALINITENTRY SET FYEARCREDITAMOUNTLOC = FYEARCREDITAMOUNT * FEXCHANGERATE where FYEARCREDITAMOUNTLOC=0
列名 'FYEARCREDITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_BANKACNTBALINITENTRY SET FENTAMOUNTLOC = FENTAMOUNT * FEXCHANGERATE where FENTAMOUNTLOC=0
列名 'FENTAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_BANKACNTBALINITENTRY SET FBANKAMOUNTLOC = FBANKAMOUNT * FEXCHANGERATE where FBANKAMOUNTLOC=0
列名 'FBANKAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_BANKACNTBALINITENTRY SET FNOREACHENTAMOUNTLOC = FNOREACHENTAMOUNT * FEXCHANGERATE where FNOREACHENTAMOUNTLOC=0
列名 'FNOREACHENTAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_BANKACNTBALINITENTRY SET FNOREACHBANKAMOUNTLOC = FNOREACHBANKAMOUNT * FEXCHANGERATE where FNOREACHBANKAMOUNTLOC=0
列名 'FNOREACHBANKAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_SC_INNERACTINIT
SET FPAYORGID=(SELECT FORGID FROM T_SC_INNERACTINITENTITY
WHERE T_SC_INNERACTINITENTITY.FID=T_SC_INNERACTINIT.FID
AND T_SC_INNERACTINITENTITY.FSEQ=1) WHERE FPAYORGID=0
列名 'FPAYORGID' 无效。
SQL脚本错误:update T_SC_INNERACTINIT
set FMAINBOOKID = ISNULL((select DISTINCT a.FCURRENCYID
from T_FA_ACCTPOLICY a
inner join T_FA_ACCTPOLICYORG b
on b.FACCTPOLICYID = a.FACCTPOLICYID
INNER JOIN T_ORG_ACCOUNTSYSTEM c
on b.facctsystemid = c.facctsystemid
inner join T_ORG_ACCTSYSENTRY d
on c.facctsystemid = d.facctsystemid
inner join T_ORG_ACCTSYSDETAIL e
on d.fentryid = e.fentryid
where a.FDOCUMENTSTATUS = 'C'
and a.FFORBIDSTATUS = 'A'
and b.FACCTORGID = d.fmainorgid
and b.FISDEFAULT = '1'
and c.FISDEFAULT='1'
AND (D.FMAINORGID =
T_SC_INNERACTINIT.FPAYORGID OR
e.FSUBORGID =
T_SC_INNERACTINIT.FPAYORGID)),
0)
where fmainbookid = 0
列名 'fmainbookid' 无效。
SQL脚本错误:update T_SC_INNERACTINIT
set FEXCHANGETYPE = ISNULL((select DISTINCT a.FRATETYPEID
from T_FA_ACCTPOLICY a
inner join T_FA_ACCTPOLICYORG b
on b.FACCTPOLICYID = a.FACCTPOLICYID
INNER JOIN T_ORG_ACCOUNTSYSTEM c
on b.facctsystemid = c.facctsystemid
inner join T_ORG_ACCTSYSENTRY d
on c.facctsystemid = d.facctsystemid
inner join T_ORG_ACCTSYSDETAIL e
on d.fentryid = e.fentryid
where a.FDOCUMENTSTATUS = 'C'
and a.FFORBIDSTATUS = 'A'
and b.FACCTORGID = d.fmainorgid
and b.FISDEFAULT = '1'
and c.FISDEFAULT='1'
AND (D.FMAINORGID =
T_SC_INNERACTINIT.FPAYORGID OR
e.FSUBORGID =
T_SC_INNERACTINIT.FPAYORGID)),
0)
where fexchangetype = 0
列名 'fexchangetype' 无效。
SQL脚本错误:IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SC_INNERACTINITENTITY')
BEGIN
INSERT INTO T_SC_INNERACTINITENTITYTMP(
FENTRYID ,
FID ,
FSEQ ,
FORGID ,
FORGINNERACTID ,
FCURRENCYID ,
FYEARDEBITAMOUNT ,
FYEARCREDITAMOUNT ,
FINITAMOUNT ,
FMAINBOOKID ,
FEXCHANGETYPE ,
FEXCHANGERATE ,
FYEARDEBITAMOUNTLOC ,
FYEARCREDITAMOUNTLOC ,
FINITAMOUNTLOC
)
SELECT
FENTRYID ,
FID ,
FSEQ ,
FORGID ,
FORGINNERACTID ,
FCURRENCYID ,
FYEARDEBITAMOUNT ,
FYEARCREDITAMOUNT ,
FINITAMOUNT ,
0 ,
0 ,
FEXCHANGERATE ,
FYEARDEBITAMOUNTLOC ,
FYEARCREDITAMOUNTLOC ,
FINITAMOUNTLOC FROM T_SC_INNERACTINITENTITY
END
列名 'FEXCHANGERATE' 无效。
列名 'FYEARDEBITAMOUNTLOC' 无效。
列名 'FYEARCREDITAMOUNTLOC' 无效。
列名 'FINITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_SC_INNERACTINITENTITY SET FEXCHANGERATE=(SELECT DISTINCT FEXCHANGERATE FROM T_SC_INNERACTINITENTITYTMP WHERE T_SC_INNERACTINITENTITYTMP.FENTRYID=T_SC_INNERACTINITENTITY.FENTRYID and T_SC_INNERACTINITENTITYTMP.FSEQ=T_SC_INNERACTINITENTITY.FSEQ)
列名 'FEXCHANGERATE' 无效。
SQL脚本错误:UPDATE T_SC_INNERACTINITENTITY SET FYEARDEBITAMOUNTLOC = FYEARDEBITAMOUNT * FEXCHANGERATE where FYEARDEBITAMOUNTLOC=0
列名 'FYEARDEBITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_SC_INNERACTINITENTITY SET FYEARCREDITAMOUNTLOC = FYEARCREDITAMOUNT * FEXCHANGERATE where FYEARCREDITAMOUNTLOC=0
列名 'FYEARCREDITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_SC_INNERACTINITENTITY SET FINITAMOUNTLOC = FINITAMOUNT * FEXCHANGERATE where FINITAMOUNTLOC=0
列名 'FINITAMOUNTLOC' 无效。
SQL脚本错误:update T_CN_INNERACTINIT
set FMAINBOOKID = ISNULL((select DISTINCT a.FCURRENCYID
from T_FA_ACCTPOLICY a
inner join T_FA_ACCTPOLICYORG b
on b.FACCTPOLICYID = a.FACCTPOLICYID
INNER JOIN T_ORG_ACCOUNTSYSTEM c
on b.facctsystemid = c.facctsystemid
inner join T_ORG_ACCTSYSENTRY d
on c.facctsystemid = d.facctsystemid
inner join T_ORG_ACCTSYSDETAIL e
on d.fentryid = e.fentryid
where a.FDOCUMENTSTATUS = 'C'
and a.FFORBIDSTATUS = 'A'
and b.FACCTORGID = d.fmainorgid
and b.FISDEFAULT = '1'
and c.FISDEFAULT='1'
AND (D.FMAINORGID =
T_CN_INNERACTINIT.FPAYORGID OR
e.FSUBORGID =
T_CN_INNERACTINIT.FPAYORGID)),
0)
where fmainbookid = 0
列名 'fmainbookid' 无效。
SQL脚本错误:update T_CN_INNERACTINIT
set FEXCHANGETYPE = ISNULL((select DISTINCT a.FRATETYPEID
from T_FA_ACCTPOLICY a
inner join T_FA_ACCTPOLICYORG b
on b.FACCTPOLICYID = a.FACCTPOLICYID
INNER JOIN T_ORG_ACCOUNTSYSTEM c
on b.facctsystemid = c.facctsystemid
inner join T_ORG_ACCTSYSENTRY d
on c.facctsystemid = d.facctsystemid
inner join T_ORG_ACCTSYSDETAIL e
on d.fentryid = e.fentryid
where a.FDOCUMENTSTATUS = 'C'
and a.FFORBIDSTATUS = 'A'
and b.FACCTORGID = d.fmainorgid
and b.FISDEFAULT = '1'
and c.FISDEFAULT='1'
AND (D.FMAINORGID =
T_CN_INNERACTINIT.FPAYORGID OR
e.FSUBORGID =
T_CN_INNERACTINIT.FPAYORGID)),
0)
where fexchangetype = 0
列名 'fexchangetype' 无效。
SQL脚本错误:UPDATE T_CN_INNERACTINITENTRY
SET FEXCHANGERATE = ISNULL((Select A.FExchangeRate
from T_BD_RATE A
INNER JOIN T_CN_INNERACTINIT B
ON A.FRATETYPEID = B.FEXCHANGETYPE
AND A.FENDDATE >= B.FDATE
AND A.FBEGDATE <= B.FDATE
where FForbidderID = 0
and ((FCYForID =
T_CN_INNERACTINITENTRY.FCURRENCYID and
B.FMAINBOOKID = FCYTOID) OR
(FCYTOID =
T_CN_INNERACTINITENTRY.FCURRENCYID and
B.FMAINBOOKID = FCYFORID))
and FFORBIDSTATUS = 'A'
and A.FDOCUMENTSTATUS = 'C'
AND B.FID = T_CN_INNERACTINITENTRY.FID),
0)
where FEXCHANGERATE = 0
列名 'FEXCHANGERATE' 无效。
SQL脚本错误:UPDATE T_CN_INNERACTINITENTRY
SET FEXCHANGERATE = 1
WHERE EXISTS
(SELECT 1
FROM T_CN_INNERACTINIT
WHERE T_CN_INNERACTINIT.fmainbookid =
T_CN_INNERACTINITENTRY.FCURRENCYID
AND T_CN_INNERACTINIT.FID = T_CN_INNERACTINITENTRY.FID)
列名 'fmainbookid' 无效。
SQL脚本错误:UPDATE T_CN_INNERACTINITENTRY SET FYEARDEBITAMOUNTLOC = FYEARDEBITAMOUNT * FEXCHANGERATE where FYEARDEBITAMOUNTLOC=0
列名 'FYEARDEBITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_INNERACTINITENTRY SET FYEARCREDITAMOUNTLOC = FYEARCREDITAMOUNT * FEXCHANGERATE where FYEARCREDITAMOUNTLOC=0
列名 'FYEARCREDITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_INNERACTINITENTRY SET FINITAMOUNTLOC = FINITAMOUNT * FEXCHANGERATE where FINITAMOUNTLOC=0
列名 'FINITAMOUNTLOC' 无效。
SQL脚本错误:update T_CN_CASHBALANCE
set FMAINBOOKCURID = ISNULL((select DISTINCT a.FCURRENCYID
from T_FA_ACCTPOLICY a
inner join T_FA_ACCTPOLICYORG b
on b.FACCTPOLICYID = a.FACCTPOLICYID
INNER JOIN T_ORG_ACCOUNTSYSTEM c
on b.facctsystemid = c.facctsystemid
inner join T_ORG_ACCTSYSENTRY d
on c.facctsystemid = d.facctsystemid
inner join T_ORG_ACCTSYSDETAIL e
on d.fentryid = e.fentryid
where a.FDOCUMENTSTATUS = 'C'
and a.FFORBIDSTATUS = 'A'
and b.FACCTORGID = d.fmainorgid
and b.FISDEFAULT = '1'
and c.FISDEFAULT='1'
AND (D.FMAINORGID =
T_CN_CASHBALANCE.FPAYORGID OR
e.FSUBORGID =
T_CN_CASHBALANCE.FPAYORGID)),
0)
where FMAINBOOKCURID = 0
列名 'FMAINBOOKCURID' 无效。
SQL脚本错误:IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CN_CASHBALANCE')
BEGIN
INSERT INTO T_CN_CASHBALANCETMP(
FID ,
FBILLNO ,
FSETTLEORGID ,
FPAYORGID ,
FDATE ,
FDOCUMENTSTATUS ,
FMAINBOOKCURID ,
FEXCHANGETYPE
)
SELECT
FID ,
FBILLNO ,
FSETTLEORGID ,
FPAYORGID ,
FDATE ,
FDOCUMENTSTATUS ,
FMAINBOOKCURID ,
0 FROM T_CN_CASHBALANCE
END
列名 'FMAINBOOKCURID' 无效。
SQL脚本错误:IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CN_CASHBALANCEENTY')
BEGIN
INSERT INTO T_CN_CASHBALANCEENTYTMP(
FID ,
FENTRYID ,
FSEQ ,
FCURRENCYID ,
FAMOUNT ,
FDC ,
FYEARDEBITAMOUNT ,
FYEARCREDITAMOUNT ,
FYEARDEBITAMOUNTLOC ,
FYEARCREDITAMOUNTLOC ,
FAMOUNTLOC ,
FEXCHANGERATE
)
SELECT
FID ,
FENTRYID ,
FSEQ ,
FCURRENCYID ,
FAMOUNT ,
FDC ,
FYEARDEBITAMOUNT ,
FYEARCREDITAMOUNT ,
FYEARDEBITAMOUNTLOC ,
FYEARCREDITAMOUNTLOC ,
FAMOUNTLOC ,
0 FROM T_CN_CASHBALANCEENTY
END
列名 'FYEARDEBITAMOUNTLOC' 无效。
列名 'FYEARCREDITAMOUNTLOC' 无效。
列名 'FAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_CASHBALANCEENTY SET FYEARDEBITAMOUNTLOC=(SELECT FYEARDEBITAMOUNTLOC FROM T_CN_CASHBALANCEENTYTMP WHERE T_CN_CASHBALANCEENTYTMP.FENTRYID=T_CN_CASHBALANCEENTY.FENTRYID)
列名 'FYEARDEBITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_CASHBALANCEENTY SET FYEARCREDITAMOUNTLOC=(SELECT FYEARCREDITAMOUNTLOC FROM T_CN_CASHBALANCEENTYTMP WHERE T_CN_CASHBALANCEENTYTMP.FENTRYID=T_CN_CASHBALANCEENTY.FENTRYID)
列名 'FYEARCREDITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_CASHBALANCEENTY SET FAMOUNTLOC=(SELECT FAMOUNTLOC FROM T_CN_CASHBALANCEENTYTMP WHERE T_CN_CASHBALANCEENTYTMP.FENTRYID=T_CN_CASHBALANCEENTY.FENTRYID)
列名 'FAMOUNTLOC' 无效。
SQL脚本错误:update T_CN_BANKACNTBAL
set FMAINBOOKCURID = ISNULL((select DISTINCT a.FCURRENCYID
from T_FA_ACCTPOLICY a
inner join T_FA_ACCTPOLICYORG b
on b.FACCTPOLICYID = a.FACCTPOLICYID
INNER JOIN T_ORG_ACCOUNTSYSTEM c
on b.facctsystemid = c.facctsystemid
inner join T_ORG_ACCTSYSENTRY d
on c.facctsystemid = d.facctsystemid
inner join T_ORG_ACCTSYSDETAIL e
on d.fentryid = e.fentryid
where a.FDOCUMENTSTATUS = 'C'
and a.FFORBIDSTATUS = 'A'
and b.FACCTORGID = d.fmainorgid
and b.FISDEFAULT = '1'
and c.FISDEFAULT='1'
AND (D.FMAINORGID =
T_CN_BANKACNTBAL.FPAYORGID OR
e.FSUBORGID =
T_CN_BANKACNTBAL.FPAYORGID)),
0)
where FMAINBOOKCURID = 0
列名 'FMAINBOOKCURID' 无效。
SQL脚本错误:IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CN_BANKACNTBAL')
BEGIN
INSERT INTO T_CN_BANKACNTBALTMP(
FID ,
FBILLNO ,
FSETTLEORGID ,
FPAYORGID ,
FDATE ,
FDOCUMENTSTATUS ,
FMAINBOOKCURID ,
FEXCHANGETYPE
)
SELECT
FID ,
FBILLNO ,
FSETTLEORGID ,
FPAYORGID ,
FDATE ,
FDOCUMENTSTATUS ,
FMAINBOOKCURID ,
0 FROM T_CN_BANKACNTBAL
END
列名 'FMAINBOOKCURID' 无效。
SQL脚本错误:IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CN_BANKACNTBALENTRY')
BEGIN
INSERT INTO T_CN_BANKACNTBALENTRYTMP(
FID ,
FENTRYID ,
FSEQ ,
FCURRENCYID ,
FBANKACNTID ,
FINNERACCOUNTID ,
FYEARDEBITAMOUNT ,
FYEARCREDITAMOUNT ,
FENTAMOUNT ,
FYEARDEBITAMOUNTLOC ,
FYEARCREDITAMOUNTLOC ,
FENTAMOUNTLOC ,
FEXCHANGERATE
)
SELECT
FID ,
FENTRYID ,
FSEQ ,
FCURRENCYID ,
FBANKACNTID ,
FINNERACCOUNTID ,
FYEARDEBITAMOUNT ,
FYEARCREDITAMOUNT ,
FENTAMOUNT ,
FYEARDEBITAMOUNTLOC ,
FYEARCREDITAMOUNTLOC ,
FENTAMOUNTLOC ,
0 FROM T_CN_BANKACNTBALENTRY
END
列名 'FYEARDEBITAMOUNTLOC' 无效。
列名 'FYEARCREDITAMOUNTLOC' 无效。
列名 'FENTAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_BANKACNTBALENTRY SET FYEARDEBITAMOUNTLOC=(SELECT FYEARDEBITAMOUNTLOC FROM T_CN_BANKACNTBALENTRYTMP WHERE T_CN_BANKACNTBALENTRYTMP.FENTRYID=T_CN_BANKACNTBALENTRY.FENTRYID)
列名 'FYEARDEBITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_BANKACNTBALENTRY SET FYEARCREDITAMOUNTLOC=(SELECT FYEARCREDITAMOUNTLOC FROM T_CN_BANKACNTBALENTRYTMP WHERE T_CN_BANKACNTBALENTRYTMP.FENTRYID=T_CN_BANKACNTBALENTRY.FENTRYID)
列名 'FYEARCREDITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_BANKACNTBALENTRY SET FENTAMOUNTLOC=(SELECT FENTAMOUNTLOC FROM T_CN_BANKACNTBALENTRYTMP WHERE T_CN_BANKACNTBALENTRYTMP.FENTRYID=T_CN_BANKACNTBALENTRY.FENTRYID)
列名 'FENTAMOUNTLOC' 无效。
SQL脚本错误:update T_CN_INNERBALFORPAYORG
set FMAINBOOKCURID = ISNULL((select DISTINCT a.FCURRENCYID
from T_FA_ACCTPOLICY a
inner join T_FA_ACCTPOLICYORG b
on b.FACCTPOLICYID = a.FACCTPOLICYID
INNER JOIN T_ORG_ACCOUNTSYSTEM c
on b.facctsystemid = c.facctsystemid
inner join T_ORG_ACCTSYSENTRY d
on c.facctsystemid = d.facctsystemid
inner join T_ORG_ACCTSYSDETAIL e
on d.fentryid = e.fentryid
where a.FDOCUMENTSTATUS = 'C'
and a.FFORBIDSTATUS = 'A'
and b.FACCTORGID = d.fmainorgid
and b.FISDEFAULT = '1'
and c.FISDEFAULT='1'
AND (D.FMAINORGID =
T_CN_INNERBALFORPAYORG.FPAYORGID OR
e.FSUBORGID =
T_CN_INNERBALFORPAYORG.FPAYORGID)),
0)
where FMAINBOOKCURID = 0
列名 'FMAINBOOKCURID' 无效。
SQL脚本错误:IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CN_INNERBALFORPAYORG')
BEGIN
INSERT INTO T_CN_INNERBALFORPAYORGTMP(
FID ,
FBILLNO ,
FPAYORGID ,
FDATE ,
FDOCUMENTSTATUS ,
FMAINBOOKCURID ,
FEXCHANGETYPE
)
SELECT
FID ,
FBILLNO ,
FPAYORGID ,
FDATE ,
FDOCUMENTSTATUS ,
FMAINBOOKCURID ,
0 FROM T_CN_INNERBALFORPAYORG
END
列名 'FMAINBOOKCURID' 无效。
SQL脚本错误:IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CN_INNERBALFORPAYORGENTRY')
BEGIN
INSERT INTO T_CN_INNERBALFORPAYORGENTRYTMP(
FID ,
FENTRYID ,
FSEQ ,
FCURRENCYID ,
FINNERACCOUNTID ,
FYEARDEBITAMOUNT ,
FYEARCREDITAMOUNT ,
FENTAMOUNT ,
FYEARDEBITAMOUNTLOC ,
FYEARCREDITAMOUNTLOC ,
FENTAMOUNTLOC ,
FEXCHANGERATE
)
SELECT
FID ,
FENTRYID ,
FSEQ ,
FCURRENCYID ,
FINNERACCOUNTID ,
FYEARDEBITAMOUNT ,
FYEARCREDITAMOUNT ,
FENTAMOUNT ,
FYEARDEBITAMOUNTLOC ,
FYEARCREDITAMOUNTLOC ,
FENTAMOUNTLOC ,
0 FROM T_CN_INNERBALFORPAYORGENTRY
END
列名 'FYEARDEBITAMOUNTLOC' 无效。
列名 'FYEARCREDITAMOUNTLOC' 无效。
列名 'FENTAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_INNERBALFORPAYORGENTRY SET FYEARDEBITAMOUNTLOC=(SELECT FYEARDEBITAMOUNTLOC FROM T_CN_INNERBALFORPAYORGENTRYTMP WHERE T_CN_INNERBALFORPAYORGENTRYTMP.FENTRYID=T_CN_INNERBALFORPAYORGENTRY.FENTRYID)
列名 'FYEARDEBITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_INNERBALFORPAYORGENTRY SET FYEARCREDITAMOUNTLOC=(SELECT FYEARCREDITAMOUNTLOC FROM T_CN_INNERBALFORPAYORGENTRYTMP WHERE T_CN_INNERBALFORPAYORGENTRYTMP.FENTRYID=T_CN_INNERBALFORPAYORGENTRY.FENTRYID)
列名 'FYEARCREDITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_INNERBALFORPAYORGENTRY SET FENTAMOUNTLOC=(SELECT FENTAMOUNTLOC FROM T_CN_INNERBALFORPAYORGENTRYTMP WHERE T_CN_INNERBALFORPAYORGENTRYTMP.FENTRYID=T_CN_INNERBALFORPAYORGENTRY.FENTRYID)
列名 'FENTAMOUNTLOC' 无效。
SQL脚本错误:update T_CN_INNERBANKBAL
set FMAINBOOKCURID = ISNULL((select DISTINCT a.FCURRENCYID
from T_FA_ACCTPOLICY a
inner join T_FA_ACCTPOLICYORG b
on b.FACCTPOLICYID = a.FACCTPOLICYID
INNER JOIN T_ORG_ACCOUNTSYSTEM c
on b.facctsystemid = c.facctsystemid
inner join T_ORG_ACCTSYSENTRY d
on c.facctsystemid = d.facctsystemid
inner join T_ORG_ACCTSYSDETAIL e
on d.fentryid = e.fentryid
where a.FDOCUMENTSTATUS = 'C'
and a.FFORBIDSTATUS = 'A'
and b.FACCTORGID = d.fmainorgid
and b.FISDEFAULT = '1'
and c.FISDEFAULT='1'
AND (D.FMAINORGID =
T_CN_INNERBANKBAL.FPAYORGID OR
e.FSUBORGID =
T_CN_INNERBANKBAL.FPAYORGID)),
0)
where FMAINBOOKCURID = 0
列名 'FMAINBOOKCURID' 无效。
SQL脚本错误:IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CN_INNERBANKBAL')
BEGIN
INSERT INTO T_CN_INNERBANKBALTMP(
FID ,
FBILLNO ,
FPAYORGID ,
FDATE ,
FDOCUMENTSTATUS ,
FMAINBOOKCURID ,
FEXCHANGETYPE
)
SELECT
FID ,
FBILLNO ,
FPAYORGID ,
FDATE ,
FDOCUMENTSTATUS ,
FMAINBOOKCURID ,
0 FROM T_CN_INNERBANKBAL
END
列名 'FMAINBOOKCURID' 无效。
SQL脚本错误:IF EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CN_INNERBANKBALENTRY')
BEGIN
INSERT INTO T_CN_INNERBANKBALENTRYTMP(
FID ,
FENTRYID ,
FSEQ ,
FCURRENCYID ,
FINNERACCOUNTID ,
FYEARDEBITAMOUNT ,
FYEARCREDITAMOUNT ,
FENTAMOUNT ,
FYEARDEBITAMOUNTLOC ,
FYEARCREDITAMOUNTLOC ,
FENTAMOUNTLOC ,
FEXCHANGERATE
)
SELECT
FID ,
FENTRYID ,
FSEQ ,
FCURRENCYID ,
FINNERACCOUNTID ,
FYEARDEBITAMOUNT ,
FYEARCREDITAMOUNT ,
FENTAMOUNT ,
FYEARDEBITAMOUNTLOC ,
FYEARCREDITAMOUNTLOC ,
FENTAMOUNTLOC ,
0 FROM T_CN_INNERBANKBALENTRY
END
列名 'FYEARDEBITAMOUNTLOC' 无效。
列名 'FYEARCREDITAMOUNTLOC' 无效。
列名 'FENTAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_INNERBANKBALENTRY SET FYEARDEBITAMOUNTLOC=(SELECT FYEARDEBITAMOUNTLOC FROM T_CN_INNERBANKBALENTRYTMP WHERE T_CN_INNERBANKBALENTRYTMP.FENTRYID=T_CN_INNERBANKBALENTRY.FENTRYID)
列名 'FYEARDEBITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_INNERBANKBALENTRY SET FYEARCREDITAMOUNTLOC=(SELECT FYEARCREDITAMOUNTLOC FROM T_CN_INNERBANKBALENTRYTMP WHERE T_CN_INNERBANKBALENTRYTMP.FENTRYID=T_CN_INNERBANKBALENTRY.FENTRYID)
列名 'FYEARCREDITAMOUNTLOC' 无效。
SQL脚本错误:UPDATE T_CN_INNERBANKBALENTRY SET FENTAMOUNTLOC=(SELECT FENTAMOUNTLOC FROM T_CN_INNERBANKBALENTRYTMP WHERE T_CN_INNERBANKBALENTRYTMP.FENTRYID=T_CN_INNERBANKBALENTRY.FENTRYID)
列名 'FENTAMOUNTLOC' 无效。
---脚本错误End---
推荐阅读