MFG制造

## 数据表：T_PRD_PPBOMCHANGE(生产用料清单变更单)

### T_PRD_PPBOMCHANGE(生产用料清单变更单)：描述

名称 | T_PRD_PPBOMCHANGE(生产用料清单变更单)
代码 | T_PRD_PPBOMCHANGE
注释 |
模型 | MFG制造
主键 | PK_PRD_PPBOMCH

### T_PRD_PPBOMCHANGE(生产用料清单变更单)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
主键 | FID | int |  | TRUE |
交易类型码 | FFORMID | varchar(36) | 36 | FALSE |
单据编号 | FBILLNO | nvarchar(80) | 80 | FALSE |
产品编码 | FMATERIALID | int |  | TRUE |
生产组织 | FPRDORGID | int |  | FALSE |
生产车间 | FWORKSHOPID | int |  | TRUE |
BOM编号 | FBOMID | int |  | TRUE |
基本数量 | FBASEQTY | decimal(23,10) | 23 | TRUE |
基本单位 | FBASEUNITID | int |  | TRUE |
生产数量 | FQTY | decimal(23,10) | 23 | TRUE |
生产单位 | FUNITID | int |  | TRUE |
生产订单类型 | FMOTYPE | varchar(36) | 36 | FALSE |
生产订单内码 | FMOID | int |  | FALSE |
生产订单编号 | FMOBILLNO | nvarchar(30) | 30 | FALSE |
生产订单分录内码 | FMOENTRYID | int |  | FALSE |
生产订单分录行号 | FMOENTRYSEQ | int |  | FALSE |
产品货主类型 | FPARENTOWNERTYPEID | varchar(36) | 36 | FALSE |
产品货主 | FPARENTOWNERID | int |  | FALSE |
辅助属性 | FAUXPROPID | int |  | FALSE |
数据状态 | FDOCUMENTSTATUS | char(1) | 1 | FALSE |
创建人 | FCREATORID | int |  | FALSE |
创建日期 | FCREATEDATE | datetime |  | FALSE |
修改人 | FMODIFIERID | int |  | FALSE |
修改日期 | FMODIFYDATE | datetime |  | FALSE |
审核人 | FAPPROVERID | int |  | FALSE |
审核日期 | FAPPROVEDATE | datetime |  | FALSE |
变更原因 | FCHANGEREASON | varchar(36) | 36 | FALSE | 辅助资料
单据类型 | FBILLTYPE | varchar(36) | 36 | FALSE |
单据日期 | FDATE | datetime |  | FALSE |

### T_PRD_PPBOMCHANGE(生产用料清单变更单)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_PRD_PPBOMCHANGE')
and name = 'IDX_PRD_PPBOMCH_DATE'
and indid > 0
and indid < 255)
drop index T_PRD_PPBOMCHANGE.IDX_PRD_PPBOMCH_DATE
go
if exists (select 1
from sysindexes
where id = object_id('T_PRD_PPBOMCHANGE')
and name = 'IDX_PRD_PPBOMCH_PRDORGID'
and indid > 0
and indid < 255)
drop index T_PRD_PPBOMCHANGE.IDX_PRD_PPBOMCH_PRDORGID
go
if exists (select 1
from sysindexes
where id = object_id('T_PRD_PPBOMCHANGE')
and name = 'IDX_PRD_PPBOMCH_MATERIALID'
and indid > 0
and indid < 255)
drop index T_PRD_PPBOMCHANGE.IDX_PRD_PPBOMCH_MATERIALID
go
if exists (select 1
from sysindexes
where id = object_id('T_PRD_PPBOMCHANGE')
and name = 'IDX_PRD_PPBOMCH_MOENTRYID'
and indid > 0
and indid < 255)
drop index T_PRD_PPBOMCHANGE.IDX_PRD_PPBOMCH_MOENTRYID
go
if exists (select 1
from sysindexes
where id = object_id('T_PRD_PPBOMCHANGE')
and name = 'IDX_PRD_PPBOMCH_MOID'
and indid > 0
and indid < 255)
drop index T_PRD_PPBOMCHANGE.IDX_PRD_PPBOMCH_MOID
go
if exists (select 1
from sysindexes
where id = object_id('T_PRD_PPBOMCHANGE')
and name = 'IDX_PRD_PPBOMCH_BILLNO'
and indid > 0
and indid < 255)
drop index T_PRD_PPBOMCHANGE.IDX_PRD_PPBOMCH_BILLNO
go
if exists (select 1
from sysobjects
where id = object_id('T_PRD_PPBOMCHANGE')
and type = 'U')
drop table T_PRD_PPBOMCHANGE
go
/*==============================================================*/
/* Table: T_PRD_PPBOMCHANGE */
/*==============================================================*/
create table T_PRD_PPBOMCHANGE (
FID int not null default 0,
FFORMID varchar(36) null,
FBILLNO nvarchar(80) null,
FMATERIALID int not null default 0,
FPRDORGID int null,
FWORKSHOPID int not null default 0,
FBOMID int not null default 0,
FBASEQTY decimal(23,10) not null default 0,
FBASEUNITID int not null default 0,
FQTY decimal(23,10) not null default 0,
FUNITID int not null default 0,
FMOTYPE varchar(36) null,
FMOID int null,
FMOBILLNO nvarchar(30) null,
FMOENTRYID int null,
FMOENTRYSEQ int null,
FPARENTOWNERTYPEID varchar(36) null,
FPARENTOWNERID int null,
FAUXPROPID int null,
FDOCUMENTSTATUS char(1) null,
FCREATORID int null,
FCREATEDATE datetime null,
FMODIFIERID int null,
FMODIFYDATE datetime null,
FAPPROVERID int null,
FAPPROVEDATE datetime null,
FCHANGEREASON varchar(36) null,
FBILLTYPE varchar(36) null,
FDATE datetime null,
constraint PK_PRD_PPBOMCH primary key (FID)
)
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'辅助资料',
'user', @CurrentUser, 'table', 'T_PRD_PPBOMCHANGE', 'column', 'FCHANGEREASON'
go
/*==============================================================*/
/* Index: IDX_PRD_PPBOMCH_BILLNO */
/*==============================================================*/
create index IDX_PRD_PPBOMCH_BILLNO on T_PRD_PPBOMCHANGE (
FBILLNO ASC
)
go
/*==============================================================*/
/* Index: IDX_PRD_PPBOMCH_MOID */
/*==============================================================*/
create index IDX_PRD_PPBOMCH_MOID on T_PRD_PPBOMCHANGE (
FMOID ASC
)
go
/*==============================================================*/
/* Index: IDX_PRD_PPBOMCH_MOENTRYID */
/*==============================================================*/
create index IDX_PRD_PPBOMCH_MOENTRYID on T_PRD_PPBOMCHANGE (
FMOENTRYID ASC
)
go
/*==============================================================*/
/* Index: IDX_PRD_PPBOMCH_MATERIALID */
/*==============================================================*/
create index IDX_PRD_PPBOMCH_MATERIALID on T_PRD_PPBOMCHANGE (
FMATERIALID ASC
)
go
/*==============================================================*/
/* Index: IDX_PRD_PPBOMCH_PRDORGID */
/*==============================================================*/
create index IDX_PRD_PPBOMCH_PRDORGID on T_PRD_PPBOMCHANGE (
FPRDORGID ASC
)
go
/*==============================================================*/
/* Index: IDX_PRD_PPBOMCH_DATE */
/*==============================================================*/
create index IDX_PRD_PPBOMCH_DATE on T_PRD_PPBOMCHANGE (
FDATE ASC
)
go

### T_PRD_PPBOMCHANGE(生产用料清单变更单)：键值定义

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

### T_PRD_PPBOMCHANGE(生产用料清单变更单)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_PRD_PPBOMCH_BILLNO | IDX_PRD_PPBOMCH_BILLNO | FALSE | FALSE | FALSE | FALSE | FALSE | T_PRD_PPBOMCHANGE(生产用料清单变更单)
IDX_PRD_PPBOMCH_MOID | IDX_PRD_PPBOMCH_MOID | FALSE | FALSE | FALSE | FALSE | FALSE | T_PRD_PPBOMCHANGE(生产用料清单变更单)
IDX_PRD_PPBOMCH_MOENTRYID | IDX_PRD_PPBOMCH_MOENTRYID | FALSE | FALSE | FALSE | FALSE | FALSE | T_PRD_PPBOMCHANGE(生产用料清单变更单)
IDX_PRD_PPBOMCH_MATERIALID | IDX_PRD_PPBOMCH_MATERIALID | FALSE | FALSE | FALSE | FALSE | FALSE | T_PRD_PPBOMCHANGE(生产用料清单变更单)
IDX_PRD_PPBOMCH_PRDORGID | IDX_PRD_PPBOMCH_PRDORGID | FALSE | FALSE | FALSE | FALSE | FALSE | T_PRD_PPBOMCHANGE(生产用料清单变更单)
IDX_PRD_PPBOMCH_DATE | IDX_PRD_PPBOMCH_DATE | FALSE | FALSE | FALSE | FALSE | FALSE | T_PRD_PPBOMCHANGE(生产用料清单变更单)

上一页

主页

下一页