Business Hours

Internal Table Name: OpenHourLocation

You can optionally define the business hours per day per site, customer or transportation asset using this table. Business Hours act as constraints on when locations are open and assets are available. If you do not define Business Hours for days in the week, the location is considered open and the asset is available for that entire day.

Simulation: Not available in Classic Simulation.

Entity

Technology: TO S

Table: OpenHourLocation

Internal Name: SiteName

Type: Short Text (100)

The location or transportation asset to which the business hours apply. This can be one of the following: customer, site, asset, customer filter or group, site filter or group, asset filter or group.

Sunday Open

Technology: TO S

Table: OpenHourLocation

Internal Name: SunOpen

Type: Short Text (50)

The time at which the location opens or asset is available on Sunday.

Default: 00:00

Sunday Closed

Technology: TO S

Table: OpenHourLocation

Internal Name: SunClosed

Type: Short Text (50)

The time at which the location closes or asset is no longer available on Sunday.

Default: 23:59

Monday Open

Technology: TO S

Table: OpenHourLocation

Internal Name: MonOpen

Type: Short Text (50)

The time at which the location opens or asset is available on Monday.

Default: 00:00

Monday Closed

Technology: TO S

Table: OpenHourLocation

Internal Name: MonClosed

Type: Short Text (50)

The time at which the location closes or asset is no longer available on Monday.

Default: 23:59

Tuesday Open

Technology: TO S

Table: OpenHourLocation

Internal Name: TueOpen

Type: Short Text (50)

The time at which the location opens or asset is available on Tuesday.

Default: 00:00

Tuesday Closed

Technology: TO S

Table: OpenHourLocation

Internal Name: TueClosed

Type: Short Text (50)

The time at which the location closes or asset is no longer available on Tuesday.

Default: 23:59

Wednesday Open

Technology: TO S

Table: OpenHourLocation

Internal Name: WedOpen

Type: Short Text (50)

The time at which the location opens or asset is available on Wednesday.

Default: 00:00

Wednesday Closed

Technology: TO S

Table: OpenHourLocation

Internal Name: WedClosed

Type: Short Text (50)

The time at which the location closes or asset is no longer available on Wednesday.

Default: 23:59

Thursday Open

Technology: TO S

Table: OpenHourLocation

Internal Name: ThuOpen

Type: Short Text (50)

The time at which the location opens or asset is available on Thursday.

Default: 00:00

Thursday Closed

Technology: TO S

Table: OpenHourLocation

Internal Name: ThuClosed

Type: Short Text (50)

The time at which the location closes or asset is no longer available on Thursday.

Default: 23:59

Friday Open

Technology: TO S

Table: OpenHourLocation

Internal Name: FriOpen

Type: Short Text (50)

The time at which the location opens or asset is available on Friday.

Default: 00:00

Friday Closed

Technology: TO S

Table: OpenHourLocation

Internal Name: FriClosed

Type: Short Text (50)

The time at which the location closes or asset is no longer available on Friday.

Default: 23:59

Saturday Open

Technology: TO S

Table: OpenHourLocation

Internal Name: SatOpen

Type: Short Text (50)

The time at which the location opens or asset is available on Saturday.

Default: 00:00

Saturday Closed

Technology: TO S

Table: OpenHourLocation

Internal Name: SatClosed

Type: Short Text (50)

The time at which the location closes or asset is no longer available on Saturday.

Default: 23:59

Activity

Technology: S

Table: OpenHourLocation

Internal Name: Activity

Type: Short Text (32)

One of null, Load, Unload, Production

You can limit the business hours to a specific activity at a site. When the business hours for a site have no Activity selected, this determines when the site is open versus closed. You can also define a record where the Activity is "Load", indicating that these are the specific hours in which loading can occur at this site.

These activities can occur outside normal business hours, and you can use the Activity to model this behavior. For example, assume the business hours of the site are 08:00 to 15:00, but production does not need to be constrained by these general business hours. You create a record using these hours with no Activity selected to model the operational hours of the site. You then create a second record with hours from 12:00 to 17:00 where the Activity is "Production". The business hours of the activity act as the constraint on production, rather than the business hours of the site itself. In our example, if there are 10 units to produce and Unit Production Time is 1 hour with a Production Policies Schedule Rule of "RunUntilUnavailable", 5 units are produced on the first day and the remaining 5 are produced when the site next opens for production.

Default: null

Status

Technology: TO S

Table: OpenHourLocation

Internal Name: Status

Type: Short Text (50)

One of Include, Exclude.

Use this column to determine if Transportation Optimization or Simulation should consider the Business Hours record.

Default: Include