金蝶云星空二次开发-数据库存查询

1. 枚举：select b1.FID,n1.FName,b2.FSeq,b2.FValue,n2.FCaption from T_META_Formenum b1 inner join T_META_Formenum_L n1 on b1.FID=n1.FID and (n1.FName like '%年%' or n1.FName like '%月%') and n1.FLocaleID=2052 inner join T_META_FormenumItem b2 on b1.FID=b2.FID inner join T_META_FormenumItem_L n2 on b2.FEnumID=n2.FEnumID and n2.FLocaleID=2052 order by b1.FID,b2.FSeq
2. 辅助资料：select b1.FID,b1.FNumber,n1.FName,b2.FEntryID,b2.FNumber,b2.FSeq,n2.FDataValue,b2.FUseOrgID from T_BAS_AssistantData b1 inner join T_BAS_AssistantData_L n1 on b1.FID=n1.FID and n1.FLocaleID=2052 inner join T_BAS_AssistantDataEntry b2 on b1.FID=b2.FID inner join T_BAS_AssistantDataEntry_L n2 on b2.FEntryID=n2.FEntryID and n2.FLocaleID=2052 where n1.FName like '%采购类型%' order by b1.FNumber,b2.FNumber,b2.FSeq
3. 数据中心：select t1.FDATACENTERID,t1.FNUMBER,t2.FNAME,t1.FDATABASENAME from T_BAS_DATACENTER t1 inner join T_BAS_DATACENTER_