成本管理

## 数据表：T_CB_CostCalExpenseDetail_H(费用计算明细)

### T_CB_CostCalExpenseDetail_H(费用计算明细)：描述

名称 | T_CB_CostCalExpenseDetail_H(费用计算明细)
代码 | T_CB_CostCalExpenseDetail_H
注释 |
模型 | 成本管理
主键 | PK_CB_COSTCALEXPENSEDETAIL_H

### T_CB_CostCalExpenseDetail_H(费用计算明细)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
主键 | FDetailId | int |  | TRUE |
内码 | FEntryId | int |  | TRUE |
费用项目 | FExpensesItemId | int |  | TRUE |
成本项目 | FCostItemId | int |  | TRUE |
期初在产品-金额 | FBeginAmount | decimal(23,10) | 23 | TRUE |
本期投入-金额 | FCurrInputAmount | decimal(23,10) | 23 | TRUE |
本期调整金额 | FAdjCurrInputAmount | decimal(23,10) | 23 | TRUE |
本期总投入-金额 | FSumCurrInputAmount | decimal(23,10) | 23 | TRUE |
期末在产-金额 | FEndAmount | decimal(23,10) | 23 | TRUE |
本期合格入库-金额 | FQualifiedInAmount | decimal(23,10) | 23 | TRUE |
本期不良入库-金额 | FDysInAmount | decimal(23,10) | 23 | TRUE |
本期废品入库-金额 | FWasteInAmount | decimal(23,10) | 23 | TRUE |
累计合格入库-金额 | FSumQualifiedInAmount | decimal(23,10) | 23 | TRUE |
累计不良入库-金额 | FSumDysInAmount | decimal(23,10) | 23 | TRUE |
累计废品入库-金额 | FSumWasteInAmount | decimal(23,10) | 23 | TRUE |
核算内码 | FOUTACCTGID | int |  | TRUE |
核算维度 | FDIMENSIONID | int |  | TRUE |
期初期末标志 | FENDINITKEY | char(1) | 1 | TRUE |

### T_CB_CostCalExpenseDetail_H(费用计算明细)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_CB_CostCalExpenseDetail_H')
and name = 'IDX_CB_CostCalExpDT_H_AGID'
and indid > 0
and indid < 255)
drop index T_CB_CostCalExpenseDetail_H.IDX_CB_CostCalExpDT_H_AGID
go
if exists (select 1
from sysindexes
where id = object_id('T_CB_CostCalExpenseDetail_H')
and name = 'IDX_CB_COSTCALEXPENSEDETAIL_H'
and indid > 0
and indid < 255)
drop index T_CB_CostCalExpenseDetail_H.IDX_CB_COSTCALEXPENSEDETAIL_H
go
if exists (select 1
from sysobjects
where id = object_id('T_CB_CostCalExpenseDetail_H')
and type = 'U')
drop table T_CB_CostCalExpenseDetail_H
go
/*==============================================================*/
/* Table: T_CB_CostCalExpenseDetail_H */
/*==============================================================*/
create table T_CB_CostCalExpenseDetail_H (
FDetailId int not null default 0,
FEntryId int not null default 0,
FExpensesItemId int not null default 0,
FCostItemId int not null default 0,
FBeginAmount decimal(23,10) not null default 0,
FCurrInputAmount decimal(23,10) not null default 0,
FAdjCurrInputAmount decimal(23,10) not null default 0,
FSumCurrInputAmount decimal(23,10) not null default 0,
FEndAmount decimal(23,10) not null default 0,
FQualifiedInAmount decimal(23,10) not null default 0,
FDysInAmount decimal(23,10) not null default 0,
FWasteInAmount decimal(23,10) not null default 0,
FSumQualifiedInAmount decimal(23,10) not null default 0,
FSumDysInAmount decimal(23,10) not null default 0,
FSumWasteInAmount decimal(23,10) not null default 0,
FOUTACCTGID int not null default 0,
FDIMENSIONID int not null default 0,
FENDINITKEY char(1) not null default '0',
constraint PK_CB_COSTCALEXPENSEDETAIL_H primary key (FDetailId)
)
go
/*==============================================================*/
/* Index: IDX_CB_COSTCALEXPENSEDETAIL_H */
/*==============================================================*/
create index IDX_CB_COSTCALEXPENSEDETAIL_H on T_CB_CostCalExpenseDetail_H (
FEntryId ASC
)
go
/*==============================================================*/
/* Index: IDX_CB_CostCalExpDT_H_AGID */
/*==============================================================*/
create index IDX_CB_CostCalExpDT_H_AGID on T_CB_CostCalExpenseDetail_H (
FOUTACCTGID ASC
)
go

### T_CB_CostCalExpenseDetail_H(费用计算明细)：键值定义

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

### T_CB_CostCalExpenseDetail_H(费用计算明细)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_CB_COSTCALEXPENSEDETAIL_H | IDX_CB_COSTCALEXPENSEDETAIL_H | FALSE | FALSE | FALSE | FALSE | FALSE | T_CB_CostCalExpenseDetail_H(费用计算明细)
IDX_CB_CostCalExpDT_H_AGID | IDX_CB_CostCalExpDT_H_AGID | FALSE | FALSE | FALSE | FALSE | FALSE | T_CB_CostCalExpenseDetail_H(费用计算明细)

上一页

主页

下一页