pixiGetDeliveryItem

Get Delivery Item for Deliveries

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


Request

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

Request body

Name Type Required Description
DateTo string false

Delivery line "Create date" filter. Show delivery lines older than @DateTo.

Type: datetime

Default value: NULL

Example: 2017-01-31 23:23:59.996

Available from: AVA 17.03 (8.4.27.29272)

EANUPC string false

Load only deliveries for a specific EANUPC

Type: varchar(13)

Default value: NULL

Example: 1234ABC

Available from: LOU Official - Update 46 (6.9.46.27927)

Offset integer false

To be used together with RowCount for paginaton. Use last SDelDkey from results to get next.

Type: int

Default value: 0

Example: 100

Available from: LOU Official - Update 46 (6.9.46.27927)

DateFrom string false

Delivery line "Create date" filter. Show delivery lines younger than @DateFrom.

Type: datetime

Default value: NULL

Example: 2017-01-01 00:00:00.000

Available from: AVA 17.03 (8.4.27.29272)

RowCount integer false

Number of rows returned

Type: int

Default value: 100

Example: 100

Available from: LOU Official - Update 46 (6.9.46.27927)

SDelHKey integer false

Reference to a specific delivery (ID)

Type: int

Default value: NULL

Example: 123

Available from: LOU Official - Update 46 (6.9.46.27927)

DeliveryNumber integer false

Reference to a specific delivery (DeliveryNumber)

Type: int

Default value: NULL

Example: 123

Available from: LOU Official - Update 46 (6.9.46.27927)

ItemNrInternal string false

Load only deliveries for a specific ItemNrInternal

Type: varchar(50)

Default value: NULL

Example: 1234ABC

Available from: LOU Official - Update 46 (6.9.46.27927)


Response

1. Delivery items details

Name Type Description
EK number

Original supplier price

Type: money

Available from: 25.06 (25.6.0.58802)

EANUPC string

Item barcode

Type: varchar

Available from: 25.06 (25.6.0.58802)

ItemKey integer

pixi item ID

Type: int

Available from: 25.06 (25.6.0.58802)

Discount number

Delivery item discount in percents

Type: money

Available from: 25.06 (25.6.0.58802)

ItemName string

Item name

Type: varchar

Available from: 25.06 (25.6.0.58802)

ItemTAGs string

Item tags

Type: varchar

Available from: 25.06 (25.6.0.58802)

MidPrice number

Discounted price for the item

Type: money

Available from: 25.06 (25.6.0.58802)

SDelDkey integer

Delivery detail ID

Type: int

Available from: 25.06 (25.6.0.58802)

SDelHKey integer

Delivery header ID

Type: int

Available from: 25.06 (25.6.0.58802)

ItemNrInt string

Shop item number

Type: varchar

Available from: 25.06 (25.6.0.58802)

FinalPrice number

Final discounted price for the item, including the delivery discount

Type: money

Available from: 25.06 (25.6.0.58802)

OrderedQty number

Ordered quantity

Type: money

Available from: 25.06 (25.6.0.58802)

BatchNumber string

Batch number

Type: varchar

Available from: 25.06 (25.6.0.58802)

ItemNrSuppl string

Default item number supplier

Type: varchar

Available from: 25.06 (25.6.0.58802)

DeliveredQty number

Delivered quantity

Type: money

Available from: 25.06 (25.6.0.58802)

PicLinkLarge string

Large picture URL

Type: varchar

Available from: 25.06 (25.6.0.58802)

PicLinkSmall string

Small picture URL

Type: varchar

Available from: 25.06 (25.6.0.58802)

BestBeforeDate string

Best before date

Type: datetime

Available from: 25.06 (25.6.0.58802)

DeliveryNumber integer

Delivery number

Type: int

Available from: 25.06 (25.6.0.58802)

DeliveryItemNrSuppl string

Item number supplier connected to delivery

Type: varchar

Available from: 25.06 (25.6.0.58802)

BatchManagementDetails string

Batch number amd Best before date data if there are multiple. Data included in XML:

  • BinItemLogId - Id from table InvBinItemLog
  • LocationId - Location Id
  • BinRef - Bin Id
  • ItemRef - Item Id
  • DeliveredQty - Delivered Quantity
  • BatchNumber - Batch Number
  • BestBeforeDate - Best Before Date

Type: XML

Available from: 25.06 (25.6.0.58802)