君泽-销售出库单带单价3 济南用友软件
发布时间：2014-12-22 23:54 文章来源：未知 被浏览次数： 次
SELECT RdRecord.cCode AS [出库单号],RdRecord.dDate AS [出库日期],RdRecord.cVouchType AS [单据类型编码],
RdRecords.cInvCode AS [存货编码],RdRecords.iQuantity AS [出库单数量],RdRecords.iUnitCost AS [出库单单价],
RdRecords.iPrice AS [出库单金额],Inventory.cInvName AS [存货名称],Inventory.cInvStd AS [规格型号],
ComputationUnit.cComUnitName AS [单位],Warehouse.cWhName AS [仓库名称],Customer.cCusAbbName AS [客户简称],
DispatchList.cDLCode AS [发货单号],DispatchList.dDate AS [发货单日期],SO_SOMain.cSOCode AS [销售订单号],
SO_SOMain.dDate AS [销售订单日期],SO_SOMain.cexch_name AS [币种名称],SO_SOMain.iExchRate AS [汇率],
SO_SODetails.iQuantity AS [销售订单数量],SO_SODetails.iUnitPrice AS [原币无税单价],
SO_SODetails.iTaxUnitPrice AS [原币含税单价],SO_SODetails.iMoney AS [原币无税金额],
SO_SODetails.iSum AS [原币价税合计],SO_SODetails.iNatUnitPrice AS [本币无税单价],
SO_SODetails.iNatMoney AS [本币无税金额],SO_SODetails.iNatSum AS [本币价税合计],SO_SODetails.iTaxRate AS [税率]
FROM RdRecord
INNER JOIN RdRecords ON RdRecord.ID = RdRecords.ID
INNER JOIN Inventory ON RdRecords.cInvCode = Inventory.cInvCode
INNER JOIN ComputationUnit ON Inventory.cComUnitCode = ComputationUnit.cComunitCode
INNER JOIN Warehouse ON RdRecord.cWhCode = Warehouse.cWhCode
INNER JOIN Customer ON RdRecord.cCusCode = Customer.cCusCode
INNER JOIN DispatchList ON RdRecord.cBusCode = DispatchList.cDLCode LEFT JOIN SO_SOMain
ON DispatchList.cSOCode = SO_SOMain.cSOCode
INNER JOIN SO_SODetails ON SO_SOMain.ID = SO_SODetails.ID WHERE RdRecord.cVouchType=32
◆ 相关内容
最新文章- ·生产-产成品入库跟踪表 济南用友
- [12-22]
- ·生产-采购订单执行统计表 jinany
- [12-22]
- ·君泽-销售出库单带单价3 济南用
- [12-22]
- ·销售出库单带单价2 济南用友
- [12-22]
- ·济南用友软件-销售出库单带单价1
- [12-22]
- · 济南用友生产执行明细表
- [12-22]
- ·君泽-生产现存量查询 济南用友软
- [12-22]
- ·济南用友发货单实际出库数量
- [12-20]
- ·济南用友，采购订单执行统计表
- [12-20]
- ·仓库-已领料生产物料在线管控表
- [12-20]
推荐阅读
