1.2 BD基础--基础资料-公用(账簿、账簿多语言)
T_BD_ACCOUNTBOOK(账簿) | |||||||
是否主键 | 字段名 | 字段描述 | 数据类型 | 长度 | 可空 | 缺省值 | 备注 |
✓ | FBOOKID | 内码 | int | 0 | |||
FNUMBER | 账簿编码 | nvarchar | 30 | ||||
FACCTTABLEID | 科目表内码 | int | 0 | 引用科目表 | |||
FPERIODID | 会计日历内码 | int | 0 | 引用会计日历 | |||
FCURRENCYID | 记账本位币内码 | int | 0 | 引用币别表 | |||
FRATETYPEID | 默认汇率类型内码 | int | 0 | 引用汇率类型 | |||
FACCOUNTORGID | 核算组织 | int | 0 | 引用组织 | |||
FACCTSYSTEMID | 核算体系 | int | 0 | 引用核算体系基础资料 | |||
FBOOKTYPE | 账簿类型 | char | 1 | 引用枚举类型【账簿类型】 0 非主账簿 1主账簿 默认0 | |||
fdefaultvouchertype | 默认凭证字 | int | 0 | ||||
FCREATEORGID | 创建组织 | int | 0 | ||||
FCREATORID | 创建人 | int | 0 | ||||
FCREATEDATE | 创建日期 | datetime | ✓ | ||||
FUSEORGID | 使用组织 | int | 0 | ||||
FMODIFIERID | 修改人 | int | 0 | ||||
FMODIFYDATE | 修改日期 | datetime | ✓ | ||||
FDOCUMENTSTATUS | 数据状态 | char | 1 | ||||
FAUDITORID | 审核人 | int | 0 | ||||
FAUDITDATE | 审核日期 | datetime | ✓ | ||||
FFORBIDSTATUS | 禁用状态 | char | 1 | ||||
FFORBIDDERID | 禁用人 | int | 0 | ||||
FFORBIDDATE | 禁用日期 | datetime | ✓ | ||||
FISSYSPRESET | 是否系统预设 | char | 1 | 是否系统预设 1 系统预设 0 非系统预设 默认0 | |||
fmasterid | 组织隔离字段 | int | 0 | ||||
FUSEADJUSTPERIOD | 启用调整期 | char | 1 | '0' | |||
FINITIALSTATUS | 初始化状态 | char | 1 | '0' | |||
FCURRENTYEAR | 当前年度 | int | 0 | 当前年度 | |||
FCURRENTPERIOD | 当前期间 | int | 0 | 当前期间 | |||
FCRTYEARPERIOD | 当前年度期间 | nvarchar | 30 | ✓ | |||
FSTARTYEAR | 启用年度 | int | 0 | 启用年度 | |||
FSTARTPERIOD | 启用期间 | int | 0 | 启用期间 | |||
FYEARANDPERIOD | 启用年度期间 | nvarchar | 30 | ✓ | |||
FACCTPOLICYID | 会计政策内码 | int | 0 | ||||
FAPFINTYPE | 财务应付确认方式 | char | 1 | ✓ | '0' | ||
FARFINTYPE | 财务应收确认方式 | char | 1 | ✓ | '0' | ||
备注:保存账簿信息 |
--建表脚本--
create table T_BD_ACCOUNTBOOK(
FBOOKID int not null comment '内码'
,FNUMBER nvarchar(30) not null comment '账簿编码'
,FACCTTABLEID int not null comment '科目表内码'
,FPERIODID int not null comment '会计日历内码'
,FCURRENCYID int not null comment '记账本位币内码'
,FRATETYPEID int not null comment '默认汇率类型内码'
,FACCOUNTORGID int not null comment '核算组织'
,FACCTSYSTEMID int not null comment '核算体系'
,FBOOKTYPE char(1) not null comment '账簿类型'
,fdefaultvouchertype int not null comment '默认凭证字'
,FCREATEORGID int not null comment '创建组织'
,FCREATORID int not null comment '创建人'
,FCREATEDATE datetime default null comment '创建日期'
,FUSEORGID int not null comment '使用组织'
,FMODIFIERID int not null comment '修改人'
,FMODIFYDATE datetime default null comment '修改日期'
,FDOCUMENTSTATUS char(1) not null comment '数据状态'
,FAUDITORID int not null comment '审核人'
,FAUDITDATE datetime default null comment '审核日期'
,FFORBIDSTATUS char(1) not null comment '禁用状态'
,FFORBIDDERID int not null comment '禁用人'
,FFORBIDDATE datetime default null comment '禁用日期'
,FISSYSPRESET char(1) not null comment '是否系统预设'
,fmasterid int not null comment '组织隔离字段'
,FUSEADJUSTPERIOD char(1) not null comment '启用调整期'
,FINITIALSTATUS char(1) not null comment '初始化状态'
,FCURRENTYEAR int not null comment '当前年度'
,FCURRENTPERIOD int not null comment '当前期间'
,FCRTYEARPERIOD nvarchar(30) default null comment '当前年度期间'
,FSTARTYEAR int not null comment '启用年度'
,FSTARTPERIOD int not null comment '启用期间'
,FYEARANDPERIOD nvarchar(30) default null comment '启用年度期间'
,FACCTPOLICYID int not null comment '会计政策内码'
,FAPFINTYPE char(1) default ''0'' comment '财务应付确认方式'
,FARFINTYPE char(1) default ''0'' comment '财务应收确认方式'
,primary key (FBOOKID)
) comment = '账簿'
--查询--
select FBOOKID as "fbookid",FNUMBER as "fnumber",FACCTTABLEID as "faccttableid",FPERIODID as "fperiodid",FCURRENCYID as "fcurrencyid",FRATETYPEID as "fratetypeid",FACCOUNTORGID as "faccountorgid",FACCTSYSTEMID as "facctsystemid",FBOOKTYPE as "fbooktype",fdefaultvouchertype as "fdefaultvouchertype",FCREATEORGID as "fcreateorgid",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FUSEORGID as "fuseorgid",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FDOCUMENTSTATUS as "fdocumentstatus",FAUDITORID as "fauditorid",FAUDITDATE as "fauditdate",FFORBIDSTATUS as "fforbidstatus",FFORBIDDERID as "fforbidderid",FFORBIDDATE as "fforbiddate",FISSYSPRESET as "fissyspreset",fmasterid as "fmasterid",FUSEADJUSTPERIOD as "fuseadjustperiod",FINITIALSTATUS as "finitialstatus",FCURRENTYEAR as "fcurrentyear",FCURRENTPERIOD as "fcurrentperiod",FCRTYEARPERIOD as "fcrtyearperiod",FSTARTYEAR as "fstartyear",FSTARTPERIOD as "fstartperiod",FYEARANDPERIOD as "fyearandperiod",FACCTPOLICYID as "facctpolicyid",FAPFINTYPE as "fapfintype",FARFINTYPE as "farfintype" from T_BD_ACCOUNTBOOK
--查询(中文字段)--
select FBOOKID as "内码",FNUMBER as "账簿编码",FACCTTABLEID as "科目表内码",FPERIODID as "会计日历内码",FCURRENCYID as "记账本位币内码",FRATETYPEID as "默认汇率类型内码",FACCOUNTORGID as "核算组织",FACCTSYSTEMID as "核算体系",FBOOKTYPE as "账簿类型",fdefaultvouchertype as "默认凭证字",FCREATEORGID as "创建组织",FCREATORID as "创建人",FCREATEDATE as "创建日期",FUSEORGID as "使用组织",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FDOCUMENTSTATUS as "数据状态",FAUDITORID as "审核人",FAUDITDATE as "审核日期",FFORBIDSTATUS as "禁用状态",FFORBIDDERID as "禁用人",FFORBIDDATE as "禁用日期",FISSYSPRESET as "是否系统预设",fmasterid as "组织隔离字段",FUSEADJUSTPERIOD as "启用调整期",FINITIALSTATUS as "初始化状态",FCURRENTYEAR as "当前年度",FCURRENTPERIOD as "当前期间",FCRTYEARPERIOD as "当前年度期间",FSTARTYEAR as "启用年度",FSTARTPERIOD as "启用期间",FYEARANDPERIOD as "启用年度期间",FACCTPOLICYID as "会计政策内码",FAPFINTYPE as "财务应付确认方式",FARFINTYPE as "财务应收确认方式" from T_BD_ACCOUNTBOOK
--INSERT脚本--
insert into T_BD_ACCOUNTBOOK(FBOOKID,FNUMBER,FACCTTABLEID,FPERIODID,FCURRENCYID,FRATETYPEID,FACCOUNTORGID,FACCTSYSTEMID,FBOOKTYPE,fdefaultvouchertype,FCREATEORGID,FCREATORID,FCREATEDATE,FUSEORGID,FMODIFIERID,FMODIFYDATE,FDOCUMENTSTATUS,FAUDITORID,FAUDITDATE,FFORBIDSTATUS,FFORBIDDERID,FFORBIDDATE,FISSYSPRESET,fmasterid,FUSEADJUSTPERIOD,FINITIALSTATUS,FCURRENTYEAR,FCURRENTPERIOD,FCRTYEARPERIOD,FSTARTYEAR,FSTARTPERIOD,FYEARANDPERIOD,FACCTPOLICYID,FAPFINTYPE,FARFINTYPE) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_BD_ACCOUNTBOOK set FBOOKID=?,FNUMBER=?,FACCTTABLEID=?,FPERIODID=?,FCURRENCYID=?,FRATETYPEID=?,FACCOUNTORGID=?,FACCTSYSTEMID=?,FBOOKTYPE=?,fdefaultvouchertype=?,FCREATEORGID=?,FCREATORID=?,FCREATEDATE=?,FUSEORGID=?,FMODIFIERID=?,FMODIFYDATE=?,FDOCUMENTSTATUS=?,FAUDITORID=?,FAUDITDATE=?,FFORBIDSTATUS=?,FFORBIDDERID=?,FFORBIDDATE=?,FISSYSPRESET=?,fmasterid=?,FUSEADJUSTPERIOD=?,FINITIALSTATUS=?,FCURRENTYEAR=?,FCURRENTPERIOD=?,FCRTYEARPERIOD=?,FSTARTYEAR=?,FSTARTPERIOD=?,FYEARANDPERIOD=?,FACCTPOLICYID=?,FAPFINTYPE=?,FARFINTYPE=? where FBOOKID=?
--delete脚本--
delete from T_BD_ACCOUNTBOOK where FBOOKID=?
--给字段加备注--
alter table T_BD_ACCOUNTBOOK comment '账簿';
alter table T_BD_ACCOUNTBOOK modify column FBOOKID int not null comment '内码';
alter table T_BD_ACCOUNTBOOK modify column FNUMBER nvarchar(30) not null comment '账簿编码';
alter table T_BD_ACCOUNTBOOK modify column FACCTTABLEID int not null comment '科目表内码';
alter table T_BD_ACCOUNTBOOK modify column FPERIODID int not null comment '会计日历内码';
alter table T_BD_ACCOUNTBOOK modify column FCURRENCYID int not null comment '记账本位币内码';
alter table T_BD_ACCOUNTBOOK modify column FRATETYPEID int not null comment '默认汇率类型内码';
alter table T_BD_ACCOUNTBOOK modify column FACCOUNTORGID int not null comment '核算组织';
alter table T_BD_ACCOUNTBOOK modify column FACCTSYSTEMID int not null comment '核算体系';
alter table T_BD_ACCOUNTBOOK modify column FBOOKTYPE char(1) not null comment '账簿类型';
alter table T_BD_ACCOUNTBOOK modify column fdefaultvouchertype int not null comment '默认凭证字';
alter table T_BD_ACCOUNTBOOK modify column FCREATEORGID int not null comment '创建组织';
alter table T_BD_ACCOUNTBOOK modify column FCREATORID int not null comment '创建人';
alter table T_BD_ACCOUNTBOOK modify column FCREATEDATE datetime default null comment '创建日期';
alter table T_BD_ACCOUNTBOOK modify column FUSEORGID int not null comment '使用组织';
alter table T_BD_ACCOUNTBOOK modify column FMODIFIERID int not null comment '修改人';
alter table T_BD_ACCOUNTBOOK modify column FMODIFYDATE datetime default null comment '修改日期';
alter table T_BD_ACCOUNTBOOK modify column FDOCUMENTSTATUS char(1) not null comment '数据状态';
alter table T_BD_ACCOUNTBOOK modify column FAUDITORID int not null comment '审核人';
alter table T_BD_ACCOUNTBOOK modify column FAUDITDATE datetime default null comment '审核日期';
alter table T_BD_ACCOUNTBOOK modify column FFORBIDSTATUS char(1) not null comment '禁用状态';
alter table T_BD_ACCOUNTBOOK modify column FFORBIDDERID int not null comment '禁用人';
alter table T_BD_ACCOUNTBOOK modify column FFORBIDDATE datetime default null comment '禁用日期';
alter table T_BD_ACCOUNTBOOK modify column FISSYSPRESET char(1) not null comment '是否系统预设';
alter table T_BD_ACCOUNTBOOK modify column fmasterid int not null comment '组织隔离字段';
alter table T_BD_ACCOUNTBOOK modify column FUSEADJUSTPERIOD char(1) not null comment '启用调整期';
alter table T_BD_ACCOUNTBOOK modify column FINITIALSTATUS char(1) not null comment '初始化状态';
alter table T_BD_ACCOUNTBOOK modify column FCURRENTYEAR int not null comment '当前年度';
alter table T_BD_ACCOUNTBOOK modify column FCURRENTPERIOD int not null comment '当前期间';
alter table T_BD_ACCOUNTBOOK modify column FCRTYEARPERIOD nvarchar(30) default null comment '当前年度期间';
alter table T_BD_ACCOUNTBOOK modify column FSTARTYEAR int not null comment '启用年度';
alter table T_BD_ACCOUNTBOOK modify column FSTARTPERIOD int not null comment '启用期间';
alter table T_BD_ACCOUNTBOOK modify column FYEARANDPERIOD nvarchar(30) default null comment '启用年度期间';
alter table T_BD_ACCOUNTBOOK modify column FACCTPOLICYID int not null comment '会计政策内码';
alter table T_BD_ACCOUNTBOOK modify column FAPFINTYPE char(1) default ''0'' comment '财务应付确认方式';
alter table T_BD_ACCOUNTBOOK modify column FARFINTYPE char(1) default ''0'' comment '财务应收确认方式';
T_BD_ACCOUNTBOOK_L(账簿多语言) | |||||||
是否主键 | 字段名 | 字段描述 | 数据类型 | 长度 | 可空 | 缺省值 | 备注 |
✓ | FPKID | 内码 | int | 0 | |||
FBOOKID | 账簿内码 | int | 0 | 引用账簿表 | |||
FNAME | 账簿名称 | nvarchar | 80 | ✓ | |||
FDESCRIPTION | 备注 | nvarchar | 255 | ||||
FLOCALEID | 语言内码 | int | 0 | ||||
备注:保存账簿多语言信息 |
--建表脚本--
create table T_BD_ACCOUNTBOOK_L(
FPKID int not null comment '内码'
,FBOOKID int not null comment '账簿内码'
,FNAME nvarchar(80) default '' comment '账簿名称'
,FDESCRIPTION nvarchar(255) not null comment '备注'
,FLOCALEID int not null comment '语言内码'
,primary key (FPKID)
) comment = '账簿多语言'
--查询--
select FPKID as "fpkid",FBOOKID as "fbookid",FNAME as "fname",FDESCRIPTION as "fdescription",FLOCALEID as "flocaleid" from T_BD_ACCOUNTBOOK_L
--查询(中文字段)--
select FPKID as "内码",FBOOKID as "账簿内码",FNAME as "账簿名称",FDESCRIPTION as "备注",FLOCALEID as "语言内码" from T_BD_ACCOUNTBOOK_L
--INSERT脚本--
insert into T_BD_ACCOUNTBOOK_L(FPKID,FBOOKID,FNAME,FDESCRIPTION,FLOCALEID) values (?,?,?,?,?)
--UPDATE脚本--
update T_BD_ACCOUNTBOOK_L set FPKID=?,FBOOKID=?,FNAME=?,FDESCRIPTION=?,FLOCALEID=? where FPKID=?
--delete脚本--
delete from T_BD_ACCOUNTBOOK_L where FPKID=?
--给字段加备注--
alter table T_BD_ACCOUNTBOOK_L comment '账簿多语言';
alter table T_BD_ACCOUNTBOOK_L modify column FPKID int not null comment '内码';
alter table T_BD_ACCOUNTBOOK_L modify column FBOOKID int not null comment '账簿内码';
alter table T_BD_ACCOUNTBOOK_L modify column FNAME nvarchar(80) default '' comment '账簿名称';
alter table T_BD_ACCOUNTBOOK_L modify column FDESCRIPTION nvarchar(255) not null comment '备注';
alter table T_BD_ACCOUNTBOOK_L modify column FLOCALEID int not null comment '语言内码';
1.2 BD基础--基础资料-公用(账簿、账簿多语言)
本文2024-09-16 18:17:20发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-21171.html