Stedi maintains this guide based on public documentation from Rite Aid. Contact Rite Aid for official EDI specifications. To report any errors in this guide, please contact us.

X12 852 Product Activity Data

X12 Release 5010

—

Delimiters

~ Segment
* Element
> Component
^ Repetition

EDI sample

—

Sample

View the latest version of this implementation guide as an interactive webpage

https://www.stedi.com/app/guides/view/rite-aid/product-activity-data/01H3CCPH3RYWJ2M0DQFWR2FJY1

Build EDI implementation guides at stedi.com

ISA

Interchange Control Header

RequiredMax use 1

—

Example

ISA-01

I01

Authorization Information Qualifier

Required

Identifier (ID)

—

00: No Authorization Information Present (No Meaningful Information in I02)

ISA-02

I02

Authorization Information

Required

String (AN)

Min 10Max 10

—

ISA-03

I03

Security Information Qualifier

Required

Identifier (ID)

—

00: No Security Information Present (No Meaningful Information in I04)

ISA-04

I04

Security Information

Required

String (AN)

Min 10Max 10

—

ISA-05

I05

Interchange ID Qualifier

Required

Identifier (ID)

Min 2Max 2

—

Codes

01: Duns (Dun & Bradstreet)
02: SCAC (Standard Carrier Alpha Code)
03: FMC (Federal Maritime Commission)
04: IATA (International Air Transport Association)
07: Global Location Number (GLN)
08: UCC EDI Communications ID (Comm ID)
09: X.121 (CCITT)
10: Department of Defense (DoD) Activity Address Code
11: DEA (Drug Enforcement Administration)
12: Phone (Telephone Companies)
13: UCS Code (The UCS Code is a Code Used for UCS Transmissions; it includes the Area Code and Telephone Number of a Modem; it Does Not Include Punctuation, Blanks or Access Code)
14: Duns Plus Suffix
15: Petroleum Accountants Society of Canada Company Code
16: Duns Number With 4-Character Suffix
17: American Bankers Association (ABA) Transit Routing Number (Including Check Digit, 9 Digit)
18: Association of American Railroads (AAR) Standard Distribution Code
19: EDI Council of Australia (EDICA) Communications ID Number (COMM ID)
20: Health Industry Number (HIN)
21: Integrated Postsecondary Education Data System, or (IPEDS)
22: Federal Interagency Commission on Education, or FICE
23: National Center for Education Statistics Common Core of Data 12-Digit Number for Pre-K-Grade 12 Institutes, or NCES
24: The College Board's Admission Testing Program 4-Digit Code of Postsecondary Institutes, or ATP
25: ACT, Inc. 4-Digit Code of Postsecondary Institutions.
26: Statistics of Canada List of Postsecondary Institutions
27: Carrier Identification Number as assigned by Health Care Financing Administration (HCFA)
28: Fiscal Intermediary Identification Number as assigned by Health Care Financing Administration (HCFA)
29: Medicare Provider and Supplier Identification Number as assigned by Health Care Financing Administration (HCFA)
30: U.S. Federal Tax Identification Number
31: Jurisdiction Identification Number Plus 4 as assigned by the International Association of Industrial Accident Boards and Commissions (IAIABC)
32: U.S. Federal Employer Identification Number (FEIN)
33: National Association of Insurance Commissioners Company Code (NAIC)
34: Medicaid Provider and Supplier Identification Number as assigned by individual State Medicaid Agencies in conjunction with Health Care Financing Administration (HCFA)
35: Statistics Canada Canadian College Student Information System Institution Codes
36: Statistics Canada University Student Information System Institution Codes
37: Society of Property Information Compilers and Analysts
38: The College Board and ACT, Inc. 6-Digit Code List of Secondary Institutions
AM: Association Mexicana del Codigo de Producto (AMECOP) Communication ID
NR: National Retail Merchants Association (NRMA) - Assigned
SA: User Identification Number as assigned by the Safety and Fitness Electronic Records (SAFER) System
SN: Standard Address Number
ZZ: Mutually Defined

ISA-06

I06

Interchange Sender ID

Required

String (AN)

Min 15Max 15

—

ISA-07

I05

Interchange ID Qualifier

Required

Identifier (ID)

Min 2Max 2

—

Codes

01: Duns (Dun & Bradstreet)
02: SCAC (Standard Carrier Alpha Code)
03: FMC (Federal Maritime Commission)
04: IATA (International Air Transport Association)
07: Global Location Number (GLN)
08: UCC EDI Communications ID (Comm ID)
09: X.121 (CCITT)
10: Department of Defense (DoD) Activity Address Code
11: DEA (Drug Enforcement Administration)
12: Phone (Telephone Companies)
13: UCS Code (The UCS Code is a Code Used for UCS Transmissions; it includes the Area Code and Telephone Number of a Modem; it Does Not Include Punctuation, Blanks or Access Code)
14: Duns Plus Suffix
15: Petroleum Accountants Society of Canada Company Code
16: Duns Number With 4-Character Suffix
17: American Bankers Association (ABA) Transit Routing Number (Including Check Digit, 9 Digit)
18: Association of American Railroads (AAR) Standard Distribution Code
19: EDI Council of Australia (EDICA) Communications ID Number (COMM ID)
20: Health Industry Number (HIN)
21: Integrated Postsecondary Education Data System, or (IPEDS)
22: Federal Interagency Commission on Education, or FICE
23: National Center for Education Statistics Common Core of Data 12-Digit Number for Pre-K-Grade 12 Institutes, or NCES
24: The College Board's Admission Testing Program 4-Digit Code of Postsecondary Institutes, or ATP
25: ACT, Inc. 4-Digit Code of Postsecondary Institutions.
26: Statistics of Canada List of Postsecondary Institutions
27: Carrier Identification Number as assigned by Health Care Financing Administration (HCFA)
28: Fiscal Intermediary Identification Number as assigned by Health Care Financing Administration (HCFA)
29: Medicare Provider and Supplier Identification Number as assigned by Health Care Financing Administration (HCFA)
30: U.S. Federal Tax Identification Number
31: Jurisdiction Identification Number Plus 4 as assigned by the International Association of Industrial Accident Boards and Commissions (IAIABC)
32: U.S. Federal Employer Identification Number (FEIN)
33: National Association of Insurance Commissioners Company Code (NAIC)
34: Medicaid Provider and Supplier Identification Number as assigned by individual State Medicaid Agencies in conjunction with Health Care Financing Administration (HCFA)
35: Statistics Canada Canadian College Student Information System Institution Codes
36: Statistics Canada University Student Information System Institution Codes
37: Society of Property Information Compilers and Analysts
38: The College Board and ACT, Inc. 6-Digit Code List of Secondary Institutions
AM: Association Mexicana del Codigo de Producto (AMECOP) Communication ID
NR: National Retail Merchants Association (NRMA) - Assigned
SA: User Identification Number as assigned by the Safety and Fitness Electronic Records (SAFER) System
SN: Standard Address Number
ZZ: Mutually Defined

ISA-08

I07

Interchange Receiver ID

Required

String (AN)

Min 15Max 15

—

ISA-09

I08

Interchange Date

Required

Date (DT)

YYMMDD format

—

ISA-10

I09

Interchange Time

Required

Time (TM)

HHMM format

—

ISA-11

I65

Repetition Separator

Required

String (AN)

Min 1Max 1

—

^: Repetition Separator

ISA-12

I11

Interchange Control Version Number

Required

Identifier (ID)

—

00501: Standards Approved for Publication by ASC X12 Procedures Review Board through October 2003

ISA-13

I12

Interchange Control Number

Required

Numeric (N0)

Min 9Max 9

—

ISA-14

I13

Acknowledgment Requested

Required

Identifier (ID)

Min 1Max 1

—

0: No Interchange Acknowledgment Requested
1: Interchange Acknowledgment Requested (TA1)

ISA-15

I14

Interchange Usage Indicator

Required

Identifier (ID)

Min 1Max 1

—

I: Information
P: Production Data
T: Test Data

ISA-16

I15

Component Element Separator

Required

String (AN)

Min 1Max 1

—

>: Component Element Separator

Functional Group Header

RequiredMax use 1

—

Example

GS-01

479

Functional Identifier Code

Required

Identifier (ID)

—

PD: Product Activity Data (852)

GS-02

142

Application Sender's Code

Required

String (AN)

Min 2Max 15

—

GS-03

124

Application Receiver's Code

Required

String (AN)

Min 2Max 15

—

GS-04

373

Date

Required

Date (DT)

CCYYMMDD format

—

GS-05

337

Time

Required

Time (TM)

HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format

—

GS-06

Group Control Number

Required

Numeric (N0)

Min 1Max 9

—

GS-07

455

Responsible Agency Code

Required

Identifier (ID)

Min 1Max 2

—

T: Transportation Data Coordinating Committee (TDCC)
X: Accredited Standards Committee X12

GS-08

480

Version / Release / Industry Identifier Code

Required

String (AN)

—

005010: Standards Approved for Publication by ASC X12 Procedures Review Board through October 2003

Heading

0100

Heading > ST

Transaction Set Header

RequiredMax use 1

—

Example

ST-01

143

Transaction Set Identifier Code

Required

Identifier (ID)

—

852: Product Activity Data

ST-02

329

Transaction Set Control Number

Required

Numeric (N)

Min 4Max 9

—

0200

Heading > XQ

Reporting Date/Action

RequiredMax use 1

—

Usage notes

—

Example

XQ-01

305

Transaction Handling Code

Required

Identifier (ID)

—

H: Notification Only

XQ-02

373

Date

Required

Date (DT)

CCYYMMDD format

—

Usage notes

—

N1 Vendor

RequiredMax >1

Variants (all may be used)

Place of Business

0600

Heading > Vendor > N1

Party Identification

RequiredMax use 1

—

Usage notes

—

Example

N1-01

Entity Identifier Code

Required

Identifier (ID)

—

VN: Vendor

N1-02

Name

Optional

String (AN)

Min 1Max 60

—

N1-03

Identification Code Qualifier

Required

Identifier (ID)

—

92: Assigned by Buyer or Buyer's Agent

N1-04

Identification Code

Required

String (AN)

Min 2Max 80

—

Usage notes

—

N1 Vendor end

N1 Place of Business

RequiredMax >1

Variants (all may be used)

Vendor

0600

Heading > Place of Business > N1

Party Identification

RequiredMax use 1

—

Usage notes

—

Example

N1-01

Entity Identifier Code

Required

Identifier (ID)

—

BU: Place of Business

N1-02

Name

Required

String (AN)

Min 1Max 60

—

Usage notes

—

N1-03

Identification Code Qualifier

Required

Identifier (ID)

—

1: D-U-N-S Number, Dun & Bradstreet
92: Assigned by Buyer or Buyer's Agent

N1-04

Identification Code

Required

String (AN)

—

Usage notes

—

014578892: Rite Aid's Duns Number

N1 Place of Business end

Heading end

Detail

LIN Loop

RequiredMax >1

LIN

0100

Detail > LIN Loop > LIN

Item Identification

RequiredMax use 1

—

Usage notes

—

Example

LIN-02

235

Product/Service ID Qualifier

Required

Identifier (ID)

—

UA: U.P.C./EAN Case Code (2-5-5)
UI: U.P.C. Consumer Package Code (1-5-5)
VN: Vendor's (Seller's) Item Number

LIN-03

234

Product/Service ID

Required

String (AN)

Min 1Max 48

—

LIN-04

235

Product/Service ID Qualifier

Required

Identifier (ID)

—

IN: Buyer's Item Number

LIN-05

234

Product/Service ID

Required

String (AN)

Min 1Max 48

—

0400

Detail > LIN Loop > N9

Extended Reference Information

RequiredMax use >1

—

Usage notes

—

Example

N9-01

128

Reference Identification Qualifier

Required

Identifier (ID)

—

82: Data Item Description (DID) Reference
—

N9-03

369

Free-form Description

Required

String (AN)

Min 1Max 45

—

ZA Loop

RequiredMax >1

0800

Detail > LIN Loop > ZA Loop > ZA

Product Activity Reporting

RequiredMax use 1

—

Usage notes

—

Example

ZA-01

859

Activity Code

Required

Identifier (ID)

—

QA: Current Inventory Quantity Available for Shipment or Sale
QO: Quantity Out of Stock
QP: Quantity On Order, Not Yet Received
—
QS: Quantity Sold

SDQ

1100

Detail > LIN Loop > ZA Loop > SDQ

Destination Quantity

RequiredMax use >1

—

Usage notes

—

Example

If either Identification Code (SDQ-05) or Quantity (SDQ-06) is present, then the other is required

If either Identification Code (SDQ-07) or Quantity (SDQ-08) is present, then the other is required

If either Identification Code (SDQ-09) or Quantity (SDQ-10) is present, then the other is required

If either Identification Code (SDQ-11) or Quantity (SDQ-12) is present, then the other is required

If either Identification Code (SDQ-13) or Quantity (SDQ-14) is present, then the other is required

If either Identification Code (SDQ-15) or Quantity (SDQ-16) is present, then the other is required

If either Identification Code (SDQ-17) or Quantity (SDQ-18) is present, then the other is required

If either Identification Code (SDQ-19) or Quantity (SDQ-20) is present, then the other is required

If either Identification Code (SDQ-21) or Quantity (SDQ-22) is present, then the other is required

SDQ-01

355

Unit or Basis for Measurement Code

Required

Identifier (ID)

—

EA: Each

SDQ-02

Identification Code Qualifier

Required

Identifier (ID)

—

92: Assigned by Buyer or Buyer's Agent

SDQ-03

Identification Code

Required

String (AN)

Min 2Max 80

—

SDQ-04

380

Quantity

Required

Decimal number (R)

Min 1Max 15

—

SDQ-05

Identification Code

Optional

String (AN)

Min 2Max 80

—

SDQ-06

380

Quantity

Optional

Decimal number (R)

Min 1Max 15

—

SDQ-07

Identification Code

Optional

String (AN)

Min 2Max 80

—

SDQ-08

380

Quantity

Optional

Decimal number (R)

Min 1Max 15

—

SDQ-09

Identification Code

Optional

String (AN)

Min 2Max 80

—

SDQ-10

380

Quantity

Optional

Decimal number (R)

Min 1Max 15

—

SDQ-11

Identification Code

Optional

String (AN)

Min 2Max 80

—

SDQ-12

380

Quantity

Optional

Decimal number (R)

Min 1Max 15

—

SDQ-13

Identification Code

Optional

String (AN)

Min 2Max 80

—

SDQ-14

380

Quantity

Optional

Decimal number (R)

Min 1Max 15

—

SDQ-15

Identification Code

Optional

String (AN)

Min 2Max 80

—

SDQ-16

380

Quantity

Optional

Decimal number (R)

Min 1Max 15

—

SDQ-17

Identification Code

Optional

String (AN)

Min 2Max 80

—

SDQ-18

380

Quantity

Optional

Decimal number (R)

Min 1Max 15

—

SDQ-19

Identification Code

Optional

String (AN)

Min 2Max 80

—

SDQ-20

380

Quantity

Optional

Decimal number (R)

Min 1Max 15

—

SDQ-21

Identification Code

Optional

String (AN)

Min 2Max 80

—

SDQ-22

380

Quantity

Optional

Decimal number (R)

Min 1Max 15

—

ZA Loop end

LIN Loop end

Detail end

Summary

CTT

0100

Summary > CTT

Transaction Totals

RequiredMax use 1

—

Example

CTT-01

354

Number of Line Items

Required

Numeric (N0)

Min 1Max 6

—

0200

Summary > SE

Transaction Set Trailer

RequiredMax use 1

—

Example

SE-01

Number of Included Segments

Required

Numeric (N0)

Min 1Max 10

—

SE-02

329

Transaction Set Control Number

Required

Numeric (N)

Min 4Max 9

—

Summary end

Functional Group Trailer

RequiredMax use 1

—

Example

GE-01

Number of Transaction Sets Included

Required

Numeric (N0)

Min 1Max 6

—

GE-02

Group Control Number

Required

Numeric (N0)

Min 1Max 9

—

IEA

Interchange Control Trailer

RequiredMax use 1

—

Example

IEA-01

I16

Number of Included Functional Groups

Required

Numeric (N0)

Min 1Max 5

—

IEA-02

I12

Interchange Control Number

Required

Numeric (N0)

Min 9Max 9

—

EDI Samples

Sample

ST*852*000010463~
XQ*H*20110408~
N1*BU*RITE AID HDQTRS. CORP.*1*014578892~
N1*VN**92*34092~
LIN**UI*07553759884*IN*0310945~
N9*82**ACCU-CHEK CMPT STR 102CT~
ZA*QA~
SDQ*EA*92*00010*1337*00035*207*00055*849*00081*741~
ZA*QP~
SDQ*EA*92*00010*1440*00035*96*00081*480~
ZA*QS~
SDQ*EA*92*00010*134*00035*21*00055*66*00081*34~
LIN**UI*07553700971*IN*0313920~
N9*82**SOFTCLIX LANCETS 100 S!!M~
ZA*QA~
SDQ*EA*92*00010*975*00035*204*00055*534*00081*420~
ZA*QP~
SDQ*EA*92*00010*576*00035*192*00055*192*00081*192~
ZA*QS~
SDQ*EA*92*00010*152*00035*6*00055*45*00081*25~
LIN**UI*36570210110*IN*0323433~
N9*82**ACCU-CHEK AVIVA METER~
ZA*QA~
SDQ*EA*92*00010*1114*00035*142*00055*438*00081*773~
ZA*QS~
SDQ*EA*92*00010*45*00035*11*00055*20*00081*19~
LIN**UI*36570210310*IN*0324477~
N9*82**ACCU-CHEK AVIVA STRP 50CT~
ZA*QA~
SDQ*EA*92*00010*2402*00035*313*00055*584*00081*765~
ZA*QP~
SDQ*EA*92*00010*864*00035*144*00055*396*00081*936~
ZA*QS~
SDQ*EA*92*00010*189*00035*26*00055*55*00081*88~
LIN**UI*36570210410*IN*0325335~
N9*82**ACCU-CHEK AVIVA STRP 100CT~
ZA*QA~
SDQ*EA*92*00010*2869*00035*495*00055*1955*00081*1627~
ZA*QP~
SDQ*EA*92*00010*648*00035*216*00055*648*00081*1296~
ZA*QS~
SDQ*EA*92*00010*339*00035*28*00055*179*00081*117~
LIN**UI*07553745097*IN*0325368~
N9*82**MULTICLIX LANCETS 102CT~
ZA*QA~
SDQ*EA*92*00010*1775*00035*309*00055*367*00081*768~
ZA*QP~
SDQ*EA*92*00055*864*00081*432~
ZA*QS~
SDQ*EA*92*00010*164*00035*14*00055*61*00081*59~
LIN**UI*07553731463*IN*0331240~
N9*82**ACCU-CHEK ACTV STR 50CT~
ZA*QA~
SDQ*EA*92*00010*1017*00035*79*00055*204*00081*251~
ZA*QP~
SDQ*EA*92*00035*48*00055*96*00081*120~
ZA*QS~
SDQ*EA*92*00010*84*00035*6*00055*18*00081*8~
LIN**UI*07553749070*IN*0331242~
N9*82**ACCU-CHEK CMPT PLUS METER~
ZA*QA~
SDQ*EA*92*00010*289*00035*60*00055*83*00081*179~
ZA*QP~
SDQ*EA*92*00010*88*00035*8*00055*24*00081*48~
ZA*QS~
SDQ*EA*92*00010*19*00035*3*00055*14*00081*6~
LIN**UI*07553747419*IN*0331243~
N9*82**ACCU-CHEK CMPT STR 51CT~
ZA*QA~
SDQ*EA*92*00010*941*00035*143*00055*415*00081*492~
ZA*QP~
SDQ*EA*92*00010*288*00035*48~
ZA*QS~
SDQ*EA*92*00010*67*00035*2*00055*21*00081*33~
LIN**UI*07553730381*IN*0387169~
N9*82**ACCU-CHEK CMF CURVE 100CT~
ZA*QA~
SDQ*EA*92*00010*960*00035*72*00055*522*00081*417~
ZA*QP~
SDQ*EA*92*00010*576*00035*48*00081*576~
ZA*QS~
SDQ*EA*92*00010*96*00035*3*00055*40*00081*40~
CTT*10~
SE*84*000010463~

Stedi is a registered trademark of Stedi, Inc. All names, logos, and brands of third parties listed on this page 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. Use of these names, logos, and brands is for identification purposes only, and does not imply any such endorsement, sponsorship, or affiliation.