USP_DATALIST_MEMBERSHIPITEMPROMOTION_BYSALESORDERITEMID

Lists membership item promotions associated with a sales order item.

Parameters

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

Definition

Copy



                create procedure dbo.USP_DATALIST_MEMBERSHIPITEMPROMOTION_BYSALESORDERITEMID(
                    @SALESORDERITEMID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        [SOIMIP].[ID],
                        [SOIMIP].[PROMOTIONNAME],
                        [MEMBERSHIPPROMO].[PROMOTIONTYPECODE],
                        [MEMBERSHIPPROMO].[PROMOTIONTYPE],
                        [SOIMIP].[AMOUNT],
                        [SOIMIP].[EXTENSIONVALUE],
                        [SOIMIP].[EXTENSIONCALCULATIONTYPECODE],
                        [SOIMIP].[EXTENSIONCALCULATIONTYPE]
                    from dbo.[SALESORDERITEMMEMBERSHIPITEMPROMOTION] as [SOIMIP]
                    inner join dbo.[MEMBERSHIPPROMO]
                        on [SOIMIP].[MEMBERSHIPPROMOID] = [MEMBERSHIPPROMO].[ID]
                    where [SOIMIP].[SALESORDERITEMID] = @SALESORDERITEMID