| | |
|---|
| | | ,f.FTAXCOMBINATION as HTAXCOMBINATION,b.FSAMPLEDAMAGEQTY as HSAMPLEDAMAGEQTY,b.FSAMPLEDAMAGEBASEQTY as HSAMPLEDAMAGEBASEQTY,a.FOWNERTYPEID as HOWNERTYPEID,a.FOWNERID as HOWNERID,a.FBFLOWID as HBFLOWID |
|---|
| | | ,isnull(fin.FPAYORGID,0) as HPAYORGID,isnull(fin.FSETTLEORGID,0) as HSETTLEORGID,isnull(fin.FSETTLECURRID,0) as HSETTLECURRID,isnull(fin.FSETTLEMODEID,0) as HSETTLEMODEID,isnull(fin.FEXCHANGETYPEID,0) as HEXCHANGETYPEID ,isnull(fin.FPAYCONDITONID,0) as HPAYCONDITONID |
|---|
| | | ,isnull(fin.FEXCHANGERATE,0) as HEXCHANGERATE,isnull(fin.FLOCALCURRID,0) as HLOCALCURRID,isnull(fin.FISINCLUDEDTAX,0) as HISINCLUDEDTAX,isnull(fin.FISPRICEEXCLUDETAX,0) as HISPRICEEXCLUDETAX |
|---|
| | | ,isnull(t.FTAXRATEID,0) as HTAXRATEID,isnull(t.FCOSTPERCENT,0) as HCOSTPERCENT,isnull(t.FCOSTAMOUNT,0) as HCOSTAMOUNT,isnull(t.FVAT,0),isnull(t.FSELLERWITHHOLDING,0) as HSELLERWITHHOLDING,isnull(t.FBUYERWITHHOLDING,0) as HBUYERWITHHOLDING |
|---|
| | | ,isnull(t.FTAXRATEID,0) as HTAXRATEID,isnull(t.FCOSTPERCENT,0) as HCOSTPERCENT,isnull(t.FCOSTAMOUNT,0) as HCOSTAMOUNT,isnull(t.FVAT,0),isnull(t.FSELLERWITHHOLDING,0) as HSELLERWITHHOLDING,isnull(t.FBUYERWITHHOLDING,0) as HBUYERWITHHOLDING,a.FSalOutStockBillNo as HSalOutStockBillNo,isnull(a.FSalOutStockEntryId,0) as HSalOutStockEntryId |
|---|
| | | from T_PUR_RECEIVEENTRY a with(nolock) |
|---|
| | | inner join T_PUR_RECEIVEENTRY_S b with(nolock) on a.FENTRYID=b.FENTRYID |
|---|
| | | left join T_PUR_RECEIVEENTRY_F f with(nolock) on a.FENTRYID=f.FENTRYID |
|---|
