前台点付款报错,提示对象名pos_quickpass 无效
问题描述:
前台点付款报错,提示对象名pos_quickpass 无效
解决方案:
执行以下脚本
/*[3664]*/
--增加银盲记录信息表
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'POS_BlindGiveInfo') AND type IN (N'U'))
BEGIN
CREATE TABLE POS_BlindGiveInfo(
[FShopID] [INT] NOT NULL,
[FShopDay] [DATETIME] NOT NULL,
[FStationNo] [VARCHAR](5) NOT NULL,
[FMoreCount] [INT] NOT NULL,
[FInputAmt] [DECIMAL](23, 11) NOT NULL,
[FEmpID] [INT] NOT NULL,
[FOperateDate] [DATETIME] NOT NULL,
CONSTRAINT [PK_POS_BlindGiveInfo] PRIMARY KEY CLUSTERED
(
[FShopID] ASC,
[FShopDay] ASC,
[FStationNo] ASC,
[FMoreCount] ASC
)
) ON [PRIMARY]
END
GO
if not exists (select 1 from sysobjects where id = object_id('POS_QuickPass') and type = 'U')
Begin
Create table POS_QuickPass
(
FId bigint identity,
FBillId bigint not null,
FPayAmt decimal(23,4) not null,
FPayState int not null,
FPayTime datetime not null default GetDate(),
FEmpId int null,
FCancelId bigint null,
FTrade_No varchar(150) null,
FRefund_Id varchar(150) null,
FOut_Trade_No varchar(150) null,
FShopId bigint null,
FShopDay datetime null,
constraint PK_POS_QUICKPASS_FID primary key (FId)
)
create index IX_POS_QuickPass_FBillId on POS_QuickPass (FBillId ASC)
end
go
IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'T_DIN_CustomerFoodType') AND name = N'PK_T_DIN_CustomerFoodType')
BEGIN
ALTER TABLE T_DIN_CustomerFoodType ADD CONSTRAINT [PK_T_DIN_CustomerFoodType] PRIMARY KEY CLUSTERED
(
[FID] ASC
)
END
GO
前台点付款报错,提示对象名pos_quickpass 无效
本文2024-09-23 04:23:18发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-164979.html