2.2 Sheet: Orders

This sheet is required and must contain at least one order.

2.2.1 Column: Id

Required: Yes.
Type: Number (integer).
Description: A unique identifier for the order.

2.2.2 Column: Site

Required: Yes.
Type: Text or (integer) number.
Description: A site identifier from the Sites sheet: the site to which the order is to be delivered.

2.2.3 Column: Product

Required: Yes.
Type: Text or (integer) number.
Description: A product identifier from the Products sheet: the product being delivered.

2.2.4 Column: Minimum Compartment Volume

Required: No.
Type: Number (nonnegative integer).
Description: A minimum volume that must be loaded into each compartment that this order is assigned to.
Default: 0.

2.2.5 Column: Target Volume

Required: Yes.
Type: Number (integer).
Description: The target volume to be delivered for this order; must be greater than zero.

2.2.6 Column: Maximum Volume

Required: Yes.
Type: Number (integer).
Description: The maximum volume to be delivered for this order; must be greater than the target volume.

2.2.7 Column: Required

Required: No.
Value Type: Text (Boolean).
Description: If TRUE, then this order is required.
Default: FALSE.