USP_DATALIST_DOCUMENTPRINTINGRULE

List printing rules for a document.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_DOCUMENTPRINTINGRULE(@DOCUMENTID uniqueidentifier)
                as
                    set nocount on;

                    select DOCUMENTPRINTINGRULE.ID,
                           DELIVERYMETHOD.NAME,
                           dbo.UFN_DOCUMENTPRINTINGRULE_SALESMETHODSLIST(DOCUMENTPRINTINGRULE.ID) SALESMETHODS
                    from dbo.DOCUMENTPRINTINGRULE inner join dbo.DELIVERYMETHOD on
                        DOCUMENTPRINTINGRULE.DELIVERYMETHODID = DELIVERYMETHOD.ID
                    where DOCUMENTID = @DOCUMENTID