问题现象: | 帐套两个年度,2010年升级失败,2011年升级成功。具体错误如下: 数据库名: UFDATA_001_2010 D:U8SOFTAdminSQLFILE10000MainUfdataStructureData_PRV_AP_mix_NL.sql 错误信息: -2147217900 为视图或函数 'Ap_DetailVend' 指定的列名比其定义中的列多。 执行如下语句时出错: CREATE PROC Ap_Proc_Alert --参数 @iType TINYINT=0, --报警类型:0:信用期,1:折扣期 @iDays INT=0, --提前期 @dCurDate DATETIME, --业务日期 @cDwCode1 VARCHAR(30)='', @cDwCode2 VARCHAR(30)='ZZZZZZZZZZZZZZZZZZZZ', --客户范围:@cDwCode1--@cDwCode2 @cVouchClass VARCHAR(2)='', --单据种类:销售发票:'2',采购发票:'0',应收单:'R',应付单:'P' @cVouchType VARCHAR(2)='', --单据类型 @cVouchID1 VARCHAR(30)='', @cVouchID2 VARCHAR(30)='', --单据编码范围:@cVouchID1--@cVouchID2 @dVouchDate1 DATETIME='1900-1-1', @dVouchDate2 DATETIME='3000-1-1', --单据日期范围:@dVouchDate1--@dVouchDate2 @dRegDate1 DATETIME='1900-1-1', @dRegDate2 DATETIME='3000-1-1', --审核日期范围:@dRegDate1--@dRegDate2 @cExchName VARCHAR(8)='', --币种 @iAmount1 MONEY=NULL, @iAmount2 MONEY=NULL, --金额范围(原币):@iAmount1--@iAmount2 @iRAmount1 MONEY=NULL, @iRAmount2 MONEY=NULL, --余额范围(原币):@iRAmount1--@iRAmount2 @cDepCode VARCHAR(12)='', --部门编码 @cPersonCode VARCHAR(8)='', --业务员编码 @cCode VARCHAR(15)='', --科目编码 @cItemCode VARCHAR(20)='', --项目编码 @iCheck TINYINT=3, --审核标志:包含已审核:1,包含未审核:2(用位运算&) @iBill TINYINT=3, --制单标志:包含已制单:1,包含未制单:2(用位运算&) @cFlag VARCHAR(2)='AR' AS IF @cDwCode1='' SET @cDwCode1=nchar(1) IF @cFlag='AR' --应收 SELECT cCoVouchType As cVouchType,Max(cCoTypeName) As cTypeName,cCoVouchID As cVouchID,Min(dVouchDate) As dVouchDate, cDwCode,Max(cDwName) As cDwName,Max(cDepName) As cDepName,Max(cPersonName) As cPersonName, Max(cPayName) As cPayName,Max(cItem_Class) As cItem_Class,Max(cItemCode) As cItemCode,Max(dExpireDate) As dExpireDate, max(cExch_Name) As cExch_Name,Max(iExchRate) As iExchRate,sum(iDAmount_f) As iAmount_f, sum(iDAmount) As iAmount,sum(iDAmount_f-iCAmount_f) As iRAmount_f,sum(iDAmount-iCAmount) As iRAmount, Max(CASE WHEN cProcStyle=cCoVouchType Or cProcStyle='BZ' THEN cDigest Else '' End) As cDigest,Max(iCreLine) as iCreLine FROM Ar_DetailCust WHERE iflag<3 And (cCoVouchType Like'2%' OR cCoVouchType Like'R%') AND cDwCode BETWEEN @cDwCode1 AND @cDwCode2 And cCoVouchType Like @cVouchClass+'%' AND (cCoVouchType=@cVouchType OR @cVouchType='') And (cCoVouchID>=@cVouchID1 OR @cVouchID1='') AND (cCoVouchID<=@cVouchID2 OR @cVouchID2='') AND (@cExchName='' OR cExch_Name=@cExchName) GROUP BY cDwCode,cCoVouchType,cCoVouchID HAVING sum(iDAmount_f-iCAmount_f)<>0 and CASE WHEN @iType=0 THEN Max(dExpireDate) ELSE Max(dFADate) END-@iDays<=@dCurDate And max(dVouchDate) BETWEEN @dVouchDate1 AND @dVouchDate2 And Max(CASE WHEN cProcStyle=cCoVouchType THEN dRegDate ELSE 0 END) BETWEEN @dRegDate1 AND @dRegDate2 AND (@iAmount1 Is Null OR sum(iDAmount_f)>=@iAmount1) And (@iAmount2 Is Null OR sum(iDAmount_f)<=@iAmount2) AND (@iRAmount1 Is Null OR sum(iDAmount_f-iCAmount_f)>=@iRAmount1) And (@iRAmount2 Is Null OR sum(iDAmount_f-iCAmount_f)<=@iRAmount2) AND (@cDepCode='' OR Max(cDeptCode) Like @cDepCode+'%') And (@cPersonCode='' OR Max(cPerson)=@cPersonCode) And (@cCode='' OR Max(cCode) Like @cCode+'%') AND (@cItemCode='' OR Max(cItemCode)=@cItemCode) And @iCheck & 1<>0 AND Min(CASE WHEN cProcStyle=cCoVouchType AND cPZID Is not Null THEN 1 ELSE 2 END) & @iBill<>0 UNION ALL |
问题原因: | |
解决方案: | 您好,谢谢您的反馈,请直接关闭此问题(只有提交问题的人才能关闭问题,或系统自动关闭),不用再反馈,谢谢! 如有问题,请及时反馈! U8/CRM/PLM |
相关补丁: | |
版本: | U8 V10.0 |
模块: | 系统管理 |
产品: | 公共平台 |
问题名称: | 890升级V10.0升级年度帐2010年失败 |
最后更新: | 2011-07-27 23:19:24 |