EDI 852 Product Activity Data

Functional Group PD

X12M Supply Chain Subcommittee

This standard provides the format and establishes the data contents of the Product Activity Data Transaction Set within the context of an Electronic Data Interchange (EDI) environment. This transaction set allows 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 Number · Max >1 · Optional

   To transmit identifying numbers and descriptive information as specified by the reference number 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, sequence of routing and to provide transit time information

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

      To specify pertinent dates and times

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

      To transmit identifying numbers and descriptive information as specified by the reference number 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 Mandatory Repeat >1

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

      To specify basic item identification data.

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

      To specify pricing information

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

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

   4. ZA Loop Mandatory Repeat 99

      1. 180 · 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, but not in both.

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

         To specify pricing information

      3. 200 · SDQ · Destination Quantity · Max >1 · Optional

         To specify destination and quantity detail.

Summary

1. 210 · 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. Hash total (CTT02) is not used in this transaction set.

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