SCO供应链协同

## 数据表：T_RPM_BALANCERULEAPTENTRY(返利余额使用规则指定商品表)

### T_RPM_BALANCERULEAPTENTRY(返利余额使用规则指定商品表)：描述

名称 | T_RPM_BALANCERULEAPTENTRY(返利余额使用规则指定商品表)
代码 | T_RPM_BALANCERULEAPTENTRY
注释 |
模型 | SCO供应链协同
主键 | Key_1

### T_RPM_BALANCERULEAPTENTRY(返利余额使用规则指定商品表)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
主键 | FAPPOINTEDENTRYID | int |  | TRUE |
主表ID | FID | int |  | TRUE |
物料ID | FMATERIALID | int |  | TRUE |
物料组 | FMATERIALGROUP | int |  | TRUE |
辅助属性 | FAUXPROPID | int |  | TRUE |
基本计量单位 | FBASEUNITID | int |  | TRUE |
计量单位 | FUNITID | int |  | TRUE |
序号 | FSEQ | int |  | TRUE |

### T_RPM_BALANCERULEAPTENTRY(返利余额使用规则指定商品表)：脚本代码

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_BALANCERULEAPTENTRY') and o.name = 'FK_T_RPM_BA_REFERENCE_T_RPM_AC')
alter table T_RPM_BALANCERULEAPTENTRY
drop constraint FK_T_RPM_BA_REFERENCE_T_RPM_AC
go
if exists (select 1
from sysindexes
where id = object_id('T_RPM_BALANCERULEAPTENTRY')
and name = 'IDX_RPM_APTENTRY_MGID'
and indid > 0
and indid < 255)
drop index T_RPM_BALANCERULEAPTENTRY.IDX_RPM_APTENTRY_MGID
go
if exists (select 1
from sysindexes
where id = object_id('T_RPM_BALANCERULEAPTENTRY')
and name = 'IDX_RPM_APTENTRY_MID'
and indid > 0
and indid < 255)
drop index T_RPM_BALANCERULEAPTENTRY.IDX_RPM_APTENTRY_MID
go
if exists (select 1
from sysindexes
where id = object_id('T_RPM_BALANCERULEAPTENTRY')
and name = 'IDX_RPM_APTENTRY_FID'
and indid > 0
and indid < 255)
drop index T_RPM_BALANCERULEAPTENTRY.IDX_RPM_APTENTRY_FID
go
if exists (select 1
from sysobjects
where id = object_id('T_RPM_BALANCERULEAPTENTRY')
and type = 'U')
drop table T_RPM_BALANCERULEAPTENTRY
go
/*==============================================================*/
/* Table: T_RPM_BALANCERULEAPTENTRY */
/*==============================================================*/
create table T_RPM_BALANCERULEAPTENTRY (
FAPPOINTEDENTRYID int not null default 0,
FID int not null default 0,
FMATERIALID int not null default 0,
FMATERIALGROUP int not null default 0,
FAUXPROPID int not null default 0,
FBASEUNITID int not null default 0,
FUNITID int not null default 0,
FSEQ int not null default 0,
constraint PK_T_RPM_BALANCERULEAPTENTRY primary key (FAPPOINTEDENTRYID)
)
go
/*==============================================================*/
/* Index: IDX_RPM_APTENTRY_FID */
/*==============================================================*/
create index IDX_RPM_APTENTRY_FID on T_RPM_BALANCERULEAPTENTRY (
FID ASC,
FAPPOINTEDENTRYID ASC
)
go
/*==============================================================*/
/* Index: IDX_RPM_APTENTRY_MID */
/*==============================================================*/
create index IDX_RPM_APTENTRY_MID on T_RPM_BALANCERULEAPTENTRY (
FMATERIALID ASC,
FAUXPROPID ASC,
FID ASC
)
go
/*==============================================================*/
/* Index: IDX_RPM_APTENTRY_MGID */
/*==============================================================*/
create index IDX_RPM_APTENTRY_MGID on T_RPM_BALANCERULEAPTENTRY (
FMATERIALGROUP ASC,
FID ASC
)
go
alter table T_RPM_BALANCERULEAPTENTRY
add constraint FK_T_RPM_BA_REFERENCE_T_RPM_AC foreign key (FID)
references T_RPM_ACCOUNTBALANCERULE (FID)
go

### T_RPM_BALANCERULEAPTENTRY(返利余额使用规则指定商品表)：键值定义

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

### T_RPM_BALANCERULEAPTENTRY(返利余额使用规则指定商品表)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_RPM_APTENTRY_FID | IDX_RPM_APTENTRY_FID | FALSE | FALSE | FALSE | FALSE | FALSE | T_RPM_BALANCERULEAPTENTRY(返利余额使用规则指定商品表)
IDX_RPM_APTENTRY_MID | IDX_RPM_APTENTRY_MID | FALSE | FALSE | FALSE | FALSE | FALSE | T_RPM_BALANCERULEAPTENTRY(返利余额使用规则指定商品表)
IDX_RPM_APTENTRY_MGID | IDX_RPM_APTENTRY_MGID | FALSE | FALSE | FALSE | FALSE | FALSE | T_RPM_BALANCERULEAPTENTRY(返利余额使用规则指定商品表)

上一页

主页

下一页