SCO供应链协同

## 数据表：T_RPM_SUMBALANCEDETAIL(返利账户流水账明细--展示)

### T_RPM_SUMBALANCEDETAIL(返利账户流水账明细--展示)：描述

名称 | T_RPM_SUMBALANCEDETAIL(返利账户流水账明细--展示)
代码 | T_RPM_SUMBALANCEDETAIL
注释 |
模型 | SCO供应链协同
主键 | PK_RPM_SUMBALANCEDETAIL

### T_RPM_SUMBALANCEDETAIL(返利账户流水账明细--展示)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
主键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 |
单据标识 | FSRCFORMID | varchar(30) | 30 | TRUE |
单据ID | FBILLID | int |  | TRUE |
结余账户余额 | FBALANCEAMOUNT | decimal(23,10) | 23 | TRUE |
更新余额 | FAMOUNT | decimal(23,10) | 23 | TRUE |
更新时间 | FUPDATETIME | datetime |  | FALSE |
操作人 | FOPERATIONID | int |  | TRUE |
操作批次 | FOPERATIONLOT | int |  | TRUE |
单据编号 | FBILLNO | nvarchar(80) | 80 | TRUE |

### T_RPM_SUMBALANCEDETAIL(返利账户流水账明细--展示)：脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_RPM_SUMBALANCEDETAIL')
and name = 'IDX_RPM_SUMBALANCED_LOT'
and indid > 0
and indid < 255)
drop index T_RPM_SUMBALANCEDETAIL.IDX_RPM_SUMBALANCED_LOT
go
if exists (select 1
from sysindexes
where id = object_id('T_RPM_SUMBALANCEDETAIL')
and name = 'IDX_RPM_SUMBALANCED_OCA'
and indid > 0
and indid < 255)
drop index T_RPM_SUMBALANCEDETAIL.IDX_RPM_SUMBALANCED_OCA
go
if exists (select 1
from sysindexes
where id = object_id('T_RPM_SUMBALANCEDETAIL')
and name = 'IDX_RPM_SUMBALANCED_BID'
and indid > 0
and indid < 255)
drop index T_RPM_SUMBALANCEDETAIL.IDX_RPM_SUMBALANCED_BID
go
if exists (select 1
from sysindexes
where id = object_id('T_RPM_SUMBALANCEDETAIL')
and name = 'IDX_RPM_SUMBALANCED_ID'
and indid > 0
and indid < 255)
drop index T_RPM_SUMBALANCEDETAIL.IDX_RPM_SUMBALANCED_ID
go
if exists (select 1
from sysobjects
where id = object_id('T_RPM_SUMBALANCEDETAIL')
and type = 'U')
drop table T_RPM_SUMBALANCEDETAIL
go
/*==============================================================*/
/* Table: T_RPM_SUMBALANCEDETAIL */
/*==============================================================*/
create table T_RPM_SUMBALANCEDETAIL (
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 '',
FSRCFORMID varchar(30) not null default '',
FBILLID 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,
FBILLNO nvarchar(80) not null default '',
constraint PK_RPM_SUMBALANCEDETAIL primary key (FID)
)
go
/*==============================================================*/
/* Index: IDX_RPM_SUMBALANCED_ID */
/*==============================================================*/
create index IDX_RPM_SUMBALANCED_ID on T_RPM_SUMBALANCEDETAIL (
FACCOUNTBALANCEID ASC
)
go
/*==============================================================*/
/* Index: IDX_RPM_SUMBALANCED_BID */
/*==============================================================*/
create index IDX_RPM_SUMBALANCED_BID on T_RPM_SUMBALANCEDETAIL (
FBILLID ASC,
FSRCFORMID ASC,
FOPERATIONLOT ASC
)
go
/*==============================================================*/
/* Index: IDX_RPM_SUMBALANCED_OCA */
/*==============================================================*/
create index IDX_RPM_SUMBALANCED_OCA on T_RPM_SUMBALANCEDETAIL (
FCUSTOMERID ASC,
FFINORGID ASC,
FACCOUNTID ASC
)
go
/*==============================================================*/
/* Index: IDX_RPM_SUMBALANCED_LOT */
/*==============================================================*/
create index IDX_RPM_SUMBALANCED_LOT on T_RPM_SUMBALANCEDETAIL (
FOPERATIONLOT ASC
)
go

### T_RPM_SUMBALANCEDETAIL(返利账户流水账明细--展示)：键值定义

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

### T_RPM_SUMBALANCEDETAIL(返利账户流水账明细--展示)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_RPM_SUMBALANCED_ID | IDX_RPM_SUMBALANCED_ID | FALSE | FALSE | FALSE | FALSE | FALSE | T_RPM_SUMBALANCEDETAIL(返利账户流水账明细--展示)
IDX_RPM_SUMBALANCED_BID | IDX_RPM_SUMBALANCED_BID | FALSE | FALSE | FALSE | FALSE | FALSE | T_RPM_SUMBALANCEDETAIL(返利账户流水账明细--展示)
IDX_RPM_SUMBALANCED_OCA | IDX_RPM_SUMBALANCED_OCA | FALSE | FALSE | FALSE | FALSE | FALSE | T_RPM_SUMBALANCEDETAIL(返利账户流水账明细--展示)
IDX_RPM_SUMBALANCED_LOT | IDX_RPM_SUMBALANCED_LOT | FALSE | FALSE | FALSE | FALSE | FALSE | T_RPM_SUMBALANCEDETAIL(返利账户流水账明细--展示)

上一页

主页

下一页