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.
- For Medifilm, the possible values are:
- 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 |
- |