Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

Topic

Designation

Example

Data declaration

  • Str: String, Text

  • Int: Integer, Number

  • 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 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

  • No labels