USP_GLACCOUNTCODE_PRELOAD

The load procedure used by the edit dataform template "Account Code Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ACTIVE	bit	INOUT	Active
@ELEMENTLENGTH	smallint	INOUT
@ELEMENTNAME	nvarchar(100)	INOUT

Definition

Copy



CREATE procedure dbo.USP_GLACCOUNTCODE_PRELOAD
(    
    @ACTIVE bit = null output,
    @ELEMENTLENGTH smallint = null output,
    @ELEMENTNAME nvarchar(100) = null output
)
as begin
  set nocount on;

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

    set @ACTIVE = 1

    -- Get the Segment Length for Masking.        

    select 
        @ELEMENTLENGTH = (case PDACCOUNTSTRUCTURE.LENGTH when 0 then 100 else PDACCOUNTSTRUCTURE.LENGTH end) ,
        @ELEMENTNAME = DESCRIPTION
    from PDACCOUNTSTRUCTURE 
  where ELEMENTDEFINITIONCODE  = 1 and PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID and ISBASICGL = 0

return 0;
end;