Order Lines

Individual lines of an order, with details such as the material and quantity to be processed.

Attributes

id uuid
Unique identifier for the object.
costCenterName string LIMIT: 50
The cost center this order line was processed at.
directionType integer
The type of order.

Possible values:

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

Default value: 2
expiryDate dateTime
Used by a material property to track material expiry.
hasStock boolean
If there is enough stock to fulfill the order line.

Possible values:

0 = False
1 = True
hostIdentification string LIMIT: 50
A unique value at the order line level that can be carried through from ERP to PPG and back to ERP.
incompleteAllocations integer
If there are any failed allocations.
Info1 string LIMIT: 80
A generic field for custom use.
Info2 string LIMIT: 80
A generic field for custom use.
Info3 string LIMIT: 80
A generic field for custom use.
Info4 string LIMIT: 80
A generic field for custom use.
Info5 string LIMIT: 80
A generic field for custom use.
lot string LIMIT: 50
Lot number used by a material property for tracking materials.
materialId uuid
The unique ID of the material on the order line.
materialName string LIMIT: 50
The name of the material on the order line.
modifiedDate datetime
The date/time this order line was last modified. This will either be the creation date if it is still queued, or the processed date.
number integer
The unique sequence number of the order line. If not provided, the system automatically generates a unique number for the order line.
orderId uuid
The unique ID of the order that the order line belongs to.
owner string LIMIT: 50
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.
productionDate dateTime
Used by a material property to track material production date.
progressType integer
Status of the individual line.

Possible values:

0 = Complete
1 = Not Started
2 = In Progress
putBinName string LIMIT: 50
Designated bin especially for transfer orders.
putDate dateTime
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.
putHeight integer
Designated height especially for transfer orders.
putLocation string LIMIT: 128
Designated location especially for transfer orders.
qualification string LIMIT: 50
A specified attribute of the material on the order line.
quantity float
The quantity on the original order line.
quantityConfirmed float
Actual quantity of units processed, confirmed by the user. Only shows if the order line has been processed.
quantityDeviated float
The difference between the quantity of units requested and units actually processed, recorded by the user. Only shows if the order line has been processed.
quantityRequested float
Original quantity requested for the order line. Only shows if the order line has been processed.
releaseDate dateTime
Used by a material property to track material release date.
serialNumber string LIMIT: 50
Unique serial number, recorded at the item level when a material is added or retrieved.
status string
Queued is imported but not fully picked, and processed is fully picked.

Possible values:

queued
processed
storageUnits array
Storage unit(s) where the order line is being processed.
[dynamicField] string LIMIT: 1999
Any of the dynamic order fields from Power Pick. Requires ItemPath's Custom Fields app.

Endpoints

List Order Lines /api/order_lines

get

Get a list of order lines from the PPG database. View the guide on adding filters to List API calls.

Body Parameters

costCenterName string
The cost center this order line was processed at.
directionType integer
The type of order.

Possible values:

1 = Put
2 = Pick
3 = Return
4 = Transport
5 = Count
7 = Production
expiryDate dateTime
Used by a material property to track material expiry. Like all date arguments, a [gt], [lt], [lte], for [gte] can be prefixed.
hasStock boolean
If there is enough stock to fulfill the order line.

Possible values:

0 = False
1 = True
hostIdentification string
The identification sent from host system, specially by SAP. Will be written to history table to report it back to the host.
incompleteAllocations integer
If there are any failed allocations.
Info1 string
A generic field for custom use.
Info2 string
A generic field for custom use.
Info3 string
A generic field for custom use.
Info4 string
A generic field for custom use.
Info5 string
A generic field for custom use.
lot string
Lot number used by a material property for tracking materials.
materialId uuid
The unique ID of the material 0n the order line.
materialName string
The name of the material on the order line.
modifiedDate datetime
The date/time this order line was last modified. This will either be the creation date if it is still queued, or the processed date.
number integer
The unique sequence number of the order line. If not provided, the system automatically generates a unique number for the order line.
orderId uuid
The unique ID of the order that the order line belongs to.
owner string
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.
pickBinName string
Designated bin especially for transfer orders.
pickLocation string
Designated location especially for transfer orders.
productionDate dateTime
Used by a material property to track material production date. Like all date arguments, a [gt], [lt], [lte], for [gte] can be prefixed.
progressType integer
Status of the individual line.

Possible values:

0 = Complete
1 = Not Started
2 = In Progress
putBinName string
Designated bin especially for transfer orders.
putDate dateTime
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. Like all date arguments, a [gt], [lt], [lte], for [gte] can be prefixed.
putHeight integer
Designated height especially for transfer orders.
putLocation string
Designated location especially for transfer orders.
qualification string
Used by a material property for tracking materials.
quantity integer
Filter by a certain quantity.
quantityConfirmed integer
Actual quantity of units processed, confirmed by the user. Only shows if the order line has been processed.
quantityDeviated integer
The difference between the quantity of units requested and units actually processed, recorded by the user. Only shows if the order line has been processed.
quantityRequested integer
Original quantity requested for the order line. Only shows if the order line has been processed.
releaseDate dateTime
Used by a material property to track material release date. Like all date arguments, a [gt], [lt], [lte], for [gte] can be prefixed.
serialNumber string
Unique serial number, recorded at the item level when a material is added or retrieved.
status string
Queued is imported but not fully picked, and processed is fully picked.

Possible values:

queued
processed
[dynamicField]
Any dynamic fields that have been set up can be used as a filter. Requires ItemPath's Custom Fields app.
countOnly boolean
When "true", will only return a count of the amount of items in the query.

Default value:
false
limit integer
A limit on the number of objects to be returned.

Default value:
1000
page integer
Page numbering is zero-based and uses the value of the "limit" argument. (For example, if limit=20, then page=0 will display the hits from 1 to 20.)
modifiedDate datetime
The date/time this order was last modified. This will either be the creation date if it is still queued, or the processed date.

Request with curl

-d 'curl -L 
-X GET '[subdomain.itempath.com or IP]/api/order_lines?limit=4&status=queued&type=put' 
-H 'Content-Type: application/json' 
-H 'Authorization: Bearer [Your JWT Access Token]''

Example Response

{
    "order_line":  {
            "number": 5,
            "serialNumber": "65",
            "quantity": 1.0,
            "Info5": null,
            "id": "4A0C741B-5E79-4713-BB4B-4F10E9C23B1C",
            "modifiedDate": "2021-11-15T15:49:20.440000",
            "releaseDate": null,
            "Info3": null,
            "lot": null,
            "putLocation": null,
            "quantityRequested": 0.0,
            "status": "queued",
            "orderId": "85A55CF6-BE05-48AF-B0D7-D71212C3ACCA",
            "hasStock": 1,
            "expiryDate": null,
            "directionType": 1,
            "putDate": null,
            "materialName": "S103",
            "progressType": 2,
            "costCenterName": null,
            "Info1": "TEST",
            "putHeight": null,
            "productionDate": null,
            "Info2": null,
            "ORDELINEISSUETO": null,
            "storageUnits": [
                {
                    "id": "CA1E5648-FA38-416F-9604-CF33A6763496",
                    "id": "18E22E33-11CA-4712-AECF-7A29123C88A5",
                    "name": "VLM-01"
                }
            ],
            "quantityDeviated": 1.0,
            "quantityConfirmed": 0.0,
            "incompleteAllocations": 0,
            "materialId": "8E7EC42A-F2B2-4B64-BF71-750F006DEF8D",
            "qualification": null,
            "ORDERLINEINFO6": null,
            "ORDERLINENOTE": null,
            "Info4": null,
            "hostIdentification": null,
            "owner": "sys",
            "putBinName": null,
            "pickBinName": null,
            "pickLocation": null
        }
}

Create Order Line /api/order_lines

post

Create an order line, to be imported by Power Pick. Requires passing the ID of the order the new line is being added to. If location details are passed in at both the order and line level, then the line location details will be used.

Body Parameters

orderId uuid
REQUIRED

The ID of the order this order line belongs to.
materialId uuid
REQUIRED

The unique ID of the item(s).
Note: A materialId OR a materialName OR a materialCode is required, but only one can be passed.
materialName string LIMIT: 50
REQUIRED

The material name of the item(s).
Note: A materialId OR a materialName OR a materialCode is required, but only one can be passed.
materialCode or code string LIMIT: 50
REQUIRED

An alternate lookup code/part number of the item(s).
Note: A materialId OR a materialName OR a materialCode is required, but only one can be passed.
quantity integer
REQUIRED

The quantity to be processed on the order line. This is not required for Count orders.
number integer
The unique sequence number of the order line. Will be automatically generated if not provided. Previously was as "name".

Default value:
1 (or next consecutive number)
carriers array
A list of carriers that this order line can be picked or put from. Either an ID or name is required.

Possible values:

Example: [{"id": "66AFE69B-695E-469F-9E73-C416A12B727E"}, {"name": "01"}]
costCenterName string LIMIT: 50
The cost center this order line was processed at.
costCenterId uuid
The id of the cost center this order was processed at.
expiryDate dateTime
Used by a material property to track material expiry.
hostIdentification string LIMIT: 50
A unique value at the order line level that can be carried through from ERP to PPG and back to ERP.
Info1 string LIMIT: 80
A generic field for custom use.
Info2 string LIMIT: 80
A generic field for custom use.
Info3 string LIMIT: 80
A generic field for custom use.
Info4 string LIMIT: 80
A generic field for custom use.
Info5 string LIMIT: 80
A generic field for custom use.
locations array
A list of locations that this order line can be picked or put from. Either an ID or name is required.

Possible values:

Example: [{"id": "8B3E44C1-EA03-4F2D-A514-EF5B7AE2BF89"}, {"name": "VLM 1/01/01"}]
lot string LIMIT: 50
Lot number used by a material property for tracking materials.
productionDate dateTime
Used by a material property to track material production date.
qualification string LIMIT: 50
A specified attribute of the material on the order line.
releaseDate dateTime
Used by a material property to track material release date.
serialNumber string LIMIT: 50
The unique serial number at the unit level of the material on the order line.
shelves array
A list of shelves that this order line can be picked or put from. Either an ID or name is required.

Possible values:

Example: [{"id": "7142BF15-38BD-4971-BCB2-D890DDA9CC32"}, {"name": "01/01"}]
storageUnits array
A list of storage units that this order line can be picked or put from. Either an ID or name is required.

Possible values:

Example: [{"id": "3276A9F6-7CE5-4924-A02B-FD8304D7C3A1"},{"id": "18E22E33-11CA-4712-AECF-7A29123C88A5"}, {"name": "VLM 1"}]
zones array
A list of zones that this order line can be picked or put from. Either an ID or name is required.

Possible values:

Example: [{"id": "9B937196-FBDC-4462-9D15-E60A7EEB5FA7"}, {"name": "Zone 1"}]
[DynamicField] LIMIT: 1999
Any field set up in Power Pick.

Request with curl

curl "http://[subdomain.itempath.com or IP]/api/order_lines" \ -X post \ -H "Content-Type: application/json" \ -H "Authorization: Bearer [Your JWT Access Token]" \

-d '{
    "orderId": "8D768C21-F0DB-49A2-B048-B75BDA00897C",
    "materialId": "C6607DB2-CE96-4888-82A5-71E36EBF2785",
    "quantity": 1,
    "storageUnits": [{"id": "66AFE69B-695E-469F-9E73-C416A12B727E"}],
}'

Example Response

{
    "order_line": {
        "expiryDate": null,
        "lot": null,
        "directionType": 1,
        "putBinName": null,
        "putLocation": null,
        "storageUnits": [{"id": "18E22E33-11CA-4712-AECF-7A29123C88A5"}, {"id":"4E650810-D8E2-444B-813D-BA0254A37A6C"}, {"id": "CA1E5648-FA38-416F-9604-CF33A6763496"}],
        "putDate": null,
        "hasStock": 1,
        "quantity": 1.0,
        "serialNumber": null,
        "number": 5,
        "status": "queued",
        "owner": "sys",
        "quantityConfirmed": 0.0,
        "costCenterName": null,
        "orderId": "8D768C21-F0DB-49A2-B048-B75BDA00897C",
        "progressType": 1,
        "putHeight": null,
        "materialName": "SampleMaterial",
        "qualification": null,
        "pickBinName": null,
        "Info3": null,
        "releaseDate": null,
        "Info2": null,
        "materialId": "C6607DB2-CE96-4888-82A5-71E36EBF2785",
        "incompleteAllocations": 0,
        "pickLocation": null,
        "productionDate": null,
        "Info4": null,
        "modifiedDate": "2022-01-28T23:05:06.500000",
        "id": "EFB5158B-1ECB-4B5B-8EA9-1AF1236D0FC2",
        "quantityRequested": 0.0,
        "Info1": null,
        "quantityDeviated": 1.0,
        "Info5": null,
        "hostIdentification": null,
    }
}

Show Order Line /api/order_lines/[id]

get

Get a specific order line from the PPG database and return a JSON response. The order will be pulled from the MasterOrderLine table.

Body Parameters

Request with curl

curl "http://[subdomain.itempath.com or IP]/api/order_lines/[id]" \ -X get \ -H "Content-Type: application/json" \ -H "Authorization: Bearer [Your JWT Access Token]"

Example Response

{
    "order_line": {
        "number": 5,
        "serialNumber": "65",
        "quantity": 1.0,
        "Info5": null,
        "id": "4A0C741B-5E79-4713-BB4B-4F10E9C23B1C",
        "modifiedDate": "2021-11-15T15:49:20.440000",
        "releaseDate": null,
        "Info3": null,
        "lot": null,
        "putLocation": null,
        "quantityRequested": 0.0,
        "status": "queued",
        "orderId": "85A55CF6-BE05-48AF-B0D7-D71212C3ACCA",
        "hasStock": 1,
        "expiryDate": null,
        "directionType": 1,
        "putDate": null,
        "materialName": "S103",
        "progressType": 2,
        "costCenterName": null,
        "Info1": "TEST",
        "putHeight": null,
        "productionDate": null,
        "Info2": null,
        "ORDELINEISSUETO": null,
        "storageUnits": [
            {
                "id": "CA1E5648-FA38-416F-9604-CF33A6763496",
                "name": "VLM-01"
            }
        ],
        "quantityDeviated": 1.0,
        "quantityConfirmed": 0.0,
        "incompleteAllocations": 0,
        "materialId": "8E7EC42A-F2B2-4B64-BF71-750F006DEF8D",
        "qualification": null,
        "ORDERLINEINFO6": null,
        "ORDERLINENOTE": null,
        "Info4": null,
        "hostIdentification": null,
        "owner": "sys",
        "putBinName": null,
        "pickBinName": null,
        "pickLocation": null
    }
}

Update Order Line /api/order_lines/[id]

put

Update an order line that has not yet been allocated.

Body Parameters

hostIdentification string LIMIT: 50
A unique value at the order line level that can be carried through from ERP to PPG and back to ERP.
costCenterName string LIMIT: 50
The cost center this order line was processed at.
Info1 string LIMIT: 80
A generic field for custom use.
Info2 string LIMIT: 80
A generic field for custom use.
Info3 string LIMIT: 80
A generic field for custom use.
Info4 string LIMIT: 80
A generic field for custom use.
Info5 string LIMIT: 80
A generic field for custom use.
lot string LIMIT: 50
Lot number used by a material property for tracking materials.
name integer
(The "number" field.) The unique sequence number of the order line. Will be automatically generated if not provided.
owner string LIMIT: 50
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.
qualification string LIMIT: 50
A specified attribute of the material on the order line.
quantityTransit integer
(The "quantity" field.) The quantity to be processed on the order line. This is not required for Count orders.
serialNumber string LIMIT: 50
The unique serial number at the unit level of the material on the order line.
[DynamicField] LIMIT: 1999
Any field set up in Power Pick.

Request with curl

curl "http://[subdomain.itempath.com or IP]/api/order_lines/[id]" \ -X put \ -H "Content-Type: application/json" \ -H "Authorization: Bearer [Your JWT Access Token]"

-d '{
    "quantityTransit": 5
}'

Example Response

{
    "order_line": {
        "expiryDate": null,
        "lot": null,
        "directionType": 1,
        "putBinName": null,
        "putLocation": null,
        "storageUnits": [{"id": "18E22E33-11CA-4712-AECF-7A29123C88A5"}, {"id":"4E650810-D8E2-444B-813D-BA0254A37A6C"}, {"id": "CA1E5648-FA38-416F-9604-CF33A6763496"}],
        "putDate": null,
        "hasStock": 1,
        "quantity": 5.0,
        "serialNumber": null,
        "number": 5,
        "status": "queued",
        "owner": "sys",
        "quantityConfirmed": 0.0,
        "costCenterName": null,
        "orderId": "8D768C21-F0DB-49A2-B048-B75BDA00897C",
        "progressType": 1,
        "putHeight": null,
        "materialName": "SampleMaterial",
        "qualification": null,
        "pickBinName": null,
        "Info3": null,
        "releaseDate": null,
        "Info2": null,
        "materialId": "C6607DB2-CE96-4888-82A5-71E36EBF2785",
        "incompleteAllocations": 0,
        "pickLocation": null,
        "productionDate": null,
        "Info4": null,
        "modifiedDate": "2022-01-28T23:05:06.500000",
        "id": "EFB5158B-1ECB-4B5B-8EA9-1AF1236D0FC2",
        "quantityRequested": 0.0,
        "Info1": null,
        "quantityDeviated": 5.0,
        "Info5": null,
        "hostIdentification": null,
    }
}

Delete Order Line /api/order_lines/[id]/delete

delete

Delete an order line.

Body Parameters

Request with curl

curl "http://[subdomain.itempath.com or IP]/api/order_lines/[id]/delete" \ -X delete \ -H "Content-Type: application/json" \ -H "Authorization: Bearer [Your JWT Access Token]"

Example Response

{"deleted": "true"}