USP_CURRENCY_ADDDEFAULTCURRENCIES
Creates default currencies for multicurrency systems.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_CURRENCY_ADDDEFAULTCURRENCIES
(
@CHANGEAGENTID uniqueidentifier = null
)
with execute as caller
as
set nocount on;
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();
declare @DEFAULTCURRENCY table
(
NAME nvarchar(100) not null,
INACTIVE bit not null default(1),
ISO4217 nvarchar(3) not null,
WINDOWSLOCALEID int not null,
DECIMALDIGITS tinyint not null default(2),
CURRENCYSYMBOL nvarchar(5) not null,
ROUNDINGTYPECODE tinyint not null default(0),
SYMBOLDISPLAYSETTINGCODE tinyint not null default(0)
);
begin try
insert into @DEFAULTCURRENCY
(NAME, INACTIVE, ISO4217, WINDOWSLOCALEID, DECIMALDIGITS, CURRENCYSYMBOL, ROUNDINGTYPECODE, SYMBOLDISPLAYSETTINGCODE)
values
(N'UAE Dirham', default, N'AED', 14337, 2, N'', default, default), -- Non-standard characters: 1583 (OtherLetter), 46 (OtherPunctuation), 1573 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Albanian Lek', default, N'ALL', 1052, 2, N'Lek', default, default),
(N'Armenian Dram', default, N'AMD', 1067, 2, N'??.', default, default),
(N'Argentine Peso', default, N'ARS', 11274, 2, N'$', default, default),
(N'Australian Dollar', default, N'AUD', 3081, 2, N'$', default, default),
(N'Convertible Marks', default, N'BAM', 4122, 2, N'KM', default, default),
(N'Bulgarian Lev', default, N'BGL', 1026, 2, N'??', default, default),
(N'Bahraini Dinar', default, N'BHD', 15361, 3, N'BD', default, default), -- Non-standard characters: 1583 (OtherLetter), 46 (OtherPunctuation), 1576 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Brunei Dollar', default, N'BND', 2110, 0, N'$', default, default),
(N'Boliviano', default, N'BOB', 16394, 2, N'$b', default, default),
(N'Real', default, N'BRL', 1046, 2, N'R$', default, default),
(N'Belarusian Ruble', default, N'BYB', 1059, 2, N'?.', default, default),
(N'Belize Dollar', default, N'BZD', 10249, 2, N'BZ$', default, default),
(N'Canadian Dollar', default, N'CAD', 4105, 2, N'$', default, default),
(N'Swiss Franc', default, N'CHF', 2055, 2, N'SFr.', default, default),
(N'Chilean Peso', default, N'CLP', 13322, 2, N'$', default, default),
(N'PRC Yuan Renminbi', default, N'CNY', 2052, 2, N'?', default, default),
(N'Colombian Peso', default, N'COP', 9226, 2, N'$', default, default),
(N'Costa Rican Colon', default, N'CRC', 5130, 2, N'?', default, default),
(N'Czech Koruna', default, N'CZK', 1029, 2, N'K?', default, default),
(N'Danish Krone', default, N'DKK', 1030, 2, N'kr', default, default),
(N'Dominican Peso', default, N'DOP', 7178, 2, N'RD$', default, default),
(N'Algerian Dinar', default, N'DZD', 5121, 2, N'DA', default, default), -- Non-standard characters: 1583 (OtherLetter), 46 (OtherPunctuation), 1580 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Estonian Kroon', default, N'EEK', 1061, 2, N'kr', default, default),
(N'Egyptian Pound', default, N'EGP', 3073, 3, N'E?', default, default), -- Non-standard characters: 1580 (OtherLetter), 46 (OtherPunctuation), 1605 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Euro', default, N'EUR', 3079, 2, N'?', default, default),
(N'UK Pound Sterling', default, N'GBP', 2057, 2, N'?', default, default),
(N'Lari', default, N'GEL', 1079, 2, N'Lari', default, default),
(N'Guatemalan Quetzal', default, N'GTQ', 4106, 2, N'Q', default, default),
(N'Hong Kong Dollar', default, N'HKD', 3076, 2, N'HK$', default, default),
(N'Honduran Lempira', default, N'HNL', 18442, 2, N'L.', default, default),
(N'Croatian Kuna', default, N'HRK', 1050, 2, N'kn', default, default),
(N'Hungarian Forint', default, N'HUF', 1038, 2, N'Ft', default, default),
(N'Indonesian Rupiah', default, N'IDR', 1057, 0, N'Rp', default, default),
(N'Israeli New Shekel', default, N'ILS', 1037, 2, N'?', default, default),
(N'Indian Rupee', default, N'INR', 1081, 2, N'?', default, default), -- Replaced symbol with another value.
(N'Iraqi Dinar', default, N'IQD', 2049, 2, N'', default, default), -- Non-standard characters: 1583 (OtherLetter), 46 (OtherPunctuation), 1593 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Iranian Rial', default, N'IRR', 1065, 2, N'', default, default), -- Replaced symbol with another value.
(N'Icelandic Krona', default, N'ISK', 1039, 0, N'kr.', default, default),
(N'Jamaican Dollar', default, N'JMD', 8201, 2, N'J$', default, default),
(N'Jordanian Dinar', default, N'JOD', 11265, 3, N'JD', default, default), -- Non-standard characters: 1583 (OtherLetter), 46 (OtherPunctuation), 1575 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Japanese Yen', default, N'JPY', 1041, 0, N'?', default, default),
(N'Kenyan Shilling', default, N'KES', 1089, 2, N'S', default, default),
(N'som', default, N'KGS', 1088, 2, N'???', default, default),
(N'Korean Won', default, N'KRW', 1042, 0, N'?', default, default),
(N'Kuwaiti Dinar', default, N'KWD', 13313, 3, N'', default, default), -- Non-standard characters: 1583 (OtherLetter), 46 (OtherPunctuation), 1603 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Tenge', default, N'KZT', 1087, 2, N'?', default, default),
(N'Lebanese Pound', default, N'LBP', 12289, 2, N'', default, default), -- Non-standard characters: 1604 (OtherLetter), 46 (OtherPunctuation), 1604 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Lithuanian Litas', default, N'LTL', 1063, 2, N'Lt', default, default),
(N'Latvian Lats', default, N'LVL', 1062, 2, N'Ls', default, default),
(N'Libyan Dinar', default, N'LYD', 4097, 2, N'LD', default, default), -- Non-standard characters: 1583 (OtherLetter), 46 (OtherPunctuation), 1604 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Moroccan Dirham', default, N'MAD', 6145, 2, N'', default, default), -- Non-standard characters: 1583 (OtherLetter), 46 (OtherPunctuation), 1605 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Macedonian Denar', default, N'MKD', 1071, 2, N'???.', default, default),
(N'Maltese Lira', default, N'MTL', 1082, 2, N'Lm', default, default),
(N'Rufiyaa', default, N'MVR', 1125, 2, N'Rf', default, default), -- Replaced symbol with another value.
(N'Mexican Peso', default, N'MXN', 2058, 2, N'$', default, default),
(N'Malaysian Ringgit', default, N'MYR', 1086, 0, N'R', default, default),
(N'Nicaraguan Cordoba Oro', default, N'NIO', 19466, 2, N'C$', default, default),
(N'Norwegian Krone', default, N'NOK', 1044, 2, N'kr', default, default),
(N'New Zealand Dollar', default, N'NZD', 5129, 2, N'$', default, default),
(N'Rial Omani', default, N'OMR', 8193, 2, N'', default, default), -- Non-standard characters: 1585 (OtherLetter), 46 (OtherPunctuation), 1593 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Panamanian Balboa', default, N'PAB', 6154, 2, N'B/.', default, default),
(N'Peruvian Nuevo Sol', default, N'PEN', 10250, 2, N'S/.', default, default),
(N'Philippine Peso', default, N'PHP', 13321, 2, N'Php', default, default),
(N'Pakistan Rupee', default, N'PKR', 1056, 2, N'Rs', default, default),
(N'Polish Zloty', default, N'PLN', 1045, 2, N'z?', default, default),
(N'Paraguay Guarani', default, N'PYG', 15370, 2, N'Gs', default, default),
(N'Qatari Rial', default, N'QAR', 16385, 2, N'QR', default, default), -- Non-standard characters: 1585 (OtherLetter), 46 (OtherPunctuation), 1602 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Romanian Leu', default, N'ROL', 1048, 2, N'lei', default, default),
(N'Russian Ruble', default, N'RUR', 1049, 2, N'?.', default, default),
(N'Saudi Riyal', default, N'SAR', 1025, 2, N'SR', default, default), -- Non-standard characters: 1585 (OtherLetter), 46 (OtherPunctuation), 1587 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Swedish Krona', default, N'SEK', 1053, 2, N'kr', default, default),
(N'Singapore Dollar', default, N'SGD', 4100, 2, N'$', default, default),
(N'Slovenian Tolar', default, N'SIT', 1060, 2, N'SIT', default, default),
(N'Slovak Koruna', default, N'SKK', 1051, 2, N'Sk', default, default),
(N'Syrian Pound', default, N'SYP', 1114, 2, N'', default, default), -- Non-standard characters: 1604 (OtherLetter), 46 (OtherPunctuation), 1587 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'Thai Baht', default, N'THB', 1054, 2, N'?', default, default),
(N'Tunisian Dinar', default, N'TND', 7169, 3, N'DT', default, default), -- Non-standard characters: 1583 (OtherLetter), 46 (OtherPunctuation), 1578 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'New Turkish Lira', default, N'TRY', 1055, 2, N'YTL', default, default),
(N'Trinidad Dollar', default, N'TTD', 11273, 2, N'TT$', default, default),
(N'New Taiwan Dollar', default, N'TWD', 1028, 2, N'NT$', default, default),
(N'Ukrainian Grivna', default, N'UAH', 1058, 2, N'???.', default, default),
(N'US Dollar', default, N'USD', 1033, 2, N'$', default, default),
(N'Peso Uruguayo', default, N'UYU', 14346, 2, N'$U', default, default),
(N'Venezuelan Bolivar', default, N'VEB', 8202, 2, N'Bs', default, default),
(N'Vietnamese Dong', default, N'VND', 1066, 2, N'?', default, default),
(N'Yemeni Rial', default, N'YER', 9217, 2, N'', default, default), -- Non-standard characters: 1585 (OtherLetter), 46 (OtherPunctuation), 1610 (OtherLetter), 46 (OtherPunctuation), 8207 (Format). Replaced symbol with another value.
(N'South African Rand', default, N'ZAR', 1078, 2, N'R', default, default),
(N'Zimbabwe Dollar', default, N'ZWD', 12297, 2, N'Z$', default, default);
insert into
dbo.CURRENCY (NAME, INACTIVE, ISO4217, LOCALEID, DECIMALDIGITS, CURRENCYSYMBOL, ROUNDINGTYPECODE, SYMBOLDISPLAYSETTINGCODE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
select
DEFAULTCURRENCY.NAME, DEFAULTCURRENCY.INACTIVE, DEFAULTCURRENCY.ISO4217, LOCALE.ID, DEFAULTCURRENCY.DECIMALDIGITS, DEFAULTCURRENCY.CURRENCYSYMBOL, DEFAULTCURRENCY.ROUNDINGTYPECODE, DEFAULTCURRENCY.SYMBOLDISPLAYSETTINGCODE, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
from
@DEFAULTCURRENCY [DEFAULTCURRENCY]
inner join dbo.LOCALE on DEFAULTCURRENCY.WINDOWSLOCALEID = LOCALE.LOCALEID
left join dbo.CURRENCY on
DEFAULTCURRENCY.NAME = CURRENCY.NAME
or DEFAULTCURRENCY.ISO4217 = CURRENCY.ISO4217
where
CURRENCY.ID is null;
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;