getStockInfoComplete

Returns the complete stock information in form of a list. This form of request is only reasonable with a small number of stock articles, because the amount of transmitted data could become very large.

Object: /net/dsb/vhs3/StockInfo
Method: getStockInfoComplete
Version: 1.0.0

Parameter

Name	Type / Lenght	Opt. / Mandat:	Description
stock-plant	AN / 2	O	0 .. n Plants
from-hit	N / 5	K	If the result set should be reduced, the you can pass here then first hit, that should be returned. Default is 1.
max-hit-count	N / 5	K	Number of the max. returned hits. Default is „all hits“.

Response Element

List of stock-info XML fragments (see below).

Example Request

<?xml version="1.0" encoding="UTF-8"?>
<message version="1.0" system="vhs/3" >
  <header>
    <client>4711</client>
    <service-provider>999</service-provider>
  </header>
  <body>
    <!-- 0 .. n -->
    <stock-plant>1</stock-plant>
  </body>
</message>

Example Response

<?xml version="1.0" encoding="UTF-8"?>
<message version="1.0" system="vhs/3">
  <header>
    <client>4711</client>
    <service-provider>999</service-provider>
  </header>
  <body>
    <!-- 0 .. 100 -->
    <stock-info>
    </stock-info>
  </body>
</message>

Response Structure

Structure <stock-info> Version 1

<stock-info>
  <stock-article-number>3AKLOPF</stock-article-number>
  <stock-article-number-external>123</stock-article-number-external>
  <stock-article-description>BAMBI PLUESCH KLOPFER</stock-article-description>
  <stock-article-ean>3AKLOPF</stock-article-ean>
  <stock-available stock-plant="">47</stock-available>
  <stock-available-free stock-plant="">40</stock-available-free>
  <stock-blocked stock-plant=""></stock-blocked>
  <stock-returned stock-plant=""></stock-returned>
  <stock-damaged stock-plant=""></stock-damaged>
  <stock-reserved stock-plant=""></stock-reserved>
  <stock-client></stock-client>
  <stock-plant></stock-plant>
  <stock-available-sum>128</stock-available-sum>
  <stock-available-free-sum>120</stock-available-free-sum>
  <stock-blocked-sum></stock-blocked-sum>
  <stock-returned-sum></stock-returned-sum>
  <stock-damaged-sum></stock-damaged-sum>
  <stock-reserved-sum></stock-reserved-sum>
  <contingent-information>
    <!—- 0 to n -->
    <contingent distribution-channel=””></contingent>
  </contingent-information>
  <!—- 0 to n -->
  <distribution-article>
    <distribution-article-number></distribution-article-number>
    <distribution-article-number-external></distribution-article-number-external >
    <distribution-channel></distribution-channel>
    <delivery-code></delivery-code>
    <product-group></product-group>
    <stock-minimum></stock-minimum>
  </distribution-article>
</stock-info>

Structure <stock-info> Version 2 + 3

<stock-info>
  <stock-article-number/>
  <stock-article-number-external/>
  <stock-article-description>BAMBI PLUESCH KLOPFER</stock-article-description>
  <stock-article-ean/>
  <stock-client/>
  <timestamp-of-last-stock-update/>
  <!—- 0 to n -->
  <stock-plant-information>
    <stock-plant-nr>1</stock-plant-nr>
    <stock-available>5</stock-available>
    <stock-available-free>4</stock-available-free>
    <stock-blocked>0</stock-blocked>
    <stock-returned>4</stock-returned>
    <stock-damaged>4</stock-damaged>
    <stock-reserved>1</stock-reserved>
  </stock-plant-information>
  <stock-available-sum>5</stock-available-sum>
  <stock-available-free-sum>4</stock-available-free-sum>
  <stock-blocked-sum>0</stock-blocked-sum>
  <stock-returned-sum>4</stock-returned-sum>
  <stock-damaged-sum>4</stock-damaged-sum>
  <stock-reserved-sum>1</stock-reserved-sum>
  <!—- 0 to n -->
  <distribution-article>
    <distribution-article-number>0000001</distribution-article-number>
    <distribution-article-number-external/>
    <distribution-channel></distribution-channel>
    <delivery-code>F1</delivery-code>
    <product-group>0000</product-group>
    <stock-minimum>0</stock-minimum>
    <!-- erst ab Version 3.0.0 -->
    <stock-reorder-quantity>0</stock-reorder-quantity>
  </distribution-article>
</stock-info>

Element Definitions

Field	Length	Type	Remark, field supply or encoding
stock-article-number	18	AN	Stock article number
stock-article-number-external	n.a.	AN	External stock article number
stock-article-description	30	AN	Stock article description
stock-article-ean	13	AN	International Article Number (former European Article Number)
stock-client	4	AN	Client (since service version 2.0.0)
timestamp-of-last-stock-update	23	AN	Timestamp, of last stock article update (since service version 2.0.0) Format yyyy-MM-ddThh:MM:ss.S
stock-plant-nr	2	AN	Name or number of the queried plant or the default plant (alternative for Attribute 'stock-plant' since service version 2.0.0)
stock-available	7	N	Stock available (of the specified plant) This value is the physically available stock
stock-available → attribute: stock-plant	2	AN	Name or number of the queried plant or the default plant
stock-available-free	7	N	Free available Stock (of the specified plant) This is a virtual value that is determined by subtracting reserved from available
stock-available-free → attribute: stock-plant	2	AN	Name or number of the queried plant or the default plant
stock-blocked	7	N	Stock blocked (of the specified plant)
stock-blocked → attribute: stock-plant	2	AN	Name or number of the queried plant or the default plant
stock-returned	7	N	Stock returned (of the specified plant)
stock-returned → attribute: stock-plant	2	AN	Name or number of the queried plant or the default plant
stock-damaged	7	N	Stock damaged (of the specified plant)
stock-damaged → attribute: stock-plant	2	AN	Name or number of the queried plant or the default plant
stock-reserved	7	N	Stock reserved (of the specified plant) because of reservations or backlogs
stock-reserved → attribute: stock-plant	2	AN	Name or number of the queried plant or the default plant

stock-client	4	AN	Stock client
stock-plant	2	AN	Plant

stock-available-sum	7	N	Stock available (sum of all queried plants)
stock-available-free-sum	7	N	Free available Stock (sum of all queried plants)
stock-available-sum	7	N	Stock available (sum of all queried plants)
stock-available-free-sum	7	N	Free available Stock (sum of all queried plants)
stock-blocked-sum	7	N	Stock blocked (sum of all queried plants)
stock-returned-sum	7	N	Stock returned (sum of all queried plants)
stock-damaged-sum	7	N	Stock damaged (sum of all queried plants)
stock-reserved-sum	7	N	Stock reserved (sum of all queried plants)
contingent-information 0 … n (only in Version 1.0.0 available)
contingent		N	accumulated contingent of all plants regarding the stock-article, per distribution-channel
contingent → Attribut: distribution-channel	4	AN	distribution-channel

distribution-article-number	18	AN	Distribution article number
distribution-article-number-external	20	AN	externe Vertriebsartikelnummer
delivery-code	4	AN	Delivery code
product-group	4	AN	Product group
distribution-channel	4	AN	Distribution channel
stock-minimum	9	N	Minimum stock of the distribution article
stock-reorder-quantity	9	N	Only in Service Version 3.0.0 available

Field mapping in VIS

XML-Element	Table and Field in VIS
stock-article-number	M_LAR.LAR_ARTNR
stock-article-description	M_LAR.LAR_BEZ
stock-article-ean	M_LAR.LAR_EAN_NR
stock-available	M_LAR.LAR_BEST_LAG1
stock-available-free	n. a.
stock-blocked	M_LAR.LAR_BEST_LAG2
stock-returned	M_LAR.LAR_BEST_LAG3
stock-damaged	M_LAR.LAR_BEST_LAG4
stock-reserved	M_LAR.LAR_RES_RUECK

stock-client	M_LAR.LAR_CLUSTER
stock-plant	M_LAR.LAR_WERK

stock-available-sum	n. a.
stock-available-free-sum	n. a.
stock-blocked-sum	n. a.
stock-returned-sum	n. a.
stock-damaged-sum	n. a.
stock-reserved-sum	n. a.

contingent-information→contingent	M_KONT.KON_MENGE(accumulated over all plants)
contingent-information→contingent → distribution-channel	M_KONT.KON_VSCHIENE

distribution-article → distribution-article-number	M_VAR.VAR_ARTNR
distribution-article → distribution-article-number-external	M_VAR.VAR_ART_NR_EXT
distribution-article → delivery-code	M_VAR.VAR_LKZ_AKT
distribution-article → product-group	M_VAR.VAR_PROD_GRP
distribution-article → distribution-channel	M_VAR.VAR_VSCHIENE
distribution-article → stock-minimum	M_VAR.VAR_MIND_BEST
distribution-article → stock-reorder-quantity	n. a.