成本管理

## 数据表：T_CB_EQUCOEFCENTRY(约当系数维护明细表)

### T_CB_EQUCOEFCENTRY(约当系数维护明细表)：描述

名称 | T_CB_EQUCOEFCENTRY(约当系数维护明细表)
代码 | T_CB_EQUCOEFCENTRY
注释 |
模型 | 成本管理
主键 | PK_CB_EQUCOEFCENTRY

### T_CB_EQUCOEFCENTRY(约当系数维护明细表)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
单据内码 | FID | int |  | FALSE |
分录ID | FENTRYID | int |  | TRUE |
成本中心内码 | FCOSTCENTERID | int |  | TRUE |
产品内码 | FPRODUCTID | int |  | TRUE |
综合系数 | FALLCOEFC | decimal(23,10) | 23 | TRUE |
工单类型 | FPROORDERTYPE | varchar(20) | 20 | TRUE |
工单基础资料内码 | FPROORDERID | varchar(36) | 36 | TRUE |
工单行号 | FPROORDERSEQ | int |  | TRUE |
工单分录内码 | FPROORDERENTRYID | int |  | TRUE |
工单编号-编号 | FPROORDERNO | varchar(510) | 510 | TRUE |
生产车间 | FWORKSHOPID | int |  | TRUE |

### T_CB_EQUCOEFCENTRY(约当系数维护明细表)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_CB_EQUCOEFCENTRY')
and name = 'IDX_EQUCOEFCENTRY_ID'
and indid > 0
and indid < 255)
drop index T_CB_EQUCOEFCENTRY.IDX_EQUCOEFCENTRY_ID
go
if exists (select 1
from sysindexes
where id = object_id('T_CB_EQUCOEFCENTRY')
and name = 'IDX_EQUCOEFCENTRY'
and indid > 0
and indid < 255)
drop index T_CB_EQUCOEFCENTRY.IDX_EQUCOEFCENTRY
go
if exists (select 1
from sysobjects
where id = object_id('T_CB_EQUCOEFCENTRY')
and type = 'U')
drop table T_CB_EQUCOEFCENTRY
go
/*==============================================================*/
/* Table: T_CB_EQUCOEFCENTRY */
/*==============================================================*/
create table T_CB_EQUCOEFCENTRY (
FID int null default 0,
FENTRYID int not null default 0,
FCOSTCENTERID int not null default 0,
FPRODUCTID int not null default 0,
FALLCOEFC decimal(23,10) not null default 0,
FPROORDERTYPE varchar(20) not null default '',
FPROORDERID varchar(36) not null default '',
FPROORDERSEQ int not null default 0,
FPROORDERENTRYID int not null default 0,
FPROORDERNO varchar(510) not null default '',
FWORKSHOPID int not null default 0,
constraint PK_CB_EQUCOEFCENTRY primary key (FENTRYID)
)
go
/*==============================================================*/
/* Index: IDX_EQUCOEFCENTRY */
/*==============================================================*/
create index IDX_EQUCOEFCENTRY on T_CB_EQUCOEFCENTRY (
FCOSTCENTERID ASC
)
go
/*==============================================================*/
/* Index: IDX_EQUCOEFCENTRY_ID */
/*==============================================================*/
create index IDX_EQUCOEFCENTRY_ID on T_CB_EQUCOEFCENTRY (
FID ASC
)
go

### T_CB_EQUCOEFCENTRY(约当系数维护明细表)：键值定义

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

### T_CB_EQUCOEFCENTRY(约当系数维护明细表)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_EQUCOEFCENTRY | IDX_EQUCOEFCENTRY | FALSE | FALSE | FALSE | FALSE | FALSE | T_CB_EQUCOEFCENTRY(约当系数维护明细表)
IDX_EQUCOEFCENTRY_ID | IDX_EQUCOEFCENTRY_ID | FALSE | FALSE | FALSE | FALSE | FALSE | T_CB_EQUCOEFCENTRY(约当系数维护明细表)

上一页

主页

下一页