invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

CALENDAR: Data Dictionary Calendar

read only

  • Catalogus: DataDictionary
  • Schema: Invantive
  • Label: Calendar

Mapping from dates to date-related integers such as year and day in week.

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel CALENDAR worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
CENTURY_NUMBER int32 Eeuwnummer The number of the century.
DAY_DATE date Dag Datum The date of the day.
DAY_IN_MONTH int32 Dag in Maand The number of the day in the month.
DAY_IN_WEEK int32 Dag in Week The number of the day in the week.
DAY_IN_YEAR_NUMBER int32 Dag in Jaar Nummer The number of the day in the year.
DAY_SINCE_19000101_NUMBER int64 Dagnummer sinds 1 januari 1900 The number of days between 01/01/1900 and the day.
ERA int32 Era The era of the century.
ID int32 ID Unique ID of the day.
ISO_WEEK_NUMBER int32 ISO-weeknummer The number of the week by ISO.
ISO_YEAR_NUMBER int32 ISO-jaarnummer The number of the year by ISO.
MONTH_NR_DAY1_IN_WEEK int32 Maandnummer van Eerste Dag in de Week The number of the month on the first day in the week.
MONTH_NR_DAY7_IN_WEEK int32 Maandnummer van Laatste Dag in de Week The number of the month on the seventh day in the week.
MONTH_NUMBER int32 Maandnummer The number of the month.
WEEK_NUMBER int32 Weeknummer The number of the week.
YEAR_NR_DAY1_IN_WEEK int32 Jaarnummer van Dag 1 in Week The number of the year on the first day in the week.
YEAR_NR_DAY7_IN_WEEK int32 Jaarnummer van Dag 1 in Week The number of the year on the seventh day in the week.
YEAR_NUMBER int32 Jaarnummer The number of the year.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: