Files

252 lines
22 KiB
SQL
Executable File

/* 脚本导出时间:2026/08/18 14:46:42 */
/* 脚本导出人员:系统管理员 */
/* 脚本 说明:T_PUR_RECEIVEENTRY 收料通知单明细*/
-- DROP TABLE T_PUR_RECEIVEENTRY
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'T_PUR_RECEIVEENTRY') AND type in (N'U'))
BEGIN
CREATE TABLE T_PUR_RECEIVEENTRY(
FROWTYPE NVARCHAR(160) NOT NULL DEFAULT '' , -- 产品类型
FMATERIALID VARCHAR(50) NOT NULL DEFAULT '' , -- 物料
FBASEUNITID VARCHAR(50) NOT NULL DEFAULT '' , -- 基本单位
FBASEUNITQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 基本单位数量
FUNITID VARCHAR(50) NOT NULL DEFAULT '' , -- 常用单位
FAUXPROPID VARCHAR(50) NOT NULL DEFAULT '' , -- 辅助属性
FKFDATE DATE NULL , -- 生产日期/采购日期/保质期
FACTRECEIVEQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 交货数量
FINSTOCKQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 累计入库数量
FINSTOCKBASEQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 累计入库数量(基本单位)
FPREDELIVERYDATE DATE NULL , -- 预计到货日期
FSUPDELQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 供应商交货数量
FDISCHARGED INT NOT NULL DEFAULT 0 , -- 紧急放行
FCHECKMETHOD INT NOT NULL DEFAULT 0 , -- 检验方式
FSTOCKID VARCHAR(50) NOT NULL DEFAULT '' , -- 仓库
FSTOCKLOCID VARCHAR(50) NOT NULL DEFAULT '' , -- 仓位
FSTOCKSTATUSID VARCHAR(50) NOT NULL DEFAULT '' , -- 库存状态
FLOT VARCHAR(50) NOT NULL DEFAULT '' , -- 批次
FREJECTQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 拒收数量
FREJECTREASON VARCHAR(50) NOT NULL DEFAULT '' , -- 拒收原因
FGIVEAWAY BIT NOT NULL DEFAULT 0 , -- 是否赠品
FSTOCKUNITID VARCHAR(50) NOT NULL DEFAULT '' , -- 库存单位
FSTOCKQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 库存单位数量
FRETURNQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 退料数量
FRETURNBASEQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 退料基本单位数量
FPRICE DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 单价
FTAXRATE DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 税率%
FTAXPRICE DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 含税单价
FDISCOUNT DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 折扣额
FDISCOUNTRATE DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 折扣率%
FAMOUNT DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 金额
FAMOUNT_LC DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 金额(本位币)
FTAXAMOUNT DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 税额
FTAXAMOUNT_LC DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 税额(本位币)
FALLAMOUNT DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 价税合计
FALLAMOUNT_LC DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 价税合计(本位币)
FSRCID VARCHAR(50) NOT NULL DEFAULT '' , -- 源单内码
FSRCFORMID VARCHAR(50) NOT NULL DEFAULT '' , -- 源单类型
FSRCBILLNO VARCHAR(50) NOT NULL DEFAULT '' , -- 源单单据编号
FSRCDETAILID VARCHAR(50) NOT NULL DEFAULT '' , -- 源单表体内码
FSRCENTRYID INT NOT NULL DEFAULT 0 , -- 源单行号
FERPENTRYID VARCHAR(50) NOT NULL DEFAULT '' , -- ERP表体内码
FREPNOTE VARCHAR(1000) NOT NULL DEFAULT '' , -- 采购申请备注
FCGSQTYPE VARCHAR(1000) NOT NULL DEFAULT '' , -- 采购申请类型
FYANFAPROJECT VARCHAR(50) NOT NULL DEFAULT '' , -- 研发项目
FYFZXM VARCHAR(50) NOT NULL DEFAULT '' , -- 研发子项目
FUSEDEPT VARCHAR(50) NOT NULL DEFAULT '' , -- 使用部门
FHGNISHOUSTOCK VARCHAR(50) NOT NULL DEFAULT '' , -- 拟收仓库
FHGNISHOUSTOCKPLACE VARCHAR(50) NOT NULL DEFAULT '' , -- 拟收仓位
FPLANMODE VARCHAR(50) NOT NULL DEFAULT '' , -- 计划模式
FMTONO VARCHAR(50) NOT NULL DEFAULT '' , -- 计划跟踪号
FRECEIVUNITID VARCHAR(50) NOT NULL DEFAULT '' , -- 收料单位
FPRICEUNITID VARCHAR(50) NOT NULL DEFAULT '' , -- 计价单位
FCHECKINCOMING BIT NOT NULL DEFAULT 0 , -- 来料检验
FGODQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 检验合格数量
FGODBASEQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 检验合格基本单位数量
FSCRAPQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 样本破坏数
FORDERBILLNO VARCHAR(50) NOT NULL DEFAULT '' , -- 订单编号
FORDERDETAILID VARCHAR(50) NOT NULL DEFAULT '' , -- 订单明细内码
FORDERENTRYID INT NOT NULL DEFAULT 0 , -- 订单明细行号
FORDERINTERID VARCHAR(50) NOT NULL DEFAULT '' , -- 订单内码
FSUPPLYLOT VARCHAR(50) NOT NULL DEFAULT '' , -- 供应商批号
FEXPIREDATE DATE NULL , -- 有效期至
FDEMANDDEPTID VARCHAR(50) NOT NULL DEFAULT '' , -- 需求部门
FDEMANDERID VARCHAR(50) NOT NULL DEFAULT '' , -- 需求人
FSFWJSD BIT NOT NULL DEFAULT 0 , -- 随附文件送达
FSHDSD BIT NOT NULL DEFAULT 0 , -- 送货单送达
FINTERID VARCHAR(50) NOT NULL DEFAULT '', -- 表内码
FENTRYID INT NOT NULL DEFAULT 0 , -- 行号
FDETAILID VARCHAR(50) NOT NULL DEFAULT '' , --表体内码
FSTATUS INT NOT NULL DEFAULT 0 , -- 状态
FDELETED BIT NOT NULL DEFAULT 0 , --禁用状态 0 = 正常 1 = 禁用
FCOMPANYID VARCHAR(50) NOT NULL DEFAULT '', -- 组织代码
C_YMD DATETIME NULL, -- 资料创建日期
C_USER VARCHAR(20) NOT NULL DEFAULT '', -- 资料创建帐号
M_YMD DATETIME NULL, -- 最后异动日期
M_USER VARCHAR(20) NOT NULL DEFAULT '', -- 最后异动帐号
UID VARCHAR(50) NOT NULL CONSTRAINT [PK_T_PUR_RECEIVEENTRY] PRIMARY KEY NONCLUSTERED
)
END
ELSE
BEGIN
if(not exists(select name from SysColumns where name ='FROWTYPE' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FROWTYPE NVARCHAR(160) NOT NULL DEFAULT '' -- 产品类型
if(not exists(select name from SysColumns where name ='FMATERIALID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FMATERIALID VARCHAR(50) NOT NULL DEFAULT '' -- 物料
if(not exists(select name from SysColumns where name ='FBASEUNITID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FBASEUNITID VARCHAR(50) NOT NULL DEFAULT '' -- 基本单位
if(not exists(select name from SysColumns where name ='FBASEUNITQTY' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FBASEUNITQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 基本单位数量
if(not exists(select name from SysColumns where name ='FUNITID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FUNITID VARCHAR(50) NOT NULL DEFAULT '' -- 常用单位
if(not exists(select name from SysColumns where name ='FAUXPROPID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FAUXPROPID VARCHAR(50) NOT NULL DEFAULT '' -- 辅助属性
if(not exists(select name from SysColumns where name ='FKFDATE' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FKFDATE DATE NULL -- 生产日期/采购日期/保质期
if(not exists(select name from SysColumns where name ='FACTRECEIVEQTY' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FACTRECEIVEQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 交货数量
if(not exists(select name from SysColumns where name ='FINSTOCKQTY' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FINSTOCKQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 累计入库数量
if(not exists(select name from SysColumns where name ='FINSTOCKBASEQTY' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FINSTOCKBASEQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 累计入库数量(基本单位)
if(not exists(select name from SysColumns where name ='FPREDELIVERYDATE' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FPREDELIVERYDATE DATE NULL -- 预计到货日期
if(not exists(select name from SysColumns where name ='FSUPDELQTY' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSUPDELQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 供应商交货数量
if(not exists(select name from SysColumns where name ='FDISCHARGED' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FDISCHARGED INT NOT NULL DEFAULT 0 -- 紧急放行
if(not exists(select name from SysColumns where name ='FCHECKMETHOD' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FCHECKMETHOD INT NOT NULL DEFAULT 0 -- 检验方式
if(not exists(select name from SysColumns where name ='FSTOCKID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSTOCKID VARCHAR(50) NOT NULL DEFAULT '' -- 仓库
if(not exists(select name from SysColumns where name ='FSTOCKLOCID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSTOCKLOCID VARCHAR(50) NOT NULL DEFAULT '' -- 仓位
if(not exists(select name from SysColumns where name ='FSTOCKSTATUSID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSTOCKSTATUSID VARCHAR(50) NOT NULL DEFAULT '' -- 库存状态
if(not exists(select name from SysColumns where name ='FLOT' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FLOT VARCHAR(50) NOT NULL DEFAULT '' -- 批次
if(not exists(select name from SysColumns where name ='FREJECTQTY' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FREJECTQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 拒收数量
if(not exists(select name from SysColumns where name ='FREJECTREASON' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FREJECTREASON VARCHAR(50) NOT NULL DEFAULT '' -- 拒收原因
if(not exists(select name from SysColumns where name ='FGIVEAWAY' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FGIVEAWAY BIT NOT NULL DEFAULT 0 -- 是否赠品
if(not exists(select name from SysColumns where name ='FSTOCKUNITID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSTOCKUNITID VARCHAR(50) NOT NULL DEFAULT '' -- 库存单位
if(not exists(select name from SysColumns where name ='FSTOCKQTY' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSTOCKQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 库存单位数量
if(not exists(select name from SysColumns where name ='FRETURNQTY' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FRETURNQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 退料数量
if(not exists(select name from SysColumns where name ='FRETURNBASEQTY' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FRETURNBASEQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 退料基本单位数量
if(not exists(select name from SysColumns where name ='FPRICE' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FPRICE DECIMAL(24,6) NOT NULL DEFAULT 0 -- 单价
if(not exists(select name from SysColumns where name ='FTAXRATE' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FTAXRATE DECIMAL(24,6) NOT NULL DEFAULT 0 -- 税率%
if(not exists(select name from SysColumns where name ='FTAXPRICE' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FTAXPRICE DECIMAL(24,6) NOT NULL DEFAULT 0 -- 含税单价
if(not exists(select name from SysColumns where name ='FDISCOUNT' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FDISCOUNT DECIMAL(24,6) NOT NULL DEFAULT 0 -- 折扣额
if(not exists(select name from SysColumns where name ='FDISCOUNTRATE' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FDISCOUNTRATE DECIMAL(24,6) NOT NULL DEFAULT 0 -- 折扣率%
if(not exists(select name from SysColumns where name ='FAMOUNT' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FAMOUNT DECIMAL(24,6) NOT NULL DEFAULT 0 -- 金额
if(not exists(select name from SysColumns where name ='FAMOUNT_LC' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FAMOUNT_LC DECIMAL(24,6) NOT NULL DEFAULT 0 -- 金额(本位币)
if(not exists(select name from SysColumns where name ='FTAXAMOUNT' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FTAXAMOUNT DECIMAL(24,6) NOT NULL DEFAULT 0 -- 税额
if(not exists(select name from SysColumns where name ='FTAXAMOUNT_LC' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FTAXAMOUNT_LC DECIMAL(24,6) NOT NULL DEFAULT 0 -- 税额(本位币)
if(not exists(select name from SysColumns where name ='FALLAMOUNT' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FALLAMOUNT DECIMAL(24,6) NOT NULL DEFAULT 0 -- 价税合计
if(not exists(select name from SysColumns where name ='FALLAMOUNT_LC' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FALLAMOUNT_LC DECIMAL(24,6) NOT NULL DEFAULT 0 -- 价税合计(本位币)
if(not exists(select name from SysColumns where name ='FSRCID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSRCID VARCHAR(50) NOT NULL DEFAULT '' -- 源单内码
if(not exists(select name from SysColumns where name ='FSRCFORMID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSRCFORMID VARCHAR(50) NOT NULL DEFAULT '' -- 源单类型
if(not exists(select name from SysColumns where name ='FSRCBILLNO' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSRCBILLNO VARCHAR(50) NOT NULL DEFAULT '' -- 源单单据编号
if(not exists(select name from SysColumns where name ='FSRCDETAILID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSRCDETAILID VARCHAR(50) NOT NULL DEFAULT '' -- 源单表体内码
if(not exists(select name from SysColumns where name ='FSRCENTRYID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSRCENTRYID INT NOT NULL DEFAULT 0 -- 源单行号
if(not exists(select name from SysColumns where name ='FERPENTRYID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FERPENTRYID VARCHAR(50) NOT NULL DEFAULT '' -- ERP表体内码
if(not exists(select name from SysColumns where name ='FREPNOTE' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FREPNOTE VARCHAR(1000) NOT NULL DEFAULT '' -- 采购申请备注
if(not exists(select name from SysColumns where name ='FCGSQTYPE' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FCGSQTYPE VARCHAR(1000) NOT NULL DEFAULT '' -- 采购申请类型
if(not exists(select name from SysColumns where name ='FYANFAPROJECT' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FYANFAPROJECT VARCHAR(50) NOT NULL DEFAULT '' -- 研发项目
if(not exists(select name from SysColumns where name ='FYFZXM' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FYFZXM VARCHAR(50) NOT NULL DEFAULT '' -- 研发子项目
if(not exists(select name from SysColumns where name ='FUSEDEPT' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FUSEDEPT VARCHAR(50) NOT NULL DEFAULT '' -- 使用部门
if(not exists(select name from SysColumns where name ='FHGNISHOUSTOCK' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FHGNISHOUSTOCK VARCHAR(50) NOT NULL DEFAULT '' -- 拟收仓库
if(not exists(select name from SysColumns where name ='FHGNISHOUSTOCKPLACE' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FHGNISHOUSTOCKPLACE VARCHAR(50) NOT NULL DEFAULT '' -- 拟收仓位
if(not exists(select name from SysColumns where name ='FPLANMODE' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FPLANMODE VARCHAR(50) NOT NULL DEFAULT '' -- 计划模式
if(not exists(select name from SysColumns where name ='FMTONO' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FMTONO VARCHAR(50) NOT NULL DEFAULT '' -- 计划跟踪号
if(not exists(select name from SysColumns where name ='FRECEIVUNITID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FRECEIVUNITID VARCHAR(50) NOT NULL DEFAULT '' -- 收料单位
if(not exists(select name from SysColumns where name ='FPRICEUNITID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FPRICEUNITID VARCHAR(50) NOT NULL DEFAULT '' -- 计价单位
if(not exists(select name from SysColumns where name ='FCHECKINCOMING' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FCHECKINCOMING BIT NOT NULL DEFAULT 0 -- 来料检验
if(not exists(select name from SysColumns where name ='FGODQTY' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FGODQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 检验合格数量
if(not exists(select name from SysColumns where name ='FGODBASEQTY' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FGODBASEQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 检验合格基本单位数量
if(not exists(select name from SysColumns where name ='FSCRAPQTY' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSCRAPQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 样本破坏数
if(not exists(select name from SysColumns where name ='FORDERBILLNO' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FORDERBILLNO VARCHAR(50) NOT NULL DEFAULT '' -- 订单编号
if(not exists(select name from SysColumns where name ='FORDERDETAILID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FORDERDETAILID VARCHAR(50) NOT NULL DEFAULT '' -- 订单明细内码
if(not exists(select name from SysColumns where name ='FORDERENTRYID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FORDERENTRYID INT NOT NULL DEFAULT 0 -- 订单明细行号
if(not exists(select name from SysColumns where name ='FORDERINTERID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FORDERINTERID VARCHAR(50) NOT NULL DEFAULT '' -- 订单内码
if(not exists(select name from SysColumns where name ='FSUPPLYLOT' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSUPPLYLOT VARCHAR(50) NOT NULL DEFAULT '' -- 供应商批号
if(not exists(select name from SysColumns where name ='FEXPIREDATE' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FEXPIREDATE DATE NULL -- 有效期至
if(not exists(select name from SysColumns where name ='FDEMANDDEPTID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FDEMANDDEPTID VARCHAR(50) NOT NULL DEFAULT '' -- 需求部门
if(not exists(select name from SysColumns where name ='FDEMANDERID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FDEMANDERID VARCHAR(50) NOT NULL DEFAULT '' -- 需求人
if(not exists(select name from SysColumns where name ='FSFWJSD' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSFWJSD BIT NOT NULL DEFAULT 0 -- 随附文件送达
if(not exists(select name from SysColumns where name ='FSHDSD' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FSHDSD BIT NOT NULL DEFAULT 0 -- 送货单送达
if(not exists(select name from SysColumns where name ='FCOMPANYID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FCOMPANYID VARCHAR(50) NOT NULL DEFAULT '' -- 组织代码
if(not exists(select name from SysColumns where name ='FINTERID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FINTERID VARCHAR(50) NOT NULL DEFAULT '' -- 表内码
if(not exists(select name from SysColumns where name ='FDETAILID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FDETAILID VARCHAR(50) NOT NULL DEFAULT '' -- 表体内码
if(not exists(select name from SysColumns where name ='FENTRYID' and id= OBJECT_ID('T_PUR_RECEIVEENTRY')))
Alter Table T_PUR_RECEIVEENTRY add FENTRYID INT NOT NULL DEFAULT 0 -- 行号
END
GO
--
IF EXISTS (SELECT * FROM sysindexes WHERE id = OBJECT_ID(N'T_PUR_RECEIVEENTRY') AND name = N'T_PUR_ReceiveEntry_0' )
Drop Index T_PUR_RECEIVEENTRY.T_PUR_ReceiveEntry_0
GO
Create index T_PUR_ReceiveEntry_0 on T_PUR_RECEIVEENTRY(FINTERID)
GO
--
IF EXISTS (SELECT * FROM sysindexes WHERE id = OBJECT_ID(N'T_PUR_RECEIVEENTRY') AND name = N'T_PUR_ReceiveEntry_2' )
Drop Index T_PUR_RECEIVEENTRY.T_PUR_ReceiveEntry_2
GO
Create unique index T_PUR_ReceiveEntry_2 on T_PUR_RECEIVEENTRY(FDETAILID)
GO
GO