MFG制造

### T_PRD_PICKMTRLDATA(生产领料单物料明细)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_PRD_PICKMTRLDATA')
and name = 'IDX_PRD_PMD_FPPBOMENTRYID'
and indid > 0
and indid < 255)
drop index T_PRD_PICKMTRLDATA.IDX_PRD_PMD_FPPBOMENTRYID
go
if exists (select 1
from sysindexes
where id = object_id('T_PRD_PICKMTRLDATA')
and name = 'IDX_PRD_PMD_FMOENTRYID'
and indid > 0
and indid < 255)
drop index T_PRD_PICKMTRLDATA.IDX_PRD_PMD_FMOENTRYID
go
if exists (select 1
from sysindexes
where id = object_id('T_PRD_PICKMTRLDATA')
and name = 'IDX_PRD_PMD_FMOID'
and indid > 0
and indid < 255)
drop index T_PRD_PICKMTRLDATA.IDX_PRD_PMD_FMOID
go
if exists (select 1
from sysindexes
where id = object_id('T_PRD_PICKMTRLDATA')
and name = 'IDX_PRD_PMD_ENTRYID'
and indid > 0
and indid < 255)
drop index T_PRD_PICKMTRLDATA.IDX_PRD_PMD_ENTRYID
go
if exists (select 1
from sysobjects
where id = object_id('T_PRD_PICKMTRLDATA')
and type = 'U')
drop table T_PRD_PICKMTRLDATA
go
/*==============================================================*/
/* Table: T_PRD_PICKMTRLDATA */
/*==============================================================*/
create table T_PRD_PICKMTRLDATA (
FID int null,
FENTRYID int not null default 0,
FSEQ int null,
FSRCBILLTYPE varchar(36) null,
FSRCBILLNO nvarchar(80) null,
FPPBOMENTRYID int null,
FMATERIALID int null,
FUNITID int null,
FMOID int null,
FMOBILLNO nvarchar(80) null,
FMOENTRYID int null,
FMOENTRYSEQ int null,
FPPBOMBILLNO nvarchar(80) null,
FSELPRCDRETURNQTY decimal(23,10) not null default 0,
FAPPQTY decimal(23,10) not null default 0,
FACTUALQTY decimal(23,10) not null default 0,
FALLOWOVERQTY decimal(23,10) not null default 0,
FBASEUNITID int null,
FBASESELPRCDRETURNQTY decimal(23,10) not null default 0,
FBASEAPPQTY decimal(23,10) not null default 0,
FBASEACTUALQTY decimal(23,10) not null default 0,
FBASEALLOWOVERQTY decimal(23,10) not null default 0,
FSTOCKUNITID int null,
FSTOCKSELPRCDRETURNQTY decimal(23,10) not null default 0,
FSTOCKAPPQTY decimal(23,10) not null default 0,
FSTOCKACTUALQTY decimal(23,10) not null default 0,
FSTOCKALLOWOVERQTY decimal(23,10) not null default 0,
FSECUNITID int null,
FSECSELPRCDRETURNQTY decimal(23,10) not null default 0,
FSECACTUALQTY decimal(23,10) not null default 0,
FSECALLOWOVERQTY decimal(23,10) not null default 0,
FSTOCKID int null,
FWORKSHOPID int null,
FSTOCKLOCID int null,
FSTOCKSTATUSID int null,
FSTOCKFLAG char(1) null,
FPRODUCEDATE datetime null,
FEXPIRYDATE datetime null,
FBOMID int null,
FMTONO nvarchar(255) null,
FPROJECTNO nvarchar(80) null,
FLOT int null,
FLOT_TEXT nvarchar(255) null,
FOPERID int null,
FPROCESSID int null,
FAUXPROPID int null,
FPRICE decimal(19,6) not null default 0,
FAMOUNT decimal(19,6) not null default 0,
FSRCINTERID int null,
FSRCENTRYID int null,
FSRCENTRYSEQ int null,
FBFLOWID varchar(36) not null default '',
constraint PK_PRD_PICKMTRLDATA primary key (FENTRYID)
)
go
/*==============================================================*/
/* Index: IDX_PRD_PMD_ENTRYID */
/*==============================================================*/
create index IDX_PRD_PMD_ENTRYID on T_PRD_PICKMTRLDATA (
FID ASC,
FENTRYID ASC
)
go
/*==============================================================*/
/* Index: IDX_PRD_PMD_FMOID */
/*==============================================================*/
create index IDX_PRD_PMD_FMOID on T_PRD_PICKMTRLDATA (
FMOID ASC
)
go
/*==============================================================*/
/* Index: IDX_PRD_PMD_FMOENTRYID */
/*==============================================================*/
create index IDX_PRD_PMD_FMOENTRYID on T_PRD_PICKMTRLDATA (
FMOENTRYID ASC
)
go
/*==============================================================*/
/* Index: IDX_PRD_PMD_FPPBOMENTRYID */
/*==============================================================*/
create index IDX_PRD_PMD_FPPBOMENTRYID on T_PRD_PICKMTRLDATA (
FPPBOMENTRYID ASC
)
go

### T_PRD_PICKMTRLDATA(生产领料单物料明细)：键值定义

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

### T_PRD_PICKMTRLDATA(生产领料单物料明细)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_PRD_PMD_ENTRYID | IDX_PRD_PMD_ENTRYID | FALSE | FALSE | FALSE | FALSE | FALSE | T_PRD_PICKMTRLDATA(生产领料单物料明细)
IDX_PRD_PMD_FMOID | IDX_PRD_PMD_FMOID | FALSE | FALSE | FALSE | FALSE | FALSE | T_PRD_PICKMTRLDATA(生产领料单物料明细)
IDX_PRD_PMD_FMOENTRYID | IDX_PRD_PMD_FMOENTRYID | FALSE | FALSE | FALSE | FALSE | FALSE | T_PRD_PICKMTRLDATA(生产领料单物料明细)
IDX_PRD_PMD_FPPBOMENTRYID | IDX_PRD_PMD_FPPBOMENTRYID | FALSE | FALSE | FALSE | FALSE | FALSE | T_PRD_PICKMTRLDATA(生产领料单物料明细)

上一页

主页

下一页