TimezoneAdjustmentRule#
Description: This table holds a set of timezone adjustment rules to fully support the conversion of a local date to UTC having in account the daylight saving time settings per region
The TimezoneAdjustmentRule table has the following fields:
| Field | Description | Key | Mandatory | Reference Type | Comments |
|---|---|---|---|---|---|
| Timezone | Timezone | No | Yes | Timezone | |
| TimezoneId | TimezoneId | Yes | Yes | ||
| RuleNo | RuleNo | No | Yes | ||
| DateStart | DateStart | Yes | Yes | ||
| DateEnd | DateEnd | Yes | Yes | ||
| DaylightTransitionStartIsFixedDateRule | DaylightTransitionStartIsFixedDateRule | No | Yes | ||
| DaylightTransitionStartMonth | DaylightTransitionStartMonth | No | Yes | ||
| DaylightTransitionStartDay | DaylightTransitionStartDay | No | Yes | ||
| DaylightTransitionStartWeek | DaylightTransitionStartWeek | No | Yes | ||
| DaylightTransitionStartDayOfWeek | DaylightTransitionStartDayOfWeek | No | Yes | ||
| DaylightTransitionStartTimeOfDay | DaylightTransitionStartTimeOfDay | No | Yes | ||
| DaylightTransitionEndIsFixedDateRule | DaylightTransitionEndIsFixedDateRule | No | Yes | ||
| DaylightTransitionEndMonth | DaylightTransitionEndMonth | No | Yes | ||
| DaylightTransitionEndDay | DaylightTransitionEndDay | No | Yes | ||
| DaylightTransitionEndWeek | DaylightTransitionEndWeek | No | Yes | ||
| DaylightTransitionEndDayOfWeek | DaylightTransitionEndDayOfWeek | No | Yes | ||
| DaylightTransitionEndTimeOfDay | DaylightTransitionEndTimeOfDay | No | Yes | ||
| DaylightDeltaSec | DaylightDeltaSec | No | Yes |
Table: TimezoneAdjustmentRule fields