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.