ARTICLE_WHOLESALER

Artikeldaten der Grossisten / Lieferinfos Verblisterer
Informations des grossistes pour leur articles / Informations de livraison de l'emballeur sous blister

Source: Wholesaler   |   Release 2008-01   |   Schema/XSD   |   Example Data

For each wholesaler (as seen in the schema WHOLESALER), this schema includes information about

  • availability
  • base prices
  • conditions

In addition, the schema also includes similar data from blister prvoiders. In these cases, the specification is slightly different:

  • The articles always represent a single dose SDO, as available from schema ARTICLE. From there on, you can link to additional PRODUCT information (e.g. the pharmacological divisibility in PRODUCT_PROPRIETARY_QUANTITY/PQ/DIV)
  • The stock information STCK has a value of 1 if this SDO can be ordered from the blister provider. The stock information of 0 denotes all SDO, which are not offered for blistering, either because the SDO is not blisterable or because there is not enough market demand. If the STCK is null (element is missing), the blistering provider has no information about this SDO right now; it is suggested to contact him directly in such a case.
    As an example, the blister provider Medifilm lists about 2400 medications, with about 1500 that are available for blistering.
  • The wholesaler code GSCD is always "Y"
  • The availability in STCKIN might contain additional stock information details, as a supplement to the binary information in STCK. We suggest to display this information to the system end user, too.
    • For Medifilm, the possible values are:
      • STCK=1/STCKIN=NORMAL: normal availablity for film / blister service
      • STCK=1/STCKIN=BESTPRI: best price ( no additional logistics costs)
      • STCK=0/STCKIN=NO: unable to blister this article
      • STCK=0/STCKIN=aH: this article is out of trade
      • STCK=0/STCKIN=UNABLE: this article has supply chain problems
      • STCK=0/STCKIN=NONEEDS: There is no market demand for this article.
      • STCK=0/STCKIN=NOSUPPLY: There is no supply for this article.
  • The return code RETCD is always "9" (no returns accpeted)
  • The minimum order size MINORD has a slightly different meaning, as it denotes the minimal divisability of a SDO than can be ordered, e.g. "0.25" for a SDO that can be ordered as a 1/4th-tablet. A tablet can always be ordered in multiples of this value, too (e.g. 0.25 allows orders of 0.5, 0.75, 1, 1.25, 1.5, 1.75 etc.)
  • The pricecode PRICD is always "N" (package without price label)
  • The price information in the node WHSPRI contains pricing information. Of note is the price type PTYP, which shall use a value of "BLST" for the prices of blistering providers.

 


Release 2015-11
Lieferinfos Verblisterer (Medifilm AG)
Im Schema ARTICLE_WHOLESALER werden laufend zusätzliche Lieferdaten von weiteren Grossisten aufgeschaltet. Im 2015 waren dies z.B. Unione und Voigt sowie die Daten zur Verfügbarkeit von Medikamenten beim Verblisterungsanbieter Medifilm AG. Damit wird es z.B. für Kranken-, Pflegeheime und Spitäler einfacher, patientenindividuell verblisterte Arzneimittel direkt anhand der INDEX-Daten zu bestellen.

Detailinformationen siehe Release Schreiben 2015-11


Release 2015-11
Informations de livraison de l’emballeur sous blister (Medifilm SA)
De plus en plus de données de livraison de nouveaux grossistes sont publiées dans le schéma ARTICLE_WHOLESALER. Depuis de l’année 2015, ce schéma affiche p. ex. les données d’Unione et de Voigt et également les données concernant la disponibilité des médicaments chez le fournisseur de blisters Medifilm SA. Il sera ainsi plus facile pour les établisseements médico-sociaux et les hôpitaux de commander des médicaments sous blister individuel directement avec la base de données INDEX.

Information voir lettre Release 2015-11

 

Tooltip

German Artikeldaten der Grossisten / Lieferinfos Verblisterer
French Informations des grossistes pour leur articles / Informations de livraison de l'emballeur sous blister

Schema Elements Overview

Element Name Short Description
AW Artikelsatz des Grossisten
Article-record of wholesaler
Article-record of wholesaler
WHSNO Wholesaler key
Wholesaler key
Wholesaler key
PLF This platform is wholesaler dependent
This platform is wholesaler dependent
This platform is wholesaler dependent
PHAR Pharmacode
Pharmacode
Pharmacode
STCK Stock/assortment information
Stock/assortment information
Stock/assortment information
GSCD Konditionen
Conditions
Conditions
RPTYP Type of replacement
Type of replacement
Type of replacement
RPCD Kind of replacement
Kind of replacement
Kind of replacement
RPART Pharmacode of an article under special sale which replaces current article
Pharmacode of an article under special sale which replaces current article
Pharmacode of an article under special sale which replaces current article
STCKIN Article availability
Article availability
Article availability
RETCD Mode for product return conditions
Mode for product return conditions
Mode for product return conditions
RETDEL Return conditions
Return conditions
Return conditions
RETPRC Percentage of withdrawal on returns by supplier
Percentage of withdrawal on returns by supplier
Percentage of withdrawal on returns by supplier
MINORD Minimum order quantity
Minimum order quantity
Minimum order quantity
SIZEX Package width in mm
Package width in mm
Package width in mm
SIZEY Package depth in mm
Package depth in mm
Package depth in mm
SIZEZ Package height in mm
Package height in mm
Package height in mm
WHSARTCD Wholesalers article number/old pseudo ‘pharmacode’ given by wholesaler
Wholesalers article number/old pseudo ‘pharmacode’ given by wholesaler
Wholesalers article number/old pseudo ‘pharmacode’ given by wholesaler
PRICD Price Code
Price Code
Price Code
SEASN Seasonal period
Seasonal period
Seasonal period
VOL Volume in cm3
Volume in cm3
Volume in cm3
WGHT Weight in gram
Weight in gram
Weight in gram
DEL Löschkennzeichen
Logical delete flag
Logical delete flag
WHSACT Wholesaler special sales
Wholesaler special sales
Wholesaler special sales
ACTNO Current number of special sale condition for article-wholesaler-combination
Current number of special sale condition for article-wholesaler-combination
Current number of special sale condition for article-wholesaler-combination
ACTCD Type of special sale
Type of special sale
Type of special sale
ACTSTRT First day of special sale
First day of special sale
First day of special sale
ACTEND Last day of special sale
Last day of special sale
Last day of special sale
QDEL Delivered quantity
Delivered quantity
Delivered quantity
QINV Delivered quantity
Delivered quantity
Delivered quantity
DISC Discount in percent
Discount in percent
Discount in percent
UPRICE Reduced price per unit on this discount level
Reduced price per unit on this discount level
Reduced price per unit on this discount level
WHSPRI Grossisten Preise
Wholesaler Prices
Wholesaler Prices
PTYP Price Type
Price Type
Price Type
VDAT Validity date
Validity date
Validity date
PRICE Price fixed by wholesaler incl. Packet depots
Price fixed by wholesaler incl. Packet depots
Price fixed by wholesaler incl. Packet depots
PDPRI Price of packet deposit like ‘Bottle’
Price of packet deposit like ‘Bottle’
Price of packet deposit like ‘Bottle’
BDPRI Price of bundle deposit like ‘Harrasse’
Price of bundle deposit like ‘Harrasse’
Price of bundle deposit like ‘Harrasse’
PHARMACODE

-


Copyright © HCI Solutions AG 2015
PROD  1.0.9047.34671