/* 脚本导出时间: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