MFG制造

## 数据表：T_SFC_OPERATIONTRANSFER_C(工序转移单-委外信息拆分表)

### T_SFC_OPERATIONTRANSFER_C(工序转移单-委外信息拆分表)：描述

名称 | T_SFC_OPERATIONTRANSFER_C(工序转移单-委外信息拆分表)
代码 | T_SFC_OPERATIONTRANSFER_C
注释 |
模型 | MFG制造
主键 | PK_SFC_OPERATIONTRANSFER_C

### T_SFC_OPERATIONTRANSFER_C(工序转移单-委外信息拆分表)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
主键 | FID | int |  | TRUE |
转出采购组织 | FOUTPURORGID | int |  | TRUE |
转入采购组织 | FINPURORGID | int |  | TRUE |
转出供应商 | FOUTSUPPLIER | int |  | TRUE |
转入供应商 | FINSUPPLIER | int |  | TRUE |
转出作业 | FOUTPROCESSID | int |  | TRUE |
转入作业 | FINPROCESSID | int |  | TRUE |
委外发出合格单价 | FSENDQUALIFIEDPRICE | decimal(23,10) | 23 | TRUE |
委外接收合格单价 | FRECEIVEQUALIFIEDPRICE | decimal(23,10) | 23 | TRUE |
委外发出工废单价 | FSENDPROFAILPRICE | decimal(23,10) | 23 | TRUE |
委外接收工废单价 | FRECEIVEPROFAILPRICE | decimal(23,10) | 23 | TRUE |
委外发出料废单价 | FSENDMATFAILPRICE | decimal(23,10) | 23 | TRUE |
委外接收料废单价 | FRECEIVEMATFAILPRICE | decimal(23,10) | 23 | TRUE |
委外发出币别 | FSENDCURRENCY | int |  | TRUE |
委外接收币别 | FRECEIVECURRENCY | int |  | TRUE |
委外发出计价单位 | FSENDVALUATIONUNITID | int |  | TRUE |
委外接收计价单位 | FRECEIVEVALUATIONUNITID | int |  | TRUE |
委外发出税率 | FSENDTAXRATE | decimal(23,10) | 23 | TRUE |
委外接收税率 | FRECEIVETAXRATE | decimal(23,10) | 23 | TRUE |
换算类型 | FCONVERTTYPE | char(1) | 1 | FALSE |
计价合格数量 | FVALQUALIFIEDQTY | decimal(23,10) | 23 | TRUE |
计价工废数量 | FVALPROFAILQTY | decimal(23,10) | 23 | TRUE |
计价料废数量 | FVALMATFAILQTY | decimal(23,10) | 23 | TRUE |
计价合格结算选单数量 | FVALQUASETTLESELQTY | decimal(23,10) | 23 | TRUE |
计价合格结算数量 | FVALQUASETTLEQTY | decimal(23,10) | 23 | TRUE |
计价工废结算选单数量 | FVALPROFAILSETTLESELQTY | decimal(23,10) | 23 | TRUE |
计价工废结算数量 | FVALPROFAILSETTLEQTY | decimal(23,10) | 23 | TRUE |
计价料废结算选单数量 | FVALMATFAILSETTLESELQTY | decimal(23,10) | 23 | TRUE |
计价料废结算数量 | FVALMATFAILSETTLEQTY | decimal(23,10) | 23 | TRUE |
委外发出合格含税单价 | FSENDQUALIFIEDTAXPRICE | decimal(23,10) | 23 | TRUE |
委外接收合格含税单价 | FRECEIVEQUALIFIEDTAXPRICE | decimal(23,10) | 23 | TRUE |
委外发出工废含税单价 | FSENDPROFAILTAXPRICE | decimal(23,10) | 23 | TRUE |
委外接收工废含税单价 | FRECEIVEPROFAILTAXPRICE | decimal(23,10) | 23 | TRUE |
委外发出料废含税单价 | FSENDMATFAILTAXPRICE | decimal(23,10) | 23 | TRUE |
委外接收料废含税单价 | FRECEIVEMATFAILTAXPRICE | decimal(23,10) | 23 | TRUE |

### T_SFC_OPERATIONTRANSFER_C(工序转移单-委外信息拆分表)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_SFC_OPERATIONTRANSFER_C')
and name = 'IDX_SFC_OT_C_INSP'
and indid > 0
and indid < 255)
drop index T_SFC_OPERATIONTRANSFER_C.IDX_SFC_OT_C_INSP
go
if exists (select 1
from sysindexes
where id = object_id('T_SFC_OPERATIONTRANSFER_C')
and name = 'IDX_SFC_OT_C_OUTSP'
and indid > 0
and indid < 255)
drop index T_SFC_OPERATIONTRANSFER_C.IDX_SFC_OT_C_OUTSP
go
if exists (select 1
from sysobjects
where id = object_id('T_SFC_OPERATIONTRANSFER_C')
and type = 'U')
drop table T_SFC_OPERATIONTRANSFER_C
go
/*==============================================================*/
/* Table: T_SFC_OPERATIONTRANSFER_C */
/*==============================================================*/
create table T_SFC_OPERATIONTRANSFER_C (
FID int not null default 0,
FOUTPURORGID int not null default 0,
FINPURORGID int not null default 0,
FOUTSUPPLIER int not null default 0,
FINSUPPLIER int not null default 0,
FOUTPROCESSID int not null default 0,
FINPROCESSID int not null default 0,
FSENDQUALIFIEDPRICE decimal(23,10) not null default 0,
FRECEIVEQUALIFIEDPRICE decimal(23,10) not null default 0,
FSENDPROFAILPRICE decimal(23,10) not null default 0,
FRECEIVEPROFAILPRICE decimal(23,10) not null default 0,
FSENDMATFAILPRICE decimal(23,10) not null default 0,
FRECEIVEMATFAILPRICE decimal(23,10) not null default 0,
FSENDCURRENCY int not null default 0,
FRECEIVECURRENCY int not null default 0,
FSENDVALUATIONUNITID int not null default 0,
FRECEIVEVALUATIONUNITID int not null default 0,
FSENDTAXRATE decimal(23,10) not null default 0,
FRECEIVETAXRATE decimal(23,10) not null default 0,
FCONVERTTYPE char(1) null,
FVALQUALIFIEDQTY decimal(23,10) not null default 0,
FVALPROFAILQTY decimal(23,10) not null default 0,
FVALMATFAILQTY decimal(23,10) not null default 0,
FVALQUASETTLESELQTY decimal(23,10) not null default 0,
FVALQUASETTLEQTY decimal(23,10) not null default 0,
FVALPROFAILSETTLESELQTY decimal(23,10) not null default 0,
FVALPROFAILSETTLEQTY decimal(23,10) not null default 0,
FVALMATFAILSETTLESELQTY decimal(23,10) not null default 0,
FVALMATFAILSETTLEQTY decimal(23,10) not null default 0,
FSENDQUALIFIEDTAXPRICE decimal(23,10) not null default 0,
FRECEIVEQUALIFIEDTAXPRICE decimal(23,10) not null default 0,
FSENDPROFAILTAXPRICE decimal(23,10) not null default 0,
FRECEIVEPROFAILTAXPRICE decimal(23,10) not null default 0,
FSENDMATFAILTAXPRICE decimal(23,10) not null default 0,
FRECEIVEMATFAILTAXPRICE decimal(23,10) not null default 0,
constraint PK_SFC_OPERATIONTRANSFER_C primary key (FID)
on "PRIMARY"
)
on "PRIMARY"
go
/*==============================================================*/
/* Index: IDX_SFC_OT_C_OUTSP */
/*==============================================================*/
create index IDX_SFC_OT_C_OUTSP on T_SFC_OPERATIONTRANSFER_C (
FOUTSUPPLIER ASC,
FOUTPROCESSID ASC
)
go
/*==============================================================*/
/* Index: IDX_SFC_OT_C_INSP */
/*==============================================================*/
create index IDX_SFC_OT_C_INSP on T_SFC_OPERATIONTRANSFER_C (
FINSUPPLIER ASC,
FINPROCESSID ASC
)
go

### T_SFC_OPERATIONTRANSFER_C(工序转移单-委外信息拆分表)：键值定义

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

### T_SFC_OPERATIONTRANSFER_C(工序转移单-委外信息拆分表)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_SFC_OT_C_OUTSP | IDX_SFC_OT_C_OUTSP | FALSE | FALSE | FALSE | FALSE | FALSE | T_SFC_OPERATIONTRANSFER_C(工序转移单-委外信息拆分表)
IDX_SFC_OT_C_INSP | IDX_SFC_OT_C_INSP | FALSE | FALSE | FALSE | FALSE | FALSE | T_SFC_OPERATIONTRANSFER_C(工序转移单-委外信息拆分表)

上一页

主页

下一页