pixiDFGetOrderlines

This API call returns all order lines for a specific order.

Since pixi version: LOU Official - Update 46 (6.9.46.27927) Additional notes:


Request

POST https://apigateway.descartes.com/tms/pixi/pixiDFGetOrderlines

Request body

Name Type Required Description
Secret string false

Customer ID, references table customers.

Type: varchar(20)

Default value: NULL

Example: abcdefg

Available from: LOU Official - Update 46 (6.9.46.27927)

OrderNR integer true

pixi order number

Type: int

Default value:

Example: 123

Available from: LOU Official - Update 46 (6.9.46.27927)

SupplNr string false

Supplier number

Type: varchar(4)

Default value: NULL

Example: abcd

Available from: LOU Official - Update 46 (6.9.46.27927)

AllOrderlines boolean false

0 = not confirmed orderlines in status FUT; 1 = all orderlines in status FUT - incl. the confirmed ones

Type: bit

Default value: 0

Example: 0 or 1

Available from: LOU Official - Update 46 (6.9.46.27927)


Response

1. Orderlines

Name Type Description
Qty integer

Item quantity

Type: int

Available from: / (25.7.0.59144)

Price number

Item's final price

Type: money

Available from: / (25.7.0.59144)

EANUPC string

Item barcode

Type: varchar (13)

Available from: / (25.7.0.59144)

Status string

Order line status

Type: varchar (3)

Available from: / (25.7.0.59144)

ArtName string

Name of the item

Type: varchar (120)

Available from: / (25.7.0.59144)

DF_Type string

Direct Fulfillment type

Type: varchar (1)

Available from: / (25.7.0.59144)

ItemRef integer

Item ID

Type: int

Available from: / (25.7.0.59144)

OrderNr integer

Order number in pixi*

Type: int

Available from: / (25.7.0.59144)

ItemNrInt string

Shop item number

Type: varchar (50)

Available from: / (25.7.0.59144)

OrderDate string

Order date

Type: datetime

Available from: / (25.7.0.59144)

SupplInfo string

Supplier number of the supplier that is assigned to the order line

Type: varchar (4)

Available from: / (25.7.0.59144)

ItemNrSuppl string

Supplier item number

Type: varchar (50)

Available from: / (25.7.0.59144)

OrderHistKey integer

Unique key for the confirmation of an orderline by the DF supplier

Type: int

Available from: / (25.7.0.59144)

OrderLineRef integer

Order line ID

Type: int

Available from: / (25.7.0.59144)

itemNrExternal string

Item number external (Imported from Shop)

Type: varchar (50)

Available from: / (25.7.0.59144)

OrderNrExternal string

External order number

Type: varchar (50)

Available from: / (25.7.0.59144)

StatusChangeDate string

Order line status change date

Type: datetime

Available from: / (25.7.0.59144)

oItemSpecialNote string

Item note

Type: varchar (8000)

Available from: / (25.7.0.59144)

InvoiceNrExternal string

External invoice number that was set for the order line

Type: varchar (20)

Available from: / (25.7.0.59144)

OrderCurrencyCode string

Order's currency code

Type: varchar (3)

Available from: / (25.7.0.59144)

BundleOrderlineRef integer

Bundle order line ID

Type: int

Available from: / (25.7.0.59144)

OrderlineConfirmed string

Flag which is set by the supplier to confirm the order line

Type: char

Available from: / (25.7.0.59144)