USP_DATALIST_STOCKSALESBYTRANSACTION
Returns a list of stock sales for a transaction.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_STOCKSALESBYTRANSACTION
(
@REVENUEID uniqueidentifier
)
as
set nocount on
select
STOCKSALE.ID,
STOCKSALE.SALEDATE as [DATE],
STOCKSALE.SALEAMOUNT as [AMOUNT],
STOCKSALE.SALEPOSTSTATUSCODE,
case when exists ( select 1 from dbo.STOCKSALEADJUSTMENT
where STOCKSALEID = STOCKSALE.ID and
STOCKSALEADJUSTMENT.POSTSTATUSCODE = 1) then 1
else 0
end HASUNPOSTEDADJUSTMENTS,
STOCKSALE.TRANSACTIONSALEAMOUNT as [TRANSACTIONAMOUNT],
STOCKSALE.SALEAMOUNT as [BASEAMOUNT],
STOCKSALE.ORGANIZATIONSALEAMOUNT as [ORGANIZATIONAMOUNT],
STOCKSALE.TRANSACTIONCURRENCYID,
STOCKSALE.BASECURRENCYID,
dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY() ORGANIZATIONCURRENCYID,
case
when ( select top 1 POSTSTATUSCODE
from dbo.STOCKSALEADJUSTMENT
where STOCKSALEID = STOCKSALE.ID
order by STOCKSALEADJUSTMENT.DATEADDED desc) = 2 then cast(1 as bit)
else cast(0 as bit)
end HASDONOTPOSTADJUSTMENT
from dbo.REVENUEPAYMENTMETHOD
inner join dbo.STOCKDETAIL on REVENUEPAYMENTMETHOD.ID = STOCKDETAIL.ID
inner join dbo.STOCKSALE on STOCKDETAIL.ID = STOCKSALE.STOCKDETAILID
where REVENUEPAYMENTMETHOD.REVENUEID = @REVENUEID
order by STOCKSALE.SALEDATE