USP_SIMPLEDATALIST_SALESORDERITEM_BYORDER

List of sales order items that are in the a specific order.

Parameters

Parameter	Parameter Type	Mode	Description
@SALESORDERID	uniqueidentifier	IN	Sales order ID

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_SALESORDERITEM_BYORDER(
                    @SALESORDERID uniqueidentifier
                )as

                select 
                    [SALESORDERITEM].[ID] as [VALUE],
                    dbo.[UFN_TRANSLATIONFUNCTION_SALESORDERITEM_WITHTOTAL]([SALESORDERITEM].[ID]) as [LABEL]
                from dbo.[SALESORDERITEM]
                where [SALESORDERITEM].[SALESORDERID] = @SALESORDERID