用友T+幾個(gè)基礎(chǔ)檔案查詢(xún)語(yǔ)句
發(fā)布時(shí)間：2024-11-18
人工客服
特價(jià)活動(dòng):>>>> 用友U8、T6、T+、T3軟件產(chǎn)品4折優(yōu)惠，暢捷通T+cloud、好會(huì)計(jì)、易代賬、好業(yè)財(cái)、好生意云產(chǎn)品6-8折優(yōu)惠。
1.存貨檔案（存貨編碼、存貨名稱(chēng)、規(guī)格型號(hào)、存貨分類(lèi)名稱(chēng)）
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.倉(cāng)庫(kù)檔案（倉(cāng)庫(kù)編碼、倉(cāng)庫(kù)名稱(chēng)）
select wh.code as WhCode,wh.name as WhName from AA_Warehouse
3.部門(mén)檔案（部門(mén)編碼、部門(mén)名稱(chēng)）
select dep.code as DepCode,dep.name as DepName from AA_Department
4.客戶(hù)檔案（客戶(hù)編碼、客戶(hù)名稱(chēng)）
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)商名稱(chēng)）
select ven.code as VenCode,ven.name as VenName from AA_Partner as ven where ven.partnertype ='226'
