MFG制造

## 数据表：T_REM_PICKMTRL(生产线领料单)

### T_REM_PICKMTRL(生产线领料单)：描述

名称 | T_REM_PICKMTRL(生产线领料单)
代码 | T_REM_PICKMTRL
注释 | 生产线领料单
模型 | MFG制造
主键 | PK_REM_PICKMTRL

### T_REM_PICKMTRL(生产线领料单)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
主键 | FID | int |  | TRUE |
交易类型码 | FFORMID | varchar(36) | 36 | FALSE |
单据编号 | FBILLNO | nvarchar(80) | 80 | FALSE |
单据状态 | FDOCUMENTSTATUS | char(1) | 1 | FALSE |
审核人 | FAPPROVERID | int |  | FALSE |
审核日期 | FAPPROVEDATE | datetime |  | FALSE |
修改人 | FMODIFIERID | int |  | FALSE |
创建日期 | FCREATEDATE | datetime |  | FALSE |
创建人 | FCREATORID | int |  | FALSE |
修改日期 | FMODIFYDATE | datetime |  | FALSE |
作废日期 | FCANCELDATE | datetime |  | FALSE |
作废人 | FCANCELER | int |  | FALSE |
作废状态 | FCANCELSTATUS | char(1) | 1 | FALSE |
单据日期 | FDATE | datetime |  | FALSE |
生产组织 | FPRDORGID | int |  | FALSE |
发料组织 | FSTOCKORGID | int |  | FALSE |
单据类型 | FBILLTYPE | varchar(36) | 36 | FALSE |
货主类型 | FOWNERTYPEID | nvarchar(36) | 36 | FALSE |
货主 | FOWNERID | int |  | FALSE |
本位币 | FCURRID | int |  | FALSE |
跨组织业务类型 | FTRANSFERBIZTYPE | int |  | FALSE |
领料人 | FPICKERID | int |  | FALSE |
仓管员 | FSTOCKERID | int |  | FALSE |
跨法人交易 | FISCROSSTRADE | char(1) | 1 | FALSE |
VMI业务 | FVMIBUSINESS | char(1) | 1 | FALSE |
需求类型 | FREQTYPE | char(1) | 1 | FALSE |
运算标识 | FCOMPUTERID | nvarchar(50) | 50 | FALSE |

### T_REM_PICKMTRL(生产线领料单)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('dbo.T_REM_PICKMTRL')
and name = 'IDX_REM_PM_FBILLNO'
and indid > 0
and indid < 255)
drop index dbo.T_REM_PICKMTRL.IDX_REM_PM_FBILLNO
go
if exists (select 1
from sysindexes
where id = object_id('dbo.T_REM_PICKMTRL')
and name = 'IDX_REM_PM_FORGID'
and indid > 0
and indid < 255)
drop index dbo.T_REM_PICKMTRL.IDX_REM_PM_FORGID
go
if exists (select 1
from sysindexes
where id = object_id('dbo.T_REM_PICKMTRL')
and name = 'IDX_REM_PM_FCOMPUTERID'
and indid > 0
and indid < 255)
drop index dbo.T_REM_PICKMTRL.IDX_REM_PM_FCOMPUTERID
go
if exists (select 1
from sysobjects
where id = object_id('dbo.T_REM_PICKMTRL')
and type = 'U')
drop table dbo.T_REM_PICKMTRL
go
/*==============================================================*/
/* Table: T_REM_PICKMTRL */
/*==============================================================*/
create table dbo.T_REM_PICKMTRL (
FID int not null default 0,
FFORMID varchar(36) null,
FBILLNO nvarchar(80) null,
FDOCUMENTSTATUS char(1) null,
FAPPROVERID int null,
FAPPROVEDATE datetime null,
FMODIFIERID int null,
FCREATEDATE datetime null,
FCREATORID int null,
FMODIFYDATE datetime null,
FCANCELDATE datetime null,
FCANCELER int null,
FCANCELSTATUS char(1) null,
FDATE datetime null,
FPRDORGID int null,
FSTOCKORGID int null,
FBILLTYPE varchar(36) null,
FOWNERTYPEID nvarchar(36) null,
FOWNERID int null,
FCURRID int null,
FTRANSFERBIZTYPE int null,
FPICKERID int null,
FSTOCKERID int null,
FISCROSSTRADE char(1) null,
FVMIBUSINESS char(1) null,
FREQTYPE char(1) null,
FCOMPUTERID nvarchar(50) null,
constraint PK_REM_PICKMTRL primary key (FID)
on "PRIMARY"
)
on "PRIMARY"
go
/*==============================================================*/
/* Index: IDX_REM_PM_FCOMPUTERID */
/*==============================================================*/
create index IDX_REM_PM_FCOMPUTERID on dbo.T_REM_PICKMTRL (
FCOMPUTERID ASC
)
go
/*==============================================================*/
/* Index: IDX_REM_PM_FORGID */
/*==============================================================*/
create index IDX_REM_PM_FORGID on dbo.T_REM_PICKMTRL (
FSTOCKORGID ASC
)
go
/*==============================================================*/
/* Index: IDX_REM_PM_FBILLNO */
/*==============================================================*/
create index IDX_REM_PM_FBILLNO on dbo.T_REM_PICKMTRL (
FBILLNO ASC
)
go

### T_REM_PICKMTRL(生产线领料单)：键值定义

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

### T_REM_PICKMTRL(生产线领料单)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_REM_PM_FCOMPUTERID | IDX_REM_PM_FCOMPUTERID | FALSE | FALSE | FALSE | FALSE | FALSE | T_REM_PICKMTRL(生产线领料单)
IDX_REM_PM_FORGID | IDX_REM_PM_FORGID | FALSE | FALSE | FALSE | FALSE | FALSE | T_REM_PICKMTRL(生产线领料单)
IDX_REM_PM_FBILLNO | IDX_REM_PM_FBILLNO | FALSE | FALSE | FALSE | FALSE | FALSE | T_REM_PICKMTRL(生产线领料单)

上一页

主页

下一页