852 Product Activity Data (Orchard Brands EDI Transaction)
852 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 852 Product Activity Data 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.
XQ Reporting Date/Action Segment
XQ02 is the reporting date. If reporting a date range, then XQ02 is the start date and XQ03 is the end date.
N9 Reference Identification Segment
- R0203 – At least one of N902 or N903 is required.
- C0605 – If N906 is present, then N905 is required.
- N906 reflects the time zone which the time reflects.
- N907 contains data relating to the value cited in N902.
LIN Item Identification Segment
- P0405 – If either LIN04 or LIN05 is present, then the other is required.
- P0607 – If either LIN06 or LIN07 is present, then the other is required.
- P0809 – If either LIN08 or LIN09 is present, then the other is required.
- P1011 – If either LIN10 or LIN11 is present, then the other is required.
- P1213 – If either LIN12 or LIN13 is present, then the other is required.
- P1415 – If either LIN14 or LIN15 is present, then the other is required.
- P1617 – If either LIN16 or LIN17 is present, then the other is required.
- P1819 – If either LIN18 or LIN19 is present, then the other is required.
- P2021 – If either LIN20 or LIN21 is present, then the other is required.
- P2223 – If either LIN22 or LIN23 is present, then the other is required.
- P2425 – If either LIN24 or LIN25 is present, then the other is required.
- P2627 – If either LIN26 or LIN27 is present, then the other is required.
- P2829 – If either LIN28 or LIN29 is present, then the other is required.
- P3031 – If either LIN30 or LIN31 is present, then the other is required.
- LIN01 is the line item identification
- LIN02 through LIN31 provide for fifteen different product/service IDs for each item. For example: Case, Color, Drawing No., U.P.C. No., ISBN No., Model No., or SKU.
CTP Pricing Information Segment
- P0405 – If either CTP04 or CTP05 is present, then the other is required.
- C0607 – If CTP06 is present, then CTP07 is required.
- C0902 – If CTP09 is present, then CTP02 is required.
- C1002 – If CTP10 is present, then CTP02 is required.
- C1103 – If CTP11 is present, then CTP03 is required.
- CTP07 is a multiplier factor to arrive at a final discounted price. A multiplier of .90 would be the factor if a 10% discount is given.
- CTP08 is the rebate amount.
ZA Product Activity Reporting Segment
ZA08 determines if the product activity code in ZA01 refers to a product that is categorized as In-bond merchandise. A “Y” indicates that the activity code applies to a product that is In-bond; an “N” indicates that the activity code does not refer to a product that is In-bond.
SDQ Destination Quantity Segment
- SDQ23 identifies the area within the location identified in SDQ03, SDQ05, SDQ07, SDQ09, SDQ11, SDQ13, SDQ15, SDQ17, SDQ19, and SDQ21.
- SDQ02 is used only if different than previously defined in the transaction set.
- SDQ03 is the store number.
- SDQ23 may be used to identify areas within a store, e.g., front room, back room, selling outpost, end aisle display, etc. The value is agreed to by trading partners or industry conventions.