USP_DATALIST_SALESMETHODDOCUMENT

List documents pertaining to a sales method

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SALESMETHODDOCUMENT
(
    @ID uniqueidentifier
)
as
    set nocount on;

    select
        ID,
        dbo.UFN_DOCUMENTTYPECODE_GETDESCRIPTION(DOCUMENTTYPECODEID) as DOCUMENTTYPE
    from
        dbo.SALESMETHODDOCUMENT
    where
        SALESMETHODID = @ID