USP_DATALIST_CREDITREFUNDMERCHANDISE

Lists all merchandise items belonging to a refund.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_CREDITREFUNDMERCHANDISE
            (
                @CONTEXTID uniqueidentifier
            )
            as
                set nocount on;

                select CREDITITEM.SALESORDERITEMID ID,
                       SALESORDERITEM.DESCRIPTION DESCRIPTION,
                       MERCHANDISEPRODUCTINSTANCE.BARCODE,
                       CREDITITEM.QUANTITY,
                       CREDITITEM.PRICE,
                       [CREDITITEM].[DISCOUNTS],
                       CREDITITEM.TOTAL,
                       SALESORDERITEM.SALESORDERID
                from dbo.CREDITITEM
                inner join dbo.[CREDIT] on [CREDIT].[ID] = [CREDITITEM].[CREDITID]
                inner join dbo.[SALESORDERITEM] on [CREDITITEM].[SALESORDERITEMID] = [SALESORDERITEM].[ID]
                inner join dbo.[SALESORDERITEMMERCHANDISE] on [SALESORDERITEMMERCHANDISE].[ID] = [SALESORDERITEM].[ID]
                inner join dbo.[MERCHANDISEPRODUCTINSTANCE] 
                    on [MERCHANDISEPRODUCTINSTANCE].[ID] = [SALESORDERITEMMERCHANDISE].[MERCHANDISEPRODUCTINSTANCEID]
                where CREDITID = @CONTEXTID
                and [CREDIT].[TYPECODE] = 0