用友T+几个基础档案查询语句
发布时间：2022-4-1
特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠，畅捷通T+cloud、好会计、易代账、好业财、好生意云产品6-8折优惠。
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'
