USP_DATAFORMTEMPLATE_VIEW_LEDGERACCOUNT

The load procedure used by the view dataform template "Ledger Account Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ACCOUNT	nvarchar(130)	INOUT	Account
@DESCRIPTION	nvarchar(400)	INOUT	Description
@CATEGORY	nvarchar(40)	INOUT	Category
@SUBCATEGORY	nvarchar(20)	INOUT	Sub Category
@CONTRAACCOUNT	bit	INOUT	Contra account
@BALANCETYPE	nvarchar(10)	INOUT	Balance type
@ISACTIVE	bit	INOUT	Active

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_LEDGERACCOUNT
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @ACCOUNT nvarchar(130) = null output,
    @DESCRIPTION nvarchar(400) = null output,
    @CATEGORY nvarchar(40) = null output,
    @SUBCATEGORY nvarchar(20) = null output,
    @CONTRAACCOUNT bit = null output,
    @BALANCETYPE nvarchar(10) = null output,
    @ISACTIVE bit = null output

)
as
    set nocount on;

    set @DATALOADED = 0;

    select @DATALOADED = 1,
        @ACCOUNT = GLACCOUNT.ACCOUNTSTRING,
        @DESCRIPTION = GLACCOUNT.ACCOUNTDESCRIPTION,
        @CATEGORY = ACCOUNTCODE.CATEGORY,
        @SUBCATEGORY = ACCOUNTCODE.SUBCATEGORY,
        @CONTRAACCOUNT = ACCOUNTCODE.CONTRAACCOUNT,
        @BALANCETYPE = (case dbo.UFN_GETCATEGORYBALANCEFROMID(GLACCOUNT.ACCOUNTCODEID)
        when 1 then 'Debit'
        when 2 then 'Credit'
        end) ,
        @ISACTIVE = ACTIVE
    from
        dbo.GLACCOUNT
    left join dbo.ACCOUNTCODE on ACCOUNTCODE.ID = GLACCOUNT.ACCOUNTCODEID
    where GLACCOUNT.ID = @ID

    if @SUBCATEGORY<>''
        set @CATEGORY = @CATEGORY + ' - ' + @SUBCATEGORY


    return 0;