All templates

1. Hover over Modules in the top menu, and then select Serial Number Manager.
2. Select the Import icon in the top right of View Serial Number Templates screen.
3. Select Choose File.
4. Locate and select the CSV file containing the serial number templates.
   See the required column headers for CSV files

   • PackagingCodeType - The format of the packaging code corresponding to the required serial number type.

   • PackagingCodeValue - The numeric value corresponding to the packaging of a particular product.

   • ItemDescription - The product description, which includes the product name, dosage, form, and the number of doses.

   • AssignToID - Templates that generate serial numbers for a specific location.

   • FilterValue - A digit that specifies the packaging level associated with the serial number.

   • ExtensionDigit - A one-digit segment to extend the serial number reference segment of an SSCC identifier.

   • TemplateType - The templates that generate serial numbers according to the type of list, or support automatic replenishment from external serial number managers.

   • RequestFromID - A Serial Number Manager Partner that will provide serial numbers.

   • NotifyAfterInHours - If no response is received after the hours indicated, TraceLink will send a notification.

   • MaximumRequestQuantity - The maximum quantity of serial numbers generated in a single request (maximum 500,000).

   • MinThreshold - The lowest amount of serial numbers allowed in the repository, which must be greater than or equal to the maximum request quantity.

   • MaxThreshold - The highest amount of serial numbers allowed in the repository (maximum 10,000,000).

   • SerialNumberLength - The number of characters in a serial number. This value can be between 10 and 20.

   • StartingSerialNumber - Once serial numbers are issued, the starting serial number cannot be changed. This value can be between 10 and 20 digits.

   • UseUpperCaseLetters - Select Upper Case Letters (A-Z) to be included in serial numbers.

   • ExcludedUpperCaseLetters - Letters I, J, L, O, Q, and U are excluded by default, because they can easily be confused with other letters or numbers. Other letters can be selected to exclude.

   • UseLowerCaseLetters - Select Lower Case Letters (a-z) to be included in serial numbers.

   • ExcludedLowerCaseLetters - Letters i, j, l, o, q, and u are excluded by default, because they can easily be confused with other letters or numbers. Other letters can be selected to exclude.

   • Status - The template status, Active or Inactive, based on the value for the packaging code in Product Master Data.

   • UniquenessID - Contains either Product Code, Company ID, or Company Location ID. If blank, defaults to Packaging Code.

   • UniquenessValue - Contains the specific Product Code value, Company ID value, or Company Location ID value. If blank, defaults to Packaging Code.

   • UseCryptoCodes - Indicates whether serial numbers must include crypto codes (i.e. encrypted identification numbers) generated by Kazakhstan's, Russia's, Russia BAFS's, or Uzbekistan's Order Management System (OMS). Use Crypto Codes can be selected only if the Kazakhstan Target Market, Russia Target Market for Food Supplement products, or Uzbekistan Target Market has a Production Type of Imported in Product Master Data. A location can Use Crypto Codes for either an Imported or Locally Manufactured product, but not both for Russia pharmaceutical products. Valid values are Yes or No. If UseCryptoCodes is set to Yes, serial numbers provisioned through the template become available to locations only after TraceLink receives their associated crypto codes (i.e. enter the Unreserved state).

     Can be set to Yes only if the following conditions are met:

     • The company owns the Kazakhstan Crypto Codes, Russia Crypto Codes, Russia BAFS Crypto Codes, or Uzbekistan Crypto Codes application.

     • PackagingCodeType is GTIN-14.

     • PackagingCodeValue has a Target Market of Kazakhstan, Russia or Uzbekistan in Product Master Data.

     • TemplateType is Auto-Replenished by Other Serial Number Manager or Generated Random List.

     • SerialNumberLength is 13 (for Generated Random List templates only).

   • PaymentType - How the company pays for crypto codes. Conditionally required if the template type is Generated Random List and UseCryptoCodes is Yes.

   • SerialNumberPrefix - This entry supports products with a target market of Russia, product type of Food Supplement, and a production type of Imported. The default is 5.

5. Select Submit.

1. Hover over Modules in the top menu, and then select Serial Number Manager.

2. Fill in one or more of the following search fields:
   1. Packaging Code Type drop-down – The format of the packaging code corresponding to the required serial number type.
   • All (default) – All templates, regardless of type.
   • CN-ResCode – A 5-digit China packaging code.
   • GS1 Company Prefix – A company identifier used in a Serial Shipping Container Code (SSCC), assigned and administered by GS1 Global.
   • GTIN-14 – A 14-digit Global Trade Item Number.
   • NTIN – A 14-digit National Trade Item Number.
   2. Packaging Code field – The numeric value corresponding to the packaging of a particular product. Each packaging code only uses one template (e.g. bottle of 100, blister pack of 25).
   3. Description field – The product description, which includes the product name, dosage, form, and the number of doses (e.g. Allergy Med 90 MG Caps 30).
   4. Status drop-down - The template status. Serial Number Manager does not create, import, replenish, or provision serial numbers in response to a serial number request for inactive templates:
   • Active (default) – Templates that format serial numbers.
   • Inactive – Templates that do not format serial numbers.
   5. Template Type drop-down – The templates that generate serial numbers according to the type of list, or support automatic replenishment from external serial number managers.
      • All (default) – All templates.
      • Auto-Replenished by Other Serial Number Manager – It supports auto-replenishment from an external serial number manager.
      • Generated Random List – It formats random, non-sequential serial number lists (e.g. 5000, 5050, 5075, 5080).
      • Generated Sequential List – It formats sequential serial number lists (e.g. 1000, 1001, 1002).
      • Generated Sequential Range – It formats a range of sequential serial numbers (e.g. 5000-6000).
      • Manually Imported List – It imports lists of serial numbers generated by an external serial number manager.
      • Provisioned by Packager – It enables the packager to assign serial numbers independently of the manufacturer.
   6. Target Market field – The country market that the product is distributed in.
   7. Packaging UOM drop-down – The packaging level (i.e. unit of measure) for the items being commissioned:
      • Primary – The level of packaging that physically touches the product (i.e. blister packs). This level is not available for CN-ResCode.
      • Each – The smallest salable unit of the product.
      • Inner Pack/Bundle – A grouping of eaches.
      • Case/Shipper – A grouping of inner packs/bundles, or a grouping of eaches if the packaging hierarchy does not include inner packs/bundles.
      • Pallet – A grouping of cases, inner packs, or eaches together on a pallet.
   8. Item Code Type drop-down – The item code used for this product. Each item code type can only be used once for each product, except for internal material number. See Identifier and Item Code Types for more information.
   9. Item Code field – The item code used for the product.
   10. Serial Numbers Assigned To drop-down – The templates that generate serial numbers for a specific location.
       • All (default) – The templates where serial numbers are available for use by all Partner locations.
       • General Pool – The templates where serial numbers are available for all Partners.
       • Location – The templates where serial numbers are available for a specific Partner.
   11. Product Name field – The user-assigned product name.
3. Select Search.

   The results display in the table.

   See the information that displays in the table

   • Packaging Code – The numeric value corresponding to the packaging of a particular product.
   • Description – The product description, which includes the product name, dosage, form, and the number of doses.
   • Serial Numbers Assigned To – The company or location that the serial numbers are assigned to.
   • Encoding Type – The type of serial number.
     • AI(01)AI(21) – An application identifier that contains the item's Global Trade Item Number (GTIN) or National Trade Item Number (NTIN) and serial number.
     • AI(00) – A Serial Shipping Container Code (SSCC).
     • CN-EDMC – A Chinese Electronic Data Monitoring Code.
   • Packaging Code Attributes – Additional information on serial numbers which vary according to the Packaging Code Type.

     • The (GS1) Company Prefix and Filter Value display on 2 lines for GTIN-14.

     • Dashes (--) display for NTIN.

     • The Filter Value and Extension Digit display on 2 lines for GS1 Company Prefix.

     • The CN-Subtype and Code Version display on 2 lines for CN-ResCode.

   • Template Type – The templates that generate serial numbers according to the type of list.
     • All (default) – All templates.
     • Auto-Replenished by Other Serial Number Manager – It supports auto-replenishment from an external serial number manager.
     • Generated Random List – It formats random, non-sequential serial number lists (e.g. 5000, 5050, 5075, 5080).
     • Generated Sequential List – It formats sequential serial number lists (e.g. 1000, 1001, 1002).
     • Generated Sequential Range – It formats a range of sequential serial numbers (e.g. 5000-6000).
     • Manually Imported List – It imports lists of serial numbers generated by an external serial number manager.
     • Provisioned by Packager – It enables the packager to assign serial numbers independently of the manufacturer.
   • Template Information – Additional information on templates which vary according to the Template Type.
     • The Min - Max Thresholds and the Serial Number Manager Partner displays on 2 lines for the Auto-Replenished type.
     • The Min - Max Thresholds and Serial Number Length display on 2 lines for the Random List type.
     • The Starting Serial Number displays for the Sequential Range or Sequential List types.
     • The Minimum Threshold displays for the Imported List type.
     • Dashes (--) display for the Provisioned by Packager type.
   • Max Request Qty – The highest amount of serial numbers requested at once.
   • Qty Available – Results vary according to the Template Type.

     • Dashes (--) display for the Sequential Range, Sequential List, or Provisioned by Packager types.

     • The Quantity of Serial Numbers Currently Available displays for the Random List type, indicating that new serial numbers are pending exchange with the Serial Number Manager.

     • The Quantity of Serial Numbers Currently Available displays for Imported List or Auto-Replenished types, indicating that imported serial numbers are pending exchange with the Serial Number Manager.

   • Status – The template status:
     • Active (default) – Templates that format serial numbers.
     • Inactive – Templates that do not format serial numbers.

Tips

• Select View Import History in the Actions column for any row with a Template Type of Manually Imported List to access import history.
• Select View Replenishment History in the Actions column for any row with a Template Type of Auto-Replenished to access replenishment history.