K3 RISE 12.2升级到旗舰版2.0 报错
金蝶云社区-云社区用户mDk05878
云社区用户mDk05878
0人赞赏了该文章 222次浏览 未经作者许可,禁止转载编辑于2018年11月12日 15:49:14

K3 RISE 12.2升级到旗舰版2.0 报错如下:

数据库升级失败!SQL文件不全或SQL语句有误!
错误描述:列名 'FBankNumber' 无效。
Sql文件名:C:\PROGRAM FILES\KINGDEE\KISERP\KISEXPRESS\KDSYSTEM\KDCOM\SqlSrv\SP_KEEV13.0ICView.sql
Sql内容:
--[NO SQL FILE INFOMATION]
CREATE VIEW vw_Organization
AS
SELECT t1.FItemID, t1.FAddress, t1.FCity, t1.FProvince, t1.FCountry, t1.FPostalCode, t1.FPhone, t1.FFax, t1.FEmail, t1.FHomePage, t1.FCreditLimit, t1.FTaxID,
t1.FBank, t1.FAccount, t1.FBankNumber, t1.FBrNo, t1.FBoundAttr, t1.FErpClsID, t1.FShortName, t1.FPriorityID, t1.FPOGroupID,
t1.FLanguageID, t1.FMinPOValue, t1.FMaxDebitDate, t1.FLegalPerson, t1.FContact, t1.FContactAcct, t1.FPhoneAcct,
t1.FFaxAcct, t1.FZipAcct, t1.FEmailAcct, t1.FAddrAcct,
...