USP_DATAFORMTEMPLATE_EDITLOAD_GLACCOUNTSEQUENCE

The load procedure used by the edit dataform template "Account Sequence 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.
@ACCOUNTSEQUENCE	xml	INOUT	Accounting Sequence

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GLACCOUNTSEQUENCE(
      @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @ACCOUNTSEQUENCE xml = null output
)
as

    set nocount on;

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

        set @DATALOADED = 1;
            set @ACCOUNTSEQUENCE = dbo.UFN_ACCOUNTSEQUENCE_TOITEMLISTXML(null);
            select @TSLONG=max(TSLONG) from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID and ISBASICGL=0;

    return 0;