USP_DATALIST_SALESORDER_EE7STUDENTPAYMENTS

Lists all student payments 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_EE7STUDENTPAYMENTS
            (
                @CONTEXTID uniqueidentifier
            )
            as
                set nocount on;

                select
                    [SALESORDERITEM].[ID],
                    [SALESORDERITEM].[DESCRIPTION],
                    [SALESORDERITEM].[PRICE],
                    [SALESORDERITEM].[QUANTITY],
                    [SALESORDERITEM].[TOTAL],
                    [SALESORDERITEM].[TYPECODE],
                    [SALESORDERITEM].[DATA],
                    [SALESORDERITEM].[CALLBACKURL]
                from dbo.[SALESORDERITEM]
                where 
                    ([SALESORDERITEM].[TYPECODE] = 15) and
                    ([SALESORDERITEM].[SALESORDERID] = @CONTEXTID)