EDI 852 Product Activity Data

Functional Group PD

X12M Supply Chain Subcommittee

This X12 Transaction Set contains the format and establishes the data contents of the Product Activity Data Transaction Set (852) for use within the context of an Electronic Data Interchange (EDI) environment. The transaction set can be used to advise a trading partner of inventory, sales, and other product activity information. Product activity data enables a trading partner to plan and ship, or propose inventory replenishment quantities, for distribution centers, warehouses or retail outlets. The receiver of the transaction set will maintain some type of inventory/product movement records for its trading partners to enable replenishment calculations based on data provided by the distributor, warehouse or retailer.

What is an EDI 852?

An EDI 852 Product Activity Data communicates sales-related information from a buyer to a supplier. It contains information about the reporting date (XQ segment), related purchase orders (XPO segment) and sell-through details (ZA segment).

How is an EDI 852 used?

For example, Retailer A will send Vendor B a daily EDI 852 Product Activity Data feed during the Q4 holiday season. This helps Vendor B know to manufacture a higher replenishment quantity for best-selling SKUs that would otherwise go out of stock.

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 · XQ · Reporting Date/Action · Max 1 · Mandatory

   To specify reporting dates, actions to be taken and an identifying number

3. 0300 · XPO · Preassigned Purchase Order Numbers · Max >1 · Optional

   To transmit preassigned purchase order numbers

4. 0400 · N9 · Extended Reference Information · Max >1 · Optional

   To transmit identifying information as specified by the Reference Identification Qualifier

5. 0450 · CUR · Currency · Max 1 · Optional

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

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

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

7. N1 Loop Optional Repeat 200

   1. 0600 · N1 · Party Identification · Max 1 · Mandatory

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

      The reporting location is required. The reporting location is specified explicitly in the N1 segment using the code RL in N101, or implicitly using the SDQ segment (Table 2) with the location data elements. They are mutually exclusive (the SDQ and the N1 with N101 containing RL).

   2. 0700 · N2 · Additional Name Information · Max 1 · Optional

      To specify additional names

   3. 0800 · N3 · Party Location · Max 2 · Optional

      To specify the location of the named party

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

      To specify the geographic place of the named party

   5. 1000 · FOB · F.O.B. Related Instructions · Max 1 · Optional

      To specify transportation instructions relating to shipment

   6. 1100 · TD5 · Carrier Details (Routing Sequence/Transit Time) · Max 1 · Optional

      To specify the carrier and sequence of routing and provide transit time information

   7. 1200 · DTM · Date/Time Reference · Max >1 · Optional

      To specify pertinent dates and times

   8. 1300 · N9 · Extended Reference Information · Max >1 · Optional

      To transmit identifying information as specified by the Reference Identification Qualifier

   9. 1400 · PER · Administrative Communications Contact · Max 3 · Optional

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

Detail

1. LIN Loop Optional Repeat 999999

   1. 0100 · LIN · Item Identification · Max 1 · Mandatory

      To specify basic item identification data

   2. 0200 · CTP · Pricing Information · Max 25 · Optional

      To specify pricing information

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

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

   4. 0250 · SAC · Service, Promotion, Allowance, or Charge Information · Max >1 · Optional

      To request or identify a service, promotion, allowance, or charge; to specify the amount or percentage for the service, promotion, allowance, or charge

   5. 0300 · PO4 · Item Physical Details · Max 1 · Optional

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

   6. 0400 · N9 · Extended Reference Information · Max >1 · Optional

      To transmit identifying information as specified by the Reference Identification Qualifier

   7. 0500 · AMT · Monetary Amount Information · Max 10 · Optional

      To indicate the total monetary amount

   8. 0600 · PAL · Pallet Type and Load Characteristics · Max 1 · Optional

      To identify the type and physical attributes of the pallet, and, gross weight, gross volume, and height of the load and the pallet

   9. 0700 · QTY · Quantity Information · Max >1 · Optional

      To specify quantity information

   10. ZA Loop Mandatory Repeat >1

       1. 0800 · ZA · Product Activity Reporting · Max 1 · Mandatory

          To provide activity details concerning product being reported

          The quantity for the item identified in the LIN segment is required. Quantity is specified either in the ZA segment (ZA02) or in the SDQ segment.

       2. 0900 · QTY · Quantity Information · Max >1 · Optional

          To specify quantity information

       3. 1000 · CTP · Pricing Information · Max 25 · Optional

          To specify pricing information

       4. 1100 · SDQ · Destination Quantity · Max >1 · Optional

          To specify destination and quantity detail

       5. G95 Loop Optional Repeat 1

          1. 1200 · G95 · Performance Requirements · Max 1 · Mandatory

             To specify the "AND" or "OR" condition for the option, or provide information related to the promotion performance conditions and allocations required, or both

          2. 1300 · DTM · Date/Time Reference · Max 2 · Optional

             To specify pertinent dates and times

Summary

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

   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. Hash total (CTT02) is not used in this transaction set.
   When sending item and activity data in the LIN loop, the CTT segment is required.

2. 0200 · 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)