【用友U8】常用数据库表名
一、基础档案1、存货档案
select * from inventory
select * from inventory_extradefind
2、人员档案
select * from person
3、部门档案
select * from department
4、供应商档案
select * from vendor
5、客户档案
select * from customer
select * from customer_extradefind
6、计量单位档案
select * from tc_unit
7、仓库档案
select * from Warehouse
8、质量原因码档案(原因码档案)
select * from Reason
9、不良品处理方式档案(不良品处理方式)
select * from QMScrapDispose
…
二、库存管理
1、现存量查询
select * from CurrentStock
2、货位存量查询
select * from InvPositionSum
3、其他出库单
select * from rdrecord09
select * from rdrecords09
4、其他入库单
select * from RdRecord08
select * from RdRecords08
5、销售出库单
select * from RdRecord32
select * from RdRecords32
6、材料出库单
select * from RdRecord11
select * from RdRecords11
7、采购入库单
select * from RdRecord01
select * from RdRecords01
8、产成品入库单
select * from rdrecord10
select * from rdrecords10
三、销售管理
1、销售订单
select * from so_somain
select * from so_soDetails
2、-发货单
select * from DispatchList
select * from DispatchLists
3、销售专用发票
select * from SaleBillVouch
select * from SaleBillVouchs
四、采购管理
1、请购单
select * from PU_AppVouch
select * from PU_AppVouchs
2、采购订单
select * from PO_Pomain
select * from PO_Podetails
3、采购到货单
select * from PU_ArrivalVouch
select * from PU_ArrivalVouchs
4、采购专用发票
select * from PurBillVouch
select * from PurBillVouchs
5、供应商存货调价单、表
select * fromPU_PriceJustMain
select * from Ven_Inv_Price
五、质量管理
1、来料报检单
select * from QMInspectVoucher
select * from QMInspectVouchers
2、来料检验单
select * from QMCheckVoucher
select * from QMCheckVouchers
3、来料不良品处理单
select * from QMRejectVoucher
select * from QMRejectVouchers
select * from QMRejectVouchers_extradefine
六、财务
1、收款单
select * from AR_CloseListDetail
select * from AR_CloseList
select * from AR_Closeck
七、系统
1、单据系列号查询 及更改
select * from ufsystem…ua_identity where cvouchtype = ‘Somain’ --cacc_id = ‘705’ and 849059
select * from VoucherHistory where CardNumber=‘17’ and AutoId>36636
select * from VoucherHistory where AutoId=36723
–update VoucherHistory set cNumber=74 where AutoId=36723 --1231
————————————————
版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
原文链接:https://blog.csdn.net/qq_44759590/article/details/131850095
学习学习 来赚个分,踩一踩 布错,好好好。。。。。。。。。。。。 WU@先森 发表于 2024-4-22 10:15
存货档案的计量单位如何在数据库修改
select a.cinvcode,f.cinvstd,f.cinvname,b.cwhname,convert(float ,a.iquantity),
g.cComUnitName as MainUnit,g.iChangRate as mainrate,h.cComUnitName as asUnit,h.iChangRate as asRate
from currentstock as a inner join warehouse as b on a.cwhcode=b.cwhcode inner join v_inventory as f on a.cinvcode=f.cinvcodeinner join inventory_extradefine as fe on f.cinvcode=fe.cinvcode
left join (select * fromComputationUnit where bMainUnit =1) as g on g.cComUnitCode=f.cComUnitCode and g.cGroupCode =f.cGroupCode
left join (select * fromComputationUnit where bMainUnit =0) as h on h.cComUnitCode=f.cSTComUnitCode and h.cGroupCode =f.cGroupCode
where iQuantity>0 and a.cinvcode like '%'+'500291'+'%'
cinvcode cinvname cwhname storagepos kc MainUnit kcas asUnit cinvstd asRate mainrate
500291 PE膜 GE成品库 1号库 1003.5842 平米 17985.38 公斤 幅宽1500,厚度0.06-单面6丝单刨 17.921147 1.000000
500291 PE膜 辅料库 1号库 3584.40145 平米 64236.59 公斤 幅宽1500,厚度0.06-单面6丝单刨 17.921147 1.000000
17379467360 发表于 2024-4-1 11:18
也可以的哈,先谢谢您了!
https://pan.baidu.com/s/1spiPCOO_9nxbAi1tF4foAA?pwd=H974我上传到网盘了,自行下载吧
好,谢谢 多谢分享,学习了 u8数据字典谁有 我需要u8数据字典 hyy12345 发表于 2024-3-29 13:11
我需要u8数据字典
我自己都没有哈 有10.0的,需要吗? luckyh2023 发表于 2024-4-1 10:48
有10.0的,需要吗?
也可以的哈,先谢谢您了!
感谢分享,学习了 luckyh2023 发表于 2024-4-1 13:13
https://pan.baidu.com/s/1spiPCOO_9nxbAi1tF4foAA?pwd=H974我上传到网盘了,自行下载吧
...
跪谢。。。。 学习学习111
页:
[1]
2