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.

  • 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.

  • 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.

  • 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.