EDI 867 Product Transfer and Resale Report

Functional Group PT

X12M Supply Chain Subcommittee

This Draft Standard for Trial Use contains 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) report information about product that has been transferred from one location to another; (2) report sales of product from one or more locations to an end customer; or (3) report sales of a product from one or more locations to an end customer, and demand beyond actual sales (lost orders). Report may be issued by either buyer or seller.

Heading

1. 0100 · ST · Transaction Set Header · Max 1 · Mandatory

   To indicate the start of a transaction set and to assign a control number

2. 0200 · BPT · Beginning Segment for Product Transfer and Resale · Max 1 · Mandatory

   To indicate the beginning of the Product Transfer and Resale Report Transaction Set and transmit identifying data

3. 0400 · CUR · Currency · Max 1 · Optional

   To specify the currency (dollars, pounds, francs, etc.) used in a transaction

4. 0500 · DTM · Date/Time Reference · Max 10 · Optional

   To specify pertinent dates and times

5. 0600 · REF · Reference Identification · Max 12 · Optional

   To specify identifying information

6. 0700 · PER · Administrative Communications Contact · Max 3 · Optional

   To identify a person or office to whom administrative communications should be directed

7. 0750 · MEA · Measurements · Max 20 · Optional

   To specify physical measurements or counts, including dimensions, tolerances, variances, and weights (See Figures Appendix for example of use of C001)

8. 0780 · PSA · Partner Share Accounting · Max 10 · Optional

   To communicate the percentage share of the project that a particular owner has to pay

9. N1 Loop Optional Repeat 5

   1. 0800 · N1 · Name · Max 1 · Mandatory

      To identify a party by type of organization, name, and code

   2. 0900 · N2 · Additional Name Information · Max 2 · Optional

      To specify additional names

   3. 1000 · N3 · Address Information · Max 2 · Optional

      To specify the location of the named party

   4. 1100 · N4 · Geographic Location · Max 1 · Optional

      To specify the geographic place of the named party

   5. 1200 · REF · Reference Identification · Max 12 · Optional

      To specify identifying information

   6. PER Loop Optional Repeat >1

      1. 1300 · PER · Administrative Communications Contact · Max 1 · Mandatory

         To identify a person or office to whom administrative communications should be directed

      2. 1350 · REF · Reference Identification · Max >1 · Optional

         To specify identifying information

10. LM Loop Optional Repeat >1

    1. 1400 · LM · Code Source Information · Max 1 · Mandatory

       To transmit standard code list identification information

    2. 1500 · LQ · Industry Code · Max 100 · Mandatory

       Code to transmit standard industry codes

Detail

1. PTD Loop Mandatory Repeat >1

   1. 0100 · PTD · Product Transfer and Resale Detail · Max 1 · Mandatory

      To indicate the start of detail information relating to the transfer/resale of a product and provide identifying data

   2. 0200 · DTM · Date/Time Reference · Max 10 · Optional

      To specify pertinent dates and times

   3. 0300 · REF · Reference Identification · Max 20 · Optional

      To specify identifying information

   4. 0350 · PRF · Purchase Order Reference · Max 1 · Optional

      To provide reference to a specific purchase order

   5. 0400 · PER · Administrative Communications Contact · Max 3 · Optional

      To identify a person or office to whom administrative communications should be directed

   6. 0450 · MAN · Marks and Numbers · Max 1 · Optional

      To indicate identifying marks and numbers for shipping containers

   7. N1 Loop Optional Repeat 5

      1. 0500 · N1 · Name · Max 1 · Mandatory

         To identify a party by type of organization, name, and code

      2. 0600 · N2 · Additional Name Information · Max 2 · Optional

         To specify additional names

      3. 0700 · N3 · Address Information · Max 2 · Optional

         To specify the location of the named party

      4. 0800 · N4 · Geographic Location · Max 1 · Optional

         To specify the geographic place of the named party

      5. 0900 · REF · Reference Identification · Max 20 · Optional

         To specify identifying information

      6. 1000 · PER · Administrative Communications Contact · Max 3 · Optional

         To identify a person or office to whom administrative communications should be directed

      7. SII Loop Optional Repeat >1

         1. 1050 · SII · Sales Item Information · Max 1 · Mandatory

            To specify line item information related to a sale of an item

         2. 1070 · N9 · Reference Identification · Max 1 · Optional

            To transmit identifying information as specified by the Reference Identification Qualifier

   8. QTY Loop Optional Repeat >1

      1. 1100 · QTY · Quantity · Max 1 · Mandatory

         To specify quantity information

      2. 1200 · LIN · Item Identification · Max 1 · Optional

         To specify basic item identification data

      3. 1220 · PO3 · Additional Item Detail · Max 25 · Optional

         To specify additional item-related data involving variations in normal price/quantity structure

      4. 1250 · PO4 · Item Physical Details · Max 1 · Optional

         To specify the physical qualities, packaging, weights, and dimensions relating to the item

      5. 1300 · UIT · Unit Detail · Max 12 · Optional

         To specify item unit data

      6. 1400 · AMT · Monetary Amount · Max 12 · Optional

         To indicate the total monetary amount

      7. 1410 · ITA · Allowance, Charge or Service · Max 10 · Optional

         To specify allowances, charges, or services

      8. 1500 · PID · Product/Item Description · Max 200 · Optional

         To describe a product or process in coded or free-form format

      9. 1600 · MEA · Measurements · Max 40 · Optional

         To specify physical measurements or counts, including dimensions, tolerances, variances, and weights (See Figures Appendix for example of use of C001)

      10. 1700 · PWK · Paperwork · Max 25 · Optional

          To identify the type or transmission or both of paperwork or supporting information

      11. 1800 · PKG · Marking, Packaging, Loading · Max 25 · Optional

          To describe marking, packaging, loading, and unloading requirements

      12. 1900 · REF · Reference Identification · Max >1 · Optional

          To specify identifying information

      13. 2000 · PER · Administrative Communications Contact · Max 3 · Optional

          To identify a person or office to whom administrative communications should be directed

      14. 2100 · DTM · Date/Time Reference · Max 10 · Optional

          To specify pertinent dates and times

      15. 2200 · CUR · Currency · Max 1 · Optional

          To specify the currency (dollars, pounds, francs, etc.) used in a transaction

      16. 2400 · DD · Demand Detail · Max >1 · Optional

          To describe the type of demand and the intended use of material

      17. 2500 · LDT · Lead Time · Max 1 · Optional

          To specify lead time for availability of products and services

      18. LM Loop Optional Repeat >1

          1. 2600 · LM · Code Source Information · Max 1 · Mandatory

             To transmit standard code list identification information

          2. 2700 · LQ · Industry Code · Max 100 · Optional

             Code to transmit standard industry codes

      19. LX Loop Optional Repeat >1

          1. 2800 · LX · Assigned Number · Max 1 · Mandatory

             To reference a line number in a transaction set

             The LX loop conveys serial number, lot number, and inventory data.

          2. 2900 · REF · Reference Identification · Max >1 · Optional

             To specify identifying information

          3. 3000 · DTM · Date/Time Reference · Max 1 · Optional

             To specify pertinent dates and times

          4. 3100 · N1 · Name · Max 1 · Optional

             To identify a party by type of organization, name, and code

          5. LM Loop Optional Repeat >1

             1. 3200 · LM · Code Source Information · Max 1 · Mandatory

                To transmit standard code list identification information

             2. 3300 · LQ · Industry Code · Max 100 · Mandatory

                Code to transmit standard industry codes

      20. FA1 Loop Optional Repeat >1

          1. 3400 · FA1 · Type of Financial Accounting Data · Max 1 · Mandatory

             To specify the organization controlling the content of the accounting citation, and the purpose associated with the accounting citation

          2. 3500 · FA2 · Accounting Data · Max >1 · Mandatory

             To specify the detailed accounting data

Summary

1. CTT Loop Optional Repeat 1

   1. 0100 · CTT · Transaction Totals · Max 1 · Mandatory

      To transmit a hash total for a specific element in the transaction set

      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.

   2. 0200 · AMT · Monetary Amount · Max 12 · Optional

      To indicate the total monetary amount

   3. 0210 · ITA · Allowance, Charge or Service · Max 10 · Optional

      To specify allowances, charges, or services

2. 0300 · SE · Transaction Set Trailer · Max 1 · Mandatory

   To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)