21数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE10000\Main\Ufdata\Structure\Data_PRV_QM_mix_NL.sql
错误信息:
-2147217900
列名'IPRINTCOUNT' 不明确。指定mom_orderdetail.IPRINTCOUNT
22数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE10000\Main\Ufdata\Structure\DATA_PRP_PB_MIX_NL.sql
错误信息:
-2147217865
对象名'dbo.sp_TransferPEtoLP_AA' 无效。
CREATE PROCEDURE [dbo].[sp_TransferPEtoLP_AA](
@iRequireTrackStyle int,
@sErrMsg nvarchar(500) OUTPUT
) AS
begin
declare @return_status int
declare @strSQL nvarchar(4000)
exec ('Update Inventory Set cSRPolicy = ''LP'' ,bSpecialOrder=1,bTrackSaleBill=1 where cInvCode in (select cInvCode from #T)')
if (@@error<>0)
begin
set @sErrMsg = N'更新存货档案(供需政策)失败！'
return -1
end
exec ('Update Inventory_Sub Set iRequireTrackStyle ='+@iRequireTrackStyle+' where cInvSubCode in (select cInvCode from #T)')
if (@@error<>0)
begin
set @sErrMsg = N'更新存货档案(需求跟踪方式)失败！'
return -1
end
return 0
end
alter table ufdata_005_2011.dbo.ca_batchmxhy_tmp add
[iflag] [bit] NOT NULL
24 数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE10000\Main\Ufdata\data\DP\DATA_DP_PB_MIX_NL.sql
错误信息:
-2147217900
找不到存储过程'sp_DataPrecision_CASC'。
Create Procedure [dbo].[sp_DataPrecision_CASC](@iStrsQuanDecDgt int,@iStrsPriDecDgt int,@iBillPrice int,
@iNumDecDgt int,@iExchRateDecDgt int,@iRateDecDgt int ,@cErrorMsg nvarchar(120) OUTPUT
)
AS
UPDATE voucheritems_base SET numpoint=@iStrsPriDecDgt
WHERE cardnum=N'CA50' and fieldname in (N'fInvStdCost',N'fLaborStdCost',N'fLaborStdCostB',N'fManuCost',N'fManuFixCost',
N'fManuFixCostB',N'fManuVarCost',N'fManuVarCostB',N'fOMCost',N'fOMCostB',N'TotalCost')
if @@ERROR<>0
BEGIN
SET @cErrorMsg=N'升级标准成本浮点位数出现错误'
RETURN -1
END
else
RETURN 0
25 数据库名: UFDATA_005_2011
E:\U8SOFT\Admin\SQLFILE10100\Main\Ufdata\Structure\Data_PRV_EX_mix_NL.sql
错误信息:
-2147217900
列名'frejectquantity' 无效。
