douml88的专栏

1 删除表：drop table T_SYS_PortalPermission 2 创建表： Create Table T_SYS_PortalPermission(FID VARCHAR(44) NOT NULL ,FUSERID VARCHAR(44),FPERSONID VARCHAR(44), FORGUNITID VARCHAR(44), FJOBID VARC

查找本级及下级的所有组织的sql  select * from t_org_costcenter subOrg inner join t_org_costcenter porg        ON subOrg.flongnumber like porg.flongnumber || '!%'        or suborg.flongnumber = porg.flongNum

select e.FNumber as 机构号, g.FNumber AS 科目编码, n.FNumber as 币种编码, s.FNumber as 往来单位编码, s.FName_L2 as 往来单位名称,--b.fentrydc,a.foriginalamountnvl(sum(decode(b.fentrydc,1,a.foriginalamount,-a.foriginala

1. 若是单实例，请直接进行下一步操作；   若是集群环境先在管理控制台中查找某一具体实例如server2的连接信息，然后修改客户端的服务器连接设置为server2的连接信息。 2. 登录客户端。切换到对应的组织 3. 打开服务器日志开关。   http://serverip:port/  用户名密码：admin/admin    （此处的端口号可以到serve

select  * from  t_cas_bankstatement  where   to_char(fcreatetime,'YYYY-mm-dd')>='2017-03-23'  order by  fcreatetime  descdelete from t_cas_bankstatement  where  to_char(fcreatetime,'YYYY-mm-dd

select com.fname_l2 公司, to_char(vou.FBookedDate ,'yyyy-mm-dd')  记账日期,per.fnumber 期间,vou.fnumber 凭证号,'已过账' 凭证状态,per.fname_l2 制单人,pers.fname_l2 审核人,pers.fname_l2 过账人,entry.fdescription 摘要,acct.fnumber 科...

select  *  into  dml_T_GL_AccountBalance_180105 from  T_GL_AccountBalance  ab where  ab.FPeriodID in (select fid from  T_BD_Period  where FPeriodYear=2018);delete from T_GL_AccountBalance ab  where  a...

1.查询卡片信息selectfacat.fnumber 固定资产类别编码,fa.fnumber 固定资产编码,fa.FOldNumber 原资产编码,fa.FAssetName 固定资产名称,fa.FAssetAmt 数量,mu.fnumber 计量单位,fa.FAccountDate 实物入账日期,fa.FFiAccountDate 账务入账日期,am.fnumber 来源...

select com.fnumber,com.fname_l2,per.fnumber from T_BD_SystemStatusCtrol sscleft join t_org_company com on ssc.fcompanyid=com.fidleft join T_BD_Period per on ssc.FCurrentPeriodID =per.fid获取...