用友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'