K3 RISE 12.2升级到旗舰版2.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,
...
推荐阅读