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.7.0.59144)

VPE string

Package unit

Type: varchar (50)

Available from: / (25.7.0.59144)

Tags string

Tags assosiated with an item

Type: varchar (4000)

Available from: / (25.7.0.59144)

Price string

Item price

Type: varchar (8000)

Available from: / (25.7.0.59144)

ACTIVE boolean

Item enabled/active flag

Type: bit

Available from: / (25.7.0.59144)

ItemKey integer

pixi item ID

Type: int

Available from: / (25.7.0.59144)

SupplNr string

Supplier number (code)

Type: varchar (4)

Available from: / (25.7.0.59144)

ITemName string

Item name

Type: varchar (8000)

Available from: / (25.7.0.59144)

IsBundle boolean

Item is bunde flag

Type: bit

Available from: / (25.7.0.59144)

Quantity integer

Summarized item quantity (excluding special stock locations)

Type: int

Available from: / (25.7.0.59144)

VATLevel string

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

Type: varchar (1)

Available from: / (25.7.0.59144)

ItemNrInt string

Shop item number

Type: varchar (50)

Available from: / (25.7.0.59144)

OrderDate string

Date when item first appeard on a customer order

Type: varchar (10)

Available from: / (25.7.0.59144)

SupplName string

Supplier name

Type: varchar (60)

Available from: / (25.7.0.59144)

TontrText string

Name of the category

Type: varchar (50)

Available from: / (25.7.0.59144)

CreateDate string

Create date

Type: varchar (10)

Available from: / (25.7.0.59144)

ExportDate string

Date of API execution

Type: varchar (10)

Available from: / (25.7.0.59144)

LocationId string

Location ID

Type: varchar (3)

Available from: / (25.7.0.59144)

SupplPrice string

Supplier price of the item

Type: varchar (8000)

Available from: / (25.7.0.59144)

ItemNrSuppl string

Supplier item number

Type: varchar (50)

Available from: / (25.7.0.59144)

MinOrderQty integer

Minimum order quantity for the item

Type: int

Available from: / (25.7.0.59144)

MinStockQty integer

Minimum stock quantity for the item

Type: int

Available from: / (25.7.0.59144)

SafetyStock integer

Item safety stock quantity

Type: int

Available from: / (25.7.0.59144)

TargetStock integer

Item target stock quantity

Type: int

Available from: / (25.7.0.59144)

LocationQuantity integer

Location quantity

Type: int

Available from: / (25.7.0.59144)

SupplierDeliveryDays integer

Supplier default delivery days

Type: int

Available from: / (25.7.0.59144)