Topic | ElaborationDesignation | Example |
|---|
Data declaration | Str: String, Text Int: Integer, Number Short: (Signed short) 0 - 32'767 Ushort: (Unsigned short) 0 - 65’535 Dec: Decimal, Number with decimals Bool: Boolean, true/false, 1/0 Date: Date
| - |
|---|
Information in brackets | After the data type, the permissible number range, the number of characters or the format is indicated in brackets. (10): A maximum of 10 digits or characters are permitted. (10,4): A maximum of 10 digits before and 4 digits after the decimal point are permitted. (8-14): Between 8 and 14 digits or characters are allowed.
| Str(100), Int(5), Dec(8,4) |
|---|
Indexierung | *_index: Describes a consecutive numbering of columns with the same content. | ImageUrl_1, ImageUrl_2 |
|---|
Sprachen | *_language: Describes the language identification of language-dependent columns with the same content. (following standard ISO 639-1) | ProductTitle_de, ProductTitle_en |
|---|
Währung | *_currency: Describes how to mark the currency of price columns. Prices can be indicated in CHR CHF or in EUR. | SalesPriceExclVat_CHF, PurchasePriceExclVat_EUR |
|---|
Einheiten | *_unit: Describes the labelling of the units of dimension-specific columns. The permissible units are indicated in the corresponding columns. | Weight_g, Length_cm |
|---|
Länder | *_country: Describes the country identification of country-specific columns. (following standard ISO 3166 ALPHA-2) | ReleaseDate_CH, ReleaseDate_DE |
|---|
