USP_DATAFORMTEMPLATE_EDITLOAD_GLACCOUNTSTRUCTURE

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

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@GLACCOUNTSTRUCTURE	xml	INOUT	Accounting Elements
@SEPARATORCODE	tinyint	INOUT	Separator

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GLACCOUNTSTRUCTURE(
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
    @GLACCOUNTSTRUCTURE xml = null output,
  @SEPARATORCODE tinyint = null output
)
as

    set nocount on;

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

    set @DATALOADED = 1;
    set @GLACCOUNTSTRUCTURE = dbo.UFN_ACCOUNTSTRUCTURE_TOITEMLISTXML(null);
  select top 1 @SEPARATORCODE = SEPARATORCODE from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID and ISBASICGL=0;
    select @TSLONG=max(TSLONG) from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID and ISBASICGL=0;

    return 0;