Asset Availability

Internal Table Name: AssetAvailability

You use the Asset Availability table to define the asset available at each site. You must define at least one asset availability record.

Site

Technology: TO

Table: AssetAvailability

Internal Name: SiteName

Type: Short Text (100)

The location (or site group) at which the asset is located.

Asset

Technology: TO

Table: AssetAvailability

Internal Name: TransportationAssetName

Type: Short Text (100)

The transportation asset (or asset group) for the availability.

Available Units

Technology: TO

Table: AssetAvailability

Internal Name: AvailableQty

Type: Number (Long Integer)

The number of vehicles of the specified asset type available at the location. When specifying the Asset Availability for a periodic VRP model, the Available Units represents the number of vehicles available per day.

Default: 0

Priority

Technology:

Table: AssetAvailability

Internal Name: Priority

Type: Number (Integer)

This column is not currently used.

Default: 0

Linehaul Source

Technology: TO

Table: AssetAvailability

Internal Name: AltRouteSource

Type: Short Text (100)

Use this field to identify the source location or group of source locations that the asset can use. The asset will be limited to linehaul routes between the Alt. Route Source and the Alt. Route Destination locations.

Linehaul Destination

Technology: TO

Table: AssetAvailability

Internal Name: AltRouteDestination

Type: Short Text (100)

Use this field to identify the destination location or group of destination locations that the asset can use. The destination locations are the hubs that the asset can serve. The asset will be limited to linehaul routes between the Linehaul Source and the Linehaul Destination locations.

Start Date

Technology: TO

Table: AssetAvailability

Internal Name: StartDateTime

Type: Date/Time

The start date and time of the asset availability. If no Date is provided, it is set to the Start Date value in the Model Settings. If no time is provided, it is set to the beginning of the day.

Start Date Formula

Technology: TO

Table: AssetAvailability

Internal Name: StartDateTimeFormula

Type: Short Text (50)

Specify a number or distribution that defines the start date and time of the asset availability. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

End Date

Technology: TO

Table: AssetAvailability

Internal Name: EndDateTime

Type: Date/Time

The end date and time of the asset availability. If no Date is provided, it is set to the End Date value in the Model Settings. If no time is provided, it is set to the end of the day.

End Date Formula

Technology: TO

Table: AssetAvailability

Internal Name: EndDateTimeFormula

Type: Short Text (50)

Specify a number or distribution that defines the end date and time of the asset availability as an offset from the Start Date. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.

Minimum Units

Technology: TO

Table: AssetAvailability

Internal Name: MinimumUnits

Type: Number (Integer)

The minimum number of vehicles that must be used for that asset availability. The Minimum Units value is a soft constraint. Example use cases include:

  • The cheapest option is to deliver all shipments in my model using 5 vehicles but I have 6 drivers so I want to use 6 vehicles. I define a Minimum Units value of 6 for this Asset Availability record.

  • I have defined both small and large vehicles, and I want to use at least 3 small vehicles. I define a Minimum Units value of 3 for this Asset Availability record.

Default: 0

Status

Technology: TO

Table: AssetAvailability

Internal Name: Status

Type: Short Text (50)

One of Include, Exclude.

Use this field to determine if Transportation Optimization should consider the Asset Availability record.

Default: Include

Last modified: Wednesday May 15, 2024

Is this useful?