Order Line

Report Columns

• Allocated Quantity

  Quantity of materials in the order line that have been allocated.

• Allocated Quantity (from Order table)

  Quantity of materials in the order that have been allocated.

• Block Reason (from Material table)

  Reason for blocking the material from warehouse operations.

• Blocked (from Material table)

  Sets or resets if the material is blocked from warehousing operations, i.e. picking and putting.

  Values:

  0 = False
  1 = True

• Can Order Point (from Material table)

  The material will be handled in the Material Can-order List, as soon as its stock falls below the entered value.

• Counting Cycle (from Material Property table)

  Number of days between count orders for a material, assigned by a material property.

• Creation Date

  Date and time the order line was created.

• Creation Date (from Material table)

  Date and time the material was created.

• Creation Date (from Order table)

  Date and time the order was created.

• Creation Date (from Cost Center table)

  Date and time cost center was created.

• Danger Class (from Material Property table)

  Number of the danger class assigned to the material.

• Deadline (from Order table)

  Date by which the order must be completed.

• Description (from Job table)

  Description of the job.

• Description (from Material Property table)

  Description of the material family the material was assigned to, from a dropdown list or tree structure.

• Description (from Cost Center table)

  Description of the cost center. This should indicate if it is recording where the picked orders are being used, or the accounting code being charged to.

• Direction Type (from Order table)

  The type of order.

  Values:

  1 = Put
  2 = Pick
  3 = Return
  4 = Transport
  5 = Count
  7 = Production

• Expiry Date

  Used by a material property to track material expiry.

• Fill Quantity (from Material table)

  The amount needed to replenish back to the can-order point.

• Has Stock

  If there is enough stock to fulfill the order line.

  Values:

  0 = False
  1 = True

• Has Stock (from Order table)

  If there is enough stock to fulfill the order.

  Values:

  0 = False
  1 = True

• Host Identification

  The identification sent from host system, specially by SAP. Will be written to history table to report it back to the host.

• Info1

  Information field 1 of the order line.

• Info1 (from Material table)

  Information field 1 of the material.

• Info1 (from Order table)

  Information field 1 of the order.

• Info2

  Information field 2 of the order line.

• Info2 (from Material table)

  Information field 2 of the material.

• Info2 (from Order table)

  Information field 2 of the order.

• Info3

  Information field 3 of the order line.

• Info3 (from Material table)

  Information field 3 of the material.

• Info3 (from Order table)

  Information field 3 of the order.

• Info4

  Information field 4 of the order line.

• Info4 (from Material table)

  Information field 4 of the material.

• Info4 (from Order table)

  Information field 4 of the order.

• Info5

  Information field 5 of the order line.

• Info5 (from Material table)

  Information field 5 of the material.

• Info5 (from Order table)

  Information field 5 of the order.

• Is Blocked (from Material table)

  Sets or resets if the material is blocked from warehousing operations, i.e. picking and putting.

  Values:

  0 = False
  1 = True

• Lot Number

  Lot number used by a material property for tracking materials.

• Name

  The unique line number. If not provided, the system automatically generates a unique number for the order line.

• Name (from Job table)

  Name of the job.

• Name (from Material table)

  Name of the material.

• Name (from Material Property table)

  Name of the material property. This should indicate the rule being applied to the material.

• Name (from Order table)

  Name of the order.

• Name (from Cost Center table)

  Name of the cost center.

• Number (from Job table)

  Number of the job.

• Owner

  Used in a transfer order. The owner will be replaced by the given recipient, which will be assigned as the new owner of the material during the put.

• Owner (from Order table)

  Used in a transfer order. The owner will be replaced by the given recipient, which will be assigned as the new owner of the material during the put.

• Pick Bin Name

  Designated bin especially for transfer orders.

• Pick Location

  Designated location especially for transfer orders.

• Priority (from Order table)

  Order priority level. Default is 2.

  Values:

  1 = Low
  2 = Medium
  3 = High
  4 = Hot

• Production Date

  Used by a material property to track material production date.

• Progress Type

  Status of the individual line.

  Values:

  0 = Complete
  1 = Not Started
  2 = In Progress

• Put Bin Name

  Designated bin especially for transfer orders.

• Put Date

  Used by return orders to specify the original put date of the material. If this value is not provided by host, the current date will be used.

• Put Height

  Designated height especially for transfer orders.

• Put Location

  Designated location especially for transfer orders.

• Quantity

  Quantity of materials for the order line.

• Quantity (from Material table)

  Current quantity of the material in storage units.

• Quantity (from Order table)

  Quantity of materials for the order.

• Recipient (from Order table)

  Used in a transfer order. The recipient given will be assigned as the new owner of the material during the put.

• Release Date

  Used by a material property to track material release date.

• Reorder Point (from Material table)

  The material will be handled in the Material Re-order List, as soon as its stock falls below the entered value.

• Serial Number

  Unique serial number, recorded at the item level when a material is add or retrieved.

• Shortage

  The amount needed to replenish back to the reorder point.

• Shortage (from Material table)

  The amount needed to replenish back to the reorder point.

• Shortage (from Order table)

  The amount needed to replenish back to the reorder point.

• Station (from Order table)

  Name of the client station used for the order.

• Status Type (from Order table)

  Order status type. Default is 1.

  Values:

  1 = Untouched
  2 = Ready for Allocation
  10 = Is Allocated
  11 = In Process.

• Stored (from Material table)

• Total Value (from Material table)

  The number of units multiplied by the value per unit.

• Type (from Order table)

  Order creation/origin type. Automatically determined.

  Values:

  0 = NotSet
  1 = External
  2 = ExtManaged
  3 = Internal
  4 = Manual
  5 = Auto

• Unit (from Order table)

  The unit is used to create a batch as soon as the order is saved. If the order gets expanded with a different Unit, the already built batches are not affected, but a new batch will be created for the new order lines.

• Unit (from Material table)

  The unit of measurement related to the material, e.g. Piece, lb, mm, Pack, Liter.

• Unit Value (from Material table)

  Value per unit of the material. Used by count orders.

• Unit Weight (from Material table)

  Weight per unit of the material.

• Warehouse (from Order table)

  Name of warehouse which owns the imported order. If none is provided, defaults to the warehouse which owns the active station.