Best Buy Company, Inc.

EDI Transaction Standards
852   Product Activity Data

SEGMENT ID  DESCRIPTION
ISA INTERCHANGE CONTROL HEADER
GS FUNCTIONAL GROUP HEADER
ST TRANSACTION SET HEADER
XQ REPORTING DATE/ACTIVITY
N9 REFERENCE NUMBER
LIN ITEM IDENTIFICATION
ZA PRODUCT ACTIVITY REPORTING
SDQ DESTINATION QUANTITY
CTT TRANSACTION TOTALS
SE TRANSACTION SET TRAILER
GE GROUP CONTROL TRAILER
IEA INTERCHANGE CONTROL TRAILER

 

Runs every Sunday at around 10:00 AM CST
for the previous Sunday through Saturday.

Best Buy can send store level or corporate level sales data.
This is a weekly document only, not available monthly.

 

ISA SEGMENT
INTERCHANGE CONTROL HEADER

DATA ELEMENT ELEMENT NUMBER FIELD LENGTH ELEMENT QUALIFIER FIELD DESCRIPTION
ISA01 I01 2/2 '00' AUTHORIZATION
QUALIFIER
ISA02 I02 10/10   AUTHORIZATION
INFORMATION
ISA03 I03 2/2 '00' SECURITY INFORMATION
QUALIFIER
ISA04 I04 10/10   SECURITY INFORMATION
ISA05 I05 2/2 '01'
'09'
SENDER ID QUALIFIER
01 = Production
09 = Test
ISA06 I06 15/15   SENDER ID
023058159 = Production
023058159TST = Test
ISA07 I05 2/2   RECEIVER ID QUALIFIER
ISA08 I07 15/15   RECEIVER ID
(This element will contain your EDI network ID.)
ISA09 I08 6/6   CREATION DATE
(YYMMDD)
ISA10 I09 4/4   CREATION TIME
(HHMM)
ISA11 I10 1/1 'U' INTERCHANGE IDENTIFIER
ISA12 I11 5/5 00300 X12 VERSION
ISA13 I12 9/9   INTERCHANGE CONTROL
NUMBER
ISA14 I13 1/1 '0' ACKNOWLEDGEMENT
REQUESTED
ISA15 I14 1/1 'P'
'T'
TEST INDICATOR
P = Production
T = Test
ISA16 I15 1/1 '>' SUB ELEMENT SEPARATOR

 

GS SEGMENT
FUNCTIONAL GROUP HEADER

DATA ELEMENT ELEMENT NUMBER FIELD LENGTH ELEMENT QUALIFIER FIELD DESCRIPTION
  GS01 479 2/2 'PD' INFORMATION TYPE CODE
PD = Product Activity Data
  GS02 142 2/12   SENDER ID
023058159 = Production
023058159TST = Test
* GS03 124 2/12   RECEIVER ID
  GS04 29 6/6   DATE TRANSMISSION SENT
(YYMMDD)
  GS05 30 4/4   TIME TRANSMISSION SENT
(HHMM)
  GS06 28 1/9   GROUP CONTROL
NUMBER
  GS07 455 1/2 'X' STANDARD ISSUER
X = X12
** GS08 480 1/12 003010VICS X12 VERSION
* A unique code to identify the receiver. This is usually the same as the code used in the ISA08
** Please note that we utilize the 3010VICS version for the retail industry. It has been a fairly common problem that our trading partners will set their systems to 3010 (without the VICS). This will cause a version mismatch at this end, so please use the 3010VICS standard.

 

ST SEGMENT
TRANSACTION SET HEADER

DATA ELEMENT ELEMENT NUMBER FIELD LENGTH ELEMENT QUALIFIER FIELD DESCRIPTION
ST01 143 3/3 '852' TRANSACTION SET CODE
852 = Product Activity Data
ST02 329 4/9   SEQUENTIAL NUMBER
(Maintained by sender)

 

XQ SEGMENT
REPORTING DATE/ACTIVITY*

DATA ELEMENT ELEMENT NUMBER FIELD LENGTH ELEMENT QUALIFIER FIELD DESCRIPTION
XQ01 305 1/1 'H' HANDLING CODE
H = Notification Only
XQ02 373 6/6   START DATE
(YYMMDD)
XQ03 373 6/6   END DATE
(YYMMDD)
* Note that we are not sending the dates that reflect the start and the end of the reporting period. In our transmission both dates will reflect the date that we processed this data. In other words, both dates will be the same, and both dates will, essentially, be the end date.

 

N9 SEGMENT
REFERENCE NUMBER

DATA ELEMENT ELEMENT NUMBER FIELD LENGTH ELEMENT QUALIFIER FIELD DESCRIPTION
N901 128 2/2 'SB' REFERENCE QUALIFIER
SB = Sales Region
N902 127 1/30   DATA LEVEL
(Corporate or Store)

 

LIN SEGMENT
ITEM IDENTIFICATION

DATA ELEMENT ELEMENT NUMBER FIELD LENGTH ELEMENT QUALIFIER FIELD DESCRIPTION
  LIN01 350 1/6   SEQUENTIAL NUMBER
  LIN02 235 2/2 'CB' SKU QUALIFIER
CB = Buyer's Catalog Number
* LIN03 234 1/17   SKU NUMBER
  LIN04 235 2/2 'UP' UPC QUALIFIER
UP = UPC Consumer Package Code
  LIN05 234 1/12   UPC CODE
(12 digits only)
  LIN06 235 2/2 'VC' MODEL NUMBER
QUALIFIER
VC = Vendor's Catalog Number
  LIN07 234 1/10   MODEL NUMBER
* SKU information sent can be for active skus, or active and inactive skus in the Best Buy system. SKUs will not be identified as active or inactive.

 

* SPECIAL NOTE ABOUT THE FOLLOWING ZA AND SDQ SEGMENTS:
Only the ZA segment will be sent when the EDI852 Product Activity Data is sent at the Corporate Level. At the Corporate Level the quantity in the ZA02 can be a positive number, negative number, or a zero. When the EDI852 Product Activity Data is sent at the Store Level, the ZA and SDQ segments will be sent. At the Store Level the quantity in the ZA02 will always be zero. The quantity in the SDQ04 will be a positive number or negative number. Zero will not be sent in the SDQ04.

 

ZA SEGMENT
PRODUCT ACTIVITY REPORTING

DATA ELEMENT ELEMENT NUMBER FIELD LENGTH ELEMENT QUALIFIER FIELD DESCRIPTION
* ZA01 859 2/2 'QS'
'QP'
'QA'
'QD'

QUANTITY QUALIFIER
QS = Quantity sold
QP = Quantity on order
QA = Sellable quantity on hand
QD = Non-sellable quantity on hand
** ZA02 380 1/15   QUANTITY
  ZA03 355 2/2 'EA' UNIT OF MEASURE
EA = Each
*** ZA04 374 3/3 '007' DATE / TIME QUALIFIER
007 = Effective
*** ZA05 373 6/6   REPORTING DATE
(YYMMDD)
* Sellable quantity on hand (QA) includes quantities in the store and warehouse. Non-sellable quantity on hand (QD) includes devo quantities and quantities at the service center.
** ZA02 will always have a quantity of zero when the SDQ is present.
*** ZA04 and ZA05 are only used for store level reporting. Only present if the SDQ segment is present.

 

SDQ SEGMENT
DESTINATION QUANTITY

*** THIS IS AN OPTIONAL SEGMENT *** USED FOR STORE LEVEL INFORMATION
DATA ELEMENT ELEMENT NUMBER FIELD LENGTH ELEMENT QUALIFIER FIELD DESCRIPTION
  SDQ01 355 2/2 'EA' UNIT OF MEASURE CODE
EA = Each
  SDQ02 66 1/2 '92' ID CODE QUALIFIER
92 = Assigned by Buyer
* SDQ03 67 2/5   IDENTIFICATION CODE
** SDQ04 380 1/7   TOTAL QUANTITY
* This will be a five digit number that will indicate the Best Buy location. The first two digits will always be "01". The final three digits will indicate the Best Buy location.
** SDQ03 AND SDQ04 CAN BE REPEATED A TOTAL OF 10 TIMES.

 

CTT SEGMENT
TRANSACTION TOTALS

DATA ELEMENT ELEMENT NUMBER FIELD LENGTH ELEMENT QUALIFIER FIELD DESCRIPTION
CTT01 354 1/6   NUMBER OF LINE ITEMS

 

SE SEGMENT
TRANSACTION SET TRAILER

DATA ELEMENT ELEMENT NUMBER FIELD LENGTH ELEMENT QUALIFIER FIELD DESCRIPTION
SE01 96 1/6   NUMBER OF INCLUDED
SEGMENTS
SE02 329 4/9   TRANSACTION SET CONTROL NUMBER

 

GE SEGMENT
GROUP CONTROL TRAILER

DATA ELEMENT ELEMENT NUMBER FIELD LENGTH ELEMENT QUALIFIER FIELD DESCRIPTION
GE01 97 1/6   NUMBER OF TRANSACTIONS
IN FUNCTIONAL GROUP
GE02 28 1/9   GROUP CONTROL NUMBER

 

IEA SEGMENT
INTERCHANGE CONTROL TRAILER

DATA ELEMENT ELEMENT NUMBER FIELD LENGTH ELEMENT QUALIFIER FIELD DESCRIPTION
IEA01 I16 1/5   NUMBER OF INCLUDED
GROUPS
(GS SEGMENTS)
IEA02 I12 9/9   INTERCHANGE CONTROL
NUMBER

 

Back to EDI Transaction Standards Table of Contents