USP_DATAFORMTEMPLATE_ADD_ACCOUNTINGELEMENTRELATIONSHIP_PRELOAD

The load procedure used by the edit dataform template "Accounting Element Relationship Add Form"

Parameters

Parameter	Parameter Type	Mode
@ACCOUNTSTRUCTURE	xml	INOUT
@DATAELEMENTRECORDTYPEID	uniqueidentifier	INOUT
@ACCOUNTCODERECORDTYPEID	uniqueidentifier	INOUT
@PROJECTRECORDTYPEID	uniqueidentifier	INOUT
@ACCOUNTRECORDTYPEID	uniqueidentifier	INOUT

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ACCOUNTINGELEMENTRELATIONSHIP_PRELOAD
          (
          @ACCOUNTSTRUCTURE xml = null output,
          @DATAELEMENTRECORDTYPEID uniqueidentifier = null output,
          @ACCOUNTCODERECORDTYPEID uniqueidentifier = null output,
          @PROJECTRECORDTYPEID uniqueidentifier = null output,
          @ACCOUNTRECORDTYPEID uniqueidentifier = null output
          )
          as
            set nocount on;

            set @ACCOUNTSTRUCTURE = 
              (select ACTSTR.ID, 
              ACTSTR.DESCRIPTION as NAME, 
              ACTSTR.ELEMENTTYPECODE,
              ACTSTR.SEGMENTCOLUMN,
              ACTSTR.ELEMENTDEFINITIONCODE
              from dbo.PDACCOUNTSTRUCTURE ACTSTR
              order by ACTSTR.DESCRIPTION
              for xml raw('ITEM'),type,elements,root('ACCOUNTSTRUCTURE'),BINARY BASE64)

            select @DATAELEMENTRECORDTYPEID = ID from dbo.RECORDTYPE
            where upper(NAME) = 'ACCOUNTING ELEMENT'

            select @ACCOUNTCODERECORDTYPEID = ID from dbo.RECORDTYPE
            where upper(NAME) = 'ACCOUNT CODE'

            select @PROJECTRECORDTYPEID = ID from dbo.RECORDTYPE
            where upper(NAME) = 'PROJECT'

            select @ACCOUNTRECORDTYPEID = ID from dbo.RECORDTYPE
            where upper(NAME) = 'ACCOUNT'

            return 0;