/* 脚本导出时间:2026/08/18 15:54:29 */ /* 脚本导出人员:系统管理员 */ /* 脚本 说明:T_BD_MATERIAL 物料*/ -- DROP TABLE T_BD_MATERIAL IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'T_BD_MATERIAL') AND type in (N'U')) BEGIN CREATE TABLE T_BD_MATERIAL( FMASTERID VARCHAR(50) NOT NULL DEFAULT '' , -- 主料号内码 FNUMBER VARCHAR(50) NOT NULL DEFAULT '' , -- 物料编码 FNAME NVARCHAR(100) NOT NULL DEFAULT '' , -- 物料名称 FNAME_EN VARCHAR(100) NOT NULL DEFAULT '' , -- 物料名称-英文 FSPECIFICATION_EN NVARCHAR(510) NOT NULL DEFAULT '' , -- 规格型号-英文 FSPECIFICATION NVARCHAR(510) NOT NULL DEFAULT '' , -- 规格型号 FDESCRIPTION NVARCHAR(510) NOT NULL DEFAULT '' , -- 描述 FBARCODE VARCHAR(50) NOT NULL DEFAULT '' , -- 条码 FERPCLSID VARCHAR(4) NOT NULL DEFAULT '' , -- 物料属性 FABC VARCHAR(50) NOT NULL DEFAULT '' , -- ABC分类 FMAXQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 最大库存 FSAFEQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 安全库存 FNETWEIGHT DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 净重 FGROSSWEIGHT DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 毛重 FBASEUNITID VARCHAR(50) NOT NULL DEFAULT '' , -- 基本单位 FSTOREUNITID VARCHAR(50) NOT NULL DEFAULT '' , -- 库存单位 FSALEUNITID VARCHAR(50) NOT NULL DEFAULT '' , -- 销售单位 FPURCHASEUNITID VARCHAR(50) NOT NULL DEFAULT '' , -- 采购单位 FISKFPERIOD BIT NOT NULL DEFAULT 0 , -- 启用保质期 FKFUNIT INT NOT NULL DEFAULT 0 , -- 保质期单位 FKFPERIOD INT NOT NULL DEFAULT 0 , -- 保质期限 FSUBCONUNITID VARCHAR(50) NOT NULL DEFAULT '' , -- 委外单位 FPRODUCEUNITID VARCHAR(50) NOT NULL DEFAULT '' , -- 生产单位 FISBATCHMANAGE BIT NOT NULL DEFAULT 0 , -- 启用批号管理 FMINPOQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 最小订货量 FINCREASEQTY DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 最小包装量 FCHECKERID VARCHAR(50) NOT NULL DEFAULT '' , -- 审核人 FCHECKDATE DATETIME NULL , -- 审核日期 FDISABLEID VARCHAR(50) NOT NULL DEFAULT '' , -- 禁用人 FDISABLEDATE DATETIME NULL , -- 禁用日期 FCHECKINCOMING BIT NOT NULL DEFAULT 0 , -- 来料检验 FOLDNUMBER VARCHAR(100) NOT NULL DEFAULT '' , -- 旧料号 FDESTOCKID VARCHAR(50) NOT NULL DEFAULT '' , -- 默认仓库 FDESPID VARCHAR(50) NOT NULL DEFAULT '' , -- 默认仓位 FVPART BIT NOT NULL DEFAULT 0 , -- 虚拟件 FTYPEID VARCHAR(50) NOT NULL DEFAULT '' , -- 物料类别ID FBARTYPE INT NOT NULL DEFAULT 2 , -- 条码类别 FPRICE DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 单价 FENBOMID BIT NOT NULL DEFAULT 0 , -- 是否启用BOM版本 FTAXRATE DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 税率 FINSPECTIONLEVEL VARCHAR(50) NOT NULL DEFAULT '' , -- 检验方式 FLOWLIMIT DECIMAL(24,6) NOT NULL DEFAULT 0 , -- 最低库存量 FFEEDSN BIT NOT NULL DEFAULT 0 , -- 启用序列号 FOTHERSN BIT NOT NULL DEFAULT 0 , -- 第三方序列号 FISPINAL BIT NOT NULL DEFAULT 0 , -- 终检 FISFEED BIT NOT NULL DEFAULT 0 , -- 不投料 FPICTURE IMAGE NULL , -- 图片 FCHARTNUMBER VARCHAR(50) NOT NULL DEFAULT '' , -- 图号 FISVMIBUSINESS BIT NOT NULL DEFAULT 0 , -- 是否VMI业务 FPAEZASSISTANT VARCHAR(50) NOT NULL DEFAULT '' , -- 最新版本号 FSUITE BIT NOT NULL DEFAULT 0 , -- 套件 FISSECUNIT BIT NOT NULL DEFAULT 0 , -- 启用辅助单位 FSHORTESTPURTIME INT NOT NULL DEFAULT 0 , -- 最短采购时间 FLONGESTPURTIME INT NOT NULL DEFAULT 0 , -- 最长采购时间 FDEFAULTMANAGER VARCHAR(50) NOT NULL DEFAULT '' , -- 默认管理员 FLENGTH DECIMAL(24,2) NOT NULL DEFAULT 0 , -- 长 FWIDTH DECIMAL(24,2) NOT NULL DEFAULT 0 , -- 宽 FHEIGHT DECIMAL(24,2) NOT NULL DEFAULT 0 , -- 高 FVOLUME DECIMAL(24,4) NOT NULL DEFAULT 0 , -- 体积 FAUXUNITID VARCHAR(50) NOT NULL DEFAULT '' , -- 默认辅助属性 FDESCEN VARCHAR(250) NOT NULL DEFAULT '' , -- 英文描述 FINTERID VARCHAR(50) NOT NULL DEFAULT '', -- 表内码 FGROUPID 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_BD_MATERIAL] PRIMARY KEY NONCLUSTERED ) END ELSE BEGIN if(not exists(select name from SysColumns where name ='FMASTERID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FMASTERID VARCHAR(50) NOT NULL DEFAULT '' -- 主料号内码 if(not exists(select name from SysColumns where name ='FNUMBER' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FNUMBER VARCHAR(50) NOT NULL DEFAULT '' -- 物料编码 if(not exists(select name from SysColumns where name ='FNAME' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FNAME NVARCHAR(100) NOT NULL DEFAULT '' -- 物料名称 if(not exists(select name from SysColumns where name ='FNAME_EN' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FNAME_EN VARCHAR(100) NOT NULL DEFAULT '' -- 物料名称-英文 if(not exists(select name from SysColumns where name ='FSPECIFICATION_EN' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FSPECIFICATION_EN NVARCHAR(510) NOT NULL DEFAULT '' -- 规格型号-英文 if(not exists(select name from SysColumns where name ='FSPECIFICATION' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FSPECIFICATION NVARCHAR(510) NOT NULL DEFAULT '' -- 规格型号 if(not exists(select name from SysColumns where name ='FDESCRIPTION' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FDESCRIPTION NVARCHAR(510) NOT NULL DEFAULT '' -- 描述 if(not exists(select name from SysColumns where name ='FBARCODE' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FBARCODE VARCHAR(50) NOT NULL DEFAULT '' -- 条码 if(not exists(select name from SysColumns where name ='FERPCLSID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FERPCLSID VARCHAR(4) NOT NULL DEFAULT '' -- 物料属性 if(not exists(select name from SysColumns where name ='FABC' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FABC VARCHAR(50) NOT NULL DEFAULT '' -- ABC分类 if(not exists(select name from SysColumns where name ='FMAXQTY' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FMAXQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 最大库存 if(not exists(select name from SysColumns where name ='FSAFEQTY' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FSAFEQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 安全库存 if(not exists(select name from SysColumns where name ='FNETWEIGHT' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FNETWEIGHT DECIMAL(24,6) NOT NULL DEFAULT 0 -- 净重 if(not exists(select name from SysColumns where name ='FGROSSWEIGHT' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FGROSSWEIGHT DECIMAL(24,6) NOT NULL DEFAULT 0 -- 毛重 if(not exists(select name from SysColumns where name ='FBASEUNITID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FBASEUNITID VARCHAR(50) NOT NULL DEFAULT '' -- 基本单位 if(not exists(select name from SysColumns where name ='FSTOREUNITID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FSTOREUNITID VARCHAR(50) NOT NULL DEFAULT '' -- 库存单位 if(not exists(select name from SysColumns where name ='FSALEUNITID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FSALEUNITID VARCHAR(50) NOT NULL DEFAULT '' -- 销售单位 if(not exists(select name from SysColumns where name ='FPURCHASEUNITID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FPURCHASEUNITID VARCHAR(50) NOT NULL DEFAULT '' -- 采购单位 if(not exists(select name from SysColumns where name ='FISKFPERIOD' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FISKFPERIOD BIT NOT NULL DEFAULT 0 -- 启用保质期 if(not exists(select name from SysColumns where name ='FKFUNIT' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FKFUNIT INT NOT NULL DEFAULT 0 -- 保质期单位 if(not exists(select name from SysColumns where name ='FKFPERIOD' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FKFPERIOD INT NOT NULL DEFAULT 0 -- 保质期限 if(not exists(select name from SysColumns where name ='FSUBCONUNITID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FSUBCONUNITID VARCHAR(50) NOT NULL DEFAULT '' -- 委外单位 if(not exists(select name from SysColumns where name ='FPRODUCEUNITID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FPRODUCEUNITID VARCHAR(50) NOT NULL DEFAULT '' -- 生产单位 if(not exists(select name from SysColumns where name ='FISBATCHMANAGE' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FISBATCHMANAGE BIT NOT NULL DEFAULT 0 -- 启用批号管理 if(not exists(select name from SysColumns where name ='FMINPOQTY' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FMINPOQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 最小订货量 if(not exists(select name from SysColumns where name ='FINCREASEQTY' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FINCREASEQTY DECIMAL(24,6) NOT NULL DEFAULT 0 -- 最小包装量 if(not exists(select name from SysColumns where name ='FCHECKERID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FCHECKERID VARCHAR(50) NOT NULL DEFAULT '' -- 审核人 if(not exists(select name from SysColumns where name ='FCHECKDATE' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FCHECKDATE DATETIME NULL -- 审核日期 if(not exists(select name from SysColumns where name ='FDISABLEID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FDISABLEID VARCHAR(50) NOT NULL DEFAULT '' -- 禁用人 if(not exists(select name from SysColumns where name ='FDISABLEDATE' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FDISABLEDATE DATETIME NULL -- 禁用日期 if(not exists(select name from SysColumns where name ='FCHECKINCOMING' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FCHECKINCOMING BIT NOT NULL DEFAULT 0 -- 来料检验 if(not exists(select name from SysColumns where name ='FOLDNUMBER' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FOLDNUMBER VARCHAR(100) NOT NULL DEFAULT '' -- 旧料号 if(not exists(select name from SysColumns where name ='FDESTOCKID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FDESTOCKID VARCHAR(50) NOT NULL DEFAULT '' -- 默认仓库 if(not exists(select name from SysColumns where name ='FDESPID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FDESPID VARCHAR(50) NOT NULL DEFAULT '' -- 默认仓位 if(not exists(select name from SysColumns where name ='FVPART' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FVPART BIT NOT NULL DEFAULT 0 -- 虚拟件 if(not exists(select name from SysColumns where name ='FTYPEID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FTYPEID VARCHAR(50) NOT NULL DEFAULT '' -- 物料类别ID if(not exists(select name from SysColumns where name ='FBARTYPE' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FBARTYPE INT NOT NULL DEFAULT 2 -- 条码类别 if(not exists(select name from SysColumns where name ='FPRICE' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FPRICE DECIMAL(24,6) NOT NULL DEFAULT 0 -- 单价 if(not exists(select name from SysColumns where name ='FENBOMID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FENBOMID BIT NOT NULL DEFAULT 0 -- 是否启用BOM版本 if(not exists(select name from SysColumns where name ='FTAXRATE' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FTAXRATE DECIMAL(24,6) NOT NULL DEFAULT 0 -- 税率 if(not exists(select name from SysColumns where name ='FINSPECTIONLEVEL' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FINSPECTIONLEVEL VARCHAR(50) NOT NULL DEFAULT '' -- 检验方式 if(not exists(select name from SysColumns where name ='FLOWLIMIT' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FLOWLIMIT DECIMAL(24,6) NOT NULL DEFAULT 0 -- 最低库存量 if(not exists(select name from SysColumns where name ='FFEEDSN' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FFEEDSN BIT NOT NULL DEFAULT 0 -- 启用序列号 if(not exists(select name from SysColumns where name ='FOTHERSN' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FOTHERSN BIT NOT NULL DEFAULT 0 -- 第三方序列号 if(not exists(select name from SysColumns where name ='FISPINAL' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FISPINAL BIT NOT NULL DEFAULT 0 -- 终检 if(not exists(select name from SysColumns where name ='FISFEED' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FISFEED BIT NOT NULL DEFAULT 0 -- 不投料 if(not exists(select name from SysColumns where name ='FPICTURE' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FPICTURE IMAGE NULL -- 图片 if(not exists(select name from SysColumns where name ='FCHARTNUMBER' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FCHARTNUMBER VARCHAR(50) NOT NULL DEFAULT '' -- 图号 if(not exists(select name from SysColumns where name ='FISVMIBUSINESS' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FISVMIBUSINESS BIT NOT NULL DEFAULT 0 -- 是否VMI业务 if(not exists(select name from SysColumns where name ='FPAEZASSISTANT' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FPAEZASSISTANT VARCHAR(50) NOT NULL DEFAULT '' -- 最新版本号 if(not exists(select name from SysColumns where name ='FSUITE' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FSUITE BIT NOT NULL DEFAULT 0 -- 套件 if(not exists(select name from SysColumns where name ='FISSECUNIT' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FISSECUNIT BIT NOT NULL DEFAULT 0 -- 启用辅助单位 if(not exists(select name from SysColumns where name ='FSHORTESTPURTIME' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FSHORTESTPURTIME INT NOT NULL DEFAULT 0 -- 最短采购时间 if(not exists(select name from SysColumns where name ='FLONGESTPURTIME' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FLONGESTPURTIME INT NOT NULL DEFAULT 0 -- 最长采购时间 if(not exists(select name from SysColumns where name ='FDEFAULTMANAGER' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FDEFAULTMANAGER VARCHAR(50) NOT NULL DEFAULT '' -- 默认管理员 if(not exists(select name from SysColumns where name ='FLENGTH' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FLENGTH DECIMAL(24,2) NOT NULL DEFAULT 0 -- 长 if(not exists(select name from SysColumns where name ='FWIDTH' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FWIDTH DECIMAL(24,2) NOT NULL DEFAULT 0 -- 宽 if(not exists(select name from SysColumns where name ='FHEIGHT' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FHEIGHT DECIMAL(24,2) NOT NULL DEFAULT 0 -- 高 if(not exists(select name from SysColumns where name ='FVOLUME' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FVOLUME DECIMAL(24,4) NOT NULL DEFAULT 0 -- 体积 if(not exists(select name from SysColumns where name ='FAUXUNITID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FAUXUNITID VARCHAR(50) NOT NULL DEFAULT '' -- 默认辅助属性 if(not exists(select name from SysColumns where name ='FDESCEN' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FDESCEN VARCHAR(250) NOT NULL DEFAULT '' -- 英文描述 if(not exists(select name from SysColumns where name ='FCOMPANYID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FCOMPANYID VARCHAR(50) NOT NULL DEFAULT '' -- 组织代码 if(not exists(select name from SysColumns where name ='FINTERID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FINTERID VARCHAR(50) NOT NULL DEFAULT '' -- 表内码 if(not exists(select name from SysColumns where name ='FGROUPID' and id= OBJECT_ID('T_BD_MATERIAL'))) Alter Table T_BD_MATERIAL add FGROUPID VARCHAR(50) NOT NULL DEFAULT '' -- 分组内码 END GO -- IF EXISTS (SELECT * FROM sysindexes WHERE id = OBJECT_ID(N'T_BD_MATERIAL') AND name = N'T_BD_MATERIAL_1' ) Drop Index T_BD_MATERIAL.T_BD_MATERIAL_1 GO Create unique index T_BD_MATERIAL_1 on T_BD_MATERIAL(FINTERID) GO -- IF EXISTS (SELECT * FROM sysindexes WHERE id = OBJECT_ID(N'T_BD_MATERIAL') AND name = N'T_BD_MATERIAL_2' ) Drop Index T_BD_MATERIAL.T_BD_MATERIAL_2 GO Create unique Clustered index T_BD_MATERIAL_2 on T_BD_MATERIAL(FCOMPANYID,FNUMBER,FDELETED) GO GO