ASC X12 Version: 008010 | Transaction Set: 852 | TR3 ID: 008010X369
852 — Product Activity Data
A pharmacy has transmitted an 852 Product Activity Data transaction to its manufacturer/trading partner, and is reporting on one product stocked at three locations. The pharmacy is providing data for quantity on-hand and total quantity sold.
Transmission Explanation
Table 1
ST*852*0001~
Indicates the start of a product activity data transaction set and assigns a control number of 0001.
XQ*H*20200601**INVRPT001*00~
This is a Seller Inventory Report (code H) as of June 1, 2020, with the unique identifier of INVRPT001, and is an original (code 00) transaction.
N9*HPI*NPI SELLER IDENTIFIER~
The Selling party is identified by an NPI Seller ID (code HPI).
PER*BL*HARRY SMITH*TE*800-555-1200*EM*HSMITH@PHARMACY.COM~
The technical contact (code BL) is Harry Smith, who may be reached at telephone number 800-555-1200 or email address hsmith@pharmacy.com.
Table 2
LIN*0001*ND*55111-0124-05~
The LIN Loop begins, and starts with the LIN segment, which identifies a product.
The LIN segment has an assigned identification number 0001. Code ND indicates that a National Drug Code follows (55111-0124-05). The following information is based as of the June 1, 2020 report date (from the XQ segment).
CTP**RTL*12.57~
The seller has decided to include the product’s retail (code RTL) price, which is $12.57.
ZA loop #1 – Quantity On-Hand
ZA*OH*500*EA~
The first ZA Loop begins, subordinate to the LIN Loop, and is reporting the Gross Quantity On-Hand (code OH). There are 500 products (code EA – eaches) on-hand amongst the reported locations.
SDQ*EA*XX*NPI PHARMACY ID1*115*NPI PHARMACY ID2*120*NPI PHARMACY ID3*265~
The 500 eaches (from the ZA segment) are split amongst three pharmacy locations using NPI (code XX) identifiers –
NPI Pharmacy ID1 has 115, NPI Pharmacy ID2 has 120, and NPI Pharmacy ID3 has 265.
ZA loop #2 – Total Sales Quantity
ZA*TS*1500*EA~
The second ZA Loop begins and is reporting the Total Sales Quantity (code TS). There are 1500 products (eaches) sold amongst the reported locations.
SDQ*EA*XX*NPI PHARMACY ID1*1000*NPI PHARMACY ID2*120*NPI PHARMACY ID3*380~
The 1500 eaches (from the ZA segment) are split amongst three pharmacy locations using NPI (code XX) identifiers – NPI Pharmacy ID1 has 1000, NPI Pharmacy ID2 has 120, and NPI Pharmacy ID3 has 380.
Table 3
CTT*1~
Indicates that the product activity data transaction contains one line item.
SE*12*0001~
Indicates that the product activity transaction, with transaction set control number 0001, has ended with a total of 12 segments.
Transmission
ST*852*0001~XQ*H*20200601**INVRPT001*00~N9*HPI*NPI SELLER IDENTIFIER~PER*BL*HARRY SMITH*TE*800-555-1200*EM* HSMITH@PHARMACY.COM~LIN*0001*ND*55111-0124-05~CTP**RTL*12.57~ ZA*OH*500*EA~SDQ*EA*XX*NPI PHARMACY ID1*115*NPI PHARMACY ID2*120*NPI PHARMACY ID3*265~ZA*TS*1500*EA~SDQ*EA*XX*NPI PHARMACY ID1*1000*NPI PHARMACY ID2*120*NPI PHARMACY ID3*380~ CTT*1~SE*12*0001~