USP_DATAFORMTEMPLATE_EDITLOAD_MULTICURRENCYCONFIGURATION

Load procedure for the multicurrency configuration edit form.

Parameters

Parameter	Parameter Type	Mode
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@ORGANIZATIONCURRENCYNAME	nvarchar(110)	INOUT
@ORGANIZATIONAMOUNTORIGINCODE	tinyint	INOUT

Definition

Copy



            create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MULTICURRENCYCONFIGURATION
            (
                @DATALOADED bit = 0 output,
                @TSLONG bigint = 0 output,
                @ORGANIZATIONCURRENCYNAME nvarchar(110) = null output,
                @ORGANIZATIONAMOUNTORIGINCODE tinyint = null output
            )
            as
                set nocount on;

                set @DATALOADED = 1;
                set @TSLONG = 0;

                declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

                if @ORGANIZATIONCURRENCYID is null 
                    raiserror('BBERR_NOORGANIZATIONCURRENCY',13,1);

                select @ORGANIZATIONCURRENCYNAME = dbo.UFN_CURRENCY_GETDESCRIPTION(@ORGANIZATIONCURRENCYID);

                select top 1 @ORGANIZATIONAMOUNTORIGINCODE = ORGANIZATIONAMOUNTORIGINCODE from dbo.MULTICURRENCYCONFIGURATION;

                return 0;