USP_DATAFORMTEMPLATE_VIEW_PDACCOUNTSYSTEMPAGE

The load procedure used by the view dataform template "Account System Page View"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@MULTIPLES	bit	INOUT	MULTIPLES
@AUTOCONFIG	bit	INOUT	AUTOCONFIG
@ISBASICPROGRAMS	bit	INOUT	ISBASICPROGRAMS
@FENXTINTEGRATED	bit	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PDACCOUNTSYSTEMPAGE
(
    @DATALOADED bit = 0 output,
    @MULTIPLES bit = null output,
    @AUTOCONFIG bit = null output,
    @ISBASICPROGRAMS bit = null output,
    @FENXTINTEGRATED bit = null output
)
as
    set nocount on;
    set @DATALOADED = 0;
    set @MULTIPLES = 0;
    set @DATALOADED = 1;
    set @FENXTINTEGRATED = 0;

    if (select count(ID) from dbo.PDACCOUNTSYSTEM Where ISBASICGL = 1) > 1
        set @MULTIPLES = 1

--    if (select count(*) from dbo.PDACCOUNTSTRUCTURE where PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B') > 1 or (select count(*) from dbo.GLACCOUNT) > 0 or (select count(*) from dbo.GLFISCALYEAR) > 0

--        set @AUTOCONFIG = 0

--    else

--        set @AUTOCONFIG = 0


    set @AUTOCONFIG = 0

    select @ISBASICPROGRAMS = dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('bb1c17bc-9e0b-4683-b490-ee40d511fa05')

        if exists (select NAME from SYS.TABLES where NAME='FENXTINTEGRATION')
        begin
            if (select count(ID) from dbo.FENXTINTEGRATION) > 0
            set @FENXTINTEGRATED = 1;
        end

    return 0;