pixiReportInventoryItemsToRefillMinStock

Since pixi version: AVA Official - Update 23 (8.4.23.27873) Additional notes:


Request

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

Request body

Name Type Required Description
Type integer false

-- 1 From Location Open Cust Order + AddLocation Missing Qty -> ToLoc

    -- 2 FROM & Additional Loc same -> Fill 

    -- 3 From POS -> Pick 

Type: int

Default value: NULL

Example: 123

Available from: AVA 17.03 (8.4.27.29272)

SortBy string false

1 means sorting by ToLocID bins otherwise FromLocID bins are sorted

Type: varchar(1)

Default value: NULL

Example: abcdefg

Available from: AVA 17.03 (8.4.27.29272)

ToLocID string false

Location to Pick From

Type: varchar(3)

Default value:

Example: abcdefg

Available from: AVA 17.03 (8.4.27.29272)

MinStock boolean false

Also include MinStock Refill

Type: bit

Default value: 1

Example: 0 or 1

Available from: AVA 17.03 (8.4.27.29272)

FromLocID string false

Location to Fill to

Type: varchar(3)

Default value:

Example: abcdefg

Available from: AVA Official - Update 23 (8.4.23.27873)

AdditionalLocID string false

Add a 2nd Location ID to refill from

Type: varchar(3)

Default value: NULL

Example: abcdefg

Available from: AVA 17.03 (8.4.27.29272)


Response

Name Type Description
EanUpc string

Item barcode

Type: varchar (13)

Available from: 25.06 (25.6.0.58802)

SortBy string

1 = ToLocBin- Sortnumber, 0 = FromLocBin- SortNumber

Type: varchar (1)

Available from: 25.06 (25.6.0.58802)

ItemName string

Item name

Type: varchar (120)

Available from: 25.06 (25.6.0.58802)

ToLocQty integer

Location quantity target location

Type: int

Available from: 25.06 (25.6.0.58802)

FromBinqty integer

Item stock on From Bin

Type: int

Available from: 25.06 (25.6.0.58802)

FromLocQty integer

Location quantity source location

Type: int

Available from: 25.06 (25.6.0.58802)

MissingQty integer

Quantity that needs to be refilled

Type: int

Available from: 25.06 (25.6.0.58802)

ParToLocID string

Value from parameter ToLocID

Type: varchar (3)

Available from: 25.06 (25.6.0.58802)

SupplPrice number

Supplier price of the item

Type: money

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)

ParFromLocID string

Value from parameter FromLocID

Type: varchar (3)

Available from: 25.06 (25.6.0.58802)

PicLinkLarge string

URL to picture of the item (large size)

Type: varchar (512)

Available from: 25.06 (25.6.0.58802)

PicLinkSmall string

URL to picture of the item (small size)

Type: varchar (512)

Available from: 25.06 (25.6.0.58802)

ToLocIDbinName string

Name target bin

Type: varchar (50)

Available from: 25.06 (25.6.0.58802)

OrdersOnHoldQty integer

Quantity sum of orderlines on HOLD

Type: int

Available from: 25.06 (25.6.0.58802)

FromLocIDbinName string

Name of source bin

Type: varchar (50)

Available from: 25.06 (25.6.0.58802)

OpenCustOrdersQty integer

Quantity sum of open customer orders

Type: int

Available from: 25.06 (25.6.0.58802)

ToLocIDbinSortNum integer

Sort number target bin

Type: int

Available from: 25.06 (25.6.0.58802)

FromLocIDbinSortNum integer

Sort number of source bin

Type: int

Available from: 25.06 (25.6.0.58802)