T_BD_ACCOUNT(科目) | |||||||
是否主键 | 字段名 | 字段描述 | 数据类型 | 长度 | 可空 | 缺省值 | 备注 |
✓ | FACCTID | 科目内码 | int | 0 | |||
FNUMBER | 科目代码 | nvarchar | 80 | ✓ | |||
FPARENTID | 上级科目内码 | int | 0 | ||||
FHELPERCODE | 助记码 | nvarchar | 80 | ||||
FGROUPID | 科目类别内码 | int | 0 | 引用会计要素表 | |||
FDC | 余额方向 | int | 1 | 1 :借方 ; -1 :贷方 | |||
FACCTTBLID | 科目表内码 | int | 0 | ||||
FISCASH | 是否现金科目 | char | 1 | '0' | 0:非现金科目 ,1:现金科目 ,默认0 | ||
FISBANK | 是否银行科目 | char | 1 | '0' | 0:非银行科目 ,1:银行科目 ,默认0 | ||
FISALLOCATE | 是否期末调汇 | char | 1 | '0' | 是否期末调汇 | ||
FISCASHFLOW | 是否现金等价物 | char | 1 | '0' | 0:非现金等价物 ,1:现金等价物 ,默认0 | ||
FITEMDETAILID | 核算项目组 | int | 0 | 引用维度组 | |||
FISQUANTITIES | 是否数量金额辅助核算 | char | 1 | ✓ | '0' | (已无用)0:非数量金额核算 ,1:数量金额核算 ,默认0 | |
FUNITGROUPID | 单位组 | int | ✓ | 0 | (已无用)引用计量单位组 | ||
FUNITID | 缺省单位 | int | ✓ | 0 | (已无用)引用计量单位 | ||
FISDETAIL | 是否明细科目 | char | 1 | '1' | 0=非明细科目 1=明细科目 默认为明细科目 | ||
FLEVEL | 级次 | int | 1 | 科目级次从一级开始 | |||
FCREATEORGID | 创建组织 | int | 0 | ||||
FCREATORID | 创建人 | int | 0 | ||||
FCREATEDATE | 创建日期 | datetime | ✓ | ||||
FUSEORGID | 使用组织 | int | 0 | ||||
FMODIFIERID | 修改人 | int | 0 | ||||
FMODIFYDATE | 修改日期 | datetime | ✓ | ||||
FAUDITORID | 审核人 | int | 0 | ||||
FAUDITDATE | 审核日期 | datetime | ✓ | ||||
FFORBIDSTATUS | 禁用状态 | varchar | 1 | ||||
FFORBIDDERID | 禁用人 | int | 0 | ||||
FFORBIDDATE | 禁用日期 | datetime | ✓ | ||||
FMASTERID | 组织隔离字段 | int | 0 | ||||
FISSYSPRESET | 是否系统预设 | char | 1 | '0' | 是否系统预设 1 系统预设 0 非系统预设 默认0 | ||
FDOCUMENTSTATUS | 数据状态 | char | 1 | ||||
FCFITEMID | 主表项目流入 | int | ✓ | 0 | |||
FOCFItemID | 主表项目流出 | int | ✓ | 0 | |||
FCFINDIRECTITEMID | 附表项目流入 | int | ✓ | 0 | |||
FOCFIndirectItemId | 附表项目流出 | int | ✓ | 0 | |||
FAllCurrency | 核算所有币别 | char | 1 | ✓ | '0' | ||
FCurrencyList | 外币核算作废 | nvarchar | 200 | ✓ | 列表显示用 | ||
FCurrencys | 外币核算 | nvarchar | 255 | ✓ | |||
FISSHOWJOURNAL | 是否出日记账 | char | 1 | '0' | 0:不出日记账 ,1:出日记账,默认0 | ||
FAMOUNTDC | 发生额方向 | smallint | 0 | ||||
FISCONTACT | 是否往来科目 | char | 1 | '0' | |||
备注:科目:保存科目信息 |
--建表脚本--
create table T_BD_ACCOUNT(
FACCTID int not null comment '科目内码'
,FNUMBER nvarchar(80) default '' comment '科目代码'
,FPARENTID int not null comment '上级科目内码'
,FHELPERCODE nvarchar(80) not null comment '助记码'
,FGROUPID int not null comment '科目类别内码'
,FDC int not null comment '余额方向'
,FACCTTBLID int not null comment '科目表内码'
,FISCASH char(1) not null comment '是否现金科目'
,FISBANK char(1) not null comment '是否银行科目'
,FISALLOCATE char(1) not null comment '是否期末调汇'
,FISCASHFLOW char(1) not null comment '是否现金等价物'
,FITEMDETAILID int not null comment '核算项目组'
,FISQUANTITIES char(1) default ''0'' comment '是否数量金额辅助核算'
,FUNITGROUPID int default 0 comment '单位组'
,FUNITID int default 0 comment '缺省单位'
,FISDETAIL char(1) not null comment '是否明细科目'
,FLEVEL 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 '修改日期'
,FAUDITORID int not null comment '审核人'
,FAUDITDATE datetime default null comment '审核日期'
,FFORBIDSTATUS varchar(1) not null comment '禁用状态'
,FFORBIDDERID int not null comment '禁用人'
,FFORBIDDATE datetime default null comment '禁用日期'
,FMASTERID int not null comment '组织隔离字段'
,FISSYSPRESET char(1) not null comment '是否系统预设'
,FDOCUMENTSTATUS char(1) not null comment '数据状态'
,FCFITEMID int default 0 comment '主表项目流入'
,FOCFItemID int default 0 comment '主表项目流出'
,FCFINDIRECTITEMID int default 0 comment '附表项目流入'
,FOCFIndirectItemId int default 0 comment '附表项目流出'
,FAllCurrency char(1) default ''0'' comment '核算所有币别'
,FCurrencyList nvarchar(200) default null comment '外币核算作废'
,FCurrencys nvarchar(255) default null comment '外币核算'
,FISSHOWJOURNAL char(1) not null comment '是否出日记账'
,FAMOUNTDC smallint not null comment '发生额方向'
,FISCONTACT char(1) not null comment '是否往来科目'
,primary key (FACCTID)
) comment = '科目'
--查询--
select FACCTID as "facctid",FNUMBER as "fnumber",FPARENTID as "fparentid",FHELPERCODE as "fhelpercode",FGROUPID as "fgroupid",FDC as "fdc",FACCTTBLID as "faccttblid",FISCASH as "fiscash",FISBANK as "fisbank",FISALLOCATE as "fisallocate",FISCASHFLOW as "fiscashflow",FITEMDETAILID as "fitemdetailid",FISQUANTITIES as "fisquantities",FUNITGROUPID as "funitgroupid",FUNITID as "funitid",FISDETAIL as "fisdetail",FLEVEL as "flevel",FCREATEORGID as "fcreateorgid",FCREATORID as "fcreatorid",FCREATEDATE as "fcreatedate",FUSEORGID as "fuseorgid",FMODIFIERID as "fmodifierid",FMODIFYDATE as "fmodifydate",FAUDITORID as "fauditorid",FAUDITDATE as "fauditdate",FFORBIDSTATUS as "fforbidstatus",FFORBIDDERID as "fforbidderid",FFORBIDDATE as "fforbiddate",FMASTERID as "fmasterid",FISSYSPRESET as "fissyspreset",FDOCUMENTSTATUS as "fdocumentstatus",FCFITEMID as "fcfitemid",FOCFItemID as "focfitemid",FCFINDIRECTITEMID as "fcfindirectitemid",FOCFIndirectItemId as "focfindirectitemid",FAllCurrency as "fallcurrency",FCurrencyList as "fcurrencylist",FCurrencys as "fcurrencys",FISSHOWJOURNAL as "fisshowjournal",FAMOUNTDC as "famountdc",FISCONTACT as "fiscontact" from T_BD_ACCOUNT
--查询(中文字段)--
select FACCTID as "科目内码",FNUMBER as "科目代码",FPARENTID as "上级科目内码",FHELPERCODE as "助记码",FGROUPID as "科目类别内码",FDC as "余额方向",FACCTTBLID as "科目表内码",FISCASH as "是否现金科目",FISBANK as "是否银行科目",FISALLOCATE as "是否期末调汇",FISCASHFLOW as "是否现金等价物",FITEMDETAILID as "核算项目组",FISQUANTITIES as "是否数量金额辅助核算",FUNITGROUPID as "单位组",FUNITID as "缺省单位",FISDETAIL as "是否明细科目",FLEVEL as "级次",FCREATEORGID as "创建组织",FCREATORID as "创建人",FCREATEDATE as "创建日期",FUSEORGID as "使用组织",FMODIFIERID as "修改人",FMODIFYDATE as "修改日期",FAUDITORID as "审核人",FAUDITDATE as "审核日期",FFORBIDSTATUS as "禁用状态",FFORBIDDERID as "禁用人",FFORBIDDATE as "禁用日期",FMASTERID as "组织隔离字段",FISSYSPRESET as "是否系统预设",FDOCUMENTSTATUS as "数据状态",FCFITEMID as "主表项目流入",FOCFItemID as "主表项目流出",FCFINDIRECTITEMID as "附表项目流入",FOCFIndirectItemId as "附表项目流出",FAllCurrency as "核算所有币别",FCurrencyList as "外币核算作废",FCurrencys as "外币核算",FISSHOWJOURNAL as "是否出日记账",FAMOUNTDC as "发生额方向",FISCONTACT as "是否往来科目" from T_BD_ACCOUNT
--INSERT脚本--
insert into T_BD_ACCOUNT(FACCTID,FNUMBER,FPARENTID,FHELPERCODE,FGROUPID,FDC,FACCTTBLID,FISCASH,FISBANK,FISALLOCATE,FISCASHFLOW,FITEMDETAILID,FISQUANTITIES,FUNITGROUPID,FUNITID,FISDETAIL,FLEVEL,FCREATEORGID,FCREATORID,FCREATEDATE,FUSEORGID,FMODIFIERID,FMODIFYDATE,FAUDITORID,FAUDITDATE,FFORBIDSTATUS,FFORBIDDERID,FFORBIDDATE,FMASTERID,FISSYSPRESET,FDOCUMENTSTATUS,FCFITEMID,FOCFItemID,FCFINDIRECTITEMID,FOCFIndirectItemId,FAllCurrency,FCurrencyList,FCurrencys,FISSHOWJOURNAL,FAMOUNTDC,FISCONTACT) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
--UPDATE脚本--
update T_BD_ACCOUNT set FACCTID=?,FNUMBER=?,FPARENTID=?,FHELPERCODE=?,FGROUPID=?,FDC=?,FACCTTBLID=?,FISCASH=?,FISBANK=?,FISALLOCATE=?,FISCASHFLOW=?,FITEMDETAILID=?,FISQUANTITIES=?,FUNITGROUPID=?,FUNITID=?,FISDETAIL=?,FLEVEL=?,FCREATEORGID=?,FCREATORID=?,FCREATEDATE=?,FUSEORGID=?,FMODIFIERID=?,FMODIFYDATE=?,FAUDITORID=?,FAUDITDATE=?,FFORBIDSTATUS=?,FFORBIDDERID=?,FFORBIDDATE=?,FMASTERID=?,FISSYSPRESET=?,FDOCUMENTSTATUS=?,FCFITEMID=?,FOCFItemID=?,FCFINDIRECTITEMID=?,FOCFIndirectItemId=?,FAllCurrency=?,FCurrencyList=?,FCurrencys=?,FISSHOWJOURNAL=?,FAMOUNTDC=?,FISCONTACT=? where FACCTID=?
--delete脚本--
delete from T_BD_ACCOUNT where FACCTID=?
--给字段加备注--
alter table T_BD_ACCOUNT comment '科目';
alter table T_BD_ACCOUNT modify column FACCTID int not null comment '科目内码';
alter table T_BD_ACCOUNT modify column FNUMBER nvarchar(80) default '' comment '科目代码';
alter table T_BD_ACCOUNT modify column FPARENTID int not null comment '上级科目内码';
alter table T_BD_ACCOUNT modify column FHELPERCODE nvarchar(80) not null comment '助记码';
alter table T_BD_ACCOUNT modify column FGROUPID int not null comment '科目类别内码';
alter table T_BD_ACCOUNT modify column FDC int not null comment '余额方向';
alter table T_BD_ACCOUNT modify column FACCTTBLID int not null comment '科目表内码';
alter table T_BD_ACCOUNT modify column FISCASH char(1) not null comment '是否现金科目';
alter table T_BD_ACCOUNT modify column FISBANK char(1) not null comment '是否银行科目';
alter table T_BD_ACCOUNT modify column FISALLOCATE char(1) not null comment '是否期末调汇';
alter table T_BD_ACCOUNT modify column FISCASHFLOW char(1) not null comment '是否现金等价物';
alter table T_BD_ACCOUNT modify column FITEMDETAILID int not null comment '核算项目组';
alter table T_BD_ACCOUNT modify column FISQUANTITIES char(1) default ''0'' comment '是否数量金额辅助核算';
alter table T_BD_ACCOUNT modify column FUNITGROUPID int default 0 comment '单位组';
alter table T_BD_ACCOUNT modify column FUNITID int default 0 comment '缺省单位';
alter table T_BD_ACCOUNT modify column FISDETAIL char(1) not null comment '是否明细科目';
alter table T_BD_ACCOUNT modify column FLEVEL int not null comment '级次';
alter table T_BD_ACCOUNT modify column FCREATEORGID int not null comment '创建组织';
alter table T_BD_ACCOUNT modify column FCREATORID int not null comment '创建人';
alter table T_BD_ACCOUNT modify column FCREATEDATE datetime default null comment '创建日期';
alter table T_BD_ACCOUNT modify column FUSEORGID int not null comment '使用组织';
alter table T_BD_ACCOUNT modify column FMODIFIERID int not null comment '修改人';
alter table T_BD_ACCOUNT modify column FMODIFYDATE datetime default null comment '修改日期';
alter table T_BD_ACCOUNT modify column FAUDITORID int not null comment '审核人';
alter table T_BD_ACCOUNT modify column FAUDITDATE datetime default null comment '审核日期';
alter table T_BD_ACCOUNT modify column FFORBIDSTATUS varchar(1) not null comment '禁用状态';
alter table T_BD_ACCOUNT modify column FFORBIDDERID int not null comment '禁用人';
alter table T_BD_ACCOUNT modify column FFORBIDDATE datetime default null comment '禁用日期';
alter table T_BD_ACCOUNT modify column FMASTERID int not null comment '组织隔离字段';
alter table T_BD_ACCOUNT modify column FISSYSPRESET char(1) not null comment '是否系统预设';
alter table T_BD_ACCOUNT modify column FDOCUMENTSTATUS char(1) not null comment '数据状态';
alter table T_BD_ACCOUNT modify column FCFITEMID int default 0 comment '主表项目流入';
alter table T_BD_ACCOUNT modify column FOCFItemID int default 0 comment '主表项目流出';
alter table T_BD_ACCOUNT modify column FCFINDIRECTITEMID int default 0 comment '附表项目流入';
alter table T_BD_ACCOUNT modify column FOCFIndirectItemId int default 0 comment '附表项目流出';
alter table T_BD_ACCOUNT modify column FAllCurrency char(1) default ''0'' comment '核算所有币别';
alter table T_BD_ACCOUNT modify column FCurrencyList nvarchar(200) default null comment '外币核算作废';
alter table T_BD_ACCOUNT modify column FCurrencys nvarchar(255) default null comment '外币核算';
alter table T_BD_ACCOUNT modify column FISSHOWJOURNAL char(1) not null comment '是否出日记账';
alter table T_BD_ACCOUNT modify column FAMOUNTDC smallint not null comment '发生额方向';
alter table T_BD_ACCOUNT modify column FISCONTACT char(1) not null comment '是否往来科目';
推荐阅读