MFG制造

### T_PRD_PPBOMCHANGEENTRY_C(生产用料清单变更单表体拆分表)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_PRD_PPBOMCHANGEENTRY_C')
and name = 'IDX_PRD_PPBOMCHE_C_ID'
and indid > 0
and indid < 255)
drop index T_PRD_PPBOMCHANGEENTRY_C.IDX_PRD_PPBOMCHE_C_ID
go
if exists (select 1
from sysobjects
where id = object_id('T_PRD_PPBOMCHANGEENTRY_C')
and type = 'U')
drop table T_PRD_PPBOMCHANGEENTRY_C
go
/*==============================================================*/
/* Table: T_PRD_PPBOMCHANGEENTRY_C */
/*==============================================================*/
create table T_PRD_PPBOMCHANGEENTRY_C (
FID int null,
FENTRYID int not null default 0,
FISSUETYPE char(1) not null default '1',
FISGETSCRAP char(1) not null default '1',
FBACKFLUSHTYPE char(1) null,
FALLOWOVER char(1) null default '0',
FOVERRATE decimal(23,10) not null default 0,
FOWNERTYPEID varchar(36) null,
FOWNERID int null,
FSUPPLYORG int null,
FSTOCKID int null,
FSTOCKLOCID int null,
FLOT int null,
FLOT_TEXT nvarchar(255) null,
FPOSITIONNO nvarchar(2000) null,
FSRCTRANSORGID int null,
FSRCTRANSSTOCKID int null,
FSRCTRANSSTOCKLOCID int null,
FISKEYCOMPONENT char(1) not null default '0',
FRESERVETYPE char(1) null default '2',
FPRIORITY int null default 0,
FISSKIP char(1) null default '0',
FREPLACEPOLICY char(1) null,
FREPLACETYPE char(1) null,
FREPLACEPRIORITY int null,
FWORKCALID int not null default 0,
FPARENTMATERIALID int not null default 0,
FPRODUCEQTY decimal(23,10) not null default 0,
FPPBOMNO nvarchar(80) null,
FCHANGETYPE char(1) null,
FBASEPRODUCEUNITID int not null default 0,
FPRODUCEUNITID int not null default 0,
FPPBOMENTRYSEQ int null,
FPPBOMENTRYID int null,
FPPBOMID int null,
FSRCBILLTYPE varchar(36) null,
FSRCBILLNO nvarchar(80) null,
FSUPPLYGROUP int null default 0,
FOVERCONTROLMODE char(1) null default '2',
FSMID int null default 0,
FSMENTRYID int null default 0,
FChildSupplyOrgId int null default 0,
FWORKSHOPID int null default 0,
FSTOCKSTATUSID int null default 0,
FEntrustPickOrgId int null default 0,
FROWID varchar(36) null,
FPARENTROWID varchar(36) null,
FROWEXPANDTYPE int null,
FISMinIssueQty char(1) not null default '0',
FGROUPBYOWNERID int null,
FSUPPLYMODE char(1) not null default '',
constraint PK_PRD_PPBOMCHENTRY_C primary key (FENTRYID)
)
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'1.直接领料;2.直接倒冲;3.转仓领料;4.转仓倒冲;5.备料发料;7.不发料',
'user', @CurrentUser, 'table', 'T_PRD_PPBOMCHANGEENTRY_C', 'column', 'FISSUETYPE'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'1.开工倒冲;2.汇报倒冲;3.入库倒冲',
'user', @CurrentUser, 'table', 'T_PRD_PPBOMCHANGEENTRY_C', 'column', 'FBACKFLUSHTYPE'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'与SCM一致',
'user', @CurrentUser, 'table', 'T_PRD_PPBOMCHANGEENTRY_C', 'column', 'FLOT'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'与SCM一致',
'user', @CurrentUser, 'table', 'T_PRD_PPBOMCHANGEENTRY_C', 'column', 'FLOT_TEXT'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'1.新增;2.变更;3变更后;',
'user', @CurrentUser, 'table', 'T_PRD_PPBOMCHANGEENTRY_C', 'column', 'FCHANGETYPE'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'货源拆分时用到',
'user', @CurrentUser, 'table', 'T_PRD_PPBOMCHANGEENTRY_C', 'column', 'FSUPPLYGROUP'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'A:委托方供料 B:受托方供料',
'user', @CurrentUser, 'table', 'T_PRD_PPBOMCHANGEENTRY_C', 'column', 'FSUPPLYMODE'
go
/*==============================================================*/
/* Index: IDX_PRD_PPBOMCHE_C_ID */
/*==============================================================*/
create index IDX_PRD_PPBOMCHE_C_ID on T_PRD_PPBOMCHANGEENTRY_C (
FID ASC
)
go

### T_PRD_PPBOMCHANGEENTRY_C(生产用料清单变更单表体拆分表)：键值定义

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

### T_PRD_PPBOMCHANGEENTRY_C(生产用料清单变更单表体拆分表)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_PRD_PPBOMCHE_C_ID | IDX_PRD_PPBOMCHE_C_ID | FALSE | FALSE | FALSE | FALSE | FALSE | T_PRD_PPBOMCHANGEENTRY_C(生产用料清单变更单表体拆分表)

上一页

主页

下一页