Costco
/
Product Activity Data
  • Specification
  • EDI Inspector
Stedi maintains this guide based on public documentation from Costco. Contact Costco for official EDI specifications. To report any errors in this guide, please contact us.
Go to Stedi Network
Costco logo

X12 852 Product Activity Data

X12 Release 4010
Delimiters
  • ~ Segment
  • * Element
  • > Component
EDI samples
  • None included
View the latest version of this implementation guide as an interactive webpage
https://www.stedi.com/app/guides/view/costco/product-activity-data/01GWW3E6KGF27AQKXSCWQZHF7J
Powered by
Build EDI implementation guides at stedi.com
Overview
ISA
-
Interchange Control Header
Max use 1
Required
GS
-
Functional Group Header
Max use 1
Required
heading
ST
010
Transaction Set Header
Max use 1
Required
XQ
020
Reporting Date/Action
Max use 1
Required
XPO
030
Preassigned Purchase Order Numbers
Max use 1
Optional
N1 Loop
detail
LIN Loop
LIN
010
Item Identification
Max use 1
Required
PO4
030
Item Physical Details
Max use 1
Optional
ZA Loop
GE
-
Functional Group Trailer
Max use 1
Required
IEA
-
Interchange Control Trailer
Max use 1
Required
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
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
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
I10
Interchange Control Standards Identifier
Required
Identifier (ID)
U
U.S. EDI Community of ASC X12, TDCC, and UCS
ISA-12
I11
Interchange Control Version Number
Required
Identifier (ID)
00401
Draft Standards for Trial Use Approved for Publication by ASC X12 Procedures Review Board through October 1997
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 Acknowledgment Requested
1
Interchange Acknowledgment Requested
ISA-15
I14
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
Required
Date (DT)
CCYYMMDD format
Required
Time (TM)
HHMM, HHMMSS, HHMMSSD, or HHMMSSDD format
GS-06
28
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)
004010
Draft Standards Approved for Publication by ASC X12 Procedures Review Board through October 1997

Heading

ST
010
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
XQ
020
Heading > XQ

Reporting Date/Action

RequiredMax use 1
Example
XQ-01
305
Transaction Handling Code
Required
Identifier (ID)
G
Plan Order(s) and Ship Product
H
Notification Only
Required
Date (DT)
CCYYMMDD format
Usage notes
Optional
Date (DT)
CCYYMMDD format
Usage notes
XPO
030
Heading > XPO

Preassigned Purchase Order Numbers

OptionalMax use >1
Example
If either Identification Code Qualifier (XPO-03) or Identification Code (XPO-04) is present, then the other is required
XPO-01
324
Purchase Order Number
Required
String (AN)
Min 1Max 22
Usage notes
XPO-02
324
Purchase Order Number
Optional
String (AN)
Min 1Max 22
Usage notes
XPO-03
66
Identification Code Qualifier
Optional
Identifier (ID)
9
D-U-N-S+4, D-U-N-S Number with Four Character Suffix
XPO-04
67
Identification Code
Optional
String (AN)
Min 2Max 80
Usage notes
N1 Loop
OptionalMax >1
N1
060
Heading > N1 Loop > N1

Name

RequiredMax use 1
Example
If either Identification Code Qualifier (N1-03) or Identification Code (N1-04) is present, then the other is required
N1-01
98
Entity Identifier Code
Required
Identifier (ID)
Min 2Max 3
N1-03
66
Identification Code Qualifier
Optional
Identifier (ID)
1
D-U-N-S Number, Dun & Bradstreet
N1-04
67
Identification Code
Optional
String (AN)
Min 2Max 80
Usage notes
N1 Loop end
Heading end

Detail

LIN Loop
OptionalMax >1
LIN
010
Detail > LIN Loop > LIN

Item Identification

RequiredMax use 1
Example
If either Product/Service ID Qualifier (LIN-04) or Product/Service ID (LIN-05) is present, then the other is required
LIN-02
235
Product/Service ID Qualifier
Required
Identifier (ID)
IN
Buyer's Item Number
UA
U.P.C./EAN Case Code (2-5-5)
UI
U.P.C. Consumer Package Code (1-5-5)
UN
U.P.C. Case Code Number (1-1-5-5)
UP
U.P.C. Consumer Package Code (1-5-5-1)
VN
Vendor's (Seller's) Item Number
LIN-03
234
Product/Service ID
Required
String (AN)
Min 1Max 48
Usage notes
LIN-04
235
Product/Service ID Qualifier
Optional
Identifier (ID)
IN
Buyer's Item Number
UA
U.P.C./EAN Case Code (2-5-5)
UI
U.P.C. Consumer Package Code (1-5-5)
UN
U.P.C. Case Code Number (1-1-5-5)
UP
U.P.C. Consumer Package Code (1-5-5-1)
VN
Vendor's (Seller's) Item Number
LIN-05
234
Product/Service ID
Optional
String (AN)
Min 1Max 48
Usage notes
PO4
030
Detail > LIN Loop > PO4

Item Physical Details

OptionalMax use 1
Example
Optional
Numeric (N0)
Min 1Max 6
Usage notes
ZA Loop
RequiredMax >1
ZA
080
Detail > LIN Loop > ZA Loop > ZA

Product Activity Reporting

RequiredMax use 1
Example
If either Date/Time Qualifier (ZA-04) or Date (ZA-05) is present, then the other is required
ZA-01
859
Activity Code
Required
Identifier (ID)
QA
Current Inventory Quantity Available for Shipment or Sale
QP
Quantity On Order, Not Yet Received
QS
Quantity Sold
ZA-04
374
Date/Time Qualifier
Optional
Identifier (ID)
Usage notes
007
Effective
173
Week Ending
Optional
Date (DT)
CCYYMMDD format
Usage notes
SDQ
110
Detail > LIN Loop > ZA Loop > SDQ

Destination Quantity

OptionalMax use >1
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
66
Identification Code Qualifier
Optional
Identifier (ID)
92
Assigned by Buyer or Buyer's Agent
SDQ-03
67
Identification Code
Required
String (AN)
Min 2Max 80
Usage notes
SDQ-04
380
Quantity
Required
Decimal number (R)
Min 1Max 15
SDQ-05
67
Identification Code
Optional
String (AN)
Min 2Max 80
SDQ-06
380
Quantity
Optional
Decimal number (R)
Min 1Max 15
SDQ-07
67
Identification Code
Optional
String (AN)
Min 2Max 80
SDQ-08
380
Quantity
Optional
Decimal number (R)
Min 1Max 15
SDQ-09
67
Identification Code
Optional
String (AN)
Min 2Max 80
SDQ-10
380
Quantity
Optional
Decimal number (R)
Min 1Max 15
SDQ-11
67
Identification Code
Optional
String (AN)
Min 2Max 80
SDQ-12
380
Quantity
Optional
Decimal number (R)
Min 1Max 15
SDQ-13
67
Identification Code
Optional
String (AN)
Min 2Max 80
SDQ-14
380
Quantity
Optional
Decimal number (R)
Min 1Max 15
SDQ-15
67
Identification Code
Optional
String (AN)
Min 2Max 80
SDQ-16
380
Quantity
Optional
Decimal number (R)
Min 1Max 15
SDQ-17
67
Identification Code
Optional
String (AN)
Min 2Max 80
SDQ-18
380
Quantity
Optional
Decimal number (R)
Min 1Max 15
SDQ-19
67
Identification Code
Optional
String (AN)
Min 2Max 80
SDQ-20
380
Quantity
Optional
Decimal number (R)
Min 1Max 15
SDQ-21
67
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
010
Summary > CTT

Transaction Totals

OptionalMax use 1
Example
If either Weight (CTT-03) or Unit or Basis for Measurement Code (CTT-04) is present, then the other is required
If either Volume (CTT-05) or Unit or Basis for Measurement Code (CTT-06) is present, then the other is required
CTT-01
354
Number of Line Items
Required
Numeric (N0)
Min 1Max 6
CTT-02
347
Hash Total
Optional
Decimal number (R)
Min 1Max 10
CTT-03
81
Weight
Optional
Decimal number (R)
Min 1Max 10
CTT-04
355
Unit or Basis for Measurement Code
Optional
Identifier (ID)
Min 2Max 2
CTT-05
183
Volume
Optional
Decimal number (R)
Min 1Max 8
CTT-06
355
Unit or Basis for Measurement Code
Optional
Identifier (ID)
Min 2Max 2
SE
020
Summary > SE

Transaction Set Trailer

RequiredMax use 1
Example
SE-01
96
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
97
Number of Transaction Sets Included
Required
Numeric (N0)
Min 1Max 6
GE-02
28
Group Control Number
Required
Numeric (N0)
Min 1Max 9

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

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.