5.0PT120107-ic_invoiceentry无效

栏目:eas cloud知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:1

5.0PT120107-ic_invoiceentry无效

旗舰版5.0打了PT120107补丁。后所有账套的销售发票审核或反审核不了。
提示原因:对象名'ic_invoiceentry无效'

解决办法:建表,
语句如下:
执行语句前请备份账套

[code]
/****** Object: Table [dbo].[IC_InvoiceEntry] Script Date: 08/13/2018 13:41:27 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[IC_InvoiceEntry](
[FEntryID] [int] IDENTITY(1,1) NOT NULL,
[FID] [int] NOT NULL,
[FIndex] [int] NOT NULL,
[FItemID] [int] NOT NULL,
[FPackagedGoods] [int] NOT NULL,
[FUnitID] [int] NOT NULL,
[FInvName] [nvarchar](500) NULL,
[FInvUnitID] [varchar](40) NOT NULL,
[FQty] [decimal](28, 10) NOT NULL,
[FPrice] [decimal](28, 10) NOT NULL,
[FNotTaxPrice] [decimal](28, 10) NOT NULL,
[FNotTaxAmount] [decimal](20, 4) NOT NULL,
[FEntryTaxAmount] [decimal](20, 4) NOT NULL,
[FAfterDiscountAmount] [decimal](20, 4) NOT NULL,
[FTaxRate] [decimal](20, 4) NOT NULL,
[FEntryTax] [decimal](20, 4) NOT NULL,
[FItemType] [nvarchar](100) NOT NULL,
[FSourceInterId] [int] NOT NULL,
[FEntryID_SRC] [int] NOT NULL,
[FClassID_SRC] [int] NOT NULL,
[FBillNo_SRC] [nvarchar](1000) NOT NULL,
CONSTRAINT [PK_IC_InvoiceEntry] PRIMARY KEY NONCLUSTERED
(
[FEntryID] 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

SET ANSI_PADDING OFF
GO
[/code]

原地址:https://wenku.my7c.com/questions/43093783198892181


{:6_156:}

5.0PT120107-ic_invoiceentry无效

旗舰版5.0打了PT120107补丁。后所有账套的销售发票审核或反审核不了。提示原因:对象名'ic_invoiceentry无效'解决办法:建表,语句如下:执...
点击下载文档
分享:
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息