4.5 Sheet: Unassigned Orders

4.5.1 Column: Order

Type: Text.
Description: The identifier of the unassigned order as given by the Id column of the Orders sheet.

4.5.2 Column: Customer Name

Type: Text.
Description: The name of the customer for the order as given in the Orders sheet. This column will be omitted if all of the orders have blank customer names.

4.5.3 Column: Weight

Type: Number.
Description: The weight of the unassigned order as given by the Weight column of the Orders sheet. This column will be omitted if there are no orders with non-zero weight.

4.5.4 Column: Volume

Type: Number.
Description: The volume of the unassigned order as given by the volume column of the Orders sheet. This column will be omitted if there are no orders with non-zero volume.

4.5.5 Column: Pickup Location

Type: Text.
Description: The identifier of the pickup location of the unassigned order as given by the Id column of the Locations sheet.

4.5.6 Column: Delivery Location

Type: Text.
Description: The identifier of the delivery location of the unassigned order as given by the Id column of the Locations sheet.

4.5.7 Column: Reason

Type: Text.
Description: A reason why the order was not assigned.
Note: There may be multiple reason columns. Reasons may not be provided for some unassigned orders; this usually indicates a lack of fleet capacity or insufficient available working hours.