MFG制造

## 数据表：T_QT_LOTSNRELATIONDETAIL(批号序列号关系维护子单据体)

### T_QT_LOTSNRELATIONDETAIL(批号序列号关系维护子单据体)：描述

名称 | T_QT_LOTSNRELATIONDETAIL(批号序列号关系维护子单据体)
代码 | T_QT_LOTSNRELATIONDETAIL
注释 |
模型 | MFG制造
主键 | Key_1

### T_QT_LOTSNRELATIONDETAIL(批号序列号关系维护子单据体)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
分录内码 | FEntryID | int |  | TRUE |
主键 | FDetailID | int |  | TRUE |
序号 | FSeq | int |  | TRUE |
物料编码 | FDMATERIALID | int |  | TRUE |
单位 | FDUNITID | int |  | FALSE |
序列号 | FDSN | int |  | FALSE |
序列号单位 | FDSNUNITID | int |  | FALSE |
批号 | FDLOT | int |  | FALSE |
批号文本 | FDLOT_Text | nvarchar(255) | 255 | FALSE |
批号数量 | FDLOTQTY | decimal(23,10) | 23 | TRUE |
基本单位 | FDBASEUNITID | int |  | FALSE |
基本单位批号数量 | FDBASELOTQTY | decimal(23,10) | 23 | TRUE |

### T_QT_LOTSNRELATIONDETAIL(批号序列号关系维护子单据体)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_QT_LOTSNRELATIONDETAIL')
and name = 'IDX_QT_LSNR_D_LOT'
and indid > 0
and indid < 255)
drop index T_QT_LOTSNRELATIONDETAIL.IDX_QT_LSNR_D_LOT
go
if exists (select 1
from sysindexes
where id = object_id('T_QT_LOTSNRELATIONDETAIL')
and name = 'IDX_QT_LSNR_D_SN'
and indid > 0
and indid < 255)
drop index T_QT_LOTSNRELATIONDETAIL.IDX_QT_LSNR_D_SN
go
if exists (select 1
from sysindexes
where id = object_id('T_QT_LOTSNRELATIONDETAIL')
and name = 'IDX_QT_LSNR_D_M'
and indid > 0
and indid < 255)
drop index T_QT_LOTSNRELATIONDETAIL.IDX_QT_LSNR_D_M
go
if exists (select 1
from sysindexes
where id = object_id('T_QT_LOTSNRELATIONDETAIL')
and name = 'IDX_QT_LSNR_DETAIL'
and indid > 0
and indid < 255)
drop index T_QT_LOTSNRELATIONDETAIL.IDX_QT_LSNR_DETAIL
go
if exists (select 1
from sysobjects
where id = object_id('T_QT_LOTSNRELATIONDETAIL')
and type = 'U')
drop table T_QT_LOTSNRELATIONDETAIL
go
/*==============================================================*/
/* Table: T_QT_LOTSNRELATIONDETAIL */
/*==============================================================*/
create table T_QT_LOTSNRELATIONDETAIL (
FEntryID int not null default 0,
FDetailID int not null default 0,
FSeq int not null default 0,
FDMATERIALID int not null default 0,
FDUNITID int null,
FDSN int null,
FDSNUNITID int null,
FDLOT int null,
FDLOT_Text nvarchar(255) null,
FDLOTQTY decimal(23,10) not null default 0,
FDBASEUNITID int null,
FDBASELOTQTY decimal(23,10) not null default 0,
constraint PK_T_QT_LOTSNRELATIONDETAIL primary key (FDetailID)
)
go
/*==============================================================*/
/* Index: IDX_QT_LSNR_DETAIL */
/*==============================================================*/
create index IDX_QT_LSNR_DETAIL on T_QT_LOTSNRELATIONDETAIL (
FEntryID ASC
)
go
/*==============================================================*/
/* Index: IDX_QT_LSNR_D_M */
/*==============================================================*/
create index IDX_QT_LSNR_D_M on T_QT_LOTSNRELATIONDETAIL (
FDMATERIALID ASC
)
go
/*==============================================================*/
/* Index: IDX_QT_LSNR_D_SN */
/*==============================================================*/
create index IDX_QT_LSNR_D_SN on T_QT_LOTSNRELATIONDETAIL (
FDSN ASC
)
go
/*==============================================================*/
/* Index: IDX_QT_LSNR_D_LOT */
/*==============================================================*/
create index IDX_QT_LSNR_D_LOT on T_QT_LOTSNRELATIONDETAIL (
FDLOT ASC
)
go

### T_QT_LOTSNRELATIONDETAIL(批号序列号关系维护子单据体)：键值定义

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

### T_QT_LOTSNRELATIONDETAIL(批号序列号关系维护子单据体)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_QT_LSNR_DETAIL | IDX_QT_LSNR_DETAIL | FALSE | FALSE | FALSE | FALSE | FALSE | T_QT_LOTSNRELATIONDETAIL(批号序列号关系维护子单据体)
IDX_QT_LSNR_D_M | IDX_QT_LSNR_D_M | FALSE | FALSE | FALSE | FALSE | FALSE | T_QT_LOTSNRELATIONDETAIL(批号序列号关系维护子单据体)
IDX_QT_LSNR_D_SN | IDX_QT_LSNR_D_SN | FALSE | FALSE | FALSE | FALSE | FALSE | T_QT_LOTSNRELATIONDETAIL(批号序列号关系维护子单据体)
IDX_QT_LSNR_D_LOT | IDX_QT_LSNR_D_LOT | FALSE | FALSE | FALSE | FALSE | FALSE | T_QT_LOTSNRELATIONDETAIL(批号序列号关系维护子单据体)

上一页

主页

下一页