SCO供应链协同

## 数据表：T_RPM_ACCOUNTUPDATEDETAIL(返利账户流水账)

### T_RPM_ACCOUNTUPDATEDETAIL(返利账户流水账)：描述

名称 | T_RPM_ACCOUNTUPDATEDETAIL(返利账户流水账)
代码 | T_RPM_ACCOUNTUPDATEDETAIL
注释 |
模型 | SCO供应链协同
主键 | PK_RPM_ACCOUNTUPDATEDETAIL

### T_RPM_ACCOUNTUPDATEDETAIL(返利账户流水账)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
主键ID | FID | int |  | TRUE |
账户ID | FACCOUNTID | int |  | TRUE |
核算组织ID | FFINORGID | int |  | TRUE |
客户ID | FCUSTOMERID | int |  | TRUE |
账户余额ID | FACCOUNTBALANCEID | int |  | TRUE |
币别 | FCURRENCYID | int |  | TRUE |
更新来源类型 | FSRCTYPE | char(1) | 1 | TRUE |
单据标识 | FFORMID | varchar(30) | 30 | TRUE |
单据ID | FBILLID | int |  | TRUE |
分录ID | FBILLENTRYID | int |  | TRUE |
结余账户余额 | FBALANCEAMOUNT | decimal(23,10) | 23 | TRUE |
更新余额 | FAMOUNT | decimal(23,10) | 23 | TRUE |
更新时间 | FUPDATETIME | datetime |  | FALSE |
操作人 | FOPERATIONID | int |  | TRUE |
操作批次 | FOPERATIONLOT | int |  | TRUE |

### T_RPM_ACCOUNTUPDATEDETAIL(返利账户流水账)：脚本代码

if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('T_RPM_ACCOUNTUPDATEDETAIL') and o.name = 'FK_T_RPM_AC_REFERENCE_T_RPM_AC')
alter table T_RPM_ACCOUNTUPDATEDETAIL
drop constraint FK_T_RPM_AC_REFERENCE_T_RPM_AC
go
if exists (select 1
from sysindexes
where id = object_id('T_RPM_ACCOUNTUPDATEDETAIL')
and name = 'IDX_RPM_ACCOUNTUPDATE_LOT'
and indid > 0
and indid < 255)
drop index T_RPM_ACCOUNTUPDATEDETAIL.IDX_RPM_ACCOUNTUPDATE_LOT
go
if exists (select 1
from sysindexes
where id = object_id('T_RPM_ACCOUNTUPDATEDETAIL')
and name = 'IDX_RPM_ACCOUNTUPDATE_OCA'
and indid > 0
and indid < 255)
drop index T_RPM_ACCOUNTUPDATEDETAIL.IDX_RPM_ACCOUNTUPDATE_OCA
go
if exists (select 1
from sysindexes
where id = object_id('T_RPM_ACCOUNTUPDATEDETAIL')
and name = 'IDX_RPM_ACCOUNTUPDATE_BID'
and indid > 0
and indid < 255)
drop index T_RPM_ACCOUNTUPDATEDETAIL.IDX_RPM_ACCOUNTUPDATE_BID
go
if exists (select 1
from sysindexes
where id = object_id('T_RPM_ACCOUNTUPDATEDETAIL')
and name = 'IDX_RPM_ACCOUNTUPDATE_ID'
and indid > 0
and indid < 255)
drop index T_RPM_ACCOUNTUPDATEDETAIL.IDX_RPM_ACCOUNTUPDATE_ID
go
if exists (select 1
from sysobjects
where id = object_id('T_RPM_ACCOUNTUPDATEDETAIL')
and type = 'U')
drop table T_RPM_ACCOUNTUPDATEDETAIL
go
/*==============================================================*/
/* Table: T_RPM_ACCOUNTUPDATEDETAIL */
/*==============================================================*/
create table T_RPM_ACCOUNTUPDATEDETAIL (
FID int not null default 0,
FACCOUNTID int not null default 0,
FFINORGID int not null default 0,
FCUSTOMERID int not null default 0,
FACCOUNTBALANCEID int not null default 0,
FCURRENCYID int not null default 0,
FSRCTYPE char(1) not null default '',
FFORMID varchar(30) not null default '',
FBILLID int not null default 0,
FBILLENTRYID int not null default 0,
FBALANCEAMOUNT decimal(23,10) not null default 0.0,
FAMOUNT decimal(23,10) not null default 0.0,
FUPDATETIME datetime null,
FOPERATIONID int not null default 0,
FOPERATIONLOT int not null default 0,
constraint PK_RPM_ACCOUNTUPDATEDETAIL primary key (FID)
)
go
/*==============================================================*/
/* Index: IDX_RPM_ACCOUNTUPDATE_ID */
/*==============================================================*/
create index IDX_RPM_ACCOUNTUPDATE_ID on T_RPM_ACCOUNTUPDATEDETAIL (
FACCOUNTBALANCEID ASC
)
go
/*==============================================================*/
/* Index: IDX_RPM_ACCOUNTUPDATE_BID */
/*==============================================================*/
create index IDX_RPM_ACCOUNTUPDATE_BID on T_RPM_ACCOUNTUPDATEDETAIL (
FBILLID ASC,
FBILLENTRYID ASC,
FFORMID ASC,
FOPERATIONLOT ASC
)
go
/*==============================================================*/
/* Index: IDX_RPM_ACCOUNTUPDATE_OCA */
/*==============================================================*/
create index IDX_RPM_ACCOUNTUPDATE_OCA on T_RPM_ACCOUNTUPDATEDETAIL (
FCUSTOMERID ASC,
FFINORGID ASC,
FACCOUNTID ASC
)
go
/*==============================================================*/
/* Index: IDX_RPM_ACCOUNTUPDATE_LOT */
/*==============================================================*/
create index IDX_RPM_ACCOUNTUPDATE_LOT on T_RPM_ACCOUNTUPDATEDETAIL (
FOPERATIONLOT ASC
)
go
alter table T_RPM_ACCOUNTUPDATEDETAIL
add constraint FK_T_RPM_AC_REFERENCE_T_RPM_AC foreign key (FACCOUNTBALANCEID)
references T_RPM_ACCOUNTBALANCE (FID)
go

### T_RPM_ACCOUNTUPDATEDETAIL(返利账户流水账)：键值定义

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

### T_RPM_ACCOUNTUPDATEDETAIL(返利账户流水账)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_RPM_ACCOUNTUPDATE_ID | IDX_RPM_ACCOUNTUPDATE_ID | FALSE | FALSE | FALSE | FALSE | FALSE | T_RPM_ACCOUNTUPDATEDETAIL(返利账户流水账)
IDX_RPM_ACCOUNTUPDATE_BID | IDX_RPM_ACCOUNTUPDATE_BID | FALSE | FALSE | FALSE | FALSE | FALSE | T_RPM_ACCOUNTUPDATEDETAIL(返利账户流水账)
IDX_RPM_ACCOUNTUPDATE_OCA | IDX_RPM_ACCOUNTUPDATE_OCA | FALSE | FALSE | FALSE | FALSE | FALSE | T_RPM_ACCOUNTUPDATEDETAIL(返利账户流水账)
IDX_RPM_ACCOUNTUPDATE_LOT | IDX_RPM_ACCOUNTUPDATE_LOT | FALSE | FALSE | FALSE | FALSE | FALSE | T_RPM_ACCOUNTUPDATEDETAIL(返利账户流水账)

上一页

主页

下一页