USP_CURRENCY_GETPROPERTIESFORCACHE

Loads information necessary for formatting a value as currency. Returns organization currency information when no ID is provided.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@DATALOADED	bit	INOUT
@NAME	nvarchar(100)	INOUT
@ISO4217	nvarchar(3)	INOUT
@LOCALEID	uniqueidentifier	INOUT
@DECIMALDIGITS	tinyint	INOUT
@CURRENCYSYMBOL	nvarchar(5)	INOUT
@ROUNDINGTYPECODE	tinyint	INOUT
@SYMBOLDISPLAYSETTINGCODE	tinyint	INOUT
@TSLONG	bigint	INOUT

Definition

Copy



create procedure dbo.USP_CURRENCY_GETPROPERTIESFORCACHE
(
    @ID uniqueidentifier = null output,
    @DATALOADED bit = 0 output,
    @NAME nvarchar(100) = null output,
    @ISO4217 nvarchar(3) = null output,
    @LOCALEID uniqueidentifier = null output,
    @DECIMALDIGITS tinyint = null output,
    @CURRENCYSYMBOL nvarchar(5) = null output,
    @ROUNDINGTYPECODE tinyint = null output,
    @SYMBOLDISPLAYSETTINGCODE tinyint = null output,
    @TSLONG bigint = 0 output
)
as
begin
    set nocount on;

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

    if @ID is null
        select
            @DATALOADED = 1,
            @ID = [ID],
            @NAME = [NAME],
            @ISO4217 = [ISO4217],
            @LOCALEID = [LOCALEID],
            @DECIMALDIGITS = [DECIMALDIGITS],
            @CURRENCYSYMBOL = [CURRENCYSYMBOL],
            @ROUNDINGTYPECODE = [ROUNDINGTYPECODE],
            @SYMBOLDISPLAYSETTINGCODE = [SYMBOLDISPLAYSETTINGCODE],
            @TSLONG = [TSLONG]
        from 
            dbo.[CURRENCY]
        where 
            [CURRENCY].[ISORGANIZATIONCURRENCY] = 1;

    else
        select
            @DATALOADED = 1,
            @ID = [ID],
            @NAME = [NAME],
            @ISO4217 = [ISO4217],
            @LOCALEID = [LOCALEID],
            @DECIMALDIGITS = [DECIMALDIGITS],
            @CURRENCYSYMBOL = [CURRENCYSYMBOL],
            @ROUNDINGTYPECODE = [ROUNDINGTYPECODE],
            @SYMBOLDISPLAYSETTINGCODE = [SYMBOLDISPLAYSETTINGCODE],
            @TSLONG = [TSLONG]
        from 
            dbo.[CURRENCY]
        where 
            [CURRENCY].[ID] = @ID;

    return 0;

end