EDI 852 Product Activity Data

Functional Group PD

X12M Supply Chain Subcommittee

This Draft Standard for Trial Use 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 by a distributor, warehouse, or retailer 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. 010 · ST · Transaction Set Header · Max 1 · Mandatory

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

2. 020 · XQ · Reporting Date/Action · Max 1 · Mandatory

   To specify reporting date and action to be taken

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

   To transmit preassigned purchase order numbers

4. 040 · N9 · Reference Identification · Max >1 · Optional

   To transmit identifying information as specified by the Reference Identification Qualifier

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

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

6. N1 Loop Optional Repeat 200

   1. 060 · N1 · Name · 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. 070 · N2 · Additional Name Information · Max 1 · Optional

      To specify additional names or those longer than 35 characters in length

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

      To specify the location of the named party

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

      To specify the geographic place of the named party

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

      To specify transportation instructions relating to shipment

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

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

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

      To specify pertinent dates and times

   8. 130 · N9 · Reference Identification · Max >1 · Optional

      To transmit identifying information as specified by the Reference Identification Qualifier

   9. 140 · 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. 010 · LIN · Item Identification · Max 1 · Mandatory

      To specify basic item identification data

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

      To specify pricing information

   3. 030 · PO4 · Item Physical Details · Max 1 · Optional

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

   4. 040 · N9 · Reference Identification · Max >1 · Optional

      To transmit identifying information as specified by the Reference Identification Qualifier

   5. 050 · AMT · Monetary Amount · Max 10 · Optional

      To indicate the total monetary amount

   6. 060 · PAL · Pallet Information · 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

   7. 070 · QTY · Quantity · Max 1 · Optional

      To specify quantity information

   8. ZA Loop Mandatory Repeat >1

      1. 080 · 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. 090 · QTY · Quantity · Max 1 · Optional

         To specify quantity information

         The QTY segment in the ZA loop is only used to provide the number of orders associated with the quantity in the ZA segment, or the total of quantities in the SDQ segments for the activity. The only allowable code value is OC = Order Count.

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

         To specify pricing information

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

         To specify destination and quantity detail

      5. G95 Loop Optional Repeat 1

         1. 120 · 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. 130 · DTM · Date/Time Reference · Max 2 · Optional

            To specify pertinent dates and times

Summary

1. 010 · 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. 020 · 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)