用友T+几个基础档案查询语句

1.存货档案（存货编码、存货名称、规格型号、存货分类名称）

    select inv.code as InvCode,inv.name as InvName,
                                inv.specification as InvStd,
                                invclass.name as InvClassName from aa_inventory as inv
                                inner join AA_InventoryClass as invclass
                                on inv.idinventoryclass=invclass.id

2.仓库档案（仓库编码、仓库名称）

select wh.code as WhCode,wh.name as WhName from AA_Warehouse

3.部门档案（部门编码、部门名称）

select dep.code as DepCode,dep.name as DepName from AA_Department

4.客户档案（客户编码、客户名称）

select cus.code as CusCode,cus.name as CusName from AA_Partner as cus where cus.partnertype ='211'

5.供应商档案（供应商编码、供应商名称）

select ven.code as VenCode,ven.name as VenName from AA_Partner as ven where ven.partnertype ='226'