Introduction
ADD_PRICE_IDMP 3.1.0 XML schema
Documentation
Last revised 01/12/2021
Documented XML schema:
ADD_PRICE_IDMP_3_1_0.xsd
Contakt DCC e.V.
Dr.-Ing. Olaf Pl�mer
E-Mail pluemer@dcc-moebel.org
Telephon 0 52 21/12 65-37
Anika Degenhard
E-Mail degenhard@dcc-moebel.org
Telephon 0 52 21/12 65-38
Basic structure of the IDM schema
������������������������������������������������������������������������������������������������������������������� �������������������������ADD_PRICE_IDMP
3.1.0 XML schema Documentation
Einleitung > Basic structure of the IDM schema
Basic structure of the IDMP schema
The main element T_ADD_PRICE_CATALOG defines that a new, additional data record with additional prices is made available in addition to the base catalogue.
The IDM schema is subdivided in data ranges that are specified in the subsequent child-elements (see figure 1) in T_ADD_PRICE_CATALOG.
Figure 1 - child elements in T_ADD_PRICE_CATALOG
The data ranges are not used in isolation from each other. In some data ranges, data is initially created and used from other data ranges via referencing.
Additionally, many data ranges contain references to the associated base catalogue.
Description of the data ranges
CATALOG
CATALOG is used to store administrative information concerning the data pool. E.g. the version of the data format, release date or the unique identification of the data pool.
�
REF_CATALOG
Information on the base catalogue is specified in REF_CATALOG.
GLOBAL_DEFINITION
The GLOBAL_DEFINITION data range is a kind of data pool for information used in the other data ranges. In this case, the information on price types can be assigned additional prices within these data records.
SERIES
The additional prices for the items of the base catalogue are specified in SERIES. Items are combined into product groups, such as armchairs or intermediate elements.
Data types
������������������������������������������������������������������������������������������������������������������� �������������������������ADD_PRICE_IDMP
3.1.0 XML schema Documentation
Einleitung > Data types
Data types and value ranges
The IDM schema uses the data types defined in the standard XML schema 1.0 second edition (28 October 2004).
It uses the following data types:
|
boolean |
This data type maps the logical values "true" or "false". In accordance with the W3C recommendation for XML schemas, the values that can be used in the IDM are true/false or 1/0. |
|
date |
In the IDMP, the data type date is used in conformity with the XML schemas as follows: YYYY-MM-DD Y = year, M = month, D = day |
|
integer |
Numbers can be positive and negative integers. |
|
nonNegativeInteger |
Value is a positive integer, including 0 |
|
positiveInteger |
Value is a positive integer, excluding 0 |
|
decimal |
The data type is used in the IDMP for floating-point values. Floating-point values for this data type are, as recommended by the W3C, stored as 126.56 or -45.98000 or +27.0. |
|
string |
A limited number of alphanumeric characters and special characters. |
|
anyURI |
The data type is used in the IDMP for URLs.anyURI represents a Uniform Resource Identifier (URI). The lexical part of anyURI is an indefinite sequence of characters that correspond to a legal URI. An anyURI value can be absolute or relative and may contain fragment codes (e.g. an URI reference). |
|
language |
The data type is used in the IDMP for the mapping of valid language keys.language represents codes for natural languages Tags for the Identification of Languagesas defined in the Thevaluerangeof language is the quantum of all character sequences that represent a valid code of a natural language. For ISO languages, the format consists of a sequence of 2-3 lower case letters optionally followed by a hyphen and a country code consisting of 2 upper case letters, e.g. en-US. |
|
|
|
|
|
|
|
Additionally, there is also a user-defined data type: |
|
|
|
|
|
operator |
Thy data type is used for rules in the IDMP. This simple, self-defined data type defines an operator for comparisons. The comparison operator is a string of 1 to 4 characters length and may contain the following values: |
|
eq (equal) |
|
|
ne (not equal) |
|
|
in (is contained in a quantity) |
|
|
nin (is not contained in a quantity) |
|
|
gt (greater) |
|
|
lt (less) |
|
|
ge (greater than or equal) |
|
|
le (less than or equal) |
|
The value ranges of the above data types are usually restricted for the elements in the IDMP. The "restrictions" in the data type definition contains restrictions for minimum and maximum values, permitted characters (pattern) and value lists.
In the documentation of the XML schema of the IDM, the value ranges are specified by the information coming after M and P.
Notes to the documentation
������������������������������������������������������������������������������������������������������������������ �������������������������ADD_PRICE_IDMP
3.1.0 XML schema Documentation
Einleitung > Notes to the documentation
Notes to the IDMP documentation
Notes to the IDM documentation schema are stored in this section.
Explanation of the element properties
Each element is documented on the basis of a description and its properties. The following shows an example for an element description:
Description:
The element properties are documented on the right side. They have the following meaning:
|
D |
The data type of the element is documented here. If this position is left blank, the element does not contain any reference data but additional child-elements. |
||
|
P |
The entries made in P and M document the value range of an element. A regular expression that defines the permitted values must be entered in P. |
||
|
M |
The minimum and maximum permitted values must be entered in M. In the case of a string data type, P defines the permitted characters and M the minimum and maximum character length. In the case of a numeric data type, the permitted minimum and maximum value is defined. |
||
Language key
�������������������������������������������������������������������������������������������������������������������� ������������������������
ADD_PRICE_IDMP
3.1.0 XML schema Documentation
Einleitung > Language key
|
Language key |
Language name |
|
AA |
Afar |
|
AB |
Abkhazian |
|
AE |
Avestan |
|
AF |
Afrikaans |
|
AK |
Akan |
|
AM |
Amharic |
|
AN |
Aragonese |
|
AR |
Arabic |
|
AS |
Assam |
|
AV |
Avarisch |
|
AY |
Aymara |
|
AZ |
Azerbaijanian |
|
BA |
Baschkirian |
|
BE |
Byelorussian |
|
BG |
Bulgarian |
|
BH |
Biharic |
|
BI |
Bislamic |
|
BM |
Bambara |
|
BN |
Bengal |
|
BO |
Tibetan |
|
BR |
Breton |
|
BS |
Bosnian |
|
CA |
Catalan |
|
CE |
Circassian |
|
CH |
Chamorro |
|
CO |
Corsican |
|
CR |
Cree |
|
CS |
Czech |
|
CU |
Old slavish |
|
CV |
Chuvash |
|
CY |
Welsh |
|
DA |
Danish |
|
DE |
German |
|
DV |
Dhivehi |
|
DZ |
Dzongkha |
|
EE |
Estonian |
|
EL |
Greek |
|
EN |
English |
|
EO |
Esperanto |
|
ES |
Spanish |
|
ET |
Estonian |
|
EU |
Basque |
|
FA |
Persian |
|
FF |
Fulfulde |
|
FI |
Finno-Ugric |
|
FJ |
Fiji |
|
FO |
Faroese |
|
FR |
French |
|
FY |
Frisian |
|
GA |
Irish |
|
GD |
Gaelic |
|
GL |
Galician |
|
GN |
Guarani |
|
GU |
Gujaratic |
|
GV |
Manx, Manx-Gaelic |
|
HA |
Hausa |
|
HE |
Hebrew |
|
HI |
Hindi |
|
HO |
Hiri Motu |
|
HR |
Croatian |
|
HT |
Haitian |
|
HU |
Hungarian |
|
HY |
Armenian |
|
HZ |
Herero |
|
IA |
Interlingua |
|
ID |
Indonesian |
|
IE |
Interlingue |
|
IG |
Igbo |
|
II |
Yi |
|
IK |
Inupiak |
|
IN |
former Indonesian |
|
IO |
Ido |
|
IS |
Icelandic |
|
IT |
Italian |
|
IU |
Inuit |
|
JA |
Japanese |
|
JV |
Javanese |
|
KA |
Georgian |
|
KG |
Kikongo |
|
KI |
Kikuyu |
|
KJ |
Kuanyama |
|
KK |
Kazakh |
|
KL |
Kalaallisut (Greenland) |
|
KM |
Cambodian |
|
KN |
Canadian |
|
KO |
Korean |
|
KR |
Kanuri |
|
KS |
Kashmirian |
|
KU |
Kurdish |
|
KV |
Komi |
|
KW |
Cornish |
|
KY |
Kirghiz |
|
LA |
Latin |
|
LB |
Luxembourgish |
|
LG |
Luganda |
|
LI |
Limburg |
|
LN |
Lingala |
|
LO |
Laotian |
|
LT |
Lithuanian |
|
LU |
Kiluba |
|
LV |
Lett |
|
MG |
Malagasy |
|
MH |
Marshallese |
|
MI |
Maori |
|
MK |
Macedonian |
|
ML |
Malay |
|
MN |
Mongolian |
|
MO |
Moldovan |
|
MR |
Marathi |
|
MS |
Malayan |
|
MT |
Maltese |
|
MY |
Burmese |
|
NA |
Nauruan |
|
NB |
Norwegian Bokm�l |
|
ND |
North Ndebele |
|
NE |
Nepalese |
|
NG |
Ndonga |
|
NL |
Dutch |
|
NN |
Norwegian Nynorsk |
|
NO |
Norwegian |
|
NR |
South Ndebele |
|
NV |
Navajo |
|
NY |
Chichewa |
|
OC |
Occitan |
|
OJ |
Ojibwe |
|
OM |
Oromo |
|
OR |
Orija |
|
OS |
Ossetian |
|
PA |
Punjab |
|
PI |
Pali |
|
PL |
Polish |
|
PS |
Paschtu |
|
PT |
Portugese |
|
QU |
Quechua |
|
RM |
Rhaeto-Romanic |
|
RN |
Kirundish |
|
RO |
Romanian |
|
RU |
Russian |
|
RW |
Kijarwanda |
|
SA |
Sanskrit |
|
SC |
Sardinian |
|
SD |
Sinto |
|
SE |
North Sami |
|
SG |
Sango |
|
SI |
Sinhalese |
|
SK |
Slovakian |
|
SL |
Slovenian |
|
SM |
Samoan |
|
SN |
Shonian |
|
SO |
Somali |
|
SQ |
Albanian |
|
SR |
Serbian |
|
SS |
Swazi |
|
ST |
Sesothish |
|
SU |
Sudanese |
|
SV |
Swedish |
|
SW |
Swahili |
|
TA |
Tamil |
|
TE |
Tegulu |
|
TG |
Tajik |
|
TH |
Thai |
|
TI |
Tigrinja |
|
TK |
Turkmenian |
|
TL |
Tagalog |
|
TN |
Sezuan |
|
TO |
Tongan |
|
TR |
Turkish |
|
TS |
Tongan |
|
TT |
Tartary |
|
TW |
Twi |
|
TY |
Thai |
|
UG |
Uighur |
|
UK |
Ukranian |
|
UR |
Urdu |
|
UZ |
Uzbek |
|
VE |
Tshivenda |
|
VI |
Vietnamese |
|
VO |
Volap�k |
|
WA |
Walloon |
|
WO |
Wolof |
|
XH |
Xhosa |
|
YI |
Yiddish |
|
YO |
Joruba |
|
ZA |
Zhuang |
|
ZH |
Chinese |
|
ZU |
Zulu |
According to the ISO standard, the language keys are generally written with small letters. Capital letters are used for the IDM data.
Country code
�������������������������������������������������������������������������������������������������������������������� ������������������������
ADD_PRICE_IDMP
3.1.0 XML schema Documentation
Einleitung > Country code
|
country code |
country |
|
AC |
Ascension |
|
AD |
Andorra |
|
AE |
United Arab Emirates |
|
AF |
Afghanistan |
|
AG |
Antigua and Barbuda |
|
AI |
Anguilla |
|
AL |
Albania |
|
AM |
Armenia |
|
AN |
Dutch Antilles |
|
AO |
Angola |
|
AQ |
Antarctica |
|
AR |
Argentina |
|
AS |
American Samoa |
|
AT |
Austria |
|
AU |
Australia |
|
AW |
Aruba |
|
AX |
Aland |
|
AZ |
Azerbaijan |
|
BA |
Bosnia and Herzegovina |
|
BB |
Barbados |
|
BD |
Bangladesh |
|
BE |
Belgium |
|
BF |
Burkina Faso |
|
BG |
Bulgaria |
|
BH |
Bahrain |
|
BI |
Burundi |
|
BJ |
Benin |
|
BL |
Saint-Barth�lemy |
|
BM |
Bermuda |
|
BN |
Brunei Darussalam |
|
BO |
Bolivia |
|
BQ |
Bonaire, Sint Eustatius and Saba |
|
BR |
Brazil |
|
BS |
Bahamas |
|
BT |
Bhutan |
|
BU |
Burma |
|
BV |
Bouvet Island |
|
BW |
Botswana |
|
BY |
Belarus |
|
BZ |
Belize |
|
CA |
Canada |
|
CC |
Cocos) Islands |
|
CD |
Democratic Republic of the Congo |
|
CF |
Central African Republic |
|
CG |
Republic of the Congo |
|
CH |
Switzerland |
|
CI |
Ivory Coast |
|
CK |
Cook Islands |
|
CL |
Chile |
|
CM |
Cameroon |
|
CN |
China |
|
CO |
Columbia |
|
CP |
Clipperton |
|
CR |
Costa Rica |
|
CU |
Cuba |
|
CV |
Cape Verde |
|
CW |
Cura�ao |
|
CX |
Christmas Island |
|
CY |
Cyprus |
|
CZ |
Czech Republic |
|
DE |
Germany |
|
DG |
Diego Garcia |
|
DJ |
Djibouti |
|
DK |
Denmark |
|
DM |
Dominica |
|
DO |
Dominican Republic |
|
DZ |
Algeria |
|
EA |
Ceuta, Melilla |
|
EC |
Ecuador |
|
EE |
Estonia |
|
EG |
Egypt |
|
EH |
Westsahara |
|
EN |
England |
|
ER |
Eritrea |
|
ES |
Spain |
|
ET |
Ethiopia |
|
FI |
Finland |
|
FJ |
Fiji |
|
FK |
Falklands |
|
FM |
Micronesia |
|
FO |
Faeroe Islands |
|
FR |
France |
|
GA |
Gabon |
|
GB |
England/Great Britain |
|
GD |
Grenada |
|
GE |
Georgia |
|
GF |
French Guiana |
|
GG |
Guernsey (Channel Island) |
|
GH |
Ghana |
|
GI |
Gibraltar |
|
GL |
Greenland |
|
GM |
Gambia |
|
GN |
Guinea |
|
GP |
Guadeloupe |
|
GQ |
Equatorial Guinea |
|
GR |
Greece |
|
GS |
South Georgia and the South Sandwich Islands |
|
GT |
Guatemala |
|
GU |
Guam |
|
GW |
Guinea-Bissau |
|
GY |
Guyana |
|
HK |
Hong Kong |
|
HM |
Heard and McDonald Islands |
|
HN |
Honduras |
|
HR |
Croatia |
|
HT |
Haiti |
|
HU |
Hungary |
|
ID |
Indonesian |
|
IE |
Ireland |
|
IL |
Israel |
|
IM |
Isle of Man |
|
IN |
India |
|
IO |
British Indian Ocean Territory |
|
IQ |
Iraq |
|
IR |
Islamic Republic of Iran |
|
IS |
Iceland |
|
IT |
Italy |
|
JE |
Channel Island of Jersey |
|
JM |
Jamaica |
|
JO |
Jordan |
|
JP |
Japan |
|
KE |
Kenya |
|
KG |
Kyrgyzstan |
|
KH |
Cambodia |
|
KI |
Kiribati |
|
KM |
Comoros |
|
KN |
Saint Kitts and Nevis |
|
KP |
Democratic People's Republic of Korea |
|
KR |
Republic of Korea |
|
KW |
Kuwait |
|
KY |
Cayman Islands |
|
KZ |
Kazakstan |
|
LA |
Laos |
|
LB |
Lebanon |
|
LC |
Saint Lucia |
|
LI |
Liechtenstein |
|
LK |
Sri Lanka |
|
LR |
Liberia |
|
LS |
Lesotho |
|
LT |
Lithuania |
|
LU |
Luxembourg |
|
LV |
Latvia |
|
LY |
Libya |
|
MA |
Morocco |
|
MC |
Monaco |
|
MD |
Moldavia |
|
ME |
Montenegro |
|
MF |
Saint Martin |
|
MG |
Madagascar |
|
MH |
Marshall Islands |
|
MK |
North Macedonia |
|
ML |
Mali |
|
MM |
Myanmar (Burma) |
|
MN |
Mongolia |
|
MO |
Macau |
|
MP |
Northern Mariana Islands |
|
MQ |
Martinique |
|
MR |
Mauritania |
|
MS |
Montserrat |
|
MT |
Malta |
|
MU |
Mauritius |
|
MV |
Maldives |
|
MW |
Malawi |
|
MX |
Mexico |
|
MY |
Malaysia |
|
MZ |
Mozambique |
|
NA |
Namibia |
|
NC |
New Caledonia |
|
NE |
Niger |
|
NF |
Norfolk Island |
|
NG |
Nigeria |
|
NI |
Nicaragua |
|
NL |
Netherlands |
|
NO |
Norway |
|
NP |
Nepal |
|
NR |
Nauru |
|
NU |
Niue |
|
NZ |
New Zealand |
|
OM |
Oman |
|
PA |
Panama |
|
PE |
Peru |
|
PF |
French Polynesia |
|
PG |
Papuan New Guinea |
|
PH |
Philippine |
|
PK |
Pakistan |
|
PL |
Poland |
|
PM |
St. Pierre and Miquelon |
|
PN |
Pitcairn Islands |
|
PR |
Puerto Rica |
|
PS |
Palestine |
|
PT |
Portugal |
|
PW |
Palau |
|
PY |
Paraguay |
|
QA |
Qatar |
|
RE |
Reunion |
|
RO |
Romania |
|
RS |
Serbia |
|
RU |
Russia |
|
RW |
Ruanda |
|
SA |
Saudi Arabia |
|
SB |
Solomon Islands |
|
SC |
Seychelles |
|
SD |
Sudan |
|
SE |
Sweden |
|
SG |
Singapore |
|
SH |
St. Helena |
|
SI |
Slovenia |
|
SJ |
Svalbard and Jan Mayen Islands |
|
SK |
Slovak Republic |
|
SL |
Sierra Leone |
|
SM |
San Marino |
|
SN |
Senegal |
|
SO |
Somalia |
|
SR |
Suriname |
|
SS |
South Sudan |
|
ST |
Democratic Republic of S�o Tom� and Pr�ncipe |
|
SV |
El Salvador |
|
SX |
Sint Maarten |
|
SY |
Syrian Arab Republic |
|
SZ |
Swaziland |
|
TC |
Turks and Caicos Islands |
|
TD |
Chad |
|
TF |
French Southern and Antarctic Territories |
|
TG |
Togo |
|
TH |
Thailand |
|
TJ |
Tadschikistan |
|
TK |
Tokelau |
|
TL |
East Timor |
|
TM |
Turkmenistan |
|
TN |
Tunisia |
|
TO |
Tonga |
|
TR |
Turkey |
|
TT |
Trinidad and Tobago |
|
TV |
Tuvalu |
|
TW |
Taiwan |
|
TZ |
Tanzania |
|
UA |
Ukraine |
|
UG |
Uganda |
|
UM |
United States Minor Outlying Islands |
|
US |
United States of America |
|
UY |
Uruguay |
|
UZ |
Uzbekistan |
|
VA |
Vatican City |
|
VC |
Saint Vincent and the Grenadines |
|
VE |
Venezuela |
|
VG |
British Virgin Islands |
|
VI |
American Virgin Islands |
|
VN |
Vietnam |
|
VU |
Vanuatu |
|
WF |
Wallis and Futuna Islands |
|
WS |
Samoa |
|
YE |
Yemen |
|
YT |
Mayotte |
|
ZA |
South Africa |
|
ZM |
Sambia |
|
ZW |
Zimbabwe |
