【问题描述】

旗舰版打开基础资料-核算项目管理-工程项目，提示：定义的应用程序或对象错误

【原因分析】

原因：缺失t_Base_ProjectItem表

【解决方案】

可参考以下脚本执行处理：

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[t_Base_ProjectItem](

[FItemID] [int] NOT NULL,

[FNumber] [nvarchar](80) NOT NULL,

[FName] [nvarchar](255) NOT NULL,

[FFullName] [nvarchar](255) NULL,

[FDeleted] [int] NOT NULL,

[FMgAcctID] [int] NOT NULL,

[FCostID] [int] NOT NULL,

[FCashID] [int] NOT NULL,

[FExpType] [int] NOT NULL,

[FRPAcctID] [int] NOT NULL,

[FAPAcctID] [int] NOT NULL,

[FNote] [nvarchar](255) NULL,

[FModifyTime] [timestamp] NULL,

 CONSTRAINT [pk_t_Base_ProjectItem] PRIMARY KEY CLUSTERED 

(

[FItemID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[t_Base_ProjectItem] ADD  DEFAULT (0) FOR [FDeleted]

GO

ALTER TABLE [dbo].[t_Base_ProjectItem] ADD  DEFAULT (0) FOR [FMgAcctID]

GO

ALTER TABLE [dbo].[t_Base_ProjectItem] ADD  DEFAULT (0) FOR [FCostID]

GO

ALTER TABLE [dbo].[t_Base_ProjectItem] ADD  DEFAULT (0) FOR [FCashID]

GO

ALTER TABLE [dbo].[t_Base_ProjectItem] ADD  DEFAULT (0) FOR [FExpType]

GO

ALTER TABLE [dbo].[t_Base_ProjectItem] ADD  DEFAULT (0) FOR [FRPAcctID]

GO

ALTER TABLE [dbo].[t_Base_ProjectItem] ADD  DEFAULT (0) FOR [FAPAcctID]

GO

insert into t_Base_ProjectItem (fitemid,fnumber,fname)

select fitemid,fnumber,fname from t_Item  where FItemClassID =2039 and FItemID  not in (select FItemID from t_Base_ProjectItem)

GO

【注意事项】

正式账套执行脚本前请先做好备份，建议待在测试账套中核实无误后再在正式账套中执行。