/****** Object:  Table [dbo].[cmLiaoWeiBG_Intf]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cmLiaoWeiBG_Intf](
	[KCLW] [varchar](38) NOT NULL,
	[LX] [int] NOT NULL,
	[DT] [datetime] NOT NULL,
	[SZ] [numeric](16, 4) NOT NULL,
	[LY] [int] NOT NULL,
	[ZY] [varchar](120) NULL,
	[BZ] [varchar](200) NULL
)
GO
/****** Object:  Table [dbo].[cmYuanLiaoYS_Intf_Log]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cmYuanLiaoYS_Intf_Log](
	[ISN] [bigint] IDENTITY(1,1) NOT NULL,
	[ITM] [datetime] NOT NULL,
	[ITP] [smallint] NOT NULL,
	[YLYS_ID] [varchar](38) NOT NULL,
	[YLYS_TM] [datetime] NULL,
 CONSTRAINT [PK_CMYUANLIAOYS_INTF_LOG] PRIMARY KEY NONCLUSTERED 
(
	[ISN] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  Table [dbo].[CmYuanLiaoXSGS]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CmYuanLiaoXSGS](
	[YLXSGS_ID] [varchar](38) NOT NULL,
	[YLXSGS_建档日期] [datetime] NOT NULL,
	[YLXSGS_MTM] [datetime] NOT NULL,
	[YLXSGS_编号] [varchar](20) NOT NULL,
	[YLXSGS_客户名称] [varchar](120) NOT NULL,
	[YLXSGS_地址] [varchar](200) NULL,
	[YLXSGS_联系人] [varchar](20) NULL,
	[YLXSGS_联系方式] [varchar](120) NULL,
	[YLXSGS_状态] [int] NULL,
	[YLXSGS_备注] [varchar](255) NULL,
 CONSTRAINT [PK_CMYUANLIAOXSGS] PRIMARY KEY NONCLUSTERED 
(
	[YLXSGS_ID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  StoredProcedure [dbo].[sp_who_lock]    Script Date: 12/09/2020 09:40:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create procedure [dbo].[sp_who_lock]
as
begin
declare @spid int,@bl int,
        @intTransactionCountOnEntry int,
        @intRowcount int,
        @intCountProperties int,
        @intCounter int

        create table #tmp_lock_who (
        id int identity(1,1),
        spid smallint,
        bl smallint)

        IF @@ERROR<>0 RETURN @@ERROR

        insert into #tmp_lock_who(spid,bl) select 0 ,blocked
          from (select * from sysprocesses where blocked>0 ) a 
          where not exists(select * from (select * from sysprocesses where blocked>0 ) b 
          where a.blocked=spid)
          union select spid,blocked from sysprocesses where blocked>0

        IF @@ERROR<>0 RETURN @@ERROR 

-- 找到临时表的记录数
        select @intCountProperties = Count(*),@intCounter = 1
        from #tmp_lock_who

        IF @@ERROR<>0 RETURN @@ERROR 

        if @intCountProperties=0
            select '现在没有阻塞和死锁信息' as message

-- 循环开始
while @intCounter <= @intCountProperties
begin
-- 取第一条记录
        select @spid = spid,@bl = bl
        from #tmp_lock_who where Id = @intCounter 
        begin
            if @spid =0 
                select '引起数据库死锁的是: '+ CAST(@bl AS VARCHAR(10)) + '进程号,其执行的SQL语法如下'
            else
                select '进程号SPID：'+ CAST(@spid AS VARCHAR(10))+ '被' + '进程号SPID：'+ CAST(@bl AS VARCHAR(10)) +'阻塞,其当前进程执行的SQL语法如下'
            DBCC INPUTBUFFER (@bl )
            end 

-- 循环指针下移
        set @intCounter = @intCounter + 1
end


drop table #tmp_lock_who

return 0
end
GO
/****** Object:  StoredProcedure [dbo].[Pro_UpcpFaTongJG]    Script Date: 12/09/2020 09:40:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROCEDURE [dbo].[Pro_UpcpFaTongJG]
    @Sql nvarchar(4000)
AS
BEGIN
    EXEC sp_executesql @Sql
END
GO
/****** Object:  StoredProcedure [dbo].[PRO_CiGongKSC]    Script Date: 12/09/2020 09:40:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROCEDURE [dbo].[PRO_CiGongKSC]
    @Sql nvarchar(max)
AS
BEGIN
   EXEC sp_executesql @Sql
END
GO
/****** Object:  StoredProcedure [dbo].[GetFaTogYS]    Script Date: 12/09/2020 09:40:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROCEDURE [dbo].[GetFaTogYS]
    @Sql nvarchar(max)
AS
BEGIN
  set nocount on;
  EXEC sp_executesql @Sql
END
  set nocount off;
GO
/****** Object:  Table [dbo].[cmYunShuGS]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cmYunShuGS](
	[YSGS_ID] [varchar](38) NOT NULL,
 CONSTRAINT [PK_CMYUNSHUGS] PRIMARY KEY NONCLUSTERED 
(
	[YSGS_ID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  StoredProcedure [dbo].[proc_ciGongKongJL_Intf]    Script Date: 12/09/2020 09:40:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[proc_ciGongKongJL_Intf](@UNIT int,@SCRQ datetime,@SCTM datetime, @SCID varchar(38), @PNO int, @PTM datetime, @PID varchar(30), @YLID varchar(30),
   @YLBH varchar(20),@YLMC varchar(60),@盘量 numeric(8, 4),@设定值 numeric(8, 3),@计量值 numeric(8, 3),@附加内容 varchar(512),@IUP bit)
as
 if not exists (SELECT 1 FROM ciGongKongJL_Intf with (nolock) WHERE UNIT = @UNIT AND SCRQ = @SCRQ AND SCTM =@SCTM AND SCID = @SCID AND PNO = @PNO AND PTM = @PTM AND PID = @PID AND YLID = @YLID) 
    INSERT INTO ciGongKongJL_Intf with(rowlock) (UNIT,SCRQ,SCTM,SCID,PNO,PTM,PID,YLID,YLBH,YLMC,盘量,设定值,计量值,附加内容,IUP) 
       VALUES (@UNIT,@SCRQ,@SCTM,@SCID,@PNO,@PTM,@PID,@YLID,@YLBH,@YLMC,@盘量,@设定值,@计量值,@附加内容,@IUP)  
     else  UPDATE ciGongKongJL_Intf with(rowlock) SET YLBH=@YLBH,YLMC=@YLMC,盘量=@盘量,设定值=@设定值,计量值=@计量值,附加内容=@附加内容,IUP=@IUP
   WHERE (UNIT = @UNIT AND SCRQ = @SCRQ AND SCTM =@SCTM AND SCID = @SCID AND PNO = @PNO AND PTM = @PTM AND PID = @PID AND YLID = @YLID)
GO
/****** Object:  Table [dbo].[cmYuanLiaoPZ]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cmYuanLiaoPZ](
	[YLPZ_ID] [varchar](38) NOT NULL,
	[YLPZ_MTM] [datetime] NOT NULL,
	[YLPZ_DEL] [bit] NULL,
	[YLPZ_原料类型] [int] NOT NULL,
	[YLPZ_编号] [varchar](20) NOT NULL,
	[YLPZ_名称] [varchar](160) NOT NULL,
	[YLPZ_品种名称] [varchar](60) NOT NULL,
	[YLPZ_规格等级] [varchar](20) NULL,
	[YLPZ_产地厂别] [varchar](60) NULL,
	[YLPZ_折方换算] [bit] NOT NULL,
	[YLPZ_折方系数] [numeric](10, 6) NULL,
	[YLPZ_暗扣模式] [int] NOT NULL,
	[YLPZ_暗扣率] [numeric](4, 2) NULL,
	[YLPZ_暗扣值] [numeric](8, 3) NULL,
	[YLPZ_备注] [varchar](255) NULL,
	[YLPZ_状态] [int] NOT NULL,
 CONSTRAINT [PK_CMYUANLIAOPZ] PRIMARY KEY NONCLUSTERED 
(
	[YLPZ_ID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  Table [dbo].[CMYuanLiaoXS]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CMYuanLiaoXS](
	[YLXS_ID] [varchar](38) NOT NULL,
	[YLXS_ISN] [int] IDENTITY(1,1) NOT NULL,
	[YLXS_Del] [bit] NULL,
	[YLXSGS_ID] [varchar](38) NOT NULL,
	[YLXS_日期] [datetime] NOT NULL,
	[YLXS_时间] [datetime] NULL,
	[YLXS_MTM] [datetime] NOT NULL,
	[YLXS_编号] [varchar](20) NOT NULL,
	[YLXS_原材料品种] [varchar](60) NOT NULL,
	[YLXS_车号] [varchar](30) NOT NULL,
	[YLXS_毛称模式] [int] NULL,
	[YLXS_毛重时间] [datetime] NULL,
	[YLXS_毛重] [numeric](12, 3) NULL,
	[YLXS_毛称人] [varchar](20) NULL,
	[YLXS_皮称模式] [int] NULL,
	[YLXS_皮重时间] [datetime] NULL,
	[YLXS_皮称人] [varchar](20) NULL,
	[YLXS_皮重] [numeric](12, 3) NULL,
	[YLXS_净重] [numeric](12, 3) NULL,
	[YLXS_扣重] [numeric](12, 3) NULL,
	[YLXS_扣重后净重] [numeric](12, 3) NULL,
	[YLXS_地址] [varchar](255) NULL,
	[YLXS_备注] [varchar](255) NULL,
	[YLXS_称验状态] [int] NOT NULL,
 CONSTRAINT [PK_CMYUANLIAOXS] PRIMARY KEY CLUSTERED 
(
	[YLXS_ID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  Table [dbo].[cmYuanLiaoGS]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cmYuanLiaoGS](
	[YLGS_ID] [varchar](38) NOT NULL,
	[YLGS_MTM] [datetime] NULL,
	[YLGS_DEL] [bit] NULL,
	[YLGS_类型] [int] NOT NULL,
	[YLGS_编号] [varchar](20) NOT NULL,
	[YLGS_合同号] [varchar](20) NULL,
	[YLGS_建档日期] [datetime] NULL,
	[YLGS_名称] [varchar](120) NOT NULL,
	[YLGS_地址] [varchar](200) NULL,
	[YLGS_联系人] [varchar](20) NULL,
	[YLGS_联系方式] [varchar](120) NULL,
	[YLGS_备注] [varchar](255) NULL,
	[YLGS_验收结算] [int] NOT NULL,
	[YLGS_状态] [int] NOT NULL,
 CONSTRAINT [PK_CMYUANLIAOGS] PRIMARY KEY NONCLUSTERED 
(
	[YLGS_ID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  Table [dbo].[cmKuCunLW]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cmKuCunLW](
	[KCLW_ID] [varchar](38) NOT NULL,
	[KCLW_BH] [varchar](10) NOT NULL,
	[KCLW_MC] [varchar](30) NULL,
	[KCLW_ZB] [varchar](30) NULL,
	[KCLW_YLLX] [int] NULL,
	[KCLW_YLMC] [varchar](200) NULL,
	[KCLW_ZXZ] [numeric](16, 4) NULL,
	[KCLW_ZDZ] [numeric](16, 4) NULL,
	[KCLW_LWBG] [varchar](38) NULL,
	[KCLW_GDJZ] [int] NULL,
 CONSTRAINT [PK_CMKUCUNLW] PRIMARY KEY NONCLUSTERED 
(
	[KCLW_ID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  Table [dbo].[cmLiaoWeiBG]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cmLiaoWeiBG](
	[LWBG_ID] [varchar](38) NOT NULL,
	[KCLW_ID] [varchar](38) NOT NULL,
	[LWBG_DT] [datetime] NOT NULL,
	[LWBG_LX] [int] NOT NULL,
	[LWBG_SZ] [numeric](16, 4) NULL,
	[LWBG_LY] [int] NULL,
	[LWBG_ZY] [varchar](120) NULL,
	[LWBG_BZ] [varchar](255) NULL,
	[LWBG_YLMC] [varchar](200) NULL,
	[LWBG_ID0] [varchar](38) NULL,
	[LWBG_SZ0] [numeric](16, 4) NULL,
	[LWBG_SZ2] [numeric](16, 4) NULL,
 CONSTRAINT [PK_CMLIAOWEIBG] PRIMARY KEY NONCLUSTERED 
(
	[LWBG_ID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  Table [dbo].[cmGongLiaoQD]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cmGongLiaoQD](
	[GLQD_ID] [varchar](38) NOT NULL,
	[YLPZ_ID] [varchar](38) NULL,
	[YLGS_ID] [varchar](38) NOT NULL,
	[GLQD_单价] [numeric](12, 4) NULL,
	[GLQD_运费] [numeric](12, 2) NULL,
 CONSTRAINT [PK_CMGONGLIAOQD] PRIMARY KEY NONCLUSTERED 
(
	[GLQD_ID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  Table [dbo].[cmGongLiaoHTMX]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cmGongLiaoHTMX](
	[YLGS_ID] [varchar](38) NOT NULL,
	[YLPZ_ID] [varchar](38) NOT NULL,
	[GLHTMX_MTM] [datetime] NOT NULL,
	[GLHTMX_开始日期] [datetime] NOT NULL,
	[GLHTMX_结束日期] [datetime] NOT NULL,
	[GLHTMX_单价] [numeric](12, 4) NOT NULL,
	[GLHTMX_负责人] [varchar](20) NOT NULL,
	[GLHTMX_运费] [numeric](12, 2) NULL
)
GO
/****** Object:  Table [dbo].[cmGongYunGL]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cmGongYunGL](
	[YLGS_ID] [varchar](38) NOT NULL,
	[YSGS_ID] [varchar](38) NOT NULL,
 CONSTRAINT [PK_CMGONGYUNGL] PRIMARY KEY CLUSTERED 
(
	[YLGS_ID] ASC,
	[YSGS_ID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  Table [dbo].[cmYuanLiaoYS]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cmYuanLiaoYS](
	[YLYS_ID] [varchar](38) NOT NULL,
	[YLPZ_ID] [varchar](38) NULL,
	[YLGS_ID] [varchar](38) NOT NULL,
	[YSGS_ID] [varchar](38) NULL,
	[YLYS_ISN] [int] IDENTITY(1,1) NOT NULL,
	[YLYS_MTM] [datetime] NOT NULL,
	[YLYS_DEL] [bit] NOT NULL,
	[YLYS_ADD] [bit] NOT NULL,
	[YLYS_FROM] [int] NOT NULL,
	[YLYS_HIDE] [bit] NOT NULL,
	[YLYS_日期] [datetime] NOT NULL,
	[YLYS_时间] [datetime] NULL,
	[YLYS_编号] [varchar](20) NOT NULL,
	[YLYS_运输供商] [bit] NOT NULL,
	[YLYS_运输车辆] [varchar](30) NOT NULL,
	[YLYS_运输备注] [varchar](20) NULL,
	[YLYS_原料类型_] [int] NOT NULL,
	[YLYS_原料编号_] [varchar](20) NOT NULL,
	[YLYS_原料品种_] [varchar](60) NOT NULL,
	[YLYS_原料规格_] [varchar](20) NULL,
	[YLYS_原料名称_] [varchar](160) NOT NULL,
	[YLYS_供方票据] [varchar](20) NULL,
	[YLYS_供方数量] [numeric](12, 3) NULL,
	[YLYS_库存料位] [varchar](20) NULL,
	[YLYS_称验状态] [int] NOT NULL,
	[YLYS_毛称模式] [int] NOT NULL,
	[YLYS_毛称时间] [datetime] NULL,
	[YLYS_毛称人] [varchar](20) NULL,
	[YLYS_毛重] [numeric](12, 3) NULL,
	[YLYS_暗扣毛重] [numeric](12, 3) NULL,
	[YLYS_实际毛重] [numeric](12, 3) NULL,
	[YLYS_皮称模式] [int] NOT NULL,
	[YLYS_皮称时间] [datetime] NULL,
	[YLYS_皮称人] [varchar](20) NULL,
	[YLYS_皮重] [numeric](12, 3) NULL,
	[YLYS_暗扣皮重] [numeric](12, 3) NULL,
	[YLYS_实际皮重] [numeric](12, 3) NULL,
	[YLYS_净重] [numeric](12, 3) NULL,
	[YLYS_实际净重] [numeric](12, 3) NULL,
	[YLYS_扣水率] [numeric](8, 2) NULL,
	[YLYS_扣水量] [numeric](10, 3) NULL,
	[YLYS_验收数量] [numeric](12, 3) NOT NULL,
	[YLYS_实际验收] [numeric](12, 3) NULL,
	[YLYS_折方系数] [numeric](10, 6) NULL,
	[YLYS_折方数量] [numeric](12, 3) NULL,
	[YLYS_备注] [varchar](255) NULL,
	[YLYS_审核状态] [int] NOT NULL,
	[YLYS_统计日期] [datetime] NOT NULL,
	[YLYS_杂项量] [numeric](12, 3) NULL,
	[YLYS_单价] [numeric](12, 4) NULL,
	[YLYS_金额] [numeric](18, 4) NULL,
	[YLYS_ISSY] [bit] NULL,
	[YLYS_运费] [numeric](8, 2) NULL,
	[YLYS_运费金额] [numeric](12, 2) NULL,
	[ISUP] [bit] NULL,
	[YLYS_审核时间] [datetime] NULL,
	[YLYS_审核人] [varchar](10) NULL,
	[YLYS_结算] [bit] NULL,
	[YLYS_退料] [bit] NULL,
	[YLYS_收货地点] [varchar](200) NULL,
	[YLYS_打印次数] [int] NULL,
	[YLYS_打印时间] [datetime] NULL,
 CONSTRAINT [PK_CMYUANLIAOYS] PRIMARY KEY NONCLUSTERED 
(
	[YLYS_ID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  View [dbo].[CmYuanLiaoXSView]    Script Date: 12/09/2020 09:40:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[CmYuanLiaoXSView] as
select YLXS.*,YLXSGS_建档日期,YLXSGS_MTM,YLXSGS_编号,YLXSGS_客户名称,YLXSGS_地址,
   YLXSGS_联系人,YLXSGS_联系方式,YLXSGS_状态,YLXSGS_备注
 from CMYuanLiaoXS YLXS  with(nolock) 
left join CmYuanLiaoXSGS YLXSGS  with(nolock)  
on YLXS.YLXSGS_ID = YLXSGS.YLXSGS_ID
GO
/****** Object:  Table [dbo].[cmShouLiaoTJ]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cmShouLiaoTJ](
	[YLGS_ID] [varchar](38) NOT NULL,
	[SLTJ_日期] [datetime] NOT NULL,
	[SLTJ_原料类型] [int] NOT NULL,
	[SLTJ_原料编号] [varchar](20) NOT NULL,
	[SLTJ_原料名称] [varchar](160) NOT NULL,
	[SLTJ_原料品种] [varchar](60) NULL,
	[SLTJ_原料规格] [varchar](20) NULL,
	[SLTJ_MTM] [datetime] NULL,
	[SLTJ_供方数量] [numeric](12, 3) NULL,
	[SLTJ_验收数量] [numeric](12, 3) NULL,
	[SLTJ_折方数量] [numeric](12, 3) NULL,
	[SLTJ_结算数量] [numeric](12, 3) NULL,
	[SLTJ_运费数量] [numeric](12, 3) NULL,
	[SLTJ_统计备注] [varchar](200) NULL,
	[SLTJ_毛重数量] [numeric](12, 3) NULL,
	[SLTJ_皮重数量] [numeric](12, 3) NULL,
	[SLTJ_净重数量] [numeric](12, 3) NULL,
	[SLTJ_车次] [int] NULL,
	[SLTJ_运输车辆] [varchar](30) NOT NULL,
	[SLTJ_单价] [numeric](12, 4) NULL,
	[SLTJ_金额] [numeric](18, 4) NULL,
 CONSTRAINT [PK_CMSHOULIAOTJ] PRIMARY KEY NONCLUSTERED 
(
	[YLGS_ID] ASC,
	[SLTJ_日期] ASC,
	[SLTJ_原料类型] ASC,
	[SLTJ_原料编号] ASC,
	[SLTJ_原料名称] ASC,
	[SLTJ_运输车辆] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  Table [dbo].[CmYuanLiaoGS_Advance_Charge]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CmYuanLiaoGS_Advance_Charge](
	[YLGS_ACID] [varchar](38) NOT NULL,
	[YLGS_ID] [varchar](38) NOT NULL,
	[YLGS_MTM] [datetime] NOT NULL,
	[YLGS_预收量] [numeric](12, 4) NULL,
	[YLGS_余量] [numeric](12, 4) NULL,
	[YLYS_ACName] [varchar](50) NULL,
	[YLPZ_ID] [varchar](38) NULL,
	[YLPZ_名称] [varchar](160) NULL,
 CONSTRAINT [YLGS_Advance_Charge] PRIMARY KEY CLUSTERED 
(
	[YLGS_ACID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  Table [dbo].[CmYuanLYSJS]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CmYuanLYSJS](
	[SLJS_ID] [varchar](38) NOT NULL,
	[YLGS_ID] [varchar](38) NOT NULL,
	[SLJS_编号] [varchar](50) NOT NULL,
	[SLJS_日期] [datetime] NULL,
	[SLJS_开始日期] [datetime] NULL,
	[SLJS_结束日期] [datetime] NULL,
	[SLJS_月份] [datetime] NULL,
	[SLJS_数量] [numeric](12, 2) NULL,
	[SLJS_金额] [numeric](18, 4) NULL,
	[SLJS_发票金额] [numeric](12, 2) NULL,
	[SLJS_付款金额] [numeric](12, 2) NULL,
	[SLJS_运费金额] [numeric](18, 4) NULL,
	[SLJS_付运费款金额] [numeric](12, 2) NULL,
	[SLJS_结算人1] [varchar](10) NULL,
	[SLJS_结算人1_联系方式] [varchar](20) NULL,
	[SLJS_结算人2] [varchar](10) NULL,
	[SLJS_结算人2_联系方式] [varchar](20) NULL,
	[SLJS_审核] [int] NULL,
	[SLJS_审核人] [varchar](10) NULL,
	[SLJS_单价] [numeric](8, 2) NULL,
	[SLJS_运费数量] [numeric](12, 2) NULL,
	[SLJS_运费单价] [numeric](8, 2) NULL,
	[SLJS_原料名称] [varchar](200) NULL,
	[SLJS_原料类型] [int] NULL,
	[SLJS_扣款] [numeric](12, 2) NULL,
	[SLJS_补差额] [numeric](12, 2) NULL,
	[SLJS_运费扣款] [numeric](12, 2) NULL,
	[SLJS_运费补差额] [numeric](12, 2) NULL,
	[YSGS_ID] [varchar](38) NULL,
	[YSGS_名称] [varchar](120) NULL,
 CONSTRAINT [PK_CmYuanLYSJS] PRIMARY KEY NONCLUSTERED 
(
	[SLJS_ID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  Table [dbo].[CmYuanLYFJS]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CmYuanLYFJS](
	[SLJS_ID] [varchar](38) NOT NULL,
	[SLYFJS_日期] [datetime] NULL,
	[SLYFJS_MTM] [datetime] NULL,
	[SLYFJS_编号] [varchar](30) NOT NULL,
	[SLYFJS_内容] [varchar](30) NOT NULL,
	[SLYFJS_数量] [numeric](12, 2) NOT NULL,
	[SLYFJS_金额] [numeric](12, 2) NOT NULL,
	[SLJSFP_结算人] [varchar](10) NULL,
	[SLJSFP_结算人_联系方式] [varchar](20) NULL,
	[SLYFJS_审核人] [varchar](10) NULL
)
GO
/****** Object:  View [dbo].[CmYuanLiaoYSView]    Script Date: 12/09/2020 09:40:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[CmYuanLiaoYSView] as
select YLYS_ID,YLYS.YLPZ_ID,YLYS.YLGS_ID,YSGS_ID,YLYS_ISN,YLYS_MTM,YLYS_DEL,YLYS_ADD,YLYS_FROM,YLYS_HIDE

  ,YLYS_日期,YLYS_时间,YLYS_编号,YLYS_运输供商,YLYS_运输车辆,YLYS_运输备注,YLYS_供方票据,YLYS_供方数量,YLYS_库存料位
  ,YLYS_称验状态,YLYS_毛称模式,YLYS_毛称时间,YLYS_毛称人,YLYS_毛重,YLYS_暗扣毛重,YLYS_实际毛重,YLYS_单价,YLYS_金额
  ,YLYS_皮称模式,YLYS_皮称时间,YLYS_皮称人,YLYS_皮重,YLYS_暗扣皮重,YLYS_实际皮重,YLYS_净重,YLYS_实际净重,YLYS_运费,YLYS_运费金额
  ,YLYS_扣水率,YLYS_扣水量,YLYS_杂项量,YLYS_验收数量,YLYS_实际验收,YLYS_折方系数,YLYS_折方数量,YLYS_备注,YLYS_审核状态

  ,YLGS.YLGS_编号,YLGS.YLGS_合同号,YLGS.YLGS_名称,YLYS.YLYS_统计日期,YLYS_ISSY,YLYS_收货地点,YLYS_打印次数,YLYS_打印时间  
  ,YSGS.YLGS_编号 YSGS_编号,YSGS.YLGS_合同号 YSGS_合同号,YSGS.YLGS_名称 YSGS_名称,YLGS.YLGS_验收结算
  ,case when YLPZ.YLPZ_ID is null then YLYS_原料类型_ else YLPZ_原料类型 end YLPZ_原料类型
  ,case when YLPZ.YLPZ_ID is null then YLYS_原料编号_ else YLPZ_编号 end YLPZ_编号 
  ,case when YLPZ.YLPZ_ID is null then YLYS_原料名称_ else YLPZ_名称 end YLPZ_名称
  ,case when YLPZ.YLPZ_ID is null then YLYS_原料品种_ else YLPZ_品种名称 end YLPZ_品种名称
 ,case when YLPZ.YLPZ_ID is null then YLYS_原料规格_ else YLPZ_规格等级 end YLPZ_规格等级
 
 ,KCLW.KCLW_MC,YLPZ.YLPZ_产地厂别
 
from cmYuanLiaoYS YLYS with(Nolock)
  join cmYuanLiaoGS YLGS with(Nolock) on YLYS.YLGS_ID=YLGS.YLGS_ID and YLGS.YLGS_类型=0
  left join cmYuanLiaoGS YSGS with(Nolock) on YLYS.YLYS_运输供商=1 and  YLYS.YSGS_ID=YSGS.YLGS_ID and YSGS.YLGS_类型=1 
  left join cmYuanLiaoPZ YLPZ with(Nolock) on YLYS.YLPZ_ID=YLPZ.YLPZ_ID
  left join cmKuCunLW KCLW with(Nolock) on YLYS.YLYS_库存料位=KCLW.KCLW_BH
  
where ISNULL(YLYS_DEL,0)=0 and ((YLYS_ADD = 0 and YLYS_称验状态 = 3) or YLYS_ADD = 1)
GO
/****** Object:  View [dbo].[CmYuanLYSJSView]    Script Date: 12/09/2020 09:40:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create View [dbo].[CmYuanLYSJSView]
as select SLJS.*,YLGS_编号,YLGS_名称,YLGS_合同号,YLGS_联系人,YLGS_联系方式 
from CmYuanLYSJS SLJS 
left join cmYuanLiaoGS YLGS on SLJS.YLGS_ID=YLGS.YLGS_ID
GO
/****** Object:  Table [dbo].[CmYuanLYSJSMX]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CmYuanLYSJSMX](
	[SLJS_ID] [varchar](38) NOT NULL,
	[YLYS_ID] [varchar](38) NOT NULL,
	[YLPZ_ID] [varchar](38) NOT NULL,
	[YLGS_ID] [varchar](38) NOT NULL,
	[YSGS_ID] [varchar](38) NOT NULL,
	[YLYS_MTM] [varchar](38) NOT NULL,
	[YLYS_日期] [datetime] NULL,
	[YLYS_时间] [datetime] NULL,
	[YLYS_编号] [varchar](20) NOT NULL,
	[YLYS_运输车辆] [varchar](30) NOT NULL,
	[YLYS_原料类型_] [int] NOT NULL,
	[YLYS_原料编号_] [varchar](20) NOT NULL,
	[YLYS_原料品种_] [varchar](60) NOT NULL,
	[YLYS_原料名称_] [varchar](160) NOT NULL,
	[YLYS_供方票据] [varchar](20) NOT NULL,
	[YLYS_供方数量] [numeric](12, 3) NULL,
	[YLYS_净重] [numeric](12, 3) NULL,
	[YLYS_验收数量] [numeric](12, 3) NOT NULL,
	[YLYS_验收磅差] [numeric](12, 3) NULL,
	[YLYS_备注] [varchar](255) NULL,
	[YLYS_单价] [numeric](12, 4) NULL,
	[YLYS_金额] [numeric](18, 4) NULL,
	[YLYS_运费金额] [numeric](18, 4) NULL,
	[YLYS_审核时间] [datetime] NULL,
	[YLYS_审核人] [varchar](30) NULL,
	[YLYS_运费单价] [numeric](8, 2) NULL,
	[SLJSMX_审核] [int] NULL,
	[YLYS_扣款] [numeric](12, 2) NULL,
	[YLYS_补差额] [numeric](12, 2) NULL,
	[YLYS_运费扣款] [numeric](12, 2) NULL,
	[YLYS_运费补差额] [numeric](12, 2) NULL,
 CONSTRAINT [PK_CmYuanLYSJSMX] PRIMARY KEY NONCLUSTERED 
(
	[YLYS_ID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  Table [dbo].[CmYuanLYSJSFaPiao]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CmYuanLYSJSFaPiao](
	[SLJS_ID] [varchar](38) NOT NULL,
	[SLJSFP_日期] [datetime] NULL,
	[SLJSFP_MTM] [datetime] NULL,
	[SLJSFP_编号] [varchar](30) NOT NULL,
	[SLJSFP_内容] [varchar](30) NOT NULL,
	[SLJSFP_数量] [numeric](12, 2) NOT NULL,
	[SLJSFP_金额] [numeric](12, 2) NOT NULL,
	[SLJSFP_开票人] [varchar](10) NULL,
	[SLJSFP_审核人] [varchar](10) NULL,
	[SLJSFP_类型] [int] NULL
)
GO
/****** Object:  Table [dbo].[cmYanShouPZ]    Script Date: 12/09/2020 09:40:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cmYanShouPZ](
	[YLYS_ID] [varchar](38) NOT NULL,
	[YSPZ_毛称拍照1] [image] NULL,
	[YSPZ_毛称拍照2] [image] NULL,
	[YSPZ_毛称拍照3] [image] NULL,
	[YSPZ_皮称拍照1] [image] NULL,
	[YSPZ_皮称拍照2] [image] NULL,
	[YSPZ_皮称拍照3] [image] NULL,
 CONSTRAINT [PK_CMYANSHOUPZ] PRIMARY KEY CLUSTERED 
(
	[YLYS_ID] ASC
)WITH (STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF)
)
GO
/****** Object:  Default [DF__CmYuanLia__YLGS___7D0E9093]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[CmYuanLiaoGS_Advance_Charge] ADD  DEFAULT ((0)) FOR [YLGS_预收量]
GO
/****** Object:  Default [DF__CmYuanLia__YLGS___7E02B4CC]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[CmYuanLiaoGS_Advance_Charge] ADD  DEFAULT ((0)) FOR [YLGS_余量]
GO
/****** Object:  Default [DF__cmYuanLia__YLYS___7EF6D905]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmYuanLiaoYS] ADD  DEFAULT ((0)) FOR [YLYS_打印次数]
GO
/****** Object:  Check [CKC_LX_CMLIAOWE]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmLiaoWeiBG_Intf]  WITH CHECK ADD  CONSTRAINT [CKC_LX_CMLIAOWE] CHECK  (([LX]>=(1) AND [LX]<=(3)))
GO
ALTER TABLE [dbo].[cmLiaoWeiBG_Intf] CHECK CONSTRAINT [CKC_LX_CMLIAOWE]
GO
/****** Object:  ForeignKey [FK_CMGONGYU_GLHTMX_YLPZ_CMYUNSHU]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmGongLiaoHTMX]  WITH CHECK ADD  CONSTRAINT [FK_CMGONGYU_GLHTMX_YLPZ_CMYUNSHU] FOREIGN KEY([YLPZ_ID])
REFERENCES [dbo].[cmYuanLiaoPZ] ([YLPZ_ID])
GO
ALTER TABLE [dbo].[cmGongLiaoHTMX] CHECK CONSTRAINT [FK_CMGONGYU_GLHTMX_YLPZ_CMYUNSHU]
GO
/****** Object:  ForeignKey [FK_CMGONGYU_GLHTMX_YSGS_CMYUNSHU]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmGongLiaoHTMX]  WITH CHECK ADD  CONSTRAINT [FK_CMGONGYU_GLHTMX_YSGS_CMYUNSHU] FOREIGN KEY([YLGS_ID])
REFERENCES [dbo].[cmYuanLiaoGS] ([YLGS_ID])
GO
ALTER TABLE [dbo].[cmGongLiaoHTMX] CHECK CONSTRAINT [FK_CMGONGYU_GLHTMX_YSGS_CMYUNSHU]
GO
/****** Object:  ForeignKey [FK_CMGONGLI_GLQD_YLGS_CMYUANLI]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmGongLiaoQD]  WITH CHECK ADD  CONSTRAINT [FK_CMGONGLI_GLQD_YLGS_CMYUANLI] FOREIGN KEY([YLGS_ID])
REFERENCES [dbo].[cmYuanLiaoGS] ([YLGS_ID])
GO
ALTER TABLE [dbo].[cmGongLiaoQD] CHECK CONSTRAINT [FK_CMGONGLI_GLQD_YLGS_CMYUANLI]
GO
/****** Object:  ForeignKey [FK_CMGONGLI_GLQD_YLPZ_CMYUANLI]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmGongLiaoQD]  WITH CHECK ADD  CONSTRAINT [FK_CMGONGLI_GLQD_YLPZ_CMYUANLI] FOREIGN KEY([YLPZ_ID])
REFERENCES [dbo].[cmYuanLiaoPZ] ([YLPZ_ID])
GO
ALTER TABLE [dbo].[cmGongLiaoQD] CHECK CONSTRAINT [FK_CMGONGLI_GLQD_YLPZ_CMYUANLI]
GO
/****** Object:  ForeignKey [FK_CMGONGYU_GYGL_YLGS_CMYUANLI]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmGongYunGL]  WITH CHECK ADD  CONSTRAINT [FK_CMGONGYU_GYGL_YLGS_CMYUANLI] FOREIGN KEY([YLGS_ID])
REFERENCES [dbo].[cmYuanLiaoGS] ([YLGS_ID])
GO
ALTER TABLE [dbo].[cmGongYunGL] CHECK CONSTRAINT [FK_CMGONGYU_GYGL_YLGS_CMYUANLI]
GO
/****** Object:  ForeignKey [FK_CMGONGYU_GYGL_YSGS_CMYUNSHU]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmGongYunGL]  WITH CHECK ADD  CONSTRAINT [FK_CMGONGYU_GYGL_YSGS_CMYUNSHU] FOREIGN KEY([YSGS_ID])
REFERENCES [dbo].[cmYunShuGS] ([YSGS_ID])
GO
ALTER TABLE [dbo].[cmGongYunGL] CHECK CONSTRAINT [FK_CMGONGYU_GYGL_YSGS_CMYUNSHU]
GO
/****** Object:  ForeignKey [FK_CMLIAOWE_LWBG_KCLW_CMKUCUNL]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmLiaoWeiBG]  WITH CHECK ADD  CONSTRAINT [FK_CMLIAOWE_LWBG_KCLW_CMKUCUNL] FOREIGN KEY([KCLW_ID])
REFERENCES [dbo].[cmKuCunLW] ([KCLW_ID])
GO
ALTER TABLE [dbo].[cmLiaoWeiBG] CHECK CONSTRAINT [FK_CMLIAOWE_LWBG_KCLW_CMKUCUNL]
GO
/****** Object:  ForeignKey [FK_CMSHOULI_SLTJ_YLGS_CMYUANLI]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmShouLiaoTJ]  WITH NOCHECK ADD  CONSTRAINT [FK_CMSHOULI_SLTJ_YLGS_CMYUANLI] FOREIGN KEY([YLGS_ID])
REFERENCES [dbo].[cmYuanLiaoGS] ([YLGS_ID])
GO
ALTER TABLE [dbo].[cmShouLiaoTJ] CHECK CONSTRAINT [FK_CMSHOULI_SLTJ_YLGS_CMYUANLI]
GO
/****** Object:  ForeignKey [FK_CMYANSHO_YSPZ_YLYS_CMYUANLI]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmYanShouPZ]  WITH CHECK ADD  CONSTRAINT [FK_CMYANSHO_YSPZ_YLYS_CMYUANLI] FOREIGN KEY([YLYS_ID])
REFERENCES [dbo].[cmYuanLiaoYS] ([YLYS_ID])
GO
ALTER TABLE [dbo].[cmYanShouPZ] CHECK CONSTRAINT [FK_CMYANSHO_YSPZ_YLYS_CMYUANLI]
GO
/****** Object:  ForeignKey [FK_CMYUANLI_REFERENCE_YLGS]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[CmYuanLiaoGS_Advance_Charge]  WITH CHECK ADD  CONSTRAINT [FK_CMYUANLI_REFERENCE_YLGS] FOREIGN KEY([YLGS_ID])
REFERENCES [dbo].[cmYuanLiaoGS] ([YLGS_ID])
GO
ALTER TABLE [dbo].[CmYuanLiaoGS_Advance_Charge] CHECK CONSTRAINT [FK_CMYUANLI_REFERENCE_YLGS]
GO
/****** Object:  ForeignKey [FK_CMYUANLI_REFERENCE_CMYUANLI]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[CMYuanLiaoXS]  WITH CHECK ADD  CONSTRAINT [FK_CMYUANLI_REFERENCE_CMYUANLI] FOREIGN KEY([YLXSGS_ID])
REFERENCES [dbo].[CmYuanLiaoXSGS] ([YLXSGS_ID])
GO
ALTER TABLE [dbo].[CMYuanLiaoXS] CHECK CONSTRAINT [FK_CMYUANLI_REFERENCE_CMYUANLI]
GO
/****** Object:  ForeignKey [FK_CMYUANLI_YLYS_YLGS_CMYUANLI]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmYuanLiaoYS]  WITH CHECK ADD  CONSTRAINT [FK_CMYUANLI_YLYS_YLGS_CMYUANLI] FOREIGN KEY([YLGS_ID])
REFERENCES [dbo].[cmYuanLiaoGS] ([YLGS_ID])
GO
ALTER TABLE [dbo].[cmYuanLiaoYS] CHECK CONSTRAINT [FK_CMYUANLI_YLYS_YLGS_CMYUANLI]
GO
/****** Object:  ForeignKey [FK_CMYUANLI_YLYS_YLPZ_CMYUANLI]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmYuanLiaoYS]  WITH CHECK ADD  CONSTRAINT [FK_CMYUANLI_YLYS_YLPZ_CMYUANLI] FOREIGN KEY([YLPZ_ID])
REFERENCES [dbo].[cmYuanLiaoPZ] ([YLPZ_ID])
GO
ALTER TABLE [dbo].[cmYuanLiaoYS] CHECK CONSTRAINT [FK_CMYUANLI_YLYS_YLPZ_CMYUANLI]
GO
/****** Object:  ForeignKey [FK_CMYUANLI_YLYS_YSGS_CMYUNSHU]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[cmYuanLiaoYS]  WITH CHECK ADD  CONSTRAINT [FK_CMYUANLI_YLYS_YSGS_CMYUNSHU] FOREIGN KEY([YSGS_ID])
REFERENCES [dbo].[cmYunShuGS] ([YSGS_ID])
GO
ALTER TABLE [dbo].[cmYuanLiaoYS] CHECK CONSTRAINT [FK_CMYUANLI_YLYS_YSGS_CMYUNSHU]
GO
/****** Object:  ForeignKey [FK_CmYuanLYFJS_JYJS_YF_CPTONGSH]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[CmYuanLYFJS]  WITH CHECK ADD  CONSTRAINT [FK_CmYuanLYFJS_JYJS_YF_CPTONGSH] FOREIGN KEY([SLJS_ID])
REFERENCES [dbo].[CmYuanLYSJS] ([SLJS_ID])
GO
ALTER TABLE [dbo].[CmYuanLYFJS] CHECK CONSTRAINT [FK_CmYuanLYFJS_JYJS_YF_CPTONGSH]
GO
/****** Object:  ForeignKey [FK_CmYuanLYSJS_JYJS_YSGS_CPTONGSH]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[CmYuanLYSJS]  WITH CHECK ADD  CONSTRAINT [FK_CmYuanLYSJS_JYJS_YSGS_CPTONGSH] FOREIGN KEY([YLGS_ID])
REFERENCES [dbo].[cmYuanLiaoGS] ([YLGS_ID])
GO
ALTER TABLE [dbo].[CmYuanLYSJS] CHECK CONSTRAINT [FK_CmYuanLYSJS_JYJS_YSGS_CPTONGSH]
GO
/****** Object:  ForeignKey [FK_CmYuanLYSJSFaPiao_JYJS_FP_CPTONGSH]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[CmYuanLYSJSFaPiao]  WITH CHECK ADD  CONSTRAINT [FK_CmYuanLYSJSFaPiao_JYJS_FP_CPTONGSH] FOREIGN KEY([SLJS_ID])
REFERENCES [dbo].[CmYuanLYSJS] ([SLJS_ID])
GO
ALTER TABLE [dbo].[CmYuanLYSJSFaPiao] CHECK CONSTRAINT [FK_CmYuanLYSJSFaPiao_JYJS_FP_CPTONGSH]
GO
/****** Object:  ForeignKey [FK_CmYuanLYFJS_JYJS_JSMX_CPTONGSH]    Script Date: 12/09/2020 09:40:06 ******/
ALTER TABLE [dbo].[CmYuanLYSJSMX]  WITH CHECK ADD  CONSTRAINT [FK_CmYuanLYFJS_JYJS_JSMX_CPTONGSH] FOREIGN KEY([SLJS_ID])
REFERENCES [dbo].[CmYuanLYSJS] ([SLJS_ID])
GO
ALTER TABLE [dbo].[CmYuanLYSJSMX] CHECK CONSTRAINT [FK_CmYuanLYFJS_JYJS_JSMX_CPTONGSH]
GO