用友U8采购订单查询SQL

SELECT PO_Pomain.dCloseDate AS 关闭日期,
       PO_Pomain.cappcode AS 请购单号,
       PO_Pomain.cVenPerson AS 供方联系人,
       PO_Pomain.ireturncount AS 打回次数,
       PO_Pomain.cBG_Auditor AS 预算审批人,
       PO_Pomain.cVenBank AS 供方银行名称,
       PO_Pomain.ControlResult AS 控制结果,
       PO_Pomain.cModifyDate AS 修改日期,
       PO_Pomain.cContactCode AS 供方联系人编码,
       PO_Pomain.cChangAuditDate AS 变更审核日期,
       PO_Pomain.cAuditTime AS 审核时间,
       PO_Pomain.cReviser AS 修改人,
       PO_Pomain.cVenAccount AS 供方银行账号,
       PO_Pomain.iverifystateex AS 单据审核状态,
       PO_Pomain.ccleanver AS 卸载版本,
       PO_Pomain.cAuditDate AS 审核日期,
       PO_Pomain.cmaketime AS 制单时间,
       PO_Pomain.iPrintCount AS 打印次数,
       PO_Pomain.cChangVerifier AS 变更审核人,
       PO_Pomain.cVenPUOMProtocol AS 收付款协议编码,
       PO_Pomain.iBG_OverFlag AS 预算审批状态,
       PO_Pomain.cBG_AuditTime AS 预算审批时间预算审批人,
       PO_Pomain.IsWfControlled AS 是否启用工作流,
       PO_Pomain.cChangAuditTime AS 变更审核时间,
       PO_Pomain.dCloseTime AS 关闭时间,
       PO_Pomain.cCurrentAuditor AS 当前审批人,
       PO_Pomain.csysbarcode AS 单据条码,
       PO_Pomain.cModifyTime AS 修改时间,
       PO_Pomain.cPOID AS 采购订单号,
       PO_Pomain.dPODate AS 单据日期,
       PO_Pomain.cVenCode AS 供应商编码,
       PO_Pomain.cDepCode AS 部门编码,
       PO_Pomain.cPersonCode AS 业务员编码,
       PO_Pomain.cPTCode AS 采购类型编码,
       PO_Pomain.cArrivalPlace AS 到货地址,
       PO_Pomain.cSCCode AS 发运方式编码,
       PO_Pomain.cexch_name AS 币种名称,
       PO_Pomain.nflat AS 汇率,
       PO_Pomain.iTaxRate AS 表头税率,
       PO_Pomain.cPayCode AS 付款条件编码,
       PO_Pomain.iCost AS 运费,
       PO_Pomain.iBargain AS 订金,
       PO_Pomain.cMemo AS 备注,
       PO_Pomain.cState AS 状态,
       PO_Pomain.cPeriod AS 物料需求计划周期,
       PO_Pomain.cMaker AS 制单人,
       PO_Pomain.cVerifier AS 审核人,
       PO_Pomain.cCloser AS 关闭人,
       PO_Pomain.POID AS 采购订单主表标识,
       PO_Pomain.iVTid AS 单据模版号,
       PO_Pomain.ufts AS 时间戳,
       PO_Pomain.cChanger AS 变更人,
       PO_Pomain.cLocker AS 锁定人,
       PO_Podetails.cxjspdids AS 询价审批单子表id,
       PO_Podetails.cBG_CaliberKey6 AS 口径6类型编码,
       PO_Podetails.cBG_CaliberKeyName2 AS 口径2类型名称,
       PO_Podetails.fPoRefuseQuantity AS 拒收数量,
       PO_Podetails.cBG_CaliberName2 AS 口径2名称,
       PO_Podetails.planlotnumber AS 计划代号,
       PO_Podetails.cBG_CaliberName5 AS 口径5名称,
       PO_Podetails.fPoArrNum AS 到货件数,
       PO_Podetails.iorderdid AS 销售订单子表ID,
       PO_Podetails.iBG_Ctrl AS 是否预算控制,
       PO_Podetails.csoordercode AS 销售订单号,
       PO_Podetails.fPoRetNum AS 退货件数,
       PO_Podetails.fPoRefuseNum AS 拒收件数,
       PO_Podetails.fexnum AS 出口件数,
       PO_Podetails.fPoValidQuantity AS 合格数量,
       PO_Podetails.cBG_CaliberName6 AS 口径6名称,
       PO_Podetails.cBG_CaliberCode3 AS 口径3编码,
       PO_Podetails.cBG_CaliberCode1 AS 口径1编码,
       PO_Podetails.cBG_CaliberKeyName6 AS 口径6类型名称,
       PO_Podetails.freceivedqty AS 合格品入库数量,
       PO_Podetails.cBG_CaliberName1 AS 口径1名称,
       PO_Podetails.irowno AS 行号,
       PO_Podetails.ContractCode AS 合同号,
       PO_Podetails.fPoValidNum AS 合格件数,
       PO_Podetails.cBG_CaliberName4 AS 口径4名称,
       PO_Podetails.cBG_CaliberKeyName4 AS 口径4类型名称,
       PO_Podetails.ivouchrowno AS 行号,
       PO_Podetails.fexquantity AS 出口数量,
       PO_Podetails.cBG_ItemName AS 预算项目,
       PO_Podetails.iordertype AS 销售订单类型,
       PO_Podetails.cbCloseTime AS 行关闭时间,
       PO_Podetails.cBG_ItemCode AS 预算项目编码,
       PO_Podetails.cBG_CaliberKey3 AS 口径3类型编码,
       PO_Podetails.cBG_CaliberName3 AS 口径3名称,
       PO_Podetails.freceivednum AS 合格品入库数量件数,
       PO_Podetails.iorderseq AS 销售订单类型,
       PO_Podetails.iInvMPCost AS 最高进价,
       PO_Podetails.cBG_CaliberKey4 AS 口径4类型编码,
       PO_Podetails.fPoRetQuantity AS 退货数量,
       PO_Podetails.cbsysbarcode AS 行条码,
       PO_Podetails.bgift AS 是否赠品,
       PO_Podetails.ContractRowNo AS 合同标的编码,
       PO_Podetails.fPoArrQuantity AS 到货数量,
       PO_Podetails.cbCloseDate AS 行关闭日期,
       PO_Podetails.cbMemo AS 行备注,
       PO_Podetails.ID AS 采购订单子表标识,
       PO_Podetails.cInvCode AS 存货编码,
       PO_Podetails.iQuantity AS 数量,
       PO_Podetails.iNum AS 辅计量数量,
       PO_Podetails.iQuotedPrice AS 报价,
       PO_Podetails.iUnitPrice AS 原币无税单价,
       PO_Podetails.iMoney AS 原币无税金额,
       PO_Podetails.iTax AS 原币税额,
       PO_Podetails.iSum AS 原币价税合计,
       PO_Podetails.iDisCount AS 原币折扣额,
       PO_Podetails.iNatUnitPrice AS 本币无税单价,
       PO_Podetails.iNatMoney AS 本币无税金额,
       PO_Podetails.iNatTax AS 本币税额,
       PO_Podetails.iNatSum AS 本币价税合计,
       PO_Podetails.iNatDisCount AS 本币折扣额,
       PO_Podetails.dArriveDate AS 计划到货日期,
       PO_Podetails.iReceivedQTY AS 累计到货数量,
       PO_Podetails.iReceivedNum AS 累计到货辅计量数量,
       PO_Podetails.iReceivedMoney AS 累计原币到货金额,
       PO_Podetails.iInvQTY AS 累计发票数量,
       PO_Podetails.iInvNum AS 累计发票辅计量数量,
       PO_Podetails.iInvMoney AS 累计原币发票金额,
       PO_Podetails.cFree1 AS 存货自由项1,
       PO_Podetails.cFree2 AS 存货自由项2,
       PO_Podetails.iNatInvMoney AS 累计本币发票金额,
       PO_Podetails.iOriTotal AS 累计原币付款,
       PO_Podetails.iTotal AS 累计本币付款,
       PO_Podetails.iPerTaxRate AS 税率,
       PO_Podetails.cItemCode AS 项目编码,
       PO_Podetails.cItem_class AS 项目大类编码,
       PO_Podetails.cItemName AS 项目名称,
       PO_Podetails.cFree3 AS 存货自由项3,
       PO_Podetails.cFree4 AS 存货自由项4,
       PO_Podetails.cFree5 AS 存货自由项5,
       PO_Podetails.cFree6 AS 存货自由项6,
       PO_Podetails.cFree7 AS 存货自由项7,
       PO_Podetails.cFree8 AS 存货自由项8,
       PO_Podetails.cFree9 AS 存货自由项9,
       PO_Podetails.cFree10 AS 存货自由项10,
       PO_Podetails.bGsp AS 是否质检,
       PO_Podetails.cUnitID AS 计量单位编码,
       PO_Podetails.iTaxPrice AS 原币含税单价,
       PO_Podetails.iArrQTY AS 到货数量,
       PO_Podetails.iArrNum AS 到货辅计量数量,
       PO_Podetails.iArrMoney AS 原币到货金额,
       PO_Podetails.iNatArrMoney AS 本币到货金额,
       PO_Podetails.iAppIds AS 采购请购单子表标识,
       PO_Podetails.cDefine28 AS 表体自定义项28,
       PO_Podetails.cDefine29 AS 表体自定义项29,
       PO_Podetails.cDefine30 AS 表体自定义项30,
       PO_Podetails.cDefine31 AS 表体自定义项31,
       PO_Podetails.cDefine32 AS 表体自定义项32,
       PO_Podetails.cDefine33 AS 表体自定义项33,
       PO_Podetails.cDefine34 AS 表体自定义项34,
       PO_Podetails.cDefine35 AS 表体自定义项35,
       PO_Podetails.cDefine36 AS 表体自定义项36,
       PO_Podetails.cDefine37 AS 表体自定义项37,
       PO_Podetails.iSOsID AS 销售订单子表标识,
       PO_Podetails.cSource AS 单据来源,
       PO_Podetails.cbCloser AS 行关闭人,
       PO_Podetails.SoDId AS 需求跟踪子表ID,
       PO_Podetails.ContractRowGUID AS 合同子表表识,
       Vendor.cVenName AS 供应商名称,
       Person.cPersonName AS 采购员,
       Department.cDepName AS 采购部门,
       Inventory.cInvStd AS 物料规格,
       Inventory.cInvName AS 存货名称,
       InventoryClass.cInvCName 存货分类名称
FROM dbo.PO_Pomain
    JOIN dbo.PO_Podetails
        ON PO_Podetails.POID = PO_Pomain.POID
    JOIN dbo.Vendor
        ON Vendor.cVenCode = PO_Pomain.cVenCode
    JOIN dbo.Person
        ON Person.cPersonCode = PO_Pomain.cPersonCode
    JOIN dbo.Department
        ON Department.cDepCode = dbo.PO_Pomain.cDepCode
    JOIN dbo.Inventory
        ON Inventory.cInvCode = PO_Podetails.cInvCode
    JOIN dbo.InventoryClass
        ON InventoryClass.cInvCCode = Inventory.cInvCCode;