T_BD_OPERATORGROUP(业务组) | |||||||
是否主键 | 字段名 | 字段描述 | 数据类型 | 长度 | 可空 | 缺省值 | 备注 |
✓ | FOperatorGroupId | 业务组内码 | int | 0 | |||
FMasterId | 主数据内码 | int | 0 | ||||
FOperatorGroupType | 业务组类型 | nvarchar | 20 | 枚举: 销售组:XSZ 采购组:CGZ 库存组:KCZ 计划组:JHZ | |||
FCreatorId | 创建人 | int | 0 | ||||
FCreateDate | 创建日期 | datetime | ✓ | getdate() | |||
FModifierId | 修改人 | int | 0 | ||||
FModifyDate | 修改日期 | datetime | ✓ | ||||
FBILLNO | 单据编码 | nvarchar | 30 | ||||
备注:业务组表 |
--建表脚本--
create table T_BD_OPERATORGROUP(
FOperatorGroupId int not null comment '业务组内码'
,FMasterId int not null comment '主数据内码'
,FOperatorGroupType nvarchar(20) not null comment '业务组类型'
,FCreatorId int not null comment '创建人'
,FCreateDate datetime default getdate() comment '创建日期'
,FModifierId int not null comment '修改人'
,FModifyDate datetime default null comment '修改日期'
,FBILLNO nvarchar(30) not null comment '单据编码'
,primary key (FOperatorGroupId)
) comment = '业务组'
--查询--
select FOperatorGroupId as "foperatorgroupid",FMasterId as "fmasterid",FOperatorGroupType as "foperatorgrouptype",FCreatorId as "fcreatorid",FCreateDate as "fcreatedate",FModifierId as "fmodifierid",FModifyDate as "fmodifydate",FBILLNO as "fbillno" from T_BD_OPERATORGROUP
--查询(中文字段)--
select FOperatorGroupId as "业务组内码",FMasterId as "主数据内码",FOperatorGroupType as "业务组类型",FCreatorId as "创建人",FCreateDate as "创建日期",FModifierId as "修改人",FModifyDate as "修改日期",FBILLNO as "单据编码" from T_BD_OPERATORGROUP
--INSERT脚本--
insert into T_BD_OPERATORGROUP(FOperatorGroupId,FMasterId,FOperatorGroupType,FCreatorId,FCreateDate,FModifierId,FModifyDate,FBILLNO) values (?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_BD_OPERATORGROUP set FOperatorGroupId=?,FMasterId=?,FOperatorGroupType=?,FCreatorId=?,FCreateDate=?,FModifierId=?,FModifyDate=?,FBILLNO=? where FOperatorGroupId=?
--delete脚本--
delete from T_BD_OPERATORGROUP where FOperatorGroupId=?
--给字段加备注--
alter table T_BD_OPERATORGROUP comment '业务组';
alter table T_BD_OPERATORGROUP modify column FOperatorGroupId int not null comment '业务组内码';
alter table T_BD_OPERATORGROUP modify column FMasterId int not null comment '主数据内码';
alter table T_BD_OPERATORGROUP modify column FOperatorGroupType nvarchar(20) not null comment '业务组类型';
alter table T_BD_OPERATORGROUP modify column FCreatorId int not null comment '创建人';
alter table T_BD_OPERATORGROUP modify column FCreateDate datetime default getdate() comment '创建日期';
alter table T_BD_OPERATORGROUP modify column FModifierId int not null comment '修改人';
alter table T_BD_OPERATORGROUP modify column FModifyDate datetime default null comment '修改日期';
alter table T_BD_OPERATORGROUP modify column FBILLNO nvarchar(30) not null comment '单据编码';
T_BD_OPERATORGROUPENTRY(业务组分录) | |||||||
是否主键 | 字段名 | 字段描述 | 数据类型 | 长度 | 可空 | 缺省值 | 备注 |
✓ | FEntryId | 分录内码 | int | 0 | |||
FOperatorGroupId | 业务组内码 | int | 0 | ||||
FOperatorGroupType | 业务组类型 | nvarchar | 20 | 枚举: 销售组:XSZ 采购组:CGZ 库存组:KCZ 计划组:JHZ | |||
FBizOrgId | 业务组织 | int | 0 | ||||
FNumber | 业务组编码 | nvarchar | 30 | ||||
FIsUse | 启用 | char | 1 | ✓ | '0' |
--建表脚本--
create table T_BD_OPERATORGROUPENTRY(
FEntryId int not null comment '分录内码'
,FOperatorGroupId int not null comment '业务组内码'
,FOperatorGroupType nvarchar(20) not null comment '业务组类型'
,FBizOrgId int not null comment '业务组织'
,FNumber nvarchar(30) not null comment '业务组编码'
,FIsUse char(1) default ''0'' comment '启用'
,primary key (FEntryId)
) comment = '业务组分录'
--查询--
select FEntryId as "fentryid",FOperatorGroupId as "foperatorgroupid",FOperatorGroupType as "foperatorgrouptype",FBizOrgId as "fbizorgid",FNumber as "fnumber",FIsUse as "fisuse" from T_BD_OPERATORGROUPENTRY
--查询(中文字段)--
select FEntryId as "分录内码",FOperatorGroupId as "业务组内码",FOperatorGroupType as "业务组类型",FBizOrgId as "业务组织",FNumber as "业务组编码",FIsUse as "启用" from T_BD_OPERATORGROUPENTRY
--INSERT脚本--
insert into T_BD_OPERATORGROUPENTRY(FEntryId,FOperatorGroupId,FOperatorGroupType,FBizOrgId,FNumber,FIsUse) values (?,?,?,?,?,?)
--UPDATE脚本--
update T_BD_OPERATORGROUPENTRY set FEntryId=?,FOperatorGroupId=?,FOperatorGroupType=?,FBizOrgId=?,FNumber=?,FIsUse=? where FEntryId=?
--delete脚本--
delete from T_BD_OPERATORGROUPENTRY where FEntryId=?
--给字段加备注--
alter table T_BD_OPERATORGROUPENTRY comment '业务组分录';
alter table T_BD_OPERATORGROUPENTRY modify column FEntryId int not null comment '分录内码';
alter table T_BD_OPERATORGROUPENTRY modify column FOperatorGroupId int not null comment '业务组内码';
alter table T_BD_OPERATORGROUPENTRY modify column FOperatorGroupType nvarchar(20) not null comment '业务组类型';
alter table T_BD_OPERATORGROUPENTRY modify column FBizOrgId int not null comment '业务组织';
alter table T_BD_OPERATORGROUPENTRY modify column FNumber nvarchar(30) not null comment '业务组编码';
alter table T_BD_OPERATORGROUPENTRY modify column FIsUse char(1) default ''0'' comment '启用';
推荐阅读