用友U8供应商存货价格表查询语句

SELECT 
       (0) AS listserialnum,
       ' ' AS selcol,
       (btaxcost) AS btaxcost,
       (cvenabbname) AS cvenabbname,
       (cvenname) AS cvenname,
       (cinvcode) AS cinvcode,
       (cinvname) AS cinvname,
       (cinvstd) AS cinvstd,
       (ccomunitname) AS ccomunitname,
       (dstartdate) AS dstartdate,
       (denddate) AS denddate,
       (cexch_name) AS cexch_name,
       (bsales) AS bsales,
       (fminquantity) AS fminquantity,
       (iunitprice) AS iunitprice,
       (itaxrate) AS itaxrate,
       (itaxunitprice) AS itaxunitprice,
       (isupplytype) AS isupplytype,
       (cinvaddcode) AS cinvaddcode,
       (ctermcode) AS ctermcode,
       (ctermname) AS ctermname,
       (ipriceid) AS ipriceid,
       (cvencode) AS cvencode,
       (ccomunitcode) AS ccomunitcode,
       (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,
       (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,
       (pricejustid) AS pricejustid,
       (csource) AS csource,
       (csourcecode) AS csourcecode,
       (csourceautoid) AS csourceautoid,
       (cmainmemo) AS cmainmemo,
       (cbodymemo) AS cbodymemo,
       cdefine22,
       cdefine23,
       cdefine24,
       cdefine25,
       cdefine26,
       cdefine27,
       cdefine28,
       cdefine29,
       cdefine30,
       cdefine31,
       cdefine32,
       cdefine33,
       cdefine34,
       cdefine35,
       cdefine36,
       cdefine37,
       cinvccode,
       cinvcname,
       (cveninvcode) AS cveninvcode,
       (cveninvname) AS cveninvname,
       extend_b_cinvcode_v_inventory_caddress
FROM pu_veninvpricelst
    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 = pu_veninvpricelst.cinvcode
WHERE 1 = 1
      AND
      (
          1 = 1
          AND
          (
              (dstartdate >= N'2023-09-01')
              AND (dstartdate <= N'2023-09-12')
          )
      );