金蝶云星空查询SQL
税率、仓库、部门、员工、供应商、客户、物料类别、物料查询、BOM查询、
辅助资料：工程项目、辅助资料：产品服务、科目、核算维度、科目余额、
未转采购订单的采购申请、采购订单未完结的：待接收的、
暂估应付： 未开票
--税率select rat.FNUMBER,rat.FTAXRATE, ratl.FNAME from T_BD_TAXRATE ratinner join T_BD_TAXRATE_L ratlon rat.FID=ratl.FID and ratl.FLOCALEID=2052;--仓库select stkl.FNAME,stk.FNUMBER,stk.FSTOCKPROPERTY, org.FNAME from t_bd_stock stkinner join T_BD_STOCK_L stklon stk.FSTOCKID=stkl.FSTOCKIDinner join T_ORG_ORGANIZATIONS_L orgon org.FORGID=stk.FUSEORGIDand org.FLOCALEID=2052order by org.FNAME ,stk.FNUMBER ;--部门select dpt.FNUMBER,dptl.FNAME ,org.FNAME ,dpt.FISDETAILDPTfrom T_BD_DEPARTMENT_L dptl inner join T_BD_DEPARTMENT dpt on dpt.FDEPTID=dptl.FDEPTIDand dptl.FLOCALEID=2052inner join T_ORG_ORGANIZATIONS_L orgon org.FORGID=dpt.FUSEORGID and org.FLOCALEID=2052where dpt.FISDETAILDPT =1and org.FNAME='所托（杭州）汽车智能设备有限公司';--员工select emp.FNUMBER,empl.FNAMEfrom T_HR_EMPINFO empinner join T_HR_EMPINFO_L emplon emp.FID=empl.FIDand empl.FLOCALEID=2052where emp.FNUMBER='0080'order by empl.FNAME--供应商select sup.FNUMBER,supl.FNAME,supbas.FADDRESS,supfin.FTAXREGISTERCODE as "纳税识别号",rat.FTAXRATE as "税率",ratl.fname as "税率1",( select term.FNAME from T_BD_PAYMENTCONDITION_L term where term.FID =supfin.FPAYCONDITION) as "付款条件"from T_BD_SUPPLIER supinner join T_BD_SUPPLIER_L suplon sup.FSUPPLIERID=supl.FSUPPLIERIDand supl.FLOCALEID=2052inner join T_BD_SUPPLIERBASE supbason supbas.FSUPPLIERID=sup.FSUPPLIERIDinner join T_BD_SUPPLIERFINANCE supfinon supfin.FSUPPLIERID=sup.FSUPPLIERIDleft join T_BD_TAXRATE raton supfin.FTAXRATEID=rat.FIDinner join T_BD_TAXRATE_L ratlon rat.FID=ratl.FID and ratl.FLOCALEID=2052where supl.FLOCALEID=2052--and sup.FNUMBER='10130086'and sup.FUSEORGID=100105;--客户select cus.FNUMBER,cusl.FNAME,org.FNAME,len(cus.FNUMBER)from T_BD_CUSTOMER cusinner join T_BD_CUSTOMER_L cuslon cus.FCUSTID=cusl.FCUSTIDand cusl.FLOCALEID=2052and cusl.FLOCALEID=2052inner join T_ORG_ORGANIZATIONS_L orgon org.FORGID=cus.FUSEORGID and org.FLOCALEID=2052where 1=1--and sup.FNUMBER='10130086'and len(cus.FNUMBER)<>8and cus.FUSEORGID=100105--单位select uom.FNUMBER,uoml.FNAME from T_BD_UNIT_L uoml inner join T_BD_UNIT uomon uom.FUNITID=uoml.FUNITID and uoml.FLOCALEID=2052--物料类别select itemg.FNUMBER,itemgl.FNAME ,(select t1.FNAME from T_BD_MATERIALGROUP_L t1 where t1.fid=itemglv.FGROUP1 )+'_'+ (select t1.FNAME from T_BD_MATERIALGROUP_L t1 where t1.fid=itemglv.FGROUP2 )+'_'+itemgl.FNAME from T_BD_MATERIALGROUP itemginner join T_BD_MATERIALGROUP_L itemglon itemg.fid=itemgl.FIDand itemgl.FLOCALEID=2052inner join T_BD_MATERIALGROUPLEVEL itemglvon itemg.FID=itemglv.FIDwhere itemglv.FLevel=3--物料查询select case when itembas.FERPCLSID =1 then '外购' when itembas.FERPCLSID =2 then '自制' when itembas.FERPCLSID =3 then '委外' when itembas.FERPCLSID =4 then '特征' when itembas.FERPCLSID =5 then '虚拟' when itembas.FERPCLSID =6 then '服务' when itembas.FERPCLSID =7 then '一次性'when itembas.FERPCLSID =9 then '配置'when itembas.FERPCLSID =10 then '资产'when itembas.FERPCLSID =11 then '费用'when itembas.FERPCLSID =12 then '模型'when itembas.FERPCLSID =13 then '产品系列' end as "物料属性",ORG.FNAME,ITEM.FNUMBER as "物料编码",ITEMCAL.FNUMBER as "物料类别", ITEML.FNAME as "物料名称",UOM.FNAME AS "单位",'有效' as "使用状态",'' as "用户物料类型",ITEML.FSPECIFICATION as "规格", item.F_PBQO_Text2 as "材质",item.FMnemonicCode as "助记码