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 the 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 Locations 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 Locations 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.