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

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

--查询新单审核流程信息()

select FTemplateID,* from ICClassMCTemplate where FClassTypeid=

select * from ICClassMCTableInfo where FTemplateID=

select * from ICClassMCRecord1007308

select * from ICClassMCStatus1007308

--单据action信息

select * from ICClassAction

select * from ICClassActionList where FClassTypeID=

--查询权限控制信息

select FObjectType,FObjectID,* from ICClassType where FID=1007310

select * from t_objecttype where  FOBJECTTYPE=4580 and FOBJECTID=4

select * from t_ObjectAccessType WHERE FOBJECTTYPE=4580 and FOBJECTID=4

select FGroupID,* from t_ObjectAccess WHERE FOBJECTTYPE=4580 and FOBJECTID=4

select * from t_GroupAccessType  WHERE Fgroupid in (1,2)

--查询k/3数据库表及其字段描述信息

select * from t_TableDescription where FDescription like '%%'

select * from t_TableDescription where FTableName=''

select * from t_FieldDescription where FTableid=

select * from t_FieldDescription where FFieldName=''  order by FTableID                                                       

--BOS元素信息

select * from ICClassElements

--K3系统信息，可以通过此表更改账套版本号

select * from t_systemProfile where FDescription like '%%'

update t_systemProfile set FValue='7.0.01.02' where FKey ='ServicePack'

--用户默认方案信息

select * from ICClassUserProfile