USP_DATAFORMTEMPLATE_VIEW_RECEIPTINGPROCESS

The load procedure used by the view dataform template "Receipting Process View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@IDSETREGISTERNAME	nvarchar(100)	INOUT	Include selection
@DESCRIPTION	nvarchar(255)	INOUT	Description
@CREATEOUTPUTIDSET	nvarchar(3)	INOUT	Create output selection
@OUTPUTIDSETRECORDTYPENAME	nvarchar(100)	INOUT	Output selection type
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Output selection name
@OVERWRITEOUTPUTIDSET	nvarchar(3)	INOUT	Overwrite existing selection
@RECEIPTDATE	datetime	INOUT	Receipt date
@MARKRECEIPTED	nvarchar(3)	INOUT	Mark revenue 'Receipted'
@OUTPUTFORMAT	nvarchar(255)	INOUT	Output format
@LETTERFILENAME	nvarchar(255)	INOUT	Letter template
@LABELFILENAME	nvarchar(255)	INOUT	Label template
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	BUSINESSPROCESSCATALOGID
@PARAMETERSID	uniqueidentifier	INOUT	PARAMETERSID
@RECEIPTTYPE	nvarchar(30)	INOUT	Receipt type
@RECEIPTTYPECODE	tinyint	INOUT	RECEIPTTYPECODE
@EXPORTDEFINITION	nvarchar(200)	INOUT	Export definition

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RECEIPTINGPROCESS
                (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @NAME nvarchar(100) = null output, 
                @IDSETREGISTERNAME nvarchar(100) = null output, 
                @DESCRIPTION nvarchar(255) = null output, 
                @CREATEOUTPUTIDSET nvarchar(3) = null output,
                @OUTPUTIDSETRECORDTYPENAME nvarchar(100) = null output, 
                @OUTPUTIDSETNAME nvarchar(100) = null output, 
                @OVERWRITEOUTPUTIDSET nvarchar(3) = null output,                
                @RECEIPTDATE datetime = null output,
                @MARKRECEIPTED nvarchar(3) = null output,
                @OUTPUTFORMAT nvarchar(255) = null output,
                @LETTERFILENAME nvarchar(255) = null output,
                @LABELFILENAME nvarchar(255) = null output,
                @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                @PARAMETERSID uniqueidentifier = null output,
                @RECEIPTTYPE nvarchar(30) = null output,
                @RECEIPTTYPECODE tinyint = null output,
                @EXPORTDEFINITION nvarchar(200) = null output
                )
            as
            begin
                set nocount on

                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @NAME = RECEIPTINGPROCESS.NAME, 
                    @IDSETREGISTERNAME =  dbo.UFN_IDSET_GETNAME(IDSETREGISTERID), 
                    @DESCRIPTION = RECEIPTINGPROCESS.DESCRIPTION, 
                    @CREATEOUTPUTIDSET = case RECEIPTINGPROCESS.CREATEOUTPUTIDSET when 0 then 'No' else 'Yes' end,
                    @OUTPUTIDSETRECORDTYPENAME = dbo.UFN_TRANSLATIONFUNCTION_RECORDTYPE_GETNAME(RECEIPTINGPROCESS.OUTPUTIDSETRECORDTYPEID), 
                    @OUTPUTIDSETNAME = RECEIPTINGPROCESS.OUTPUTIDSETNAME, 
                    @OVERWRITEOUTPUTIDSET = case RECEIPTINGPROCESS.OVERWRITEOUTPUTIDSET when 0 then 'No' else 'Yes' end,                    
                    @RECEIPTDATE = case RECEIPTINGPROCESS.MARKRECEIPTED when 1 then case RECEIPTINGPROCESS.RECEIPTDATETYPECODE when 0 then getdate() else RECEIPTINGPROCESS.RECEIPTDATE end end,
                    @MARKRECEIPTED = case RECEIPTINGPROCESS.MARKRECEIPTED when 0 then 'No' else 'Yes' end,
                    @OUTPUTFORMAT = dbo.UFN_BUSINESSPROCESSVIEW_GETNAME(RECEIPTINGPROCESS.BUSINESSPROCESSVIEWID),
                    @LETTERFILENAME = RECEIPTINGPROCESS.LETTERFILENAME,
                    @LABELFILENAME = RECEIPTINGPROCESS.LABELFILENAME,
                    @BUSINESSPROCESSCATALOGID = '83048DED-208E-45c9-852C-E7D5C7317882',
                    @PARAMETERSID = @ID,
                    @RECEIPTTYPE = RECEIPTINGPROCESS.RECEIPTTYPE,
                    @RECEIPTTYPECODE = RECEIPTINGPROCESS.RECEIPTTYPECODE,
                    @EXPORTDEFINITION=EXPORTDEFINITION.NAME
                from
                    dbo.RECEIPTINGPROCESS
                    left join dbo.EXPORTDEFINITION on RECEIPTINGPROCESS.EXPORTDEFINITIONID = EXPORTDEFINITION.ID
                where
                    RECEIPTINGPROCESS.ID = @ID

                return 0
            end