USP_DATAFORMTEMPLATE_VIEW_LEDGERACCOUNT_LISTSUMMARY

The load procedure used by the view dataform template "Ledger Account List Summary View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@HASINACTIVEELEMENTS	bit	INOUT	Has inactive elements
@HASACCOUNTS	bit	INOUT	Has accounts

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_LEDGERACCOUNT_LISTSUMMARY
(
    @DATALOADED bit = 0 output,
    @HASINACTIVEELEMENTS bit = null output,
  @HASACCOUNTS bit = null output
)
as
    set nocount on;

    set @DATALOADED = 1;

  if exists
    (select unpvt.ID 
    from
        (select ID, DATAELEMENT1ID, DATAELEMENT2ID, DATAELEMENT3ID, DATAELEMENT4ID, DATAELEMENT5ID, DATAELEMENT6ID, DATAELEMENT7ID, DATAELEMENT8ID, DATAELEMENT9ID, DATAELEMENT10ID, 
            DATAELEMENT11ID, DATAELEMENT12ID, DATAELEMENT13ID, DATAELEMENT14ID, DATAELEMENT15ID, DATAELEMENT16ID, DATAELEMENT17ID, DATAELEMENT18ID, DATAELEMENT19ID, DATAELEMENT20ID, 
            DATAELEMENT21ID, DATAELEMENT22ID, DATAELEMENT23ID, DATAELEMENT24ID, DATAELEMENT25ID, DATAELEMENT26ID, DATAELEMENT27ID, DATAELEMENT28ID, DATAELEMENT29ID, DATAELEMENT30ID
        from dbo.GLACCOUNT) l
    unpivot
        (DATAELEMENTID for dColumn in
            (DATAELEMENT1ID, DATAELEMENT2ID, DATAELEMENT3ID, DATAELEMENT4ID, DATAELEMENT5ID, DATAELEMENT6ID, DATAELEMENT7ID, DATAELEMENT8ID, DATAELEMENT9ID, DATAELEMENT10ID, 
            DATAELEMENT11ID, DATAELEMENT12ID, DATAELEMENT13ID, DATAELEMENT14ID, DATAELEMENT15ID, DATAELEMENT16ID, DATAELEMENT17ID, DATAELEMENT18ID, DATAELEMENT19ID, DATAELEMENT20ID, 
            DATAELEMENT21ID, DATAELEMENT22ID, DATAELEMENT23ID, DATAELEMENT24ID, DATAELEMENT25ID, DATAELEMENT26ID, DATAELEMENT27ID, DATAELEMENT28ID, DATAELEMENT29ID, DATAELEMENT30ID)
        ) as unPvt
      inner join dbo.PDACCOUNTSEGMENTVALUE on DATAELEMENTID = PDACCOUNTSEGMENTVALUE.ID
      inner join dbo.PDACCOUNTSTRUCTURE on PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID = PDACCOUNTSTRUCTURE.ID
    where PDACCOUNTSEGMENTVALUE.ISACTIVE = 0
      and PDACCOUNTSTRUCTURE.ELEMENTTYPECODE = 1
    group by unpvt.ID
  ) set @HASINACTIVEELEMENTS = 1

  select @HASACCOUNTS = 1 from dbo.GLACCOUNT;

    return 0;