您好,登錄后才能下訂單哦!
以系統(tǒng)中的供應(yīng)商基礎(chǔ)資料為例,因?yàn)榇嘶A(chǔ)資料是分配型的,所以在開(kāi)發(fā)相關(guān)的簡(jiǎn)單賬表和其他類型賬表的時(shí)候,要注意拼接條件的不同;
select t1.fdate Fdate,FPURCHASEORGID,
FREALQTY Fqty,t3.FAPJOINAMOUNT/t2.FREALQTY Fprice,t3.FAPJOINAMOUNT Famount,FMATERIALID,t4.fmasterid FSUPPLIERID,FSTOCKID,FSTOCKDEPTID,t1.FDOCUMENTSTATUS
from (select fbillno,fdate,FSUPPLIERID,FSTOCKDEPTID,fid,FPURCHASEORGID,FDOCUMENTSTATUS,FSTOCKORGID from T_STK_INSTOCK where fid>1) t1
inner join (select FSTOCKID,fid,FREALQTY,FMATERIALID,FENTRYID from T_STK_INSTOCKentry where FENTRYID>1) t2 on t1.fid=t2.fid
inner join (select FENTRYID,FAPJOINAMOUNT from T_STK_INSTOCKENTRY_F where FENTRYID>1) t3 on t2.FENTRYID=t3.FENTRYID
inner join t_bd_supplier t4 on t1.FSUPPLIERID =t4.FSUPPLIERID and t1.FSTOCKORGID=FUSEORGID
where 1=1 {0}
注:入庫(kù)單中的供應(yīng)商字段后臺(tái)存的id是與供應(yīng)商基礎(chǔ)資料的FSUPPLIERID相對(duì)應(yīng)(t1.FSUPPLIERID =t4.FSUPPLIERID ),但是如果過(guò)濾框中如果使用了供應(yīng)商條件的話,它傳到臨時(shí)表中的id是fmasterid,所以要轉(zhuǎn)換下!
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。