BOSIDE 查询SQL

/*****BOSIDE*****/

--领域模型

select *from T_MDL_DOMAINMODETYPE

select *from T_MDL_DOMAINMODELSUB

select *from T_MDL_DOMAINMODETYPE_L where FLOCALEID=2052;

select *from T_MDL_DOMAINMODELSUB_L where FLOCALEID=2052;

--元素分类

select b.FNAME,a.* from T_MDL_ELEMENTTYPE a

inner join T_MDL_ELEMENTTYPE_L b on a.FID=b.FID where b.FLOCALEID=2052

--元数据表

select *from T_META_OBJECTTYPE where FSUPPLIERNAME='Kingdee'--FDEVTYPE=2 --表示扩展

--操作

select b.FNAME,a.* from T_MDL_FORMOPERATIONTYPE a

inner join T_MDL_FORMOPERATIONTYPE_L b on a.FID=b.FID where b.FLOCALEID=2052

--校验器

select b.FNAME,a.* from T_MDL_FORMVALIDATIONTYPE a

inner join T_MDL_FORMVALIDATIONTYPE_L b on a.FTYPEID=b.FTYPEID where b.FLOCALEID=2052

--实体服务

select b.FDESC,a.* from T_MDL_FORMBUSINESS a

inner join T_MDL_FORMBUSINESS_L b on a.FACTIONID=b.FACTIONID where b.FLOCALEID=2052

--缺省值函数

select b.FDESC,a.* from T_MDL_FORMFUNCTION a

inner join T_MDL_FORMFUNCTION_L b on a.FID=b.FID where b.FLOCALEID=2052

--表达式函数

select SUBSTRING(a.FAPPEARANCECLA