USP_DATAFORMTEMPLATE_VIEW_GLACCOUNTCODE

The load procedure used by the view dataform template "Account Code 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.
@SHORTID	nvarchar(100)	INOUT	Account code
@DESCRIPTION	nvarchar(60)	INOUT	Description
@CATEGORY	nvarchar(10)	INOUT	Category
@SUBCATEGORY	nvarchar(20)	INOUT	Subcategory
@ACTIVE	bit	INOUT	Active
@CONTRAACCOUNT	bit	INOUT	Contra account
@PREVENTDATAENTRY	bit	INOUT	Prevent data entry
@PREVENTDATAENTRYBEFOREDATE	UDT_FUZZYDATE	INOUT	Before
@PREVENTDATAENTRYAFTERDATE	UDT_FUZZYDATE	INOUT	After
@PREVENTPOST	bit	INOUT	Prevent posting
@PREVENTPOSTBEFOREDATE	UDT_FUZZYDATE	INOUT	Before
@PREVENTPOSTAFTERDATE	UDT_FUZZYDATE	INOUT	After
@BALANCETYPECODE	int	INOUT	Balance type code
@CATEGORYCODE	int	INOUT	Category code
@SUBCATEGORYCODE	int	INOUT	Subcategory code

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_GLACCOUNTCODE
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @SHORTID nvarchar(100) = null  output,
    @DESCRIPTION nvarchar(60) = null output,
    @CATEGORY nvarchar(10) = null output,
    @SUBCATEGORY nvarchar(20) = null output,
  @ACTIVE bit = null output,
  @CONTRAACCOUNT bit = null output,
  @PREVENTDATAENTRY bit = null output,
  @PREVENTDATAENTRYBEFOREDATE dbo.UDT_FUZZYDATE = null output,
  @PREVENTDATAENTRYAFTERDATE dbo.UDT_FUZZYDATE = null output,
  @PREVENTPOST bit = null output,
  @PREVENTPOSTBEFOREDATE dbo.UDT_FUZZYDATE = null output,
  @PREVENTPOSTAFTERDATE dbo.UDT_FUZZYDATE = null output,
  @BALANCETYPECODE int = null output,
  @CATEGORYCODE int = null output,
  @SUBCATEGORYCODE int = null output
    )
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows

    set @DATALOADED = 0

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.  Also note that we fetch the TSLONG so that concurrency

    -- can be considered.

    select
        @DATALOADED = 1,
        @SHORTID = T2.SHORTDESCRIPTION,
        @DESCRIPTION = T2.DESCRIPTION,
        @CATEGORY = T1.CATEGORY,
    @ACTIVE = T2.ISACTIVE,
    @CONTRAACCOUNT = T1.CONTRAACCOUNT,
    @SUBCATEGORY = T1.SUBCATEGORY,
    @PREVENTDATAENTRY = T2.PREVENTDATAENTRY,
    @PREVENTDATAENTRYBEFOREDATE = T2.PREVENTDATAENTRYBEFOREDATE,
    @PREVENTDATAENTRYAFTERDATE = T2.PREVENTDATAENTRYAFTERDATE,
    @PREVENTPOST = T2.PREVENTPOST,
    @PREVENTPOSTBEFOREDATE = T2.PREVENTPOSTBEFOREDATE,
    @PREVENTPOSTAFTERDATE = T2.PREVENTPOSTAFTERDATE,
    @BALANCETYPECODE = (dbo.UFN_GETCATEGORYBALANCEFROMID(T1.ID)),
    @CATEGORYCODE = T1.CATEGORYCODE,
    @SUBCATEGORYCODE = T1.SUBCATEGORYCODE
  from dbo.ACCOUNTCODE as T1
    inner join dbo.PDACCOUNTSEGMENTVALUE as T2 on T1.ID = T2.ID
  where T1.ID = @ID

    return 0;