ðÒÉ×ÅÔ.
Select Inv.*,C.Text as CustomerText,D.Text as DepotText,cast(0.00 as
numeric(15,2)) as SaleAmount1
from Invoice03 Inv
inner join Depot D on D.IDKey=Inv.IDDepot and Inv.IDKey=?IDKey
left join Customer C on C.IDKey=Inv.IDCustomer
äÏÌÇÏ. IDKey = null
select A.IDKey as IDCommodity,
CT.TEXT as GroupText,
A.IDCOMMODITYTREE,
A.CODE1,
A.CODE2,
A.TEXT,
A.PROPERTYTEXT,
A.IDMEASURE,
A.TEXTAdd,
A.PROPERTYTEXTAdd,
A.IDMEASUREAdd,
A.CCol1 as HasNDS,
A.Factor,
case bgl_check_inscheme('COSTPRICE',?IDSCHEME)
when 1 then Rem.costprice
else null end as CostPrice,
case bgl_check_inscheme('SALEPRICE',?IDSCHEME)
when 1 then bgl_roundfloat(Rem.SalePrice*Ref5.RateAmount,3)
else bgl_roundfloat(
case Dep.IDColumn
when 0 then A.SalePrices
when 1 then A.SalePrices1
when 2 then A.SalePrices2
end*Ref5.RateAmount,3) end as SalePriceExpect,
case bgl_check_inscheme('SALEPRICE',?IDSCHEME)
when 1 then Rem.SALEPRICE
else null end as SALEPRICE,
case bgl_check_inscheme('USEBYDATE',?IDSCHEME)
when 1 then Rem.usebydate
else null end as UseByDate,
case bgl_check_inscheme('IDCOLOR',?IDSCHEME)
when 1 then Rem.idcolor
else null end as IDColor,
case bgl_check_inscheme('BARCODE',?IDSCHEME)
when 1 then Rem.barcode
else null end as Barcode,
case bgl_check_inscheme('PARAM1',?IDSCHEME)
when 1 then Rem.param1
else null end as Param1,
case bgl_check_inscheme('PARAM2',?IDSCHEME)
when 1 then Rem.param2
else null end as Param2,
sum(Rem.QUANTITY_REM) as Quantity
From(Commodity A
inner join REMAINDER_QUICK Rem on Rem.IDDepot=?IDDepot and
Rem.IDDate<=?IDDate and A.IDKey=Rem.IDCommodity and @@WhereSearch%0=0@)
inner join Depot Dep on Dep.IDKey=Rem.IDDepot
Left join SP_Get_Rate(?IDCurrencySale,?IDCurrency,?IDDate) Ref5 on 0=0
Left join CommodityTree CT on CT.IDKey=A.IDCommodityTree
group by 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21
á ÜÔÏ ÌÅÔÁÅÔ. ðÒÉËÏÌ ÉÍÅÎÎÏ × ÔÏÍ, ÞÔÏ ×ÏÚ×ÒÁÝÁÅÔ ÚÁÐÒÏÓ. åÓÌÉ ÎÅÔ ÄÁÎÎÙÈ,
ÔÏ ÄÏÌÇÏ. åÓÌÉ ÅÓÔØ - ÔÏ ÓÒÁÚÕ. õ ÍÅÎÑ ÕÖÅ ËÒÙÛÁ ÅÄÅÔ.
äÍÉÔÒÉÊ
--~--~---------~--~----~------------~-------~--~----~
-~----------~----~----~----~------~----~------~--~---
