pixiGetItemsStockHistory

API call returns stock movement details

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


Request

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

Request body

Name Type Required Description
DateTo string false

End date of item stock movements

Type: datetime

Default value: Current date time

Example: YYYY-MM-DD hh:mm:ss

Available from: LOU Official - Update 46 (6.9.46.27927)

IbilKey integer false

Get data from IBILkey further

Type: int

Default value: 0

Example: 0

Available from: 22.02 (22.2.0.64904)

DateFrom string true

Start date of item stock movements

Type: datetime

Default value:

Example: YYYY-MM-DD hh:mm:ss

Available from: LOU Official - Update 46 (6.9.46.27927)

Location string false

Location ID

Type: varchar(3)

Default value: NULL

Example: 001

Available from: LOU Official - Update 46 (6.9.46.27927)

RowCount integer false

Rows to retun data

Type: int

Default value: 1000

Example: 1000

Available from: 22.02 (22.2.0.64904)

DeliveryNumber integer false

Delivery number

Type: int

Default value: NULL

Example: 123

Available from: 18.05 (8.4.41.34394)

OrderNumberExternal string false

Order number external

Type: varchar(50)

Default value: NULL

Example: abcdefg

Available from: 18.05 (8.4.41.34394)

RelocateTransactionID string false

Relocate transaction ID

Type: uniqueidentifier

Default value: NULL

Example: UNIQUEIDENTIFIER

Available from: 18.05 (8.4.41.34394)


Response

1. Stock movement details

Name Type Description
Qty integer

Quantity connected to stock movement

Type: int

Available from: 25.06 (25.6.0.58802)

LocID string

Location code

Type: varchar

Available from: 25.06 (25.6.0.58802)

EANUPC string

Item barcode

Type: varchar

Available from: 25.06 (25.6.0.58802)

Reason string

Manually entered reason for stock movement

Type: varchar

Available from: 25.06 (25.6.0.58802)

SMType string

Stock Movement Type Code

Type: varchar

Available from: 25.06 (25.6.0.58802)

BinName string

Bin name

Type: varchar

Available from: 25.06 (25.6.0.58802)

IBILkey integer

Internal ID for this stock movement (can be used for INSERT OR REPLACE queries)

Type: int

Available from: 25.06 (25.6.0.58802)

ItemKey integer

pixi* item 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)

UpdateEmp string

User who last updated the record

Type: varchar

Available from: 25.06 (25.6.0.58802)

UpdateDate string

Last update date of the record

Type: datetime

Available from: 25.06 (25.6.0.58802)

BatchNumber string

Item batch number

Type: varchar

Available from: 25.06 (25.6.0.58802)

ItemNrSuppl string

Supplier item number

Type: varchar

Available from: 25.06 (25.6.0.58802)

SMOperation string

Stock Movement Operation (Application/Action)

Type: varchar

Available from: 25.06 (25.6.0.58802)

ForOrderline integer

Connected orderline ID

Type: int

Available from: 25.06 (25.6.0.58802)

BestBeforeDate string

Item 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)

OrderNrExternal string

Order number external

Type: varchar

Available from: 25.06 (25.6.0.58802)

RelocateTransactionID string

Relocate transaction ID

Type: uniqueidentifier

Available from: 25.06 (25.6.0.58802)