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