KIS 专业版v8.0自定义的核算项目类别添加核算项目明细时出错
问题描述 自定义的核算项目类别添加核算项目明细时出错，系统提示：定义的应用程序或对象错误 错
误代码:3639(E37H) Source :EBSGLItem.ItemUpdate.Create Detail : 对象名
'Access_t_ItemDefine' 无效。
问题原因 当前账套中丢失了数据表：Access_t_ItemDefine
解决方法 SQL 语句参考如下：
*/
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Access_t_ItemDefine]') and OBJECTPROPERTY(id, N'IsUserTable') =
1)
drop table [dbo].[Access_t_ItemDefine]
GO
CREATE TABLE [dbo].[Access_t_ItemDefine] (
[FItemID] [int] NOT NULL ,
[FParentIDX] [int] NOT NULL ,
[FDataAccessDelete] [binary] (100) NOT NULL ,
[FDataAccessEdit] [binary] (100) NOT NULL ,
[FDataAccessView] [binary] (100) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Access_t_ItemDefine] WITH NOCHECK ADD
CONSTRAINT [PK_Access_t_ItemDefine] PRIMARY KEY CLUSTERED
(
[FItemID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Access_t_ItemDefine] ADD CONSTRAINT [DF_Access_t_ItemDefine_FDataAccessDelete] DEFAULT (0) FOR
[FDataAccessDelete],
CONSTRAINT [DF_Access_t_ItemDefine_FDataAccessEdit] DEFAULT (0) FOR
[FDataAccessEdit],
CONSTRAINT [DF_Access_t_ItemDefine_FDataAccessView] DEFAULT (0) FOR
[FDataAccessView]
GO
|
|
|
返回列表 返回顶部