pixiGetOrderlinesForProduction

This function returns all Orders that need to be producted (personalised Items)

Since pixi version: LOU Official (6.3.0.4452) Additional notes:

Additional Parameters: 

  • OrderNRExternal VARCHAR(50) = NULL ,
  • CustShipLock VARCHAR(1) = NULL ,
  • CustName VARCHAR(100) = NULL ,
  • ShopId VARCHAR(8000) = NULL ,
  • ShowPersonalizedAll INT = 1

Request

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

Request body

Name Type Required Description
ShopId string false

Type: varchar (8000)

Default value:

Example:

Available from: LOU Official (6.3.0.4452)

SupplNR string false

[optional] 4 digit Supplier Code

Type: varchar (4)

Default value:

Example:

Available from: LOU Official (6.3.0.4452)

CustName string false

Type: varchar (100)

Default value:

Example:

Available from: LOU Official (6.3.0.4452)

ANGdateTo string true

[mandatory] Date, the order was set to ANG (End)

Type: datetime

Default value:

Example:

Available from: LOU Official (6.3.0.4452)

IncludeHAL integer false

[optional] Include Orders on Status "HAL"? Either 1 (True) or 0 (False)

Type: int

Default value:

Example:

Available from: LOU Official (6.3.0.4452)

ANGdateFrom string true

[mandatory] Date, the order was set to ANG (Start)

Type: datetime

Default value:

Example:

Available from: LOU Official (6.3.0.4452)

CustShipLock string false

Type: varchar (1)

Default value:

Example:

Available from: LOU Official (6.3.0.4452)

OrderNRExternal string false

Type: varchar (50)

Default value:

Example:

Available from: LOU Official (6.3.0.4452)

ShowPersonalizedAll integer false

Type: int

Default value:

Example:

Available from: LOU Official (6.3.0.4452)


Response

Name Type Description
Qty string

Quantity the customer ordered

Type: integer

Available from: LOU Official (6.3.0.4452)

Note string

Type: 1

Available from: LOU Official (6.3.0.4452)

Price number

Price in Euro

Type: money

Available from: LOU Official (6.3.0.4452)

Status string

Actual Status

Type: varchar(3)

Available from: LOU Official (6.3.0.4452)

ANGdate string

Date, the order was set to ANG (or date of Order on items that are imported on ANG)

Type: DateTime

Available from: LOU Official (6.3.0.4452)

SupplNR string

Reference to Supplier

Type: Varchar(4)

Available from: LOU Official (6.3.0.4452)

ItemName string

Artikelname for Item

Type: varchar

Available from: LOU Official (6.3.0.4452)

ItemNote string

Personlization Text for Orderline

Type: varchar(8000)

Available from: LOU Official (6.3.0.4452)

ShipCost number

Type: money

Available from: LOU Official (6.3.0.4452)

FullPrice number

Price without Discount

Type: money

Available from: LOU Official (6.3.0.4452)

OrdShopID string

Shop-ID the order was created for

Type: varchar(3)

Available from: LOU Official (6.3.0.4452)

OrderDate string

Date, the order was placed

Type: date

Available from: LOU Official (6.3.0.4452)

OrderNrPixi integer

pixi internal OrderNR

Type: int

Available from: LOU Official (6.3.0.4452)

CustomerName string

Name of the Customer

Type: varchar

Available from: LOU Official (6.3.0.4452)

OrderlineKey integer

ID for the Orderline

Type: int

Available from: LOU Official (6.3.0.4452)

CustomerNrPixi string

pixi internal customer-Number

Type: varchar

Available from: LOU Official (6.3.0.4452)

ItemNrExternal string

External NR for specific Orderline, imported from Shop

Type: varchar

Available from: LOU Official (6.3.0.4452)

OrderNrExternal string

OrderNR External (Imported from Shop)

Type: varchar

Available from: LOU Official (6.3.0.4452)

CustomerNrExternal string

External Reference to the Customer (imported from Shop)

Type: varchar

Available from: LOU Official (6.3.0.4452)

PersonalizedBarcode string

Personalized Barcode to be put on the item for personalized scan-in

Type: varchar(100)

Available from: LOU Official (6.3.0.4452)