USP_DATALIST_SALESORDER_RE7DONATIONS

Lists all donations belonging to a sales order.

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_SALESORDER_RE7DONATIONS
            (
                @CONTEXTID uniqueidentifier
            )
            as
                set nocount on;

                select
                    [SALESORDERITEM].[ID],
                    [SALESORDERITEM].[DESCRIPTION],
                    [SALESORDERITEM].[PRICE],
                    CAST([SALESORDERITEM].[QUANTITY] as INT) as [QUANTITY],
                    [SALESORDERITEM].[TOTAL],
                    [SALESORDERITEM].[TYPECODE],
                    [SALESORDERITEMRE7DONATION].[ECARDSDATA]
                from dbo.[SALESORDERITEM]
                inner join dbo.[SALESORDERITEMRE7DONATION]
                    on [SALESORDERITEM].[ID] = [SALESORDERITEMRE7DONATION].[ID]
                where 
                    [SALESORDERITEM].[SALESORDERID] = @CONTEXTID