集团财务

## 数据表：T_WB_BankPayMent(银行付款单)

### T_WB_BankPayMent(银行付款单)：描述

名称 | T_WB_BankPayMent(银行付款单)
代码 | T_WB_BankPayMent
注释 | 银行付款单)
模型 | 集团财务
主键 | PK_WB_BankPayMent

### T_WB_BankPayMent(银行付款单)：列规格定义

名称 | 代码 | 数据类型 | 长度 | 强制 | 注释
本表主键 | FID | int |  | TRUE |
付款账号 | FPAYBANKNO | varchar(50) | 50 | TRUE | 付款账号
付款账户名称 | FPAYNONAME | nvarchar(50) | 50 | TRUE | 付款账户名称
付款账号开户行 | FPAYOPENBANK | nvarchar(50) | 50 | TRUE | 付款账号开户行
来源单据编号 | FFROMNO | nvarchar(50) | 50 | TRUE |
单据编号 | FBILLNO | nvarchar(50) | 50 | TRUE |
总笔数 | FCOUNT | int |  | TRUE |
付款方开户银行 | FPAYBANKID | int |  | TRUE |
币别 | FCURRENCYID | int |  | TRUE |
结算组织 | FSETTLEORGID | int |  | TRUE |
总金额 | FTOTALAMOUNT | decimal(23,10) | 23 | TRUE |
来源单据 | FFROMBILLID | varchar(36) | 36 | TRUE |
数据状态 | FDocumentStatus | char(1) | 1 | TRUE | A：创建 B：审核中 C：已审核 D：重新审核 Z：暂存

### T_WB_BankPayMent(银行付款单)：脚本代码

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_WB_BankPayMentENTRY_S') and o.name = '主从表')
alter table T_WB_BankPayMentENTRY_S
drop constraint 主从表
go
if exists (select 1
from sysindexes
where id = object_id('T_WB_BankPayMent')
and name = 'IDX_WB_BankPayMent_BANKNO'
and indid > 0
and indid < 255)
drop index T_WB_BankPayMent.IDX_WB_BankPayMent_BANKNO
go
if exists (select 1
from sysindexes
where id = object_id('T_WB_BankPayMent')
and name = 'IDX_WB_BankPayMent_BillNo'
and indid > 0
and indid < 255)
drop index T_WB_BankPayMent.IDX_WB_BankPayMent_BillNo
go
if exists (select 1
from sysobjects
where id = object_id('T_WB_BankPayMent')
and type = 'U')
drop table T_WB_BankPayMent
go
/*==============================================================*/
/* Table: T_WB_BankPayMent */
/*==============================================================*/
create table T_WB_BankPayMent (
FID int not null default 0,
FPAYBANKNO varchar(50) not null default ' ',
FPAYNONAME nvarchar(50) not null default ' ',
FPAYOPENBANK nvarchar(50) not null default ' ',
FFROMNO nvarchar(50) not null default ' ',
FBILLNO nvarchar(50) not null default ' ',
FCOUNT int not null default 0,
FPAYBANKID int not null default 0,
FCURRENCYID int not null default 0,
FSETTLEORGID int not null default 0,
FTOTALAMOUNT decimal(23,10) not null default 0,
FFROMBILLID varchar(36) not null default ' ',
FDocumentStatus char(1) not null default '',
constraint PK_WB_BankPayMent primary key (FID)
)
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'银行付款单)',
'user', @CurrentUser, 'table', 'T_WB_BankPayMent'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'付款账号',
'user', @CurrentUser, 'table', 'T_WB_BankPayMent', 'column', 'FPAYBANKNO'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'付款账户名称',
'user', @CurrentUser, 'table', 'T_WB_BankPayMent', 'column', 'FPAYNONAME'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'付款账号开户行',
'user', @CurrentUser, 'table', 'T_WB_BankPayMent', 'column', 'FPAYOPENBANK'
go
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'A：创建
B：审核中
C：已审核
D：重新审核
Z：暂存',
'user', @CurrentUser, 'table', 'T_WB_BankPayMent', 'column', 'FDocumentStatus'
go
/*==============================================================*/
/* Index: IDX_WB_BankPayMent_BillNo */
/*==============================================================*/
create index IDX_WB_BankPayMent_BillNo on T_WB_BankPayMent (
FBILLNO ASC
)
go
/*==============================================================*/
/* Index: IDX_WB_BankPayMent_BANKNO */
/*==============================================================*/
create index IDX_WB_BankPayMent_BANKNO on T_WB_BankPayMent (
FPAYBANKNO ASC
)
go

### T_WB_BankPayMent(银行付款单)：键值定义

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

### T_WB_BankPayMent(银行付款单)：索引定义

名称 | 代码 | 唯一的 | 群集器 | 主要的 | 外键 | 候选键 | 表格
IDX_WB_BankPayMent_BillNo | IDX_WB_BankPayMent_BillNo | FALSE | FALSE | FALSE | FALSE | FALSE | T_WB_BankPayMent(银行付款单)
IDX_WB_BankPayMent_BANKNO | IDX_WB_BankPayMent_BANKNO | FALSE | FALSE | FALSE | FALSE | FALSE | T_WB_BankPayMent(银行付款单)

上一页

主页

下一页