Tracelink University

Table of contents

The Product Transfer Resale Transaction is used primarily by distributors, wholesalers, and resellers to share detailed information with manufacturers or suppliers about the movement of their products. This includes data on sales, returns that are eligible for rebates, transfers, and sometimes non-physical movements, helping manufacturers gain visibility into how their products are performing across different locations and customer segments.

For example, a distributor may send a product transfer resale transaction after selling a product to an end customer, allowing the manufacturer to process a rebate based on those sales. In some cases, the product transfer resale transaction may be used alongside promotional programs or contractual agreements.

While the product transfer resale transaction is similar to product activity data, it provides a more comprehensive and detailed view of inventory movement. It captures not only product sales and transfers between locations but also includes insights into sales to end customers and instances of lost demand or unfulfilled orders. This expanded scope makes it an essential tool for rebate validation, as well as for inventory analysis, demand forecasting, and sales performance tracking.

Product transfer resale transaction can be triggered by specific events (e.g., a product sale) or sent on a regular schedule (e.g., weekly or monthly reports). Once received, the manufacturer typically sends a functional acknowledgment to confirm successful receipt.

Product transfer resale transaction (X12)

The Product Transfer Resale Transaction X12 message includes information on transferred products, sales to end customers, and lost demand or unfulfilled orders via a X12 basic type message.

Contact your TraceLink Services representative for more information about integrating with this message.

  • Message Type: MPC_PRODUCT_TRANSFER_RESALE_REPORT
  • X12 Format: X12 867
  • Transform Names:

    • B2B_EDI_X12_867_ProductTransferResaleReport_IB_V1

    • B2B_EDI_X12_867_ProductTransferResaleReport_OB_V1

Input Element Occurs Length Description Example
ISA 1…1 - Required. ISA interchange envelope. -
  ISA01 1…1 2/2 Required. Qualifier for authorization control number in ISA02. 00
  ISA02 1…1 10/10 Required. Information used for additional identification or authorization of the interchange sender or the data in the interchange/ 10 spaces a valid entry. -
  ISA03 1…1 2/2 Required. Qualifier for security information in ISA04. 00
  ISA04 1…1 10/10 Required. Identifies security information about the interchange sender or data. -
  ISA05 1…1 2/2

Required. Interchange sender partner ID qualifier.

  • 01 – Duns (Dun & Bradstreet).
  • 02 – Standard Carrier Alpha Code.
  • 03 – Federal Maritime Commission.
  • 04 – International Air Transport Association.
  • 07 – Global Location Number (GLN).
  • 08 – UCC EDI Communications ID (Comm ID).
  • 09 – X.121 (CCITT).
  • 10 – Department of Defense (DoD) Activity Address Code.
  • 11 – Drug Enforcement Administration identifier.
  • 12 – Telephone Companies.
  • 13 – Used for UCS Transmissions. Includes Area Code and Telephone Number of a Modem.
  • 14 – Duns Plus Suffix.
  • 15 – Petroleum Accountants Society of Canada Company Code.
  • 16 – DINS Number With 4-Character Suffix.
  • 17 – American Bankers Association (ABA) Transit Routing Number (Including Check Digit, 9 Digit).
  • 18 – Association of American Railroads (AAR) Standard Distribution Code.
  • 19 – EDI Council of Australia (EDICA) Communications ID Number (COMM ID).
  • 20 – Health Industry Number (HIN).
  • 21 – Integrated Postsecondary Education Data System.
  • 22 – Federal Interagency Commission on Education, or FICE.
  • 23 – National Center for Education Statistics Common Core of Data 12-Digit Number for Pre-K-Grade 12 Institutes.
  • 24 – The College Board's Admission Testing Program 4-Digit Code of Postsecondary Institutes, or ATP.
  • 25 – 4-Digit Code of Postsecondary Institutions.
  • 26 – Statistics of Canada List of Postsecondary Institutions.
  • 27 – Carrier Identification Number as assigned by Health Care Financing Administration (HCFA).
  • 28 – Fiscal Intermediary Identification Number as assigned by Health Care Financing Administration (HCFA).
  • 29 – Medicare Provider and Supplier Identification Number assigned by Health Care Financing Administration (HCFA).
  • 30 – U.S. Federal Tax Identification Number.
  • 31 – Jurisdiction Identification Number Plus 4 assigned by the International Association of Industrial Accident Boards and Commissions (IAIABC).
  • 32 – U.S. Federal Employer Identification Number (FEIN).
  • 33 – National Association of Insurance Commissioners Company Code (NAIC).
  • 34 – Medicaid Provider and Supplier Identification Number as assigned by individual State Medicaid Agencies in conjunction with Health Care Financing Administration (HCFA).
  • 35 – Statistics Canada Canadian College Student Information System Institution Codes
  • 36 – Statistics Canada University Student Information System Institution Codes.
  • 37 – Society of Property Information Compilers and Analysts (SPICA).
  • 38 – The College Board and ACT, Inc. 6-Digit Code List of Secondary Institutions.
  • AM – Association Mexicana del Codigo de Producto (AMECOP) Communication ID.
  • NR – National Retail Merchants Association (NRMA) - Assigned.
  • SA – User Identification Number as assigned by the Safety and the Fitness Electronic Records (SAFER) System.
  • SN – Standard Address Number.
  • ZZ – Mutually Defined.
 07
  ISA06 1…1 15/15

Required. Interchange sender identification mapping to:

  • fileSenderNumber with party type defined in ISA05

  • linkIdentifier

  • x12InterchangeControlEnvelope for sender in X12 control file header

7777776067344
  ISA07 1…1 2/2

Required. Interchange receiver partner ID qualifier.

  • 01 – Duns (Dun & Bradstreet).
  • 02 – Standard Carrier Alpha Code.
  • 03 – Federal Maritime Commission.
  • 04 – International Air Transport Association.
  • 07 – Global Location Number (GLN).
  • 08 – UCC EDI Communications ID (Comm ID).
  • 09 – X.121 (CCITT).
  • 10 – Department of Defense (DoD) Activity Address Code.
  • 11 – Drug Enforcement Administration identifier.
  • 12 – Telephone Companies.
  • 13 – Used for UCS Transmissions. Includes Area Code and Telephone Number of a Modem.
  • 14 – Duns Plus Suffix.
  • 15 – Petroleum Accountants Society of Canada Company Code.
  • 16 – DINS Number With 4-Character Suffix.
  • 17 – American Bankers Association (ABA) Transit Routing Number (Including Check Digit, 9 Digit).
  • 18 – Association of American Railroads (AAR) Standard Distribution Code.
  • 19 – EDI Council of Australia (EDICA) Communications ID Number (COMM ID).
  • 20 – Health Industry Number (HIN).
  • 21 – Integrated Postsecondary Education Data System.
  • 22 – Federal Interagency Commission on Education, or FICE.
  • 23 – National Center for Education Statistics Common Core of Data 12-Digit Number for Pre-K-Grade 12 Institutes.
  • 24 – The College Board's Admission Testing Program 4-Digit Code of Postsecondary Institutes, or ATP.
  • 25 – 4-Digit Code of Postsecondary Institutions.
  • 26 – Statistics of Canada List of Postsecondary Institutions.
  • 27 – Carrier Identification Number as assigned by Health Care Financing Administration (HCFA).
  • 28 – Fiscal Intermediary Identification Number as assigned by Health Care Financing Administration (HCFA).
  • 29 – Medicare Provider and Supplier Identification Number assigned by Health Care Financing Administration (HCFA).
  • 30 – U.S. Federal Tax Identification Number.
  • 31 – Jurisdiction Identification Number Plus 4 assigned by the International Association of Industrial Accident Boards and Commissions (IAIABC).
  • 32 – U.S. Federal Employer Identification Number (FEIN).
  • 33 – National Association of Insurance Commissioners Company Code (NAIC).
  • 34 – Medicaid Provider and Supplier Identification Number as assigned by individual State Medicaid Agencies in conjunction with Health Care Financing Administration (HCFA).
  • 35 – Statistics Canada Canadian College Student Information System Institution Codes
  • 36 – Statistics Canada University Student Information System Institution Codes.
  • 37 – Society of Property Information Compilers and Analysts (SPICA).
  • 38 – The College Board and ACT, Inc. 6-Digit Code List of Secondary Institutions.
  • AM – Association Mexicana del Codigo de Producto (AMECOP) Communication ID.
  • NR – National Retail Merchants Association (NRMA) - Assigned.
  • SA – User Identification Number as assigned by the Safety and the Fitness Electronic Records (SAFER) System.
  • SN – Standard Address Number.
  • ZZ – Mutually Defined.

 01
  ISA08 1…1 15/15

Required. EDI receiver ID mapping to file control header and to ServiceLinkId.

Interchange receiver identification mapping to ediInterchangePartyValue for receiver in X12 control file header.

888888404358877
  ISA09 1…1 6/6 Required. Interchange date in 6 char YYMMDD format. 231020
  ISA10 1…1 4/4 Required. Interchange time in 4 char HHMM format. 1420
  ISA11 1…1 1/1 Required. This value is dependent on X12 version.

  • Version 4012 and earlier, this is the interchange control standards identifier. The valid value is U.

  • Version 4020 and later, this is the repetition separator, a delimiter that separates repeated occurrences of a data element or composite data structure, which must be different than the data element separator, component separator, and segment terminator.

^
  ISA12 1…1 5/5 Required. Interchange control version number. This could be any X12 version. 00501
  ISA13 1…1 9/9

Required. Interchange Control Number mapping to

  • file control header

  • X12 control file header interchangeControlIdentifier.

0000000000619827
  ISA14 1…1 1/1

Required. Interchange level acknowledgment requested.

Valid values:

  • 0 - No acknowledgment requested

  • 1 - Interchange level acknowledgment requested

0
  ISA15 1…1 1/1 Required. Indicates whether the interchange is for production, test, or information purposes.

Valid values:

  • I - Information

  • P - Production data

  • T - Test data

 P
  ISA16 1…1 1/1 Required. Component element separator. Delimiter that separates data elements within a composite data structure. Must be different than the data element separator and segment terminator. >
GS 1…* - GS group functional envelope. Child of ISA. Only one GS group expected per interchange. -
  GS01 1…1 2/2

Required. GS group function code.

Valid value is PT - Product Transfer Resale Report X12 849

PT
  GS02 1…1 2/15 Required. Application Sender's Code. 2222224043588
  GS03 1…1 2/15 Required. Application Receiver's Code. TRACELINK
  GS04 1…1 8/8 Required. Current date stamp in 8 char X12 date format YYYYMMDD. 20241020
  GS05 1…1 4/8 Required. Current time stamp in 6 char X12 time format HHMMSS. 142000
  GS06 1…1 1/9 Required. Group Control ID Number. 619827
  GS07 1…1 1/2

Required. Responsible Agency Code.

Valid values:

  • T - Transportation Data Coordinating Committee (TDCC)

  • X - Accredited Standards Committee X12

X
  GS08 1…1 1/12 Required. X12 message version code. This could be any X12 version. 005010
ST 1…* - ST transaction set envelope. Child of GS group. Only one ST transaction expected. -
  ST01 1…1 3/3 Required. Transaction set identifier code. 867
  ST02 1…1 4/9 Required. Transaction set ID number. Counter for each ST segment beginning with 1. 0001
  BPT 1…1 - Required. Response to Product transfer resale report beginning segment. -
    BPT01 1…1 2/2

Required. Transaction set purpose code.

Valid values:

  • 00 - Original

  • 05 - Replace

00
    BPT02 0…1 1/80 Reference identification number, Transaction unique identifier number. 234001
    BPT03 0…1 8/8 Transaction date in YYYYMMDD format. 20070609
    BPT04 0…1 2/2

Report type code, indicating content of the transaction.

Valid values:

  • 01 - Product transfer report

  • 02 - Resale

  • DC - Report between Distributor/Customer inventory report

  • DD - Distributor inventory report

  • DM - Report between Distributor/Manufacturer inventory report

  • IV - Sellers invoice

  • MB - Report between Manufacturer/Distributor inventory report

  • SS - Seller sales report

  • ZZ - Mutually defined

SS
    BPT08 0…1 '4/8 Transaction time in hhmmss format. 131204
    BPT09 0…1 1/80 Reference identification of Previous report number. 234000
  CUR 0…1 - Currency code info for Product transfer resale report. -
    CUR01 1…1 2/3

Required. Entity identifier code for an organization, physical location, property or individual for use of the currency.

Valid values:

  • SE - Selling party currency

  • BY - Buying party currency

SE
    CUR02 1…1 3/3 Required. Standard ISO currency code for the country in which the payments are specified. USD
    CUR03 0…1 4/10 Exchange rate value to be used as a multiplier conversion factor to convert monetary value from one currency to another. -
  DTM 0…10 - Date segment for Transaction report dates or document reference dates, when report start is present it is advised to have report end date as well. -
    DTM01 1…1 3/3

Required. Date type qualifier for the report dates.

Valid values:

  • 090 - Report start date

  • 091 - Report end date

  • 004 - Purchase order date

  • 040 - Status (After and Including)

  • 041 - Status (Prior and Including)

090
    DTM02 0…1 8/8 Processing date in date format YYYYMMDD. 20240628
    DTM03 0…1 4/8 Processing time in time format HHMMSS. 123422
  REF 0…12 - Reference segment for mapping to the transaction references. -
    REF01 1…1 2/3

Required. Reference identification qualifier for the contract class.

Valid values:

  • IV - Seller Invoice number

  • VN - Supplier order number

  • PO - Purchase order number

  • DL - Sellers debit memo

  • CM - Buyer credit memo

  • OI - Original invoice number

  • SB - Sales region number

VN
    REF02 0…1 1/80 Reference identifier value. 123456
    REF03 0…1 1/80 Description defined by qualifier code in REF02. sub-340B
  N1 0…1 -

N1 name segment loop for the

  • customer party information extended with dates and reference identifiers

  • supplier party

  • vendor party

  • bill to party

  • ship to party information extended with dates and reference identifiers

  • manufacturer party

  • reporting location

  • distributor party

-
    N101 1…1 2/3

Required. Entity qualifier for the Customer party identifier and address information.

Valid values:

  • BY - Customer party

  • SU - Supplier party

  • VN - Vendor party

  • BT - Bill to party

BY
    N102 0…1 1/60 Name. Pharma customer
    N103 0…1 1/2

Identifier code qualifier.

Valid values:

  • 01 – DUNS
  • 09 – DUNS+4
  • 11 – Drug Enforcement Agency registration number
  • 21 – Health Industry Number
  • 91 – Company identifier
  • 92 – Company location identifier
  • UL – Global Location Number
 UL
    N104 0…1 2/80 Customer party identifier as qualified by N103 mapping to companyIdentifierValue. 3333331013655
  N3 0…1 - N3: Address: Child of purchasing group (Customer party) N1 name segment. -
      N301 1…1 1/55 Required. Street address 1. 555 Neelan Road
      N302 0…1 1/55 Street address 2. Suite 123
  N4 0…1 - N4: Geographic Location. Child of Customer party N1 name segment. -
      N401 0…1 2/30 City name. Sacramento
      N402 0…1 2/2 State or province code. Code (Standard state/province) as defined by appropriate government agency. CA
      N403 0…1 3/15 Postal code. Code defining international postal zone code excluding punctuation and blanks. 95833
      N404 0…1 2/3 Country code. US
  PER 0…3 - Contact Information. -
      PER01 1…1 2/2 Required. Contact function code identifying major duty or responsibility of person or group named as contact. Valid value is AJ - Primary contact AJ
      PER02 0…1 1/60 Name of the contact person responsible for authenticating the pedigree information. John Smith
      PER03 0…1 2/2

Communication Number Qualifier identifying the contact person's telephone number or email address.

Valid value:

  • TE - Telephone number

  • EM - email address

TE
      PER04 0…1 1/2048

Communication number:

  • Telephone number of the contact person expected in this field.

  • Email address of the contact person.

+1.516.747.6849
      PER05 0…1 2/2

Communication Number Qualifier identifying the contact person's telephone number or email address.

Valid value:

  • TE - Telephone number

  • EM - email address

EM
      PER06 0…1 1/2048

Communication number:

  • Email address for the contact person expected in this field.

  • Telephone number of the contact person.

jsmith@manufac.com
  PTD Loop 1…* - Product Transfer and Resale loop for specifying transfers and resale details. -
    PTD01 1…1 2/2

Required. Product transfer type code.

Valid values:

  • CR - Credit Rebill

  • CC - Charitable Contribution, transferred products to charitable organization

  • DS - Drop and ship sale, Quantity drop shipped directly to Distributor’s customers from Manufacturer

  • IB - Inter branch transfer, All transfers from this location to other Distributor branches

  • RU - Return to saleable inventory

  • RV - Return from distributor customer to vendor when disposition (saleable/unsaleable) is unknown

  • SS - Stock Sale, All sales from this location to Distributor’s customers

  • SU - Total sales from this location, including different type of sales

  • TD - Transfer for disposal, unsaleable return from a distributor customer

CC
    PTD04 0…1 2/3

Reference Identification Qualifier.

Valid values:

  • CT - Contract

  • Q1 - Quote

  • VC - Supplier contract

  • 92 or 2I - Tracking Number

CT
    PTD05 0…1 1/80 Reference Identification. ABCDEFG12345
    PTD06 0…1 2/2

Product transfer movement type code.

Valid values:

  • AI - Adjustment In

  • AO - Adjustment Out

  • CD - Customer to Distributor

  • DC - Distributor to Customer

  • DM - Distributor to Manufacturer

  • MD - Manufacturer to Distributor

  • TI - Transfer In

  • TO - Transfer Out

AI
  REF 0…20 -

REF reference segment loop for:

  • contract number reference in PTD loop group

  • capturing reference identfiers in PTD loop group

-
      REF01 1…1 2/3

Required. Reference identification qualifier for the contract number.

Valid values:

  • DI - Distributor Invoice

  • ZZ - Custom

  • RY - Rebate number

  • IV - Seller Invoice number

  • PO - Purchase order number

  • CM - Buyer credit memo

  • 2I - Tracking Number

CT
      REF02 0…1 1/80 Reference identifier value. 4500018486
      REF03 0…1 1/80 A free-form description to clarify the related data elements and their content. Description defined by qualifier code in transactionReferenceIdentifier (REF02). Acute Care
  DTM 0…10 - DTM date segment for contract reference dates in CON loop. -
      DTM01 1…1 3/3 Required. Date type qualifier for the contract reference dates in CON loop. 092
      DTM02 0…1 8/8 Processing date in date format YYYYMMDD. 20240628
      DTM03 0…1 4/8 Processing time in time format HHMMSS. 123422
    N1 0…1 -

N1 name segment loop for:

  • Bill to party information extended with dates and reference identifiers

  • ship to party information extended with dates and reference identifiers Mostly this is the only party appears in line item level.

  • bill and ship to party information extended with dates and reference identifiers.

  • manufacturer party

  • distributor party information extended with dates and reference identifiers.

  • distributor branch location.

-
      N101 1…1 2/3

Required. Entity qualifier for the Bill to party identifier and address information.

Valid values:

  • BT - Bill to party

  • ST - Ship to party

  • BS - Bill and ship to party

  • MF - Manufacturer party

  • DS - Distributor party

  • DB - Distributor branch

 BT
      N102 0…1 1/60 Name. Pharma customer
      N103 0…1 1/2

Identifier code qualifier.

Valid values:

  • 01 – DUNS
  • 09 – DUNS+4
  • 11 – Drug Enforcement Agency registration number
  • 21 – Health Industry Number
  • 91 – Company identifier
  • 92 – Company location identifier
  • UL – Global Location Number
 UL
      N104 0…1 2/80 Bill to party identifier as qualified by N103 mapping to companyIdentifierValue. 3333331013655
    N3 0…1 - N3: Address: Child of bill to party N1 name segment. -
        N301 1…1 1/55 Required. Street address 1. 555 Neelan Road
        N302 0…1 1/55 Street address 2. Suite 123
    N4 0…1 - N4: Geographic Location. Child of bill to party N1 name segment. -
        N401 0…1 2/30 City name. Sacramento
        N402 0…1 2/2 State or province code. Code (Standard state/province) as defined by appropriate government agency. CA
        N403 0…1 3/15 Postal code. Code defining international postal zone code excluding punctuation and blanks. 95833
        N404 0…1 2/3 Country code. US
    REF (PTD-N1-N3-N4-REF) 0…12 - REF reference segment for mapping for reference identifiers. -
        REF01 1…1 2/3

Required. Reference information for identifiers that are not related to transaction documents. This group would map to X12 segments REF and N9 and EDIFACT RFF for information other than transaction documents. HDA mapping.

Valid values:

  • DH - Drug Enforcement Administration Number

  • HI - Health Industry Number (HIN)

  • IT - Internal customer/buyer number

  • PO - Purchase order number

  • OQ - Order number

DH
        REF02 0…1 1/80 Transaction reference identifier value as defined by enum in transactionReferenceType. AC
        REF03 0…1 1/80 A free-form description to clarify the related data elements and their content. Acute Care
    PER 0…3 - Contact information for Distributor branch location. -
        PER01 1…1 2/2 Required. Contact function code identifying major duty or responsibility of person or group named as contact. Valid value for Distributor branch is AJ - Primary contact. AJ
        PER02 0…1 1/60 Name of the contact person responsible for authenticating the pedigree information. John Smith
        PER03 0…1 2/2

Communication Number Qualifier identifying the contact person's telephone number or email address.

Valid values:

  • TE - Telephone number

  • EM - email address

TE
        PER04 0…1 1/2048 Communication number: Telephone number of the contact person expected in this field. +1.516.747.6849
        PER05 0…1 2/2 Communication Number Qualifier identifying the contact person's telephone number or email address.

Valid values:

  • TE - Telephone number

  • EM - email address

EM
        PER06 0…1 1/2048

Communication number:

  • Email address for the contact person expected in this field.

  • Telephone number of the contact person.

jsmith@manufac.com
  QTY 0…* - Product transfer resale report transaction is driven by quantity, hence product, unit, price, reference details are inside this loop. -
      QTY01 1…1 2/2

Required. Quantity type for return.

Valid values:

  • 32 - Sold

  • 76 - Returned

  • V3 - Transfer

  • 39 - Shipped

  • 41 - Batches

  • AJ - Daily adjusted quantity

32
      QTY02 0…1 1/15 Quantity of product. 25.00
      QTY03.1 1…1 2/2

Required. Unit of measure used for pricing.

  • 02 – Statute Mile
  • 4G – Microliter
  • AM – Ampoule
  • AV – Capsule
  • BD – Bundle
  • BG – Bag
  • BO – Bottle
  • BX – Box
  • C3 – Centiliter
  • CA – Case
  • CC – Cubic Centimeter
  • CF – Cubic Feet
  • CG – Card, Blister
  • CI – Cubic Inches
  • CL – Cylinder
  • CM – Centimeter
  • CN – Can
  • CP – Crate
  • CQ – Cartridge
  • CR – Cubic Meters
  • CT – Carton
  • DA – Day
  • DI – Dispenser
  • DK – Kilometers
  • DL – Deciliter
  • DM – Decimeter
  • DR – Drum
  • DS – Display
  • DZ – Dozen
  • EA – Each
  • FO – Fluid Ounce
  • FT – Foot
  • GA – Gallon
  • GL – Gram/liter
  • GR – Gram
  • GS – Gross
  • H4 – Hectoliter
  • HF – Hundred Feet
  • HR – Hours
  • IN – Inch
  • K6 – Kiloliters
  • KG – Kilogram
  • KT – Kit
  • LB – Pounds
  • LF – Linear Foot
  • LO – Lot (unit of procurement)
  • LT – Liter
  • LY – Linear Yard
  • MC – Microgram
  • ME – Milligram
  • ML – Milliliter
  • MM – Millimeter
  • MO – Months
  • MR – Meter
  • OZ – Ounces
  • PC – Piece
  • PF – Pallet
  • PK – Package
  • PR – Pair
  • PT – Pint
  • QT – Quart
  • RL – Roll
  • SC – Square Centimeter
  • SF – Square Foot
  • SH – Sheet
  • SI – Square Inch
  • SM – Square Meter
  • ST – Set
  • SY – Square Yard
  • T3 – Thousand Pieces
  • TB – Tube
  • TH – Thousand
  • TY – Tray
  • U2 – Tablet
  • UM – Million
  • UN – Unit
  • V2 – Pouch
  • VI – Vial
  • WK – Week
  • YD – Yard
  • YR – Years

 UN
    PO3 0…25 - Additional item details segment in PTD-QTY. -
        PO301 1…1 2/2

Required. Change reason code, kind of change that is being communicated.

Valid values:

  • DC - Changed date

  • EV - Estimated quantity

  • QH - Quantity on hand

  • QO - Quantity Ordered

  • UP - Unit price changes

  • ZZ - Custom value

QO
        PO302 0…1 8/8 Provision to provide a date change. 20220828
        PO303 0…1 3/3 Price identifier code. -
        PO304 0…1 1/17 Unite price. 10.11
        PO305 0…1 2/2

Basis of unit price code.

Valid values:

  • CT - Price according to the contract

  • WH - Wholesale price

  • DI - Distributor price

  • NT - Net price

  • RS - Resale price

  • CA - Catalog price

  • DR - Dealer price

  • DS - Discount price

DR
        PO306 1…1 1/15 Required. Product quantity related to the change reason code. 100
        PO307 1…1 2/2

Required. Unit of measure used for pricing.

  • 02 – Statute Mile
  • 4G – Microliter
  • AM – Ampoule
  • AV – Capsule
  • BD – Bundle
  • BG – Bag
  • BO – Bottle
  • BX – Box
  • C3 – Centiliter
  • CA – Case
  • CC – Cubic Centimeter
  • CF – Cubic Feet
  • CG – Card, Blister
  • CI – Cubic Inches
  • CL – Cylinder
  • CM – Centimeter
  • CN – Can
  • CP – Crate
  • CQ – Cartridge
  • CR – Cubic Meters
  • CT – Carton
  • DA – Day
  • DI – Dispenser
  • DK – Kilometers
  • DL – Deciliter
  • DM – Decimeter
  • DR – Drum
  • DS – Display
  • DZ – Dozen
  • EA – Each
  • FO – Fluid Ounce
  • FT – Foot
  • GA – Gallon
  • GL – Gram/liter
  • GR – Gram
  • GS – Gross
  • H4 – Hectoliter
  • HF – Hundred Feet
  • HR – Hours
  • IN – Inch
  • K6 – Kiloliters
  • KG – Kilogram
  • KT – Kit
  • LB – Pounds
  • LF – Linear Foot
  • LO – Lot (unit of procurement)
  • LT – Liter
  • LY – Linear Yard
  • MC – Microgram
  • ME – Milligram
  • ML – Milliliter
  • MM – Millimeter
  • MO – Months
  • MR – Meter
  • OZ – Ounces
  • PC – Piece
  • PF – Pallet
  • PK – Package
  • PR – Pair
  • PT – Pint
  • QT – Quart
  • RL – Roll
  • SC – Square Centimeter
  • SF – Square Foot
  • SH – Sheet
  • SI – Square Inch
  • SM – Square Meter
  • ST – Set
  • SY – Square Yard
  • T3 – Thousand Pieces
  • TB – Tube
  • TH – Thousand
  • TY – Tray
  • U2 – Tablet
  • UM – Million
  • UN – Unit
  • V2 – Pouch
  • VI – Vial
  • WK – Week
  • YD – Yard
  • YR – Years
 UN
    LIN 0…1 - Item identification segment in PTD - QTY. -
        LIN01 0…1 1/20 Line item identification. 01
        LIN02 1…1 2/2 Required. Product service ID qualifier mapping from global standards enum list. VN
        LIN03 1…1 1/80 Required. Product or service identifier. 08202000230
        LIN04 0…1 2/2 product service ID qualifier mapping from global standards enum list. VN
        LIN05 0…1 1/80 Product or service identifier. 08202000230
        LIN06 0…1 2/2 product service ID qualifier mapping from global standards enum list. LT
        LIN07 0…1 1/80 Product or service identifier. LOT123
        LIN08 - - product service ID qualifier mapping from global standards enum list. VN
        LIN09 - - Product or service identifier. 08202000230
        LIN10 0…1 2/2 product service ID qualifier mapping from global standards enum list. VN
        LIN11 0…1 1/80 Product or service identifier. 08202000230
        LIN12 0…1 2/2 product service ID qualifier mapping from global standards enum list. VN
        LIN13 0…1 1/80 Product or service identifier. 08202000230
        LIN14 0…1 2/2 product service ID qualifier mapping from global standards enum list. VN
        LIN15 0…1 1/80 Product or service identifier. 08202000230
        LIN16 0…1 2/2 product service ID qualifier mapping from global standards enum list. VN
        LIN17 0…1 1/80 Product or service identifier. 08202000230
    PID 0…200 - To capture product description details. -
      PID01 1…1 1/1

Required. Item description type code.

Valid value is F - Free form description

F
    PID05 0…1 1/80 Free form description of item. Free form text
    MEA 0…40 - To indicate actual sales and market capture for the product. -
        MEA01 0…1 2/2

Measurement Reference ID code.

Valid values:

  • AF - Total market sales

  • AK - Penetration of this product

AK
        MEA02 0…1 1/3

Measurement qualifier - Code identifying a measurement type for a measurement value.

Valid value is AY - Number of comparable sales

CP
        MEA03 0…1 1/20 Measurement value - The value of the measurement. 12324
        MEA04.1 1…1 2/2

Required. Marks and numbers used to identify a shipment or parts of a shipment.

  • 02 – Statute Mile
  • 4G – Microliter
  • AM – Ampoule
  • AV – Capsule
  • BD – Bundle
  • BG – Bag
  • BO – Bottle
  • BX – Box
  • C3 – Centiliter
  • CA – Case
  • CC – Cubic Centimeter
  • CF – Cubic Feet
  • CG – Card, Blister
  • CI – Cubic Inches
  • CL – Cylinder
  • CM – Centimeter
  • CN – Can
  • CP – Crate
  • CQ – Cartridge
  • CR – Cubic Meters
  • CT – Carton
  • DA – Day
  • DI – Dispenser
  • DK – Kilometers
  • DL – Deciliter
  • DM – Decimeter
  • DR – Drum
  • DS – Display
  • DZ – Dozen
  • EA – Each
  • FO – Fluid Ounce
  • FT – Foot
  • GA – Gallon
  • GL – Gram/liter
  • GR – Gram
  • GS – Gross
  • H4 – Hectoliter
  • HF – Hundred Feet
  • HR – Hours
  • IN – Inch
  • K6 – Kiloliters
  • KG – Kilogram
  • KT – Kit
  • LB – Pounds
  • LF – Linear Foot
  • LO – Lot (unit of procurement)
  • LT – Liter
  • LY – Linear Yard
  • MC – Microgram
  • ME – Milligram
  • ML – Milliliter
  • MM – Millimeter
  • MO – Months
  • MR – Meter
  • OZ – Ounces
  • PC – Piece
  • PF – Pallet
  • PK – Package
  • PR – Pair
  • PT – Pint
  • QT – Quart
  • RL – Roll
  • SC – Square Centimeter
  • SF – Square Foot
  • SH – Sheet
  • SI – Square Inch
  • SM – Square Meter
  • ST – Set
  • SY – Square Yard
  • T3 – Thousand Pieces
  • TB – Tube
  • TH – Thousand
  • TY – Tray
  • U2 – Tablet
  • UM – Million
  • UN – Unit
  • V2 – Pouch
  • VI – Vial
  • WK – Week
  • YD – Yard
  • YR – Years
 CA
    UIT 0…5 - Specifies item unit details of the product that is being reported. PTD-QTY-UIT -
        UIT01 1…1 - Required. - -
        UIT01.1 1…1 2/2

Required. Unit of measure for recorded product in adjustment.

  • 02 – Statute Mile
  • 4G – Microliter
  • AM – Ampoule
  • AV – Capsule
  • BD – Bundle
  • BG – Bag
  • BO – Bottle
  • BX – Box
  • C3 – Centiliter
  • CA – Case
  • CC – Cubic Centimeter
  • CF – Cubic Feet
  • CG – Card, Blister
  • CI – Cubic Inches
  • CL – Cylinder
  • CM – Centimeter
  • CN – Can
  • CP – Crate
  • CQ – Cartridge
  • CR – Cubic Meters
  • CT – Carton
  • DA – Day
  • DI – Dispenser
  • DK – Kilometers
  • DL – Deciliter
  • DM – Decimeter
  • DR – Drum
  • DS – Display
  • DZ – Dozen
  • EA – Each
  • FO – Fluid Ounce
  • FT – Foot
  • GA – Gallon
  • GL – Gram/liter
  • GR – Gram
  • GS – Gross
  • H4 – Hectoliter
  • HF – Hundred Feet
  • HR – Hours
  • IN – Inch
  • K6 – Kiloliters
  • KG – Kilogram
  • KT – Kit
  • LB – Pounds
  • LF – Linear Foot
  • LO – Lot (unit of procurement)
  • LT – Liter
  • LY – Linear Yard
  • MC – Microgram
  • ME – Milligram
  • ML – Milliliter
  • MM – Millimeter
  • MO – Months
  • MR – Meter
  • OZ – Ounces
  • PC – Piece
  • PF – Pallet
  • PK – Package
  • PR – Pair
  • PT – Pint
  • QT – Quart
  • RL – Roll
  • SC – Square Centimeter
  • SF – Square Foot
  • SH – Sheet
  • SI – Square Inch
  • SM – Square Meter
  • ST – Set
  • SY – Square Yard
  • T3 – Thousand Pieces
  • TB – Tube
  • TH – Thousand
  • TY – Tray
  • U2 – Tablet
  • UM – Million
  • UN – Unit
  • V2 – Pouch
  • VI – Vial
  • WK – Week
  • YD – Yard
  • YR – Years
 UN
        UIT02 0…1 1/17 Item unit price. 12.10
        UIT03 0…1 2/2

Code identifying the type of unit price.

Valid values :

  • CT - Price according to the contract

  • WH - Wholesale price

  • DI - Distributor price

  • NT - Net price

  • RS - Resale price

  • DR - Dealer price

  • DS - Discount price

  • CA - Catalog price

CT
    AMT 0…12 - Line item monetary amount. -
        AMT01 1…1 1/3

Required. Qualifier code defining amount for.

Valid values:

  • 1 - Line item total

  • CC - Chargeback Claim Amount

  • CM - Claimant Requested Total

  • NA - Net Adjustment

  • S - Submitted Chargeback Claim Amount

  • TP - Total Payment

  • Z3 - Unit Cost of Discrepant Material

1
        AMT02 1…1 1/18 Required. Monetary amount. 275.36
        AMT03 0…1 1/1

Credit or debit flag code indicating whether the amount is a credit or a debit.

Valid values:

  • C - Credit

  • D - Debit

D
    ITA 0…10 - Allowances and charges -
        ITA01 1…1 1/1

Required. Allowance or charge indicator.

Valid values:

  • P - Pramotion

  • A - Allowance

  • C - Charge

P
        ITA04 1…1 2/2 Required. Allowance or charge method of handling code.Valid value is 02 - Offinvoice 02
        ITA06 0…1 1/15 Allowance or charge percent rate. 10.00
        ITA07 0…1 1/17 Allowance or charge total amount (Implicit decimal). 12.00
    REF 0…20 - REF reference segment loop for invoice number reference in PTD-QTY loop group. -
        REF01 1…1 2/3

Required. Reference identification qualifier for the contract number.

Valid values:

  • LT - Lot number

  • 8V - Credit reference number

  • DI - Distributor invoice number

  • RY - Rebate reference number

  • ZZ - Mutually defined number

  • IX - Item number

  • PE - Plant number

  • LI - Line item number

8V
        REF02 0…1 1/80 Reference identifier value. 4500018486
        REF03 0…1 1/80 A free-form description to clarify the related data elements and their content. Description defined by qualifier code in transactionReferenceIdentifier (REF02). Acute Care
    DTM 0…10 - DTM date segment in PTD-QTY loop group 120. -
        DTM01 1…1 3/3

Required. Date type qualifier for contract dates in PTD-QTY-DTM loop.

Valid values:

  • 003 - Invoice

  • 188 - Credit advice date

  • 514 - Quantity transfer date

  • 004 - Purchase order date

  • 011- Shipped date

'514
        DTM02 0…1 8/8 Contract date in date format YYYYMMDD. 20240628
        DTM03 0…1 4/8 Contract time in time format HHMMSS. 123422
    LX 0…* - LX group to capture serial numbers of products. -
      LX01 1…1 1/6 Required. Assigned Number, line item unique number for each serial number, this will get incremented for each LX iteration. This will get reset to 1 for each iteration of productTransferQuantityDetails array. 1
      REF 0…* - REF reference segment loop for each product serial number, mostly it will be one iteration. -
          REF01 1…1 2/3 Required. Reference identification qualifier for the contract number. Valid values is SE - Serial number SE
          REF02 0…1 1/80 Reference identifier value. 45123
  CTT 1…1 - Required. CTT-Transaction Totals -
    CTT01 1…1 1/6 Required. Total number of line items in the transaction set. 15
    CTT02 0…1 1/10 Sum of Total number of quantities in transaction. 10
  AMT 0…12 - Summary monetary amount. -
      AMT01 1…1 1/3

Required. Qualifier code defining amount for.

Valid values:

  • CC - Chargeback Claim Amount

  • NA - Net Adjustment

  • S - Submitted Chargeback Claim Amount

  • TP - Total Payment

  • TS - Total sales

  • TT - Total transaction amount

TP
      AMT02 1…1 1/18 Required. Monetary amount. 275.36
      AMT03 0…1 1/1

Credit or debit flag code indicating whether the amount is a credit or a debit.

Valid values:

  • C - Credit

  • D - Debit

D
SE 1…1 - Required. ST … SE transaction set trailer envelope. Child of GS group. Only one ST transaction expected. -
  SE01 1…1 1/10 Required. Total count of segments in ST … SE transaction set including ST and SE segments. 10
  SE02 1…1 4/9 Required. Transaction set control number. 0001
GE 1…1 - Required. GS … GE functional group trailer envelope. Child of ISA interchange. Only one GS group expected. -
  GE01 1…1 1/6 Required. Number of transaction sets in functional group. 5
  GE02 1…1 1/9 Required. Functional group control number. 619827
IEA 1…1 - Required. ISA … IEA interchange control trailer envelope. Only one interchange expected per transmission. -
  IEA01 1…1 1/5 Required. Number of functional groups in interchange. 1
  IEA02 1…1 9/9 Required. Interchange control number. 0000000000619827
Review TraceLink's API: Terms of Use

Table of contents