BOS常用表的查询SQL集锦

--查询业务对象模板信息

select * from ICClassType where FName_chs like '%%'

select * from ICClassType where FID=

select * from ICClassTypeEntry where FParentID=

select * from ICClassTableInfo where FClassTypeID=

--查询工业单据模板信息

select * from ICTransactionType where FName like '%%'

select * from ICTransactionType where FTemplateID=

select * from ICTempalte where FID=

select * from ICTempalteEntry where FID=

--t_dataflowtopclass    一级菜单-主控台顶层

--t_dataflowsubsystem   二级菜单-主控台子系统

--t_dataflowsubfunc     三级菜单-主控台子功能

--t_DataFlowDetailFunc     四级菜单-主控台明细功能

--查询某类型单据所在的子系统,在主控台对应的明细功能位置

select u.ftopclassid,u.ftopclassname,v.fsubsysid,v.fname,w.fsubfuncid,w.ffuncname,x.fdetailfuncid,x.ffuncname 

from t_dataflowtopclass u left join t_dataflowsubsystem v on u.ftopclassid=v.ftopclassid left join t_dataflowsubfunc w

on v.fsubsysid = w.fsubsysid left join t_dataflowdetailfunc x on w.fsubfuncid=x.fsubfuncid 

where v.fsubsysid in (select FFunctionID from icclasstype where fid=1007310)

--查询选单流程相关信息

select * from ICClassLink WHERE FDestClassTypeID = -71 AND FSourClassTypeID = 1007311

select * from ICClassLinkEntry where FDestClassTypeID = -71 AND FSourClassTypeID = 1007311

select * from ICClassLinkCommit WHERE FDstClsTypID = -71 AND FSrcClsTypID = 1007311

select * from ICClassWorkFlowJoin WHERE FDestClassTypeID = -71 and  FSourClassTypeID = 1007311

select * from ICClassWorkFlowBill WHERE FClassTypeID = 1007311

--查询老单选单流程信息(其中FBillID、FID为目标单ID，FFieldID、FFieldName为源单ID)

select * from ICTableRelation where FBillID='P02' and FFieldID='1007311' 

select * from ICSelBills where FID='P02' and FFieldName='1007311'

--查询老审核流程信息

select * from ICClassMCFlowInfo where FID=

select * from ICClassMCTasks where FID=

select * from ICClassCheckRecords1007311

select * from ICClassCheckStatus1007311

--查询