| 123456789101112131415161718 |
-
- SELECT ifnull(pc.fdate,pc2.fdate) 单据日期,ifnull(pc.fno,pc2.fno)as 采购合同号,sc."fno" AS 销售合同号 , sc."foursname" 我方,
- ifnull(pc.supname,pc2.supname)as 供应商,sc.ctname as 客户,ifnull(t1.ctname,t2.ctname)as 多结算方
- FROM "salesContract" sc
- LEFT JOIN "View_salesOneClick" v_sale_po ON sc."oneClickSourceid" = v_sale_po."rid"
- AND sc."foursname" = V_SALE_PO."foursname" AND V_SALE_PO."contractType" ='采购合同'
- LEFT JOIN "purchaseContract" pc ON V_SALE_PO."contractId" = pc."id"
- LEFT JOIN "purchaseContract" pc2 ON sc."sourceid" = pc2."id"
- LEFT JOIN "multiPartyTrade" t1 ON t1."rid" = pc."id"
- LEFT JOIN "multiPartyTrade" t2 ON t2."rid" = pc2."id"
- WHERE 1=1
- AND IFNULL(sc."del_flag",0) <> 1
- AND IFNULL(pc."del_flag",0) <> 1
- AND ifnull(pc2."del_flag",0) <> 1
- AND (pc."pono" IS NOT NULL OR pc2."pono" IS NOT NULL)
- AND sc."placed" = 2
- and substr(ifnull(pc.fdate,pc2.fdate),1,4) = '2026'
|
