USP_DATAFORMTEMPLATE_VIEW_POSTTOGLDETAILREPORT

The load procedure used by the view dataform template "Post To GL Detail Report Page View"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nvarchar(212)	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.
@GLBATCHID	uniqueidentifier	INOUT	GL Batch ID
@GLBATCHNAME	nvarchar(100)	INOUT	GL Batch Name
@PARENTPAGEID	uniqueidentifier	INOUT	Parent page
@PARENTCONTEXTID	uniqueidentifier	INOUT	Parent context
@BUSINESSPROCESSSTATUSID	uniqueidentifier	INOUT	Business process status
@PARENTPAGENAME	nvarchar(100)	INOUT	Parent page
@HASPARENTPAGENAME	bit	INOUT	Has parent page name
@PARENTPAGEISTRANSACTIONPAGE	bit	INOUT	Parent page is Transaction page
@PARENTPAGEISGLPROCESSPAGE	bit	INOUT	Parent page is GL Process page

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_POSTTOGLDETAILREPORT
                (
                    @ID nvarchar(212),
                    @DATALOADED bit = 0 output,
                    @GLBATCHID uniqueidentifier = null output,
                    @GLBATCHNAME nvarchar(100) = null output,
                    @PARENTPAGEID uniqueidentifier = null output,
                    @PARENTCONTEXTID uniqueidentifier = null output,
                    @BUSINESSPROCESSSTATUSID uniqueidentifier = null output,
                    @PARENTPAGENAME nvarchar(100) = null output,
                    @HASPARENTPAGENAME bit = null output,
                    @PARENTPAGEISTRANSACTIONPAGE bit = null output,
                    @PARENTPAGEISGLPROCESSPAGE bit = null output
                )
                as
                set nocount on;

                select
                    @PARENTPAGEID = cast(substring(@ID, 0, 37) as uniqueidentifier),
                    @PARENTCONTEXTID = cast(substring(@ID, 38, 36) as uniqueidentifier),
                    @GLBATCHID = cast(substring(@ID, 75, 36) as uniqueidentifier),
                    @PARENTPAGENAME =
                        case 
                            when len(@ID) > 111 then substring(@ID, 112, len(@ID) - 111)
                            else N''
                        end

                select 
                    @HASPARENTPAGENAME = 
                        case 
                            when len(@PARENTPAGENAME) > 0 then 1 
                            else 0
                        end,
                    @PARENTPAGEISTRANSACTIONPAGE = 
                        case
                            when @PARENTPAGEID = '387f861b-6c03-486c-9ff5-9cc5bb7a5275' then 1 
                            else 0 
                        end,
                    @PARENTPAGEISGLPROCESSPAGE = 
                        case
                            when @PARENTPAGEID = 'F89AF027-30A3-4b6b-AF6F-8BC54FC58208' then 1 
                            else 0
                        end

                select 
                    @DATALOADED = 1,
                    @GLBATCHNAME = coalesce(GLBATCH.LOOKUPID, N'')
                from dbo.GLBATCH
                where GLBATCH.ID = @GLBATCHID;