USP_DATAFORMTEMPLATE_VIEW_GLPOSTPROCESS

The load procedure used by the view dataform template "GL Post 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
@DESCRIPTION	nvarchar(255)	INOUT	Description
@CREATEOUTPUTIDSET	nvarchar(3)	INOUT	Create output selection
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Output selection name
@OVERWRITEOUTPUTIDSET	nvarchar(3)	INOUT	Overwrite existing selection
@INCLUDEBYPOSTDATE	nvarchar(3)	INOUT	Include 'not posted' transactions by post date
@POSTTHROUGHDATE	nvarchar(20)	INOUT	Post dates up to and including
@SUMMARIZEBYDATE	nvarchar(13)	INOUT	Summarize transactions by
@POSTMETHODLABELS	nvarchar(max)	INOUT	POSTMETHODLABELS
@POSTMETHODS	nvarchar(max)	INOUT	POSTMETHODS
@TRANSACTIONCRITERIALABELS	nvarchar(max)	INOUT	TRANSACTIONCRITERIALABELS
@TRANSACTIONCRITERIA	nvarchar(max)	INOUT	TRANSACTIONCRITERIA
@BACKPAGEID	uniqueidentifier	INOUT	BACKPAGEID

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_GLPOSTPROCESS
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @NAME nvarchar(100) = null output, 
    @DESCRIPTION nvarchar(255) = null output,                 
    @CREATEOUTPUTIDSET nvarchar(3) = null output,
    @OUTPUTIDSETNAME nvarchar(100) = null output, 
    @OVERWRITEOUTPUTIDSET nvarchar(3) = null output,
  @INCLUDEBYPOSTDATE nvarchar(3) = null output,
  @POSTTHROUGHDATE nvarchar(20) = null output,
  @SUMMARIZEBYDATE nvarchar(13) = null output,
  @POSTMETHODLABELS nvarchar(max) = null output,
  @POSTMETHODS nvarchar(max) = null output,
  @TRANSACTIONCRITERIALABELS nvarchar(max) = null output,
  @TRANSACTIONCRITERIA nvarchar(max) = null output,
  @BACKPAGEID uniqueidentifier = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.

    select @DATALOADED = 1,
           @NAME = NAME,
           @DESCRIPTION = DESCRIPTION,
           @CREATEOUTPUTIDSET = case CREATEOUTPUTIDSET when 0 then N'No' else N'Yes' end,
       @OUTPUTIDSETNAME = OUTPUTIDSETNAME,
       @OVERWRITEOUTPUTIDSET = case OVERWRITEOUTPUTIDSET when 0 then N'No' else N'Yes' end,
       @INCLUDEBYPOSTDATE = case INCLUDEBYPOSTDATE when 0 then N'No' else N'Yes' end,
       @POSTTHROUGHDATE = POSTTHROUGHDATE,
       @SUMMARIZEBYDATE = SUMMARIZEBYDATE
    from dbo.GLPOSTPROCESS
    where ID = @ID

  select @POSTMETHODLABELS = replace((select GLPOSTPROCESSPOSTMETHODTRANSLATION.DESCRIPTION+':'+'CRLF'
    from GLPOSTPROCESS inner join GLPOSTPROCESSPOSTMETHODTRANSLATION on GLPOSTPROCESS.FINANCIALSYSTEMID = GLPOSTPROCESSPOSTMETHODTRANSLATION.FINANCIALSYSTEMID
    inner join GLPOSTPROCESSPOSTMETHOD on GLPOSTPROCESS.ID = GLPOSTPROCESSPOSTMETHOD.GLPOSTPROCESSID
        and GLPOSTPROCESSPOSTMETHODTRANSLATION.TRANSACTIONTYPECODE = GLPOSTPROCESSPOSTMETHOD.TRANSACTIONTYPECODE
        and GLPOSTPROCESSPOSTMETHODTRANSLATION.FINANCIALSYSTEMTRANSACTIONTYPEID = GLPOSTPROCESSPOSTMETHOD.FINANCIALSYSTEMTRANSACTIONTYPEID
    where glpostprocess.id = @ID
    order by GLPOSTPROCESSPOSTMETHODTRANSLATION.DESCRIPTION
    for xml path('')),'CRLF',char(13)),
    @POSTMETHODS = replace((select case GLPOSTPROCESSPOSTMETHOD.POSTMETHODCODE when 1 then N'Detail' when 2 then N'Detail' when 3 then N'Summary' end+'CRLF'
    from GLPOSTPROCESS inner join GLPOSTPROCESSPOSTMETHODTRANSLATION on GLPOSTPROCESS.FINANCIALSYSTEMID = GLPOSTPROCESSPOSTMETHODTRANSLATION.FINANCIALSYSTEMID
    inner join GLPOSTPROCESSPOSTMETHOD on GLPOSTPROCESS.ID = GLPOSTPROCESSPOSTMETHOD.GLPOSTPROCESSID
        and GLPOSTPROCESSPOSTMETHODTRANSLATION.TRANSACTIONTYPECODE = GLPOSTPROCESSPOSTMETHOD.TRANSACTIONTYPECODE
        and GLPOSTPROCESSPOSTMETHODTRANSLATION.FINANCIALSYSTEMTRANSACTIONTYPEID = GLPOSTPROCESSPOSTMETHOD.FINANCIALSYSTEMTRANSACTIONTYPEID
    where glpostprocess.id = @ID
    order by GLPOSTPROCESSPOSTMETHODTRANSLATION.DESCRIPTION
    for xml path('')),'CRLF',char(13))


select @TRANSACTIONCRITERIALABELS = replace((select GLPOSTPROCESSTRANSACTIONCRITIATRANSLATION.DESCRIPTION+':'
          +case GLPOSTPROCESSTRANSACTIONCRITERIA.POSTINGOPTIONCODE 
              when 1 then 'CRLF'+'  Selection:' else '' end+'CRLF'
      from GLPOSTPROCESS inner join GLPOSTPROCESSTRANSACTIONCRITIATRANSLATION on GLPOSTPROCESS.FINANCIALSYSTEMID = GLPOSTPROCESSTRANSACTIONCRITIATRANSLATION.FINANCIALSYSTEMID
      inner join GLPOSTPROCESSTRANSACTIONCRITERIA on GLPOSTPROCESS.ID = GLPOSTPROCESSTRANSACTIONCRITERIA.GLPOSTPROCESSID
          and GLPOSTPROCESSTRANSACTIONCRITIATRANSLATION.FINANCIALSYSTEMTRANSACTIONTYPEID = GLPOSTPROCESSTRANSACTIONCRITERIA.FINANCIALSYSTEMTRANSACTIONTYPEID
      left join IDSETREGISTER on GLPOSTPROCESSTRANSACTIONCRITERIA.IDSETREGISTERID = IDSETREGISTER.ID and GLPOSTPROCESSTRANSACTIONCRITERIA.POSTINGOPTIONCODE = 1
      where GLPOSTPROCESS.ID =  @ID
    order by GLPOSTPROCESSTRANSACTIONCRITIATRANSLATION.DESCRIPTION
      for xml path('')),'CRLF',char(13)),
      @TRANSACTIONCRITERIA = replace((select case GLPOSTPROCESSTRANSACTIONCRITERIA.POSTINGOPTIONCODE 
              when 0 then N'All' 
              when 1 then N'Selected'+'CRLF'+IDSETREGISTER.NAME
              when 2 then 'None' end+'CRLF'
      from GLPOSTPROCESS inner join GLPOSTPROCESSTRANSACTIONCRITIATRANSLATION on GLPOSTPROCESS.FINANCIALSYSTEMID = GLPOSTPROCESSTRANSACTIONCRITIATRANSLATION.FINANCIALSYSTEMID
      inner join GLPOSTPROCESSTRANSACTIONCRITERIA on GLPOSTPROCESS.ID = GLPOSTPROCESSTRANSACTIONCRITERIA.GLPOSTPROCESSID
          and GLPOSTPROCESSTRANSACTIONCRITIATRANSLATION.FINANCIALSYSTEMTRANSACTIONTYPEID = GLPOSTPROCESSTRANSACTIONCRITERIA.FINANCIALSYSTEMTRANSACTIONTYPEID
      left join IDSETREGISTER on GLPOSTPROCESSTRANSACTIONCRITERIA.IDSETREGISTERID = IDSETREGISTER.ID and GLPOSTPROCESSTRANSACTIONCRITERIA.POSTINGOPTIONCODE = 1
      where GLPOSTPROCESS.ID =  @ID
    order by GLPOSTPROCESSTRANSACTIONCRITIATRANSLATION.DESCRIPTION
      for xml path('')),'CRLF',char(13))

    select @BACKPAGEID = '381f4b36-6f5b-4be1-ac5d-fc28a990522c'

    return 0;