--查询单据在哪个表 

--以采购订单为例

select t3.FTopClassName,t2.FName ,t1.FName_CHS,FFunctionID, * from ICClassType t1 

inner join t_DataFlowSubSystem t2 on t1.FFunctionID=t2.FSubSysID

inner join t_DataFlowTopClass t3 on t2.FTopClassID=t3.FTopClassID

where t1.FName_CHS like '%采购订单%'