USP_DATAFORMTEMPLATE_ADD_LEDGERACCOUNT_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@ACCOUNTCODEINFO	xml	INOUT
@DEFAULTDESCRIPTIONINFO	xml	INOUT
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_LEDGERACCOUNT_PRELOAD
(
    @ACCOUNTCODEINFO xml = null output,
  @DEFAULTDESCRIPTIONINFO xml = null output,
  @PDACCOUNTSYSTEMID uniqueidentifier
)
as
    set nocount on;
  if @PDACCOUNTSYSTEMID is null
    set @PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'

    set @ACCOUNTCODEINFO =
    (select
        AC.ID,
        AC.CATEGORYCODE,
        AC.SUBCATEGORYCODE,
    case AC.CONTRAACCOUNT when 1 then case AC.NORMALBALANCECODE when 1 then 2 else 1 end else AC.NORMALBALANCECODE end as BALANCETYPE,
        AC.CONTRAACCOUNT as ISCONTRA
    from dbo.ACCOUNTCODE AC
  inner join dbo.PDACCOUNTSEGMENTVALUE DE on AC.ID = DE.ID
  inner join dbo.PDACCOUNTSTRUCTURE ST on DE.PDACCOUNTSTRUCTUREID = ST.ID
  where ST.PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID and ST.ISBASICGL = 0
    for xml raw('ITEM'),type,elements,root('ACCOUNTCODEINFO'),BINARY BASE64)

  set @DEFAULTDESCRIPTIONINFO = 
  (select
    ST.DEFAULTDESCRIPTIONLENGTH,
    ST.SEGMENTSEQUENCE
  from dbo.PDACCOUNTSTRUCTURE ST
  where ST.PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID and ST.ISBASICGL = 0
    and
    DEFAULTDESCRIPTIONSEQUENCE > 0
  order by DEFAULTDESCRIPTIONSEQUENCE
  for xml raw('ITEM'),type,elements,root('DEFAULTDESCRIPTIONINFO'),BINARY BASE64)

    return 0;