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

Position
Segment
Name
Max use
  1. To indicate the start of a transaction set and to assign a control number

  2. To specify reporting date and action to be taken

  3. To transmit preassigned purchase order numbers

  4. To transmit identifying information as specified by the Reference Identification Qualifier

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

  6. N1 Loop Optional
    Repeat 200
    1. 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. To specify additional names or those longer than 35 characters in length

    3. To specify the location of the named party

    4. To specify the geographic place of the named party

    5. To specify transportation instructions relating to shipment

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

    7. To specify pertinent dates and times

    8. To transmit identifying information as specified by the Reference Identification Qualifier

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

Detail

Position
Segment
Name
Max use
  1. LIN Loop Optional
    Repeat 999999
    1. To specify basic item identification data

    2. To specify pricing information

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

    4. To transmit identifying information as specified by the Reference Identification Qualifier

    5. To indicate the total monetary amount

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

    7. To specify quantity information

    8. ZA Loop Mandatory
      Repeat >1
      1. 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. 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. To specify pricing information

      4. To specify destination and quantity detail

      5. G95 Loop Optional
        Repeat 1
        1. 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. To specify pertinent dates and times

Summary

Position
Segment
Name
Max use
  1. 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. To indicate the end of the transaction set and provide the count of the transmitted segments (including the beginning (ST) and ending (SE) segments)

Stedi is a registered trademark of Stedi, Inc. Stedi's EDI Reference is provided for marketing purposes and is free of charge. All names, logos, and brands of third parties listed on our site are trademarks of their respective owners (including “X12”, which is a trademark of X12 Incorporated). Stedi, Inc. and its products and services are not endorsed by, sponsored by, or affiliated with these third parties. Our use of these names, logos, and brands is for identification purposes only, and does not imply any such endorsement, sponsorship, or affiliation.