用友T+幾個基礎(chǔ)檔案查詢語句
發(fā)布時間：2024-11-18
人工客服
特價活動:>>>> 用友U8、T6、T+、T3軟件產(chǎn)品4折優(yōu)惠，暢捷通T+cloud、好會計、易代賬、好業(yè)財、好生意云產(chǎn)品6-8折優(yōu)惠。
1.存貨檔案（存貨編碼、存貨名稱、規(guī)格型號、存貨分類名稱）
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.供應(yīng)商檔案（供應(yīng)商編碼、供應(yīng)商名稱）
select ven.code as VenCode,ven.name as VenName from AA_Partner as ven where ven.partnertype ='226'
