USP_DATAFORMTEMPLATE_VIEW_PDACCOUNTCODEMAP

The load procedure used by the view dataform template "Account Code Map 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.
@SYSTEMNAME	nvarchar(50)	INOUT	SYSTEMNAME
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT	PDACCOUNTSYSTEMID
@HASINTERCURRENCYMAPPING	bit	INOUT	HASINTERCURRENCYMAPPING

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PDACCOUNTCODEMAP
(
    @ID uniqueidentifier,    
    @DATALOADED bit = 0 output,
    @SYSTEMNAME nvarchar(50) = null output,
    @PDACCOUNTSYSTEMID uniqueidentifier = null output,
    @HASINTERCURRENCYMAPPING bit = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,
        @SYSTEMNAME = NAME,
        @PDACCOUNTSYSTEMID = ID
    from 
        dbo.PDACCOUNTSYSTEM 
    where 
        ID = @ID

    set @HASINTERCURRENCYMAPPING = 
        case when 
        (
            select 
                count(ID) 
            from 
                dbo.PDACCOUNTCODEMAPPING 
            where 
                OFFICEID = 18 and 
                PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID
        ) = 0 
        then 
            0 
        else 
            1 
        end;

return 0;