pixiReport_StockValue

API call exposes Stock value report.

Since pixi version: AVA 17.03 (8.4.27.29272) Additional notes:


Request

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

Request body

Name Type Required Description
LocID string false

[optional] pixi* Location ID (filter).

Type: varchar(10)

Default value:

Example:

Available from: AVA 17.03 (8.4.27.29272)

SupplNr string false

[optional] pixi* Supplier number (filter).

Type: varchar(10)

Default value:

Example:

Available from: AVA 17.03 (8.4.27.29272)

Category string false

[optional] pixi* category ID (filter).

Type: varchar(10)

Default value:

Example:

Available from: AVA 17.03 (8.4.27.29272)

ParamDate string false

[optional] Date used to show the data of Stock value report. If left empty it defaults to end of current day.

Type: datetime

Default value:

Example:

Available from: AVA 17.03 (8.4.27.29272)


Response

1. Result set

Name Type Description
EK number

EK

Type: money

Available from: 25.06 (25.6.0.58802)

LocID string

LocID

Type: varchar

Available from: 25.06 (25.6.0.58802)

Sum_EK number

Sum_EK

Type: money

Available from: 25.06 (25.6.0.58802)

Barcode string

Barcode

Type: varchar

Available from: 25.06 (25.6.0.58802)

Bestand integer

Bestand

Type: int

Available from: 25.06 (25.6.0.58802)

MwStSatz number

MwStSatz

Type: numeric

Available from: 25.06 (25.6.0.58802)

VK_Netto number

VK_Netto

Type: numeric

Available from: 25.06 (25.6.0.58802)

Kategorie string

Kategorie

Type: varchar

Available from: 25.06 (25.6.0.58802)

Rohertrag number

Rohertrag

Type: numeric

Available from: 25.06 (25.6.0.58802)

Rohertrah number

Rohertrah

Type: numeric

Available from: 25.06 (25.6.0.58802)

SupplName string

SupplName

Type: varchar

Available from: 25.06 (25.6.0.58802)

VK_Brutto number

VK_Brutto

Type: money

Available from: 25.06 (25.6.0.58802)

par_LocID string

par_LocID

Type: varchar

Available from: 25.06 (25.6.0.58802)

Artikelname string

Artikelname

Type: varchar

Available from: 25.06 (25.6.0.58802)

par_SupplNR string

par_SupplNR

Type: varchar

Available from: 25.06 (25.6.0.58802)

CurrencyCode string

CurrencyCode

Type: varchar

Available from: 25.06 (25.6.0.58802)

Sum_VK_Netto number

Sum_VK_Netto

Type: numeric

Available from: 25.06 (25.6.0.58802)

par_Category string

par_Category

Type: varchar

Available from: 25.06 (25.6.0.58802)

Artikelnummer string

Artikelnummer

Type: varchar

Available from: 25.06 (25.6.0.58802)

Sum_VK_Brutto number

Sum_VK_Brutto

Type: money

Available from: 25.06 (25.6.0.58802)

par_paramdate string

par_paramdate

Type: datetime

Available from: 25.06 (25.6.0.58802)

LieferantenArtikelnummer string

LieferantenArtikelnummer

Type: varchar

Available from: 25.06 (25.6.0.58802)