1.1 BD基础--基础资料-公用（科目）

--建表脚本--

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 '是否往来科目';