Import Partner Master Data

Select the Import icon in the top right-hand corner of the View Partner Master Data screen.

Upload CSV files and import data elements for a trade partner company's Master Data or trade partner company location(s).

• Data to Upload – Which type of data the uploaded CSV file contains.
  • Company Data Element – To upload company master data.
  • Location Data Element(s) – To upload company location master data.

The element headers below are all required in the CSV file, in order, and separated by commas. See Edit Partner Company Details for country requirements. For the definitions and formats of identifiers and item codes, see Identifier and Item Code Types.

Companies that use TraceLink for serialization or compliance must enter a value for the Street1, City, StateOrRegion, PostalCode, and Country elements.

• BusinessName – The name of this company.
• Status – Whether the data tied to the trade partner company is active or inactive. The status of the Master Data tied to this company.
  • Active – The data can be used in messages and UI functions, and TraceLink pulls the data when necessary.
  • Inactive – The data cannot be pulled for other functions within TraceLink.

  Setting the trade partner company data to Inactive disables data for all the locations tied to that trade partner company.

• PartnerType – The type of business the company conducts (value optional).
  • Manufacturer – The license holder of the pharmaceutical product (e.g. Brand Owners, Generics, MAHs, Specialty Companies).
  • Chemist – The company specializes in the composition of substances, may mix substances in preparation for dispensation, and has a shop selling medicines and cosmetics. Also know as a compounding facility.
  • Packager – The company packages products.
  • Logistics – The company provides logistics services (e.g. LSP, 3PL).
  • Carrying and Forwarding Agent – (CFA) The company facilitates the movement and transfer of goods. In India, CFAs are often involved in moving goods as interstate stock transfers.
  • Wholesaler – The company is a wholesaler of pharmaceuticals.
  • Distributor – The company distributes pharmaceuticals.
  • Stockist (Regional Distributor) – The company stocks the products, and then distributes them.
  • Importer – The company imports products. For customs purposes, this company makes the import declaration, the shipping document names the company as consignee, and the exporter's invoice names the company as buyer.
  • Exporter – The company exports products. For customs purposes, this company makes the export declaration and sells the products to a company in another country, known as the importer.
  • Returns Processor – The company processes returns.
  • Healthcare Facility – The company dispenses pharmaceuticals as a healthcare facility.
  • Pharmacy – The company sells product directly to patients.
• Street1 – Street address, including number and street name. Typically, the company address uses the corporate address (value required if any of the following elements contains a value; Street2, City, District,Village, House Number, Township, StateOrRegion, PostalCode, Country, BuildingNumber, PlantNumber, FloorNumber, AddressObjectGUID, HouseGUID, Premises Code, Company Fax, and TaxRegistrationCode).
• Street2 – Any additional address information (value optional).
• City – The city for this company (value required if any of the following elements contains a value; Street1, Street2, District, Village, House Number, Township, StateOrRegion, PostalCode, Country, BuildingNumber, PlantNumber, FloorNumber, AddressObjectGUID, HouseGUID,Premises Code, Company Fax, and TaxRegistrationCode).
• District – The district for this company's address (value optional).
• StateOrRegion – The state or region for this company (value required if any of the following elements contains a value; Street1, Street2, City, District, Village, House Number, Township, PostalCode, Country, BuildingNumber, PlantNumber, FloorNumber, AddressObjectGUID, HouseGUID, Premises Code, Company Fax, and TaxRegistrationCode).
• PostalCode – The postal code for this company (value required if any of the following elements contains a value; Street1, Street2, City, District, Village, House Number, Township, StateOrRegion, Country, BuildingNumber, PlantNumber, FloorNumber, AddressObjectGUID, HouseGUID, Premises Code, Company Fax, and TaxRegistrationCode).

• Country – Two-letter country code for this company (required if any of the following elements contains a value; Street1, Street2, City, District, Village, House Number, Township, StateOrRegion, PostalCode, BuildingNumber, PlantNumber, FloorNumber, AddressObjectGUID, HouseGUID, Premises Code, Company Fax, and TaxRegistrationCode).

  See Country Codes for a list of codes.

• BuildingNumber – This company's building number (value optional).
• PlantNumber – This company's plant number (value optional).
• FloorNumber – This company's floor number (value optional).
• AddressObjectGUID – The global identifier for the trade partner's entire physical location, assigned by the Russian Federation Information Address System (FIAS). Maximum 36 characters, using the digits 0-9 and letters A-F, e.g. 19406454-0022-000C-00B0-000000000152 (value optional).
• HouseGUID – The global identifier for a specific house number or unit within the trade partner's physical location, assigned by the Russian Federation Information Address System (FIAS). Maximum 36 characters, using the digits 0-9 and letters A-F, e.g. 19606494-0022-000A-0067-000000001259 (value optional).
• CompanyPhone – This company's phone number (value optional).
• CompanyEmail – This company's main email address (value optional).
• ContactName – The regulatory contact's name (value optional).
• ContactTitle – The regulatory contact's title (value optional).
• ContactEmail – The regulatory contact's email address (value optional).
• ContactPhone – The regulatory contact's phone number (value optional).
• IdentifierType – The identifier type used for this entity.
• Value – The value associated with the identifier type.
• Primary – Indicates the primary identifier used by this company. Only one primary identifier is allowed, and it cannot be deleted. TraceLink uses the primary identifier to match any future updates or imports to the correct entity in the TraceLink Network.
• LicenseAgency – Agency that grants the regulatory license (value optional).
• LicenseCountry – Country of the licensing agency (value optional).
• LicenseStateOrRegion – State or region of the licensing agency (value optional).
• LicenseNumber – Regulatory license number for this location (value optional).
• TaxRegistrationCode – The code used to identify this entity for tax or other legal reporting purposes, e.g. a Russia KPP Registration Code (value optional).
• HouseNumber – The identifying number of the building, house, or unit (e.g. 14B) for this company (value optional). House numbers are only separated from the street address for addresses in China.
• Village – The village in which this company is located (value optional).
• Township – The township in which this company is located (value optional).
• CompanyFax – The fax number for this company (value optional).
• PremisesCode – The internal identifier associated with this company. For example, a company with 4 locations in the city of Mumbai that internally refers to the 4th location as MUM4 (value optional).

The element headers below are all required in the CSV file, in order, and separated by commas. See Edit Partner Location Details for country requirements. For the definitions and formats of identifiers and item codes, see Identifier and Item Code Types.

Companies that use TraceLink for serialization or compliance must enter a value for the Street1, City, StateOrRegion, PostalCode, and Country elements.

• PartnerPrimaryIdentifierType – The type of identifier used for the parent company of this location.
• PartnerPrimaryIdentifierValue – The value of the identifier type used for the parent company of this location.
• LocationName – The name of this particular location.
• Street1 – Street address, including number and street name (value required if any of the following elements contains a value; Street2, City, District,Village, House Number, Township, StateOrRegion, PostalCode, Country, BuildingNumber, PlantNumber, FloorNumber, AddressObjectGUID, HouseGUID, Premises Code, Company Fax, and TaxRegistrationCode).
• Street2 – Any additional address information (value optional).
• City – The city for this location (value required if any of the following elements contains a value; Street1, Street2, District, Village, House Number, Township, StateOrRegion, PostalCode, Country, BuildingNumber, PlantNumber, FloorNumber, AddressObjectGUID, HouseGUID,Premises Code, Company Fax, and TaxRegistrationCode).
• District – The district for this location (value optional).
• StateOrRegion – The state or region for this location (value required if any of the following elements contains a value; Street1, Street2, City, District, Village, House Number, Township, PostalCode, Country, BuildingNumber, PlantNumber, FloorNumber, AddressObjectGUID, HouseGUID, Premises Code, Company Fax, and TaxRegistrationCode).
• PostalCode – The postal code for this location (value required if any of the following elements contains a value; Street1, Street2, City, District, Village, House Number, Township, StateOrRegion, Country, BuildingNumber, PlantNumber, FloorNumber, AddressObjectGUID, HouseGUID, Premises Code, Company Fax, and TaxRegistrationCode).

• Country – Two-letter country code for this location (required if any of the following elements contains a value; Street1, Street2, City, District, Village, House Number, Township, StateOrRegion, PostalCode, BuildingNumber, PlantNumber, FloorNumber, AddressObjectGUID, HouseGUID, Premises Code, Company Fax, and TaxRegistrationCode).

  See Country Codes for a list of codes.

• BuildingNumber – This location's building number (value optional).
• PlantNumber – This location's plant number (value optional).
• FloorNumber – This location's floor number (value optional).
• Status – Indicates whether the Master Data tied to this location is active or inactive.
  • Active – The data can be used in messages and UI functions, and TraceLink pulls the data when necessary.
  • Inactive – The data cannot be pulled for other functions within TraceLink.

  Setting the location data to Inactive disables data only for that specific location.

• AddressObjectGUID – The global identifier for the trade partner's entire physical location, assigned by the Russian Federation Information Address System (FIAS). Maximum 36 characters, using the digits 0-9 and letters A-F, e.g. 19406454-0022-000C-00B0-000000000152 (value optional).
• HouseGUID – The global identifier for a specific house number or unit within the trade partner's physical location, assigned by the Russian Federation Information Address System (FIAS). Maximum 36 characters, using the digits 0-9 and letters A-F, e.g. 19606494-0022-000A-0067-000000001259 (value optional).
• CompanyPhone – This location's phone number (value optional).
• CompanyEmail – The company email address tied to this location (value optional).
• ContactName – The regulatory contact's name (value optional).
• ContactTitle – The regulatory contact's title (value optional).
• ContactEmail – The regulatory contact's email address (value optional).
• ContactPhone – The regulatory contact's phone number (value optional).
• IdentifierType – The identifier type used for this entity.
• Value – The value associated with the identifier type.
• Primary – Indicates the primary identifier used by this company. Only one primary identifier is allowed, and it cannot be deleted. TraceLink uses the primary identifier to match any future updates or imports to the correct entity in the TraceLink Network.
• LicenseAgency – Agency that grants the regulatory license (value optional).
• LicenseCountry – Country of the licensing agency (value optional).
• LicenseStateOrRegion – State or region of the licensing agency (value optional).
• LicenseNumber – Regulatory license number for this location (value optional).
• TaxRegistrationCode – The code used to identify this entity for tax or other legal reporting purposes, e.g. a Russia KPP Registration Code (value optional).
• Village – The village in which this location is located (value optional).
• HouseNumber – The identifying number of the building, house, or unit (e.g. 14B) for this location (value optional). House numbers are only separated from the street address for addresses in China.
• Township – The township in which this location is located (value optional).
• CompanyFax – The fax number for this location (value optional).
• PremisesCode – The internal identifier a company uses for this location. For example, a company with 4 locations in the city of Mumbai that internally refers to the 4th location as MUM4 (value optional).

1. Select the type of Data to Upload from the drop-down.
2. Select Choose File.
3. Browse for and select the desired CSV File.
4. Select Submit.

The View Partner Master Data screen displays, and TraceLink begins asycnhronously processing the imported file. Go to Info Exchange to see the status of the asynchronous import, as well as any errors generated by the CSV file.

1. Select PartnerCompanyElementSample.csv.
2. If prompted, select Save, not Open.

3. View the CSV file in a text editor or in Microsoft Excel.

   If opening in Excel, follow the procedure in Opening Exported CSV Reports with Excel.

1. Select PartnerLocationElementsSample.csv.
2. If prompted, select Save, not Open.

3. View the CSV file in a text editor or in Microsoft Excel.

   If opening in Excel, follow the procedure in Opening Exported CSV Reports with Excel.