Deprecated

Exports various item information (name, default supplier, current stock, price, supplier price, ..)

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


Request

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

Request body

Name Type Required Description
ItemCount integer false

Amount of returned items. The limitation is set on the item level. So in case of 2 locations, the reslut lines will double

Type: int

Default value: 1000

Example: 200

Available from: 21.01 (9.0.23.54983)

LocationIds string false

Comma separated list of Locations

Type: varchar(-1)

Default value: NULL

Example: 001,002

Available from: AVA Official - Update 7 (8.4.7.23158)

ItemKeyStart integer false

Item ID (ItemKey) to start with

Type: int

Default value: 0

Example: 1234

Available from: LOU Official (6.3.0.4452)


Response

1. List of items

Name Type Description
Typ string

"0100" maintainig backvards compatibility for some applications

Type: varchar (4)

Available from: 25.06 (25.6.0.58802)

VPE string

Package unit

Type: varchar (50)

Available from: 25.06 (25.6.0.58802)

Tags string

Tags assosiated with an item

Type: varchar (4000)

Available from: 25.06 (25.6.0.58802)

Price string

Item price

Type: varchar (8000)

Available from: 25.06 (25.6.0.58802)

ACTIVE boolean

Item enabled/active flag

Type: bit

Available from: 25.06 (25.6.0.58802)

ItemKey integer

pixi item ID

Type: int

Available from: 25.06 (25.6.0.58802)

SupplNr string

Supplier number (code)

Type: varchar (4)

Available from: 25.06 (25.6.0.58802)

ITemName string

Item name

Type: varchar (8000)

Available from: 25.06 (25.6.0.58802)

IsBundle boolean

Item is bunde flag

Type: bit

Available from: 25.06 (25.6.0.58802)

Quantity integer

Summarized item quantity (excluding special stock locations)

Type: int

Available from: 25.06 (25.6.0.58802)

VATLevel string

VAT level (L - Low, H - High, 0 -Zero)

Type: varchar (1)

Available from: 25.06 (25.6.0.58802)

ItemNrInt string

Shop item number

Type: varchar (50)

Available from: 25.06 (25.6.0.58802)

OrderDate string

Date when item first appeard on a customer order

Type: varchar (10)

Available from: 25.06 (25.6.0.58802)

SupplName string

Supplier name

Type: varchar (60)

Available from: 25.06 (25.6.0.58802)

TontrText string

Name of the category

Type: varchar (50)

Available from: 25.06 (25.6.0.58802)

CreateDate string

Create date

Type: varchar (10)

Available from: 25.06 (25.6.0.58802)

ExportDate string

Date of API execution

Type: varchar (10)

Available from: 25.06 (25.6.0.58802)

LocationId string

Location ID

Type: varchar (3)

Available from: 25.06 (25.6.0.58802)

SupplPrice string

Supplier price of the item

Type: varchar (8000)

Available from: 25.06 (25.6.0.58802)

ItemNrSuppl string

Supplier item number

Type: varchar (50)

Available from: 25.06 (25.6.0.58802)

MinOrderQty integer

Minimum order quantity for the item

Type: int

Available from: 25.06 (25.6.0.58802)

MinStockQty integer

Minimum stock quantity for the item

Type: int

Available from: 25.06 (25.6.0.58802)

SafetyStock integer

Item safety stock quantity

Type: int

Available from: 25.06 (25.6.0.58802)

TargetStock integer

Item target stock quantity

Type: int

Available from: 25.06 (25.6.0.58802)

LocationQuantity integer

Location quantity

Type: int

Available from: 25.06 (25.6.0.58802)

SupplierDeliveryDays integer

Supplier default delivery days

Type: int

Available from: 25.06 (25.6.0.58802)