867 Product Transfer and Resale Report

Document Sample
867 Product Transfer and Resale Report Powered By Docstoc
					National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC
NDC Document Version 1.2
March 01, 2006
EDI Standard: ANSI X12 4010
                                                                             Functional Group ID=    PT


Purpose:
The purpose of this document is to specify the format and establishes the data contents of the Product
Transfer and Resale Report Transaction Set (867) for use within the context of an Electronic Data
Interchange (EDI) environment. The transaction set can be used to:
     1) Submit rebate claims to NDC for sales made by NDC’s member distributors of manufacturer
         products.
     2) Submit sales tracings for manufacturer and GPO contract business.



Notes:

This document is based on the HBICC Standard 867 Example 1 dated February 10, 2004 available at
http://hibcc.org/EBUS/editemplates/867ex1.doc Only minimal modification or extensions have been made to
support the requirements of NDC.




                                                Page 1                                                   1
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC
Heading:
          Pos.   Seg.                                                Req.              Loop         Notes and
          No.    ID     Name                                         Des.   Max.Use   Repeat       Comments

M         010    ST     Transaction Set Header                       M            1
M         020    BPT    Beginning Segment for Product Transfer and   M            1
                        Resale
          050    DTM    Date/Time Reference                          M            2
                        LOOP ID - N1                                                       >1
          080    N1     Name                                         M            1




Detail:
          Pos.   Seg.                                                Req.              Loop         Notes and
          No.    ID     Name                                         Des.   Max.Use   Repeat       Comments

                        LOOP ID - PTD                                                      >1
M         010    PTD    Product Transfer and Resale Detail           M            1
                        LOOP ID - N1                                                           2
          050    N1     Name                                         M            1
          070    N3     Address Information                          O            1
          080    N4     Geographic Location                          O            1


                        LOOP ID - QTY                                                      >1
          110    QTY    Quantity                                     M            1
          120    LIN    Item Identification                          M            1
          130    UIT    Unit Detail                                  M            3
          140    AMT    Monetary Amount                              O            1
          150    PID    Product/Item Description                     M            1
          190    REF    Reference Identification                     M            1
          210    DTM    Date/Time Reference                          O            2


Summary:
          Pos.   Seg.                                                Req.              Loop         Notes and
          No.    ID     Name                                         Des.   Max.Use   Repeat       Comments

                        LOOP ID - CTT                                                          1
          010    CTT    Transaction Totals                           O            1
          020    AMT    Monetary Amount                              O            1

M         030    SE     Transaction Set Trailer                      M            1




Transaction Set Notes
1.   The number of line items (CTT01) is the accumulation of the number of LIN segments. If used, hash
     total (CTT02) is the sum of the value of quantities (QTY02) for each QTY segment.



                                                   Page 2                                                  2
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC

          Segment:          ST Transaction Set Header
          Position:         010
             Loop:
             Level:         Heading
            Usage:          Mandatory
          Max Use:          1
          Purpose:          To indicate the start of a transaction set and to assign a control number
      Syntax Notes:
    Semantic Notes:         1     The transaction set identifier (ST01) is used by the translation routines of
                                  the interchange partners to select the appropriate transaction set definition
                                  (e.g., 810 selects the Invoice Transaction Set).
            Comments:

                                           Data Element Summary

Ref.        Name                                                                                Use     Attributes
Des.
ST01        Transaction Set Identifier Code                                                     M
            Code uniquely identifying a Transaction Set
            867          Product Transfer and Resale Report
ST02        Transaction Set Control Number                                                      M
            Identifying control number that must be unique within the transaction set
            functional group assigned by the originator for a transaction set


             Segment:       BPT Beginning Segment for Product Transfer and Resale
             Position:      020
                Loop:
                Level:      Heading
               Usage:       Mandatory
             Max Use:       1
             Purpose:       To indicate the beginning of the Product Transfer and Resale Report Transaction
                            Set and transmit identifying data
      Syntax Notes:         1 If either BPT05 or BPT06 is present, then the other is required.
    Semantic Notes:         1 BPT02 identifies the transfer/resale number.
                            2 BPT03 identifies the transfer/resale date.
            Comments:

                                           Data Element Summary

Ref. Des.     Name                                                                              Use     Attributes
BPT01         Transaction Set Purpose Code                                                      M       ID 2/2
              Code identifying purpose of transaction set
              00           Original
BPT02         Reference Identification                                                          M       AN 1/30
              Debit Memo Number
BPT03         Date                                                                              M       DT 8/8
              Date expressed as CCYYMMDD
BPT04         Report Type Code                                                                  O       ID 2/2
              Code indicating the title or contents of a document, report or supporting
              item
              SS            Seller Sales Report


                                                   Page 3                                                         3
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC


           Segment:       DTM Date/Time Reference
           Position:      050
              Loop:
              Level:      Heading
             Usage:       Optional
           Max Use:       2
           Purpose:       To specify pertinent dates and times
       Syntax Notes:      1 At least one of DTM02 DTM03 or DTM05 is required.
                          2 If DTM04 is present, then DTM03 is required.
                          3 If either DTM05 or DTM06 is present, then the other is required.
    Semantic Notes:
       Comments:

                                        Data Element Summary

Ref. Des.   Name                                                                       Use     Attributes
DTM0        Date/Time Qualifier                                                        M
   1        Code specifying type of date or time, or both date and time
            090          Report Start                                                  M
            091          Report End                                                    M
DTM0        Date                                                                       X
  2         Date expressed as CCYYMMDD




                                               Page 4                                                 4
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC

            Segment:      N1 Name
            Position:     080
               Loop:      N1
               Level:     Heading
              Usage:      Mandatory
            Max Use:      1
            Purpose:      To identify a party by type of organization, name, and code
        Syntax Notes:     1 At least one of N102 or N103 is required.
                          2 If either N103 or N104 is present, then the other is required.
    Semantic Notes:
       Comments:          One N1 segments will always be used.
                          1) One with N101=DB which contains the distributor’s identifying
                          2) An N1 segment with N101=MF, which contains the manufacturer’s
                              identifying information, is optional.



                                         Data Element Summary

Ref. Des.   Name                                                                          Use    Attributes
 N101       Entity Identifier Code                                                        M        ID 2/3
            Code identifying an organizational entity, a physical location, property or
            an individual.
            DB             Distributor Branch                                             M
            MF             Manufacturer of Goods                                          M
 N102       Name                                                                          X       AN 1/60
            Free-form name
            Example: NATIONAL DISTRIBUTION & CONTRACTING, INC.
 N103       Identification Code Qualifier                                                          ID 1/2
            Code designating the system/method of code structure used for
            Identification Code.
            91              Assigned by Seller or Seller's Agent
 N104       Identification Code                                                              X    AN 2/80
            Three letter code assigned by NDC to identify the distributor




                                                Page 5                                                  5
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC

            Segment:      PTD Product Transfer and Resale Detail
            Position:     010
               Loop:      PTD      Mandatory
               Level:     Detail
              Usage:      Mandatory
            Max Use:      1
            Purpose:      To indicate the start of detail information relating to the transfer/resale of a
                          product and provide identifying data
       Syntax Notes:      1 If either PTD02 or PTD03 is present, then the other is required.
                          2 If either PTD04 or PTD05 is present, then the other is required.
    Semantic Notes:
       Comments:          The qualifier used in the PTD04 is the distributor’s choice.


                                         Data Element Summary

Ref. Des.   Name                                                                              Use    Attributes
PTD01       Product Transfer Type Code                                                        M        ID 2/2
            Code identifying the type of product transfer
            SS              Stock Sale
PTD04       Reference ID Qualifier                                                            M         ID 2/3
            Code qualifying the Reference Identification
            CT              Vendor Contract Number
            VC               Vendor Contract Number
PTD05       Reference ID                                                                      M        AN 1/30
            Reference information as defined for a particular Transaction Set or as
            specified by the Reference Identification Qualifier.
            Contract Number




                                                Page 6                                                       6
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC

            Segment:      N1 Name
            Position:     050
               Loop:      N1
               Level:     Detail
              Usage:      Mandatory
            Max Use:      1
            Purpose:      To identify a party by type of organization, name, and code
        Syntax Notes:     1 At least one of N102 or N103 is required.
                          2 If either N103 or N104 is present, then the other is required.
    Semantic Notes:
       Comments:          1   Use your customer number for BT and ST.


                                         Data Element Summary

Ref. Des.   Name                                                                          Use    Attributes
 N101       Entity Identifier Code                                                        M        ID 2/3
            Code identifying an organizational entity, a physical location, property or
            an individual.
            ST              Ship-to                                                       M
            BT              Bill-to                                                       M
 N102       Name                                                                          X       AN 1/60
            Free-form name
 N103       Identification Code Qualifier                                                    X     ID 1/2
            Code designating the system/method of code structure used for
            Identification Code.
            92              Assigned by Buyer or Buyer's Agent
 N104       Identification Code                                                              X    AN 2/80
            Code identifying a party or other code



          Segment:        N3 Address Information
          Position:       070
             Loop:        N1
             Level:       Detail
            Usage:        Optional
          Max Use:        1
          Purpose:        To specify the location of the named party
      Syntax Notes:
    Semantic Notes:
        Comments:


                                         Data Element Summary

Ref. Des.   Name                                                                          Use    Attributes
 N301       Address Information                                                           M       AN 1/55
            Address information
 N302       Address Information                                                              O    AN 1/55
            Address information



                                                Page 7                                                  7
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC


          Segment:        N4 Geographic Location
          Position:       080
             Loop:        N1
             Level:       Detail
            Usage:        Optional
          Max Use:        1
          Purpose:        To specify the geographic place of the named party
      Syntax Notes:       1 If N406 is present, then N405 is required.
    Semantic Notes:
        Comments:         1   A combination of either N401 through N404, or N405 and N406 may be
                              adequate to specify a location.
                          2   N402 is required only if city name (N401) is in the U.S. or Canada.


                                       Data Element Summary

Ref. Des.   Name                                                                     Use   Attributes
 N401       City Name                                                                M      AN 1/55
            Free-form text for city name
 N402       State or Province Code                                                   M      AN 1/55
            Code (Standard State/Province) as defined by appropriate government
            agency
 N403       Postal Code                                                              O       ID 3/15
            Code defining international postal zone code excluding punctuation and
            blanks (zip code for United States)




                                              Page 8                                                8
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC

           Segment:       QTY Quantity
           Position:      110
              Loop:       QTY
              Level:      Detail
             Usage:       Mandatory
           Max Use:       1
           Purpose:       To specify quantity information
       Syntax Notes:      1 At least one of QTY02 or QTY04 is required.
                          2 Only one of QTY02 or QTY04 may be present.
    Semantic Notes:
       Comments:


                                         Data Element Summary
Ref. Des.   Name                                                                       Use   Attributes
QTY01       Quantity Qualifier                                                         M       ID 2/2
            Code specifying the type of quantity
            32             Quantity Sold
QTY02       Quantity                                                                   X       R 1/15
            Numeric value of quantity
QTY03       Composite Unit of Measure                                                  O
            To identify a composite unit of measure (See Figures Appendix for
            examples of use)
C00101      Unit or Basis for Measurement Code                                         M       ID 2/2
            Code specifying the units in which a value is being expressed, or manner
            in which a measurement has been taken




                                               Page 9                                               9
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC

          Segment:        LIN Item Identification
          Position:       120
             Loop:        QTY
             Level:       Detail
            Usage:        Mandatory
          Max Use:        1
          Purpose:        To specify basic item identification data
      Syntax Notes:
    Semantic Notes:       1   LIN01 is the line item identification
        Comments:         1   See the Data Dictionary for a complete list of IDs.
                          2   LIN02 through LIN31 provide for fifteen different product/service IDs for
                              each item.

                                        Data Element Summary

Ref. Des.   Name                                                                        Use    Attributes
LIN01       Assigned Identification                                                     O       AN 1/20
            Alphanumeric characters assigned for differentiation within a transaction
            set
LIN02       Product/Service ID Qualifier                                                M        ID 2/2
            Code identifying the type/source of the descriptive number used in
            Product/Service ID
            F1             Distributor’s Product ID
LIN03       Product/Service ID                                                          M       AN 1/48
            Identifying number for a product or service
LIN04       Product/Service ID Qualifier                                                M        ID 2/2
            Code identifying the type/source of the descriptive number used in
            Product/Service ID
            MG             Manufacturer's Item Number
LIN05       Product/Service ID                                                          M       AN 1/48
            Identifying number for a product or service
LIN06       Product/Service ID Qualifier                                                M        ID 2/2
            Code identifying the type/source of the descriptive number used in
            Product/Service ID
            ZZ
LIN07       Product/Service ID                                                          M       AN 1/48
            Manufacturer Name
LIN08       Product/Service ID Qualifier                                                 O       ID 2/2
            Code identifying the type/source of the descriptive number used in
            Product/Service ID
            VC            NDC’s Warehouse Item Number
LIN09       Product/Service ID                                                           O      AN 1/48
            Identifying number for a product or service
LIN10       Product/Service ID Qualifier                                                 O       ID 2/2
            Code identifying the type/source of the descriptive number used in
            Product/Service ID
            ND            National Drug Code
LIN11       Product/Service ID                                                           O      AN 1/48
            Identifying number for a product or service
LIN12       Product/Service ID Qualifier                                                 O       ID 2/2
            Code identifying the type/source of the descriptive number used in
            Product/Service ID



                                               Page 10                                                10
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC
            MF            Distributor’s Vendor ID
LIN13       Product/Service ID                                                         O      AN 1/48
            Identifying number for a product or service
LIN14       Product/Service ID Qualifier                                               O       ID 2/2
            Code identifying the type/source of the descriptive number used in
            Product/Service ID
            UP            UPC/UPN number
LIN15       Product/Service ID                                                         O      AN 1/48
            Identifying number for a product or service




          Segment:        UIT Unit Detail
          Position:       130
             Loop:        QTY
             Level:       Detail
            Usage:        Mandatory
          Max Use:        3
          Purpose:        To specify item unit data
      Syntax Notes:       1 If UIT03 is present, then UIT02 is required.
    Semantic Notes:
        Comments:         Two UIT segments with UIT03=CT and UIT03=DI are required for rebate
                             claims. One UIT segment with UIT03=RS is required for sales
                             tracings. All three may be sent together.

                                        Data Element Summary

Ref. Des.   Name                                                                       Use   Attributes
UIT01       Composite Unit of Measure                                                  M
            To identify a composite unit of measure
C00101      Unit or Basis for Measurement Code                                         M       ID 2/2
            Code specifying the units in which a value is being expressed, or manner
            in which a measurement has been taken
UIT02       Unit Price                                                                 M       R 1/17
            Price per unit of product, service, commodity, etc
UIT03       Basis of Unit Price Code                                                   M       ID 2/2
            Code identifying the type of unit price for an item
            CT           Contract Cost                                                 M
            DI           Distributor Acquisition Cost                                  M
            RS           Distributor Resale Price                                      O




                                              Page 11                                              11
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC

          Segment:       AMT Monetary Amount
          Position:      140
             Loop:       QTY
             Level:      Detail
            Usage:       Optional
          Max Use:       1
          Purpose:       To indicate the total monetary amount
      Syntax Notes:
    Semantic Notes:
        Comments:        This is the difference between contract cost and distributor acquisition cost
                         multiplied by the quantity.
                         The qualifier used in the AMT01 is the Distributor’s choice




                                       Data Element Summary

Ref. Des.    Name                                                                     Use    Attributes
AMT01        Amount Qualifier Code                                                    M        ID 1/3
             CC            Chargeback (Rebate) Claim Amount
             S             Chargeback (Rebate) Claim Amount
AMT02        Monetary Amount                                                           X       R 1/18
             Total extended line item chargeback(rebate) requested




           Segment:      PID Product/Item Description
            Position:    150
              Loop:      QTY
              Level:     Detail
              Usage:     Mandatory
           Max Use:      1
           Purpose:
       Syntax Notes:     1 If PID04 is present, then PID03 is required
                         2 At least one of PID04 or PID05 is required.
    Semantic Notes:
       Comments:


                                       Data Element Summary

Ref. Des.    Name                                                                     Use    Attributes
 PTD01       Amount Qualifier Code                                                    M        ID 1/1
             F            Free-form text
PTD05        Description                                                               X      AN 1/60
             A free-form description of the product




                                              Page 12                                               12
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC



          Segment:          REF Reference Identification
          Position:         190
             Loop:          QTY
             Level:         Detail
            Usage:          Mandatory
          Max Use:          1
          Purpose:          To specify identifying information
      Syntax Notes:         1 At least one of REF02 or REF03 is required.
    Semantic Notes:
        Comments:

                                          Data Element Summary

Ref. Des.     Name                                                                   Use   Attributes
REF01         Reference Identification Qualifier                                     M       ID 2/3
              Code qualifying the Reference Identification
              DI              Distributor Invoice Number                             M
REF02         Reference Identification                                               X      AN 1/20
              Distributor Invoice Number




          Segment:          DTM Date/Time Reference
          Position:         210
             Loop:          QTY
             Level:         Detail
            Usage:          Optional
          Max Use:          2
          Purpose:          To specify pertinent dates and times
      Syntax Notes:         1 At least one of DTM02 DTM03 or DTM05 is required.
    Semantic Notes:
        Comments:           DTM01=003 is always included with the distributor’s invoice date.
                              DTM01=004 is sent when available and may identify a sale that was
                              ordered within the contract period, but due to backorder may not have
                              been invoiced within the contract period.

                                          Data Element Summary

Ref.        Name                                                                     Use   Attributes
Des.
DTM         Date/Time Qualifier                                                      M       ID 2/3
 01         Code specifying type of date or time, or both date and time
            003          Invoice Date                                                M
            004          Order Date                                                  O
DTM         Date                                                                     X      AN 1/30
 02         Date expressed as CCYYMMDD




                                                 Page 13                                         13
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC


          Segment:           CTT Transaction Totals
          Position:          010
             Loop:           CTT      Optional
             Level:          Summary
            Usage:           Optional
          Max Use:           1
          Purpose:           To transmit a hash total for a specific element in the transaction set
      Syntax Notes:
    Semantic Notes:
        Comments:            1   This segment is intended to provide hash totals to validate transaction
                                 completeness and correctness.


                                           Data Element Summary

Ref.        Name                                                                                Use   Attributes
Des.
CTT         Number of Line Items                                                                M       N0 1/6
 01         Total number of line items in the transaction set




          Segment:           AMT Monetary Amount
          Position:          020
             Loop:           CTT      Optional
             Level:          Detail
            Usage:           Optional
          Max Use:           1
          Purpose:           To indicate the total monetary amount
      Syntax Notes:
    Semantic Notes:
        Comments:            This segment will contain the total of line item AMT02 amounts.

                            The qualifier used in the AMT01 is the distributor’s choice



                                           Data Element Summary

Ref. Des.     Name                                                                              Use   Attributes
AMT0          Amount Qualifier Code                                                             M       ID 1/3
   1          CC          Chargeback (Rebate) Claim Amount
              S           Chargeback (Rebate) Claim Amount
AMT0          Monetary Amount                                                                   X       R 1/18
 2            Monetary amount




                                                  Page 14                                                   14
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC


            Segment:      SE Transaction Set Trailer
            Position:     030
               Loop:
               Level:     Summary
              Usage:      Mandatory
            Max Use:      1
            Purpose:      To indicate the end of the transaction set and provide the count of the
                          transmitted segments (including the beginning (ST) and ending (SE) segments)
      Syntax Notes:
    Semantic Notes:
        Comments:         1     SE is the last segment of each transaction set.


                                         Data Element Summary

Ref. Des.   Name                                                                        Use   Attributes
 SE01       Number of Included Segments                                                 M      N0 1/10
            Total number of segments included in a transaction set including ST and
            SE segments
 SE02       Transaction Set Control Number                                              M       AN 4/9
            Identifying control number that must be unique within the transaction set
            functional group assigned by the originator for a transaction set




                                                Page 15                                             15
National Distribution and Contracting, Inc.
867 Product Transfer and Resale Report
For Filing Rebate Claims with NDC
Example of 867 Rebate Document
Note that segments will not be unwrapped in the actual document.

ISA^00^           ^00^         ^12^8778535294     ^ZZ^1234567890
^050927^0950^U^00400^000000011^0^P^>~
GS^PT^8778535294^1234567890^20050927^0950^11^X^004010~
ST^867^0001~
BPT^00^NDC123^20050825~
DTM^090^20050529~
DTM^091^20050625~
N1^DB^ABC MEDICAL DISTRIBUTOR^91^123456789~
PTD^SS^^^CT^102030~
N1^ST^FAMILY PRACTICE LOCATION 02^92^003272302~
N3^123 BROADWAY~
N4^NASHVILLE^TN^37216~
N1^BT^FAMILY PRACTICE^92^0032723~
N3^987 MAIN ST.^SUITE 101~
N4^NASHVILLE^TN^37217~
QTY^32^150^BX~
LIN^^F1^ABC0123^MG^XYZ0123^ZZ^XYZ MANUFACTURING^VC^NDC0123~
UIT^BX^3.00^CT~
UIT^BX^4.00^DI~
AMT^CC^150.00~
REF^DI^ABC1234~
DTM^003^20050607~
DTM^004^20050606~
PTD^SS^^^CT^405060~
N1^ST^SURGICAL ASSOCIATES LLC^91^00317238~
N3^123 2ND AVE~
N4^LAS VEGAS^NV^89044~
QTY^32^3^BX~
LIN^^F1^ABC8910^MG^3218910^ZZ^321 INC^VC^NDC8910~
UIT^BX^21.00^CT~
UIT^BX^18.00^DI~
AMT^CC^9.00~
REF^DI^ABC1593~
DTM^003^20050607~
DTM^004^20050607~
CTT^2~
AMT^CC^159.00~
SE^35^0001~
GE^1^11~
IEA*1*000000011~




                                                   Page 16         16

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:8
posted:12/12/2011
language:
pages:16