欢迎来到芜湖云友软件技术有限公司(科友软件),我们已经为3600多家客户提供专业的软件服务!
客服电话:0553-3930001/3939689

知识库

用友畅捷通T1商贸宝11.5升级到12.0升级脚本补丁文件下载

发布时间:2021-03-04 21:58:00 访问数:1304

CREATE TABLE [dbo].[F_SetUfidaCode] (
[AutoID] [int] IDENTITY (1, 1) NOT NULL ,
[SetType] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[BillType] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[ProdID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[AccID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_CodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_CodeName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[U_YFCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_YFCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_CGTaxCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_CGTaxCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_CGYHCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_CGYHCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_YSCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_YSCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_XSTaxCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_XSTaxCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_XSYHCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_XSYHCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_VipCardCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_VipCardCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_DJJCodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_DJJCodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_DJJCECodeID] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[U_DJJCECodeName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO


 CREATE  CLUSTERED  INDEX [IX_SetUfidaCode] ON [dbo].[F_SetUfidaCode]([SetType]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[F_PZList] ADD 
CONSTRAINT [DF_F_PZList_Bill_Type_Sale] DEFAULT ('') FOR [BillType_Sale],
CONSTRAINT [DF_F_PZList_MoneyJF] DEFAULT (0) FOR [MoneyJF],
CONSTRAINT [DF_F_PZList_MoneyDF] DEFAULT (0) FOR [MoneyDF],
CONSTRAINT [DF_F_PZList_NumJF] DEFAULT (0) FOR [NumJF],
CONSTRAINT [DF_F_PZList_NumDF] DEFAULT (0) FOR [NumDF],
CONSTRAINT [DF_F_PZList_ZS] DEFAULT (0) FOR [ZS],
CONSTRAINT [DF_F_PZList_PZFlag] DEFAULT (0) FOR [PZFlag]
GO

ALTER TABLE [dbo].[F_SetUfidaCode] ADD 
CONSTRAINT [DF_SetUfidaCode_SetType] DEFAULT ('') FOR [SetType],
CONSTRAINT [DF_SetUfidaCode_BillType] DEFAULT ('') FOR [BillType],
CONSTRAINT [DF_SetUfidaCode_ProdID] DEFAULT ('') FOR [ProdID],
CONSTRAINT [DF_SetUfidaCode_AccID] DEFAULT ('') FOR [AccID],
CONSTRAINT [DF_SetUfidaCode_U_CodeID] DEFAULT ('') FOR [U_CodeID],
CONSTRAINT [DF_SetUfidaCode_U_CodeName] DEFAULT ('') FOR [U_CodeName],
CONSTRAINT [DF_SetUfidaCode_U_YFCodeID] DEFAULT ('') FOR [U_YFCodeID],
CONSTRAINT [DF_SetUfidaCode_U_YFCodeName] DEFAULT ('') FOR [U_YFCodeName],
CONSTRAINT [DF_SetUfidaCode_U_CGTaxCodeID] DEFAULT ('') FOR [U_CGTaxCodeID],
CONSTRAINT [DF_SetUfidaCode_U_CGTaxCodeName] DEFAULT ('') FOR [U_CGTaxCodeName],
CONSTRAINT [DF_SetUfidaCode_U_CGYHCodeID] DEFAULT ('') FOR [U_CGYHCodeID],
CONSTRAINT [DF_SetUfidaCode_U_CGYHCodeName] DEFAULT ('') FOR [U_CGYHCodeName],
CONSTRAINT [DF_SetUfidaCode_U_YSCodeID] DEFAULT ('') FOR [U_YSCodeID],
CONSTRAINT [DF_SetUfidaCode_U_YSCodeName] DEFAULT ('') FOR [U_YSCodeName],
CONSTRAINT [DF_SetUfidaCode_U_XSTaxCodeID] DEFAULT ('') FOR [U_XSTaxCodeID],
CONSTRAINT [DF_SetUfidaCode_U_XSTaxCodeName] DEFAULT ('') FOR [U_XSTaxCodeName],
CONSTRAINT [DF_SetUfidaCode_U_XSYHCodeID] DEFAULT ('') FOR [U_XSYHCodeID],
CONSTRAINT [DF_SetUfidaCode_U_XSYHCodeName] DEFAULT ('') FOR [U_XSYHCodeName],
CONSTRAINT [DF_SetUfidaCode_U_VipCardCodeID] DEFAULT ('') FOR [U_VipCardCodeID],
CONSTRAINT [DF_SetUfidaCode_U_VipCardCodeName] DEFAULT ('') FOR [U_VipCardCodeName],
CONSTRAINT [DF_SetUfidaCode_U_DJJCodeID] DEFAULT ('') FOR [U_DJJCodeID],
CONSTRAINT [DF_SetUfidaCode_U_DJJCodeName] DEFAULT ('') FOR [U_DJJCodeName]
GO


CREATE TABLE [dbo].[F_StorBill] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[FullID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ChoiceID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Bill_SID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Bill_SN] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[BillType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ChoiceID_XSCB_QT] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ChoiceID_XSSR] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ChoiceID_XSCB_QT_Flag] [bit] NOT NULL ,
[ChoiceID_XSSR_Flag] [bit] NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[F_StorBill] WITH NOCHECK ADD 
CONSTRAINT [PK_F_StorBill] PRIMARY KEY  CLUSTERED 
(
[ID]
)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[F_StorBill] ADD 
CONSTRAINT [DF_F_StorBill_BillType] DEFAULT ('') FOR [BillType],
CONSTRAINT [DF_F_StorBill_ChoiceID_XSCB_QT_Flag] DEFAULT (0) FOR [ChoiceID_XSCB_QT_Flag],
CONSTRAINT [DF_F_StorBill_ChoiceID_XSSR_Flag] DEFAULT (0) FOR [ChoiceID_XSSR_Flag]
GO

TAG: 用友T1 T1商贸宝 畅捷通T1
上一篇:用友畅捷通T1商贸宝11.1升级到11.5升级脚本补丁文件下载
下一篇:用友T1畅捷通商贸宝财务增强包系统集成组件补丁脚本下载