MFG制造

## 数据表：T_SUB_PPBOMCHANGEENTRY(委外用料清单变更单表体)

### T_SUB_PPBOMCHANGEENTRY(委外用料清单变更单表体)：描述

名称 | T_SUB_PPBOMCHANGEENTRY(委外用料清单变更单表体)
代码 | T_SUB_PPBOMCHANGEENTRY
注释 |
模型 | MFG制造
主键 | PK_SUB_PPBOMCHENTRY

### T_SUB_PPBOMCHANGEENTRY(委外用料清单变更单表体)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
委外用料清单ID | FID | int |  | FALSE |
主键 | FENTRYID | int |  | TRUE |
序号 | FSEQ | int |  | FALSE |
委外申请单类型 | FSUBREQTYPE | varchar(36) | 36 | FALSE |
委外申请单内码 | FSUBREQID | int |  | TRUE |
委外申请单编号 | FSUBREQBILLNO | nvarchar(80) | 80 | FALSE |
委外申请单分录内码 | FSUBREQENTRYID | int |  | TRUE |
委外申请单分录行号 | FSUBREQENTRYSEQ | int |  | TRUE |
BOM编号 | FBOMID | int |  | FALSE |
BOM分录内码 | FBOMENTRYID | int |  | FALSE |
物料编码 | FMATERIALID | int |  | FALSE |
子项类型 | FMATERIALTYPE | char(1) | 1 | TRUE | 1.普通件;2.返还件;3.替代件
偏置提前期 | FOFFSETTIME | decimal(19,6) | 19 | TRUE |
偏置提前期单位 | FTIMEUNIT | varchar(10) | 10 | TRUE | 1.天;24.时;1440.分;86400.秒
辅助属性 | FAUXPROPID | int |  | FALSE |
用量类型 | FDOSAGETYPE | char(1) | 1 | TRUE | 1.固定;2.变动;3.阶梯
使用比例 | FUSERATE | decimal(19,6) | 19 | TRUE |
基本单位原分子 | FBASEBOMNUMERATOR | decimal(23,10) | 23 | TRUE |
基本单位原分母 | FBASEBOMDENOMINATOR | decimal(23,10) | 23 | TRUE |
基本单位分子 | FBASENUMERATOR | decimal(23,10) | 23 | TRUE |
基本单位分母 | FBASEDENOMINATOR | decimal(23,10) | 23 | TRUE |
原分子 | FBOMNUMERATOR | decimal(23,10) | 23 | TRUE |
原分母 | FBOMDENOMINATOR | decimal(23,10) | 23 | TRUE |
分子 | FNUMERATOR | decimal(23,10) | 23 | TRUE |
分母 | FDENOMINATOR | decimal(23,10) | 23 | TRUE |
单位 | FUNITID | int |  | TRUE |
基本单位 | FBASEUNITID | int |  | FALSE |
固定损耗 | FFIXSCRAPQTY | decimal(19,6) | 19 | TRUE |
基本单位固定损耗 | FBASEFIXSCRAPQTY | decimal(23,10) | 23 | FALSE |
变动损耗率 | FSCRAPRATE | decimal(19,6) | 19 | FALSE |
工序 | FOPERID | int |  | FALSE |
作业编码 | FPROCESSID | int |  | FALSE |
需求日期 | FNEEDDATE | datetime |  | FALSE |
标准用量 | FSTDQTY | decimal(23,10) | 23 | TRUE |
基本单位标准用量 | FBASESTDQTY | decimal(23,10) | 23 | TRUE |
需求数量 | FNEEDQTY | decimal(23,10) | 23 | TRUE |
基本单位需求数量 | FBASENEEDQTY | decimal(23,10) | 23 | TRUE |
应发数量 | FMUSTQTY | decimal(23,10) | 23 | TRUE |
基本单位应发数量 | FBASEMUSTQTY | decimal(23,10) | 23 | TRUE |
计划跟踪号 | FMTONO | nvarchar(255) | 255 | FALSE |
项目编号 | FPROJECTNO | nvarchar(80) | 80 | FALSE |
项次 | FREPLACEGROUP | int |  | FALSE | (后台字段,IDE中隐藏)
是否替代关键件 | FISKEYITEM | char(1) | 1 | TRUE |
业务流程 | FBFLOWID | varchar(36) | 36 | TRUE |

### T_SUB_PPBOMCHANGEENTRY(委外用料清单变更单表体)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_SUB_PPBOMCHANGEENTRY')
and name = 'IDX_SUB_PPBOMCHE_REQENTRYID'
and indid > 0
and indid < 255)
drop index T_SUB_PPBOMCHANGEENTRY.IDX_SUB_PPBOMCHE_REQENTRYID
go
if exists (select 1
from sysindexes
where id = object_id('T_SUB_PPBOMCHANGEENTRY')
and name = 'IDX_SUB_PPBOMCHE_ID'
and indid > 0
and indid < 255)
drop index T_SUB_PPBOMCHANGEENTRY.IDX_SUB_PPBOMCHE_ID
go
if exists (select 1
from sysindexes
where id = object_id('T_SUB_PPBOMCHANGEENTRY')
and name = 'IDX_SUB_PPBOMCHE_MATERIALID'
and indid > 0
and indid < 255)
drop index T_SUB_PPBOMCHANGEENTRY.IDX_SUB_PPBOMCHE_MATERIALID
go
if exists (select 1
from sysindexes
where id = object_id('T_SUB_PPBOMCHANGEENTRY')
and name = 'IDX_SUB_PPBOMCHE_MTONO'
and indid > 0
and indid < 255)
drop index T_SUB_PPBOMCHANGEENTRY.IDX_SUB_PPBOMCHE_MTONO
go
if exists (select 1
from sysindexes
where id = object_id('T_SUB_PPBOMCHANGEENTRY')
and name = 'IDX_SUB_PPBOMCHE_BOMID'
and indid > 0
and indid < 255)
drop index T_SUB_PPBOMCHANGEENTRY.IDX_SUB_PPBOMCHE_BOMID
go
if exists (select 1
from sysindexes
where id = object_id('T_SUB_PPBOMCHANGEENTRY')
and name = 'IDX_SUB_PPBOMCHE_SUBREQID'
and indid > 0
and indid < 255)
drop index T_SUB_PPBOMCHANGEENTRY.IDX_SUB_PPBOMCHE_SUBREQID
go
if exists (select 1
from sysobjects
where id = object_id('T_SUB_PPBOMCHANGEENTRY')
and type = 'U')
drop table T_SUB_PPBOMCHANGEENTRY
go
/*==============================================================*/
/* Table: T_SUB_PPBOMCHANGEENTRY */
/*==============================================================*/
create table T_SUB_PPBOMCHANGEENTRY (
FID int null,
FENTRYID int not null default 0,
FSEQ int null,
FSUBREQTYPE varchar(36) null,
FSUBREQID int not null default 0,
FSUBREQBILLNO nvarchar(80) null,
FSUBREQENTRYID int not null default 0,
FSUBREQENTRYSEQ int not null default 0,
FBOMID int null,
FBOMENTRYID int null,
FMATERIALID int null,
FMATERIALTYPE char(1) not null default '1',
FOFFSETTIME decimal(19,6) not null default 0,
FTIMEUNIT varchar(10) not null default '1',
FAUXPROPID int null,
FDOSAGETYPE char(1) not null default '2',
FUSERATE decimal(19,6) not null default 0,
FBASEBOMNUMERATOR decimal(23,10) not null default 1,
FBASEBOMDENOMINATOR decimal(23,10) not null default 1,
FBASENUMERATOR decimal(23,10) not null default 1,
FBASEDENOMINATOR decimal(23,10) not null default 1,
FBOMNUMERATOR decimal(23,10) not null default 1,
FBOMDENOMINATOR decimal(23,10) not null default 1,
FNUMERATOR decimal(23,10) not null default 1,
FDENOMINATOR decimal(23,10) not null default 1,
FUNITID int not null default 0,
FBASEUNITID int null,
FFIXSCRAPQTY decimal(19,6) not null default 0,
FBASEFIXSCRAPQTY decimal(23,10) null default 0,
FSCRAPRATE decimal(19,6) null default 0,
FOPERID int null,
FPROCESSID int null,
FNEEDDATE datetime null,
FSTDQTY decimal(23,10) not null default 0,
FBASESTDQTY decimal(23,10) not null default 0,
FNEEDQTY decimal(23,10) not null default 0,
FBASENEEDQTY decimal(23,10) not null default 0,
FMUSTQTY decimal(23,10) not null default 0,
FBASEMUSTQTY decimal(23,10) not null default 0,
FMTONO nvarchar(255) null,
FPROJECTNO nvarchar(80) null,
FREPLACEGROUP int null,
FISKEYITEM char(1) not null default '0',
FBFLOWID varchar(36) not null default '',
constraint PK_SUB_PPBOMCHENTRY primary key (FENTRYID)
)
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'1.普通件;2.返还件;3.替代件',
'user', @CurrentUser, 'table', 'T_SUB_PPBOMCHANGEENTRY', 'column', 'FMATERIALTYPE'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'1.天;24.时;1440.分;86400.秒',
'user', @CurrentUser, 'table', 'T_SUB_PPBOMCHANGEENTRY', 'column', 'FTIMEUNIT'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'1.固定;2.变动;3.阶梯',
'user', @CurrentUser, 'table', 'T_SUB_PPBOMCHANGEENTRY', 'column', 'FDOSAGETYPE'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'(后台字段,IDE中隐藏)',
'user', @CurrentUser, 'table', 'T_SUB_PPBOMCHANGEENTRY', 'column', 'FREPLACEGROUP'
go
/*==============================================================*/
/* Index: IDX_SUB_PPBOMCHE_SUBREQID */
/*==============================================================*/
create index IDX_SUB_PPBOMCHE_SUBREQID on T_SUB_PPBOMCHANGEENTRY (
FSUBREQID ASC
)
go
/*==============================================================*/
/* Index: IDX_SUB_PPBOMCHE_BOMID */
/*==============================================================*/
create index IDX_SUB_PPBOMCHE_BOMID on T_SUB_PPBOMCHANGEENTRY (
FBOMID ASC
)
go
/*==============================================================*/
/* Index: IDX_SUB_PPBOMCHE_MTONO */
/*==============================================================*/
create index IDX_SUB_PPBOMCHE_MTONO on T_SUB_PPBOMCHANGEENTRY (
FMTONO ASC
)
go
/*==============================================================*/
/* Index: IDX_SUB_PPBOMCHE_MATERIALID */
/*==============================================================*/
create index IDX_SUB_PPBOMCHE_MATERIALID on T_SUB_PPBOMCHANGEENTRY (
FMATERIALID ASC
)
go
/*==============================================================*/
/* Index: IDX_SUB_PPBOMCHE_ID */
/*==============================================================*/
create index IDX_SUB_PPBOMCHE_ID on T_SUB_PPBOMCHANGEENTRY (
FID ASC
)
go
/*==============================================================*/
/* Index: IDX_SUB_PPBOMCHE_REQENTRYID */
/*==============================================================*/
create index IDX_SUB_PPBOMCHE_REQENTRYID on T_SUB_PPBOMCHANGEENTRY (
FSUBREQENTRYID ASC
)
go

### T_SUB_PPBOMCHANGEENTRY(委外用料清单变更单表体)：键值定义

名称 | 代码 | 主要的
PK_SUB_PPBOMCHENTRY | PK_SUB_PPBOMCHENTRY | TRUE

### T_SUB_PPBOMCHANGEENTRY(委外用料清单变更单表体)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_SUB_PPBOMCHE_SUBREQID | IDX_SUB_PPBOMCHE_SUBREQID | FALSE | FALSE | FALSE | FALSE | FALSE | T_SUB_PPBOMCHANGEENTRY(委外用料清单变更单表体)
IDX_SUB_PPBOMCHE_BOMID | IDX_SUB_PPBOMCHE_BOMID | FALSE | FALSE | FALSE | FALSE | FALSE | T_SUB_PPBOMCHANGEENTRY(委外用料清单变更单表体)
IDX_SUB_PPBOMCHE_MTONO | IDX_SUB_PPBOMCHE_MTONO | FALSE | FALSE | FALSE | FALSE | FALSE | T_SUB_PPBOMCHANGEENTRY(委外用料清单变更单表体)
IDX_SUB_PPBOMCHE_MATERIALID | IDX_SUB_PPBOMCHE_MATERIALID | FALSE | FALSE | FALSE | FALSE | FALSE | T_SUB_PPBOMCHANGEENTRY(委外用料清单变更单表体)
IDX_SUB_PPBOMCHE_ID | IDX_SUB_PPBOMCHE_ID | FALSE | FALSE | FALSE | FALSE | FALSE | T_SUB_PPBOMCHANGEENTRY(委外用料清单变更单表体)
IDX_SUB_PPBOMCHE_REQENTRYID | IDX_SUB_PPBOMCHE_REQENTRYID | FALSE | FALSE | FALSE | FALSE | FALSE | T_SUB_PPBOMCHANGEENTRY(委外用料清单变更单表体)

上一页

主页

下一页