用友U8供应商存货调价历史查询语句-Toy模板网

这篇具有很好参考价值的文章主要介绍了用友U8供应商存货调价历史查询语句。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

SELECT
(0) AS listserialnum,
' ' AS selcol,
(btaxcost) AS btaxcost,
(ccode) AS ccode,
(dupdate) AS dupdate,
(ddate) AS ddate,
(cdepname) AS cdepname,
(cpersonname) AS cpersonname,
(cmainmemo) AS cmainmemo,
(cmaker) AS cmaker,
(cverifier) AS cverifier,
(dverifydate) AS dverifydate,
(isupplytype) AS isupplytype,
(iunitprice) AS iunitprice,
(itaxunitprice) AS itaxunitprice,
(cinvcode) AS cinvcode,
(cinvname) AS cinvname,
(cinvstd) AS cinvstd,
(cvenabbname) AS cvenabbname,
(ccomunitname) AS ccomunitname,
(itaxrate) AS itaxrate,
(fminquantity) AS fminquantity,
(bsales) AS bsales,
(dstartdate) AS dstartdate,
(denddate) AS denddate,
(cbodymemo) AS cbodymemo,
(operationtype) AS operationtype,
(cexch_name) AS cexch_name,
(iverifystate) AS iverifystate,
(ireturncount) AS ireturncount,
(iswfcontrolled) AS iswfcontrolled,
(cdepcode) AS cdepcode,
(cdefine5) AS cdefine5,
(cdefine6) AS cdefine6,
(cdefine7) AS cdefine7,
(cdefine8) AS cdefine8,
(cdefine9) AS cdefine9,
(cdefine10) AS cdefine10,
(cdefine11) AS cdefine11,
(cdefine12) AS cdefine12,
(cdefine13) AS cdefine13,
(cdefine14) AS cdefine14,
(cdefine15) AS cdefine15,
(cdefine16) AS cdefine16,
(cdefine1) AS cdefine1,
(cdefine2) AS cdefine2,
(cdefine3) AS cdefine3,
(cdefine4) AS cdefine4,
(cpersoncode) AS cpersoncode,
(ivtid) AS ivtid,
(ipriceid) AS ipriceid,
(cinvccode) AS cinvccode,
(cinvcname) AS cinvcname,
(cinvaddcode) AS cinvaddcode,
(cvenname) AS cvenname,
(ccomunitcode) AS ccomunitcode,
(cvencode) AS cvencode,
(cdefine22) AS cdefine22,
(cdefine23) AS cdefine23,
(cdefine24) AS cdefine24,
(cdefine25) AS cdefine25,
(cdefine26) AS cdefine26,
(cdefine27) AS cdefine27,
(cdefine28) AS cdefine28,
(cdefine29) AS cdefine29,
(cdefine30) AS cdefine30,
(cdefine31) AS cdefine31,
(cdefine32) AS cdefine32,
(cdefine33) AS cdefine33,
(cdefine34) AS cdefine34,
(cdefine35) AS cdefine35,
(cdefine36) AS cdefine36,
(cdefine37) AS cdefine37,
(cinvdefine1) AS cinvdefine1,
(cinvdefine2) AS cinvdefine2,
(cinvdefine3) AS cinvdefine3,
(cinvdefine4) AS cinvdefine4,
(cinvdefine5) AS cinvdefine5,
(cinvdefine6) AS cinvdefine6,
(cinvdefine7) AS cinvdefine7,
(cinvdefine8) AS cinvdefine8,
(cinvdefine9) AS cinvdefine9,
(cinvdefine10) AS cinvdefine10,
(cinvdefine11) AS cinvdefine11,
(cinvdefine12) AS cinvdefine12,
(cinvdefine13) AS cinvdefine13,
(cinvdefine14) AS cinvdefine14,
(cinvdefine15) AS cinvdefine15,
(cinvdefine16) AS cinvdefine16,
(id) AS id,
(cfree1) AS cfree1,
(cfree2) AS cfree2,
(cfree3) AS cfree3,
(cfree4) AS cfree4,
(cfree5) AS cfree5,
(cfree6) AS cfree6,
(cfree7) AS cfree7,
(cfree8) AS cfree8,
(cfree9) AS cfree9,
(cfree10) AS cfree10,
(pricejustid) AS pricejustid,
cbdefine20,
cbdefine21,
chdefine8,
cbdefine34
--INTO tempdb..[TMPUF_103235815_Lst118302118556]
FROM v_pupricejust
LEFT JOIN
(
SELECT cbdefine20 AS cbdefine20,
cbdefine21 AS cbdefine21,
cbdefine34 AS cbdefine34,
autoid AS keyextend_b_autoid_pu_pricejustdetail_extradefine_autoid
FROM PU_PriceJustDetail_extradefine
) extend_b_autoid_pu_pricejustdetail_extradefine
ON keyextend_b_autoid_pu_pricejustdetail_extradefine_autoid = v_pupricejust.pricejustautoid
LEFT JOIN
(
SELECT chdefine8 AS chdefine8,
id AS keyextend_t_id_pu_pricejustmain_extradefine_id
FROM PU_PriceJustMain_extradefine
) extend_t_id_pu_pricejustmain_extradefine
ON keyextend_t_id_pu_pricejustmain_extradefine_id = v_pupricejust.pricejustid
LEFT JOIN
(
SELECT cEngineerFigNo AS extend_b_cinvcode_v_inventory_cengineerfigno,
cAddress AS extend_b_cinvcode_v_inventory_caddress,
cInvCode AS keyextend_b_cinvcode_v_inventory_cinvcode
FROM v_inventory
) extend_b_cinvcode_v_inventory
ON keyextend_b_cinvcode_v_inventory_cinvcode = v_pupricejust.cinvcode
WHERE (ddate >= N'2023-09-01')
AND (ddate <= N'2023-09-08')

文章来源地址https://www.toymoban.com/news/detail-707734.html