Product Export

Export sheet specific to All Products and MP4U type Apps

O
Written by OpenHealth - Customer Success Center
Updated over a week ago


Module name

Trigram: PE

Classification

Export sheet specific to All Products and MP4U type Apps

Screenshot

List of fields found in the Export table

# GTIN

AFIPA_Category

AFIPA_Segments

AFIPA_SELFCARE

AFIPA_Sub-Segments

ANS ATCVet Level1

ANS ATCVet Level2

ANS ATCVet Level3

ANS ATCVet Level4

ANS ATCVet Level5

ANS Code ATCVet

ANS_Condition Delivrance

ANS_Espece Destination

ANS_Nature

Brands

Companies

EphMRA Code Level 1

EphMRA Code Level 2

EphMRA Code Level 3

EphMRA Code Level 4

Family

Freely Available

GTIN

IRI_Brand

IRI_Category

IRI_Company

IRI_Department

IRI_Ray

IRI_Sub-Ray

IRI_Sub-Type

IRI_Type

Line

Network

OHC Classification Level 1

OHC Classification Level 2

OHC Classification Level 3

OHC Classification Level 4

OHC Classification Level 5

OHC_DateInscriptionDTM

OHC_DateInscriptionSRC

OHC_Tech_BDDSource

OHC_Tech_DateHeureExtraction

OMS Code Level 1

OMS Code Level 2

OMS Code Level 3

OMS Code Level 4

OMS Code Level 5

Prescription Type

Product lining

Products (References)

Segments

TECHNICAL CODE 2

THE_Active Substance

THE_Administration Way

THE_CIS Code

THE_Complement Form

THE_Container

THE_Container Name

THE_Container Number

THE_Contenance_Number

THE_Contenance_Unit

THE_Dosage Base Substance Unit

THE_Form

THE_Generic Type

THE_GSP Code

THE_List

THE_Market Authorization first approval

THE_Nature

THE_Packaging Unit Name

THE_Packaging Units Number

THE_Reimbursement

THE_Substance Dosage

THE_Substance Dosage Unit

THE_Substance Father

THE_Substance Label

THE_UCD

THE_UCD Code

THE_UCD Nature

THE_UCD Number

THE_Way

Measures

#TECHNICAL CODE 2: Separate statement of Technical Codes
#GTIN: Separate statement of 13 Digits Product Codes

Version


Current version:

Product Export v2010011240

  • Replacement of dimension 50 corresponding to the THE_Substance Label (EXT_LibelleSubstance) field

version:

  • Addition of the "Data Input" Warning

  • Added missing fields based on MP4U, as well as crossover between MPA and MPA.

  • Internal Technical Improvement

Did this answer your question?