数据表:t_BF_InstanceAmount(业务流程数值携带表)

t_BF_InstanceAmount(业务流程数值携带表):描述

名称

t_BF_InstanceAmount(业务流程数值携带表)

代码

T_BF_INSTANCEAMOUNT

注释

存储单据流转时,携带的控制字段值

模型

BOS

主键

PK_BF_INSTANCEAMOUNT


t_BF_InstanceAmount(业务流程数值携带表):列规格定义

名称

代码

数据类型

长度

强制

注释

数据内码

FDetailId

varchar(36)

36

TRUE

 

路线内码

FRouteId

varchar(36)

36

TRUE

 

源单字段

FSourceField

varchar(30)

30

TRUE

 

目标单字段

FTargetField

varchar(30)

30

TRUE

 

携带数值

FAmount

decimal(23,10)

23

TRUE

 

创建时间

FCreateTime

datetime

 

FALSE

 


t_BF_InstanceAmount(业务流程数值携带表):脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_BF_INSTANCEAMOUNT')
and name = 'IDX_BF_INSTANCEAMOUNT_TIME'
and indid > 0
and indid < 255)
drop index T_BF_INSTANCEAMOUNT.IDX_BF_INSTANCEAMOUNT_TIME
go

if exists (select 1
from sysindexes
where id = object_id('T_BF_INSTANCEAMOUNT')
and name = 'IDX_BF_INSTANCEAMOUNT'
and indid > 0
and indid < 255)
drop index T_BF_INSTANCEAMOUNT.IDX_BF_INSTANCEAMOUNT
go

if exists (select 1
from sysobjects
where id = object_id('T_BF_INSTANCEAMOUNT')
and type = 'U')
drop table T_BF_INSTANCEAMOUNT
go

/*==============================================================*/
/* Table: T_BF_INSTANCEAMOUNT */
/*==============================================================*/
create table T_BF_INSTANCEAMOUNT (
FDetailId varchar(36) not null default NEWID(),
FRouteId varchar(36) not null default '',
FSourceField varchar(30) not null default '',
FTargetField varchar(30) not null default '',
FAmount decimal(23,10) not null default 0,
FCreateTime datetime null,
constraint PK_BF_INSTANCEAMOUNT primary key (FDetailId)
)
go

/*==============================================================*/
/* Index: IDX_BF_INSTANCEAMOUNT */
/*==============================================================*/
create index IDX_BF_INSTANCEAMOUNT on T_BF_INSTANCEAMOUNT (
FRouteId ASC
)
go

/*==============================================================*/
/* Index: IDX_BF_INSTANCEAMOUNT_TIME */
/*==============================================================*/
create index IDX_BF_INSTANCEAMOUNT_TIME on T_BF_INSTANCEAMOUNT (
FCreateTime ASC
)
go


t_BF_InstanceAmount(业务流程数值携带表):键值定义

名称

代码

主要的

PK_BF_INSTANCEAMOUNT

PK_BF_INSTANCEAMOUNT

TRUE


t_BF_InstanceAmount(业务流程数值携带表):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_BF_INSTANCEAMOUNT

IDX_BF_INSTANCEAMOUNT

FALSE

FALSE

FALSE

FALSE

FALSE

t_BF_InstanceAmount(业务流程数值携带表)

IDX_BF_INSTANCEAMOUNT_TIME

IDX_BF_INSTANCEAMOUNT_TIME

FALSE

FALSE

FALSE

FALSE

FALSE

t_BF_InstanceAmount(业务流程数值携带表)