USP_DATAFORMTEMPLATE_VIEW_GLACCOUNTSEQUENCE_SUMMARY

The load procedure used by the view dataform template "Account Sequence Summary View"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ACCOUNTSEQUENCE	xml	INOUT	Current Sequence:
@SEPARATOR	nvarchar(1)	INOUT	Separator
@DESCRIPTIONSTRING	nvarchar(max)	INOUT	Default account description

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_GLACCOUNTSEQUENCE_SUMMARY
(
    @DATALOADED bit = 0 output,
    @ACCOUNTSEQUENCE xml = null output,
  @SEPARATOR nvarchar(1) = null output,
  @DESCRIPTIONSTRING nvarchar(max) = null output
)
as
    set nocount on;

  declare @PDACCOUNTSYSTEMID uniqueidentifier = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B';

    -- We always want to show this view, even if there's no data

    set @DATALOADED = 1;
    set @ACCOUNTSEQUENCE  = dbo.UFN_ACCOUNTSEQUENCE_TOITEMLISTXML(@PDACCOUNTSYSTEMID);

  select top 1 @SEPARATOR = SEPARATOR from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID and ISBASICGL=0;

  select @DESCRIPTIONSTRING = (select isnull(DESCRIPTION + ' description - ', '')
  from dbo.PDACCOUNTSTRUCTURE 
  where PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID and ISBASICGL = 0 and DEFAULTDESCRIPTIONSEQUENCE > 0
  order by DEFAULTDESCRIPTIONSEQUENCE
  for xml path(''), type).value('.','nvarchar(max)')

  set @DESCRIPTIONSTRING = substring(@DESCRIPTIONSTRING, 1, len(@DESCRIPTIONSTRING)-2)

    return 0;