用友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')