pixiReportGetShippableOrdersV2

Multi Currency: Return database currency code in field dbCurrency depend on if Multi Currency is Enabled then we:

  • calculate and return data in database currency else
  • calculate and return data in order / original currency (with value NULL for currency code).

Since pixi version: 21.06 (21.6.0.58890) Additional notes:


Request

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

Request body

Name Type Required Description
ShopId string false

Shop Code

Type: varchar(3)

Default value:

Example: abcdef

Available from: 21.06 (21.6.0.58890)

PerLocation boolean false

Return summary of shippable orders per location.

Type: bit

Default value: 0

Example: 0 or 1

Available from: 21.06 (21.6.0.58890)

ViewDetails boolean false

Return summarized output or return detailed output.

Type: bit

Default value:

Example: 0 or 1

Available from: 21.06 (21.6.0.58890)

OnlyPartDelivery boolean false

Show only orderlines which were partially delivered

Type: bit

Default value:

Example: 0 or 1

Available from: 21.06 (21.6.0.58890)

IncludePartDelivery boolean false

Include also orderlines which were partially delivered.

Type: bit

Default value:

Example: 0 or 1

Available from: 21.06 (21.6.0.58890)

UseFIFObyLocationV2 boolean false

Mannualy skip setting UseFIFObyLocation, when NULL we use setting

Type: bit

Default value: NULL

Example: NULL 0 or 1

Available from: 21.06 (21.6.0.58890)

IncludeOrdersWithAnyShipDate boolean false

By default, return all orders without ship date and orders where shipdate =< today. Exclude order where ship date is in the future. If parameter @IncludeOrdersWithAnyShipDate = 1 then return all orders (ship date is ignored)

Type: bit

Default value: 0

Example: 0 or 1

Available from: 21.06 (21.6.0.58890)


Response

1. Detailed output for @PerLocation = 0

Name Type Description
Qty integer

Orderline Quantity

Type: int

Available from: / (25.7.0.59144)

Price number

Orderline Price

Type: money

Available from: / (25.7.0.59144)

Status string

Orderline Status

Type: varchar (3)

Available from: / (25.7.0.59144)

ItemRef integer

Item ID

Type: int

Available from: / (25.7.0.59144)

OrderNr integer

pixi Order Number

Type: int

Available from: / (25.7.0.59144)

ShipCost number

The total shipping costs of the whole order

Type: money

Available from: / (25.7.0.59144)

Shippable integer

Marks if there is enough stock to ship orderline

Type: int

Available from: / (25.7.0.59144)

dbCurrency string

Database Currency

Type: varchar (3)

Available from: / (25.7.0.59144)

OrderlineRef integer

Orderline id

Type: int

Available from: / (25.7.0.59144)

2. Summarized output for @PerLocation = 0

Name Type Description
Picks integer

Summarized quantity which is available to be shipped

Type: int

Available from: / (25.7.0.59144)

Orders integer

Order count

Type: int

Available from: / (25.7.0.59144)

ShipCost number

Summarized shipping costs

Type: money

Available from: / (25.7.0.59144)

OrderTotal number

Summarized order total

Type: money

Available from: / (25.7.0.59144)

dbCurrency string

Database Currency

Type: varchar (3)

Available from: / (25.7.0.59144)

3. Detailed output for @PerLocation = 1

Name Type Description
Qty integer

Orderline Quantity

Type: int

Available from: / (25.7.0.59144)

Price number

Orderline Price

Type: money

Available from: / (25.7.0.59144)

Status string

Orderline Status

Type: varchar (3)

Available from: / (25.7.0.59144)

ItemRef integer

Item ID

Type: int

Available from: / (25.7.0.59144)

OrderNr integer

pixi Order Number

Type: int

Available from: / (25.7.0.59144)

ShipCost number

The total shipping costs of the whole order

Type: money

Available from: / (25.7.0.59144)

Shippable integer

Marks if there is enough stock to ship orderline

Type: int

Available from: / (25.7.0.59144)

LocationID string

Location of shippable orders.

Type: varchar(3)

Available from: / (25.7.0.59144)

dbCurrency string

Database Currency

Type: varchar (3)

Available from: / (25.7.0.59144)

OrderlineRef integer

Orderline id

Type: int

Available from: / (25.7.0.59144)

4. Summarized output for @PerLocation = 1

Name Type Description
Picks integer

Summarized quantity which is available to be shipped

Type: int

Available from: / (25.7.0.59144)

Orders integer

Order count

Type: int

Available from: / (25.7.0.59144)

ShipCost number

Summarized shipping costs, when the Order have lines on multiple locations, the same shipcost amount will apear on all location (duplicated value)

Type: money

Available from: / (25.7.0.59144)

LocationID string

Location of shippable orders.

Type: varchar(3)

Available from: / (25.7.0.59144)

OrderTotal number

Summarized order total

Type: money

Available from: / (25.7.0.59144)

dbCurrency string

Database Currency

Type: varchar (3)

Available from: / (25.7.0.59144)