Product Activity Data 852

Documentation

 

Document Segment Summary

Header Area (Table 1) - Contains data that applies to the entire Product Activity.

ID

Segment Name

Mandatory/Optional

Max Use

Loop Repeat

ST

Transaction Set Header

M

1

XQ

Reporting Date/Action

M

1

XPO

Preassigned PO Numbers

O

>1

N9

Reference Identifiiication

O

>1

N1

Name

O

1

N1/200

TD5

Carrier Details

O

1

 

Detail Area (Table 2) - Contains data that applies to each line item. The entire section repeats for each line item.

ID

Segment Name

Mandatory/Optional

Max Use

Loop Repeat

LIN

Item Identification

M

1

LIN/999999

PO4

Item Physical Details

O

1

  

ZA

Product Activity Reporting

M

1

ZA/>1

SDQ

Destination Quantity

O

>1

  

 

Summary Area (Table 3) - Contains data that applies to the entire Product Activity.

ID

Segment Name

Mandatory/Optional

Max Use

Loop Repeat

CTT

Transaction Totals

O

1

  

SE

Transaction Set Trailer

M

1

  


Key

Mandatory/Optional 
    M = Mandatory; at lease one occurrence must appear in the transaction set.
    O = Optional; may be present if information is available.

Max Use Maximum number of segments that will be used.

Loop Repeat Loop Name / Maximum number of times the loop repeats.

 

                                        SEG#      Description                                      Data                                 MIN/     Data   Elmt  Mandatory
                                                                                                                                                    Entered                          MAX     Elmt    Type   For CRP
ST Transaction Set Header          ST01     Transaction set identifier           852                            3/3      143       ID         M
ex: ST*852*111111001                  ST02     Transaction set control number                                    4/9      329       AN        M

 
XQ Reporting Date/Action            XQ01     Transaction handling code          G Plan and ship           1/2      305       ID        M
ex: XQ*G*940105*940105                                                                           H Notification only
                                                   XQ02     Report start date                       CCYYMMDD                 8/8      373       DT       M
                                                   XQ03     Report end date                         CCYYMMDD                 8/8      373       D         O
                      

Note: 
1) When sending summary or week-ending files, XQ03 is the week-ending date.

 
N9 Reference Number                 N901      Reference Number Qualifier       VR, IA, CR, ZA            2/3        128       ID       M
ex: N9*VR*ABCDEF                        N902      Reference Number                     Reference Number      1/30      127       AN      M

 
N1 Name                                     N101      Entity ID code                            ST Ship To (DC)         2/3          98        ID       M
ex: N1*ST*Customer Name*9         N102      Name                                        Customer name         1/60        93        AN      O
     *1234567891234                     N103      ID code qualifier                        9                              1/2          66        ID       M
                                         N104      ID code                                      DUNS + Suffix           2/80        67        AN      M

Note:
1) The N1 segment must be sent with an ST value identifying the Ship-To location.
2) It is preferred to receive the DUNS + suffix in the N1 segment. If the DUNS + suffix will not be sent, identify the value and the  appropriate qualifier.

 
N1 Name                                     N101      Entity ID code                             VN Vendor                2/3          98        ID        M
ex: N1*VN*Vendor Name*9             N102      Name                                         Vendor name           1/60         93        AN       O
      *1234567895678                     N103      ID code qualifier                         9                             1/2          66        ID        M
                                                   N104      ID code                                      DUNS + Suffix           2/80        67        AN       M

Note: 
1) Use of the Vendor N1 segment is optional.

 
TD5 Carrier Details                     TD504   Transportation Method/Type Code  H Customer pick-up   1/2       91        ID        M
ex: TD5****M                                                                                                M Motor (common carrier)
                                                                                            L Contract Carrier

 
LIN Item Identifier                      LIN02    Product/Service ID qualifier     UA UPC case qualifier 2-5-5  2/2    235      ID        M
ex: LIN**UA*001234512345                                                                     UI UPC item qualifier 1-5-5
                                                                                                            UP UPC item qualifier 1-5-5-1
                                                   LIN03    Product Service ID                  UPC 1/48 234 AN M
                                                                                                            Buyer item categories

Note:  
1) All UPCs must be sent within each document, regardless of whether there has been product movement.
2) If a buyer item code is used instead of a UPC code, IBM must set up the appropriate control file definition and UPC code conversion table in advance. The qualifier must be forwarded in advance to IBM in order to set up the appropriate control file definitions and UPC code conversion table.

 
PO4 Item Physical Detail             PO401     Pack                                     Pack quantity                      1/6     356     N0       M
ex: PO4*12

 
ZA Product Activity Reporting     ZA01       Activity code                       See Activity code reporting   2/2      859     ID        M
ex: ZA*QA*150*CA*173*940105      ZA02       Quantity                Amount associated with activity code 1/15    380      R         O
                                                   ZA03       Unit/Basis measure code      EA eaches                           2/2      355     ID        M
                                                                                                            CA cases
                                                   ZA04       Date qualifier                       002 delivery requested        3/3      374     ID        O
                                                                                                            007 effective
                                                                                                            173 week ending, cumulative for a week
                                                   ZA05       Date                                    Activity date (CCYYMMDD)   8/8      373     DT       O
                                                   ZA06       Reference number qualifier   PO, L1, PD                          2/3      128     ID        O
                                                   ZA07       Reference number                PO number, notes, deal#     1/30     127     AN       O

Note:
1) Date qualifier 173 can be sent with all activity codes, but it only applies to QS and QO (See XQ for XQ03 date details).
2) A QA activity code is mandatory for each UPC code and can be sent with either positive, zero, or no quantity.
3) A date in the ZA05 segments overrides the date in the XQ segment. Otherwise, the start date in the XQ segment will be used as the activity date.
4) Effective and week-ending dates can be combined within the same ZA segment. For example, the QA and QP Activity Codes can have effective dates (007) and be combined with the QS and QO Activity Codes with week-ending dates (173).
5) The QD activity code must contain a date qualifier and a date which is equal to, or greater than, today’s date.
6) If the quantity for a QN activity code = 0, the item is discontinued.
7) If the quantity for a QN activity code is > 0, the quantity is used to populate the Requested Order Quantity field within CRP.

Activity Code         Definition
QA                         On Hand Inventory: Quantity of product currently in inventory.
QC                         Quantity Committed:
QD                         Additional Demand:
QN                         Planned Inventory/Requested Order Quantity (ROQ): Specific either the order quantities requested by the
                             retailer or zero to discontinue.
QO                        Out of Stock/Outs: Product that was requested from the warehouse, but was not available.
QP                         On Order: Product that has been ordered, but not yet received.
QS                         Sales: Product sales and warehouse pulls.
QT                         Inventory Adjustment Quantity:
QX                         Quantity Requested: A quantity of zero with this qualifier indicates a discontinued item.

 
SDQ Destination Quantity            SDQ01     Unit/Basis measure code      EA eaches                            2/2      355     ID       M
ex: SDQ*EA*92*1234*0*4321*60                                                              CA cases
      1111*500                               SDQ02     Identification code qualifier  92 assigned by buyer            1/2       66      ID       M
                                                   SDQ03     Identification code               DC store number                  2/80     67      AN      M
                                                   SDQ04     Quantity                                                                        1/15     380     R        M

Note: 
1) The SDQ03 and SDQ04 pair can be repeated up to 10 times in each SDQ segment.

 
CTT Transaction Totals               CTT01     Number of detail line items   Total number of LIN segments 1/6    354     N0      M
ex: CTT*10

 
SE Transaction Set Trailer           SE01       Number segments included in transaction set                     1/10    96      N0      M
ex: SE*35*11111001                      SE02       Transaction set control number                                         4/9     329     AN      M