知识库

----------------------财务接口------------------------------------------



ALTER TABLE setgridinfo
ADD [FieldHide] bit DEFAULT (0)
go


-------------------------------------------------------------------------------


alter table Units alter column  AReceive_0 numeric(28,12)
go
alter table Units alter column  APayDue_0 numeric(28,12)
go
ALTER TABLE Department ADD AReceive_0 numeric(28,12)

go
ALTER TABLE Department ADD APayDue_0 numeric(28,12)

go
ALTER table Employee ADD  AReceive_0 numeric(28,12)
go
ALTER table Employee ADD  APayDue_0 numeric(28,12)
go


ALTER TABLE dbo.MasterBill ADD
MakeUfidaPZList varchar(50) NULL
GO
ALTER TABLE dbo.MasterBill ADD CONSTRAINT
DF_MasterBill_MakeUfidaPZList DEFAULT '' FOR MakeUfidaPZList
GO

ALTER TABLE dbo.MasterBill ADD
FirstDate varchar(10) NULL
go         

ALTER TABLE dbo.MasterBill ADD
BillTime varchar(10) NULL
go


ALTER TABLE dbo.MasterBillDft ADD
BillTime varchar(10) NULL
go

ALTER TABLE dbo.DTS_MasterBill ADD
BillTime varchar(10) NULL
go



CREATE TABLE [PromStorHouse] (
[s_PID] [int] NOT NULL ,
[s_SID] [int] NOT NULL ,
CONSTRAINT [PK_PromotionStorHouse] PRIMARY KEY  CLUSTERED 
(
[s_PID],
[s_SID]
)  ON [PRIMARY] ,
CONSTRAINT [FK_PromStorHouse_SalesAdv] FOREIGN KEY 
(
[s_PID]
) REFERENCES [SalesAdv] (
[s_ID]
) ON DELETE CASCADE 
) ON [PRIMARY]
GO

ALTER TABLE dbo.SalesAdvList WITH NOCHECK ADD CONSTRAINT
FK_PromotionList_Promotion FOREIGN KEY
(
Prom_ID
) REFERENCES dbo.SalesAdv
(
s_ID
) ON DELETE CASCADE

GO
go
ALTER TABLE dbo.SalesAdvList ADD OldPrice numeric(28,10)
go


CREATE TABLE [dbo].[ImpowerType] (
[s_ID] [int] IDENTITY (1, 1) NOT NULL ,
[s_Syb] [smallint] NULL ,
[s_Content] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[InputSyb] [bit] NULL ,
[Remark1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Remark2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[ImpowerType] WITH NOCHECK ADD 
CONSTRAINT [PK_ImpowerType] PRIMARY KEY  CLUSTERED 
(
[s_ID]
)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ImpowerType] ADD 
CONSTRAINT [DF_ImpowerType_s_Content] DEFAULT ('') FOR [s_Content]
GO


CREATE TABLE [dbo].[RoleImpower] (
[s_ID] [int] IDENTITY (1, 1) NOT NULL ,
[s_Syb] [smallint] NULL ,
[Group_ID] [int] NOT NULL ,
[Class_ID] [int] NULL ,
[IT_ID] [int] NULL ,
[u_CheckE] [bit] NULL ,
[u_CheckV] [bit] NULL ,
[u_Value] [numeric](20, 10) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[RoleImpower] WITH NOCHECK ADD 
CONSTRAINT [PK_RoleImpower] PRIMARY KEY  CLUSTERED 
(
[s_ID]
)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[RoleImpower] ADD 
CONSTRAINT [DF_RoleImpower_u_Check] DEFAULT (0) FOR [u_CheckE],
CONSTRAINT [DF_RoleImpower_u_CheckE1] DEFAULT (0) FOR [u_CheckV]
GO

ALTER TABLE Product ADD InsteadProdID int null
go

ALTER TABLE Product ADD C_BIZHUB_ISMODIFIED bit DEFAULT 0
go

ALTER TABLE Units ADD UUNo varchar(50)
go


ALTER TABLE Employee ADD UUNo varchar(50)
go


ALTER TABLE VIPCard ADD UUNo varchar(50)
go

ALTER table F_PZList ALTER COLUMN MoneyJF numeric(28,12)
go

ALTER table F_PZList ALTER COLUMN MoneyDF numeric(28,12)
go

ALTER table F_PZList ALTER COLUMN NumJF numeric(28,12)
go

ALTER table F_PZList ALTER COLUMN NumDF numeric(28,12)
go