Item Upload Processed Records Report

Purpose: Use this report to review records from the Retail Integration Item Upload file that processed successfully.

This report sorts in request type/request date/request time/record type/item/SKU sequence.

For more information: See Retail Integration Item Upload File (RIIUPP) for a discussion of the information on this report.

How to print: Press F9 at the Work with Retail Item Upload Screen to process the Retail Integration Item Upload File (RIIUPP).

CWDirect Rel 5.0 Item Upload Processed Records Report KBOTTGER INR1733 12/27/00 8:48:24 Page 1 KAB Co. Request Type: A Add Request Request Record Date Time Type Item SKU 12/27/00 8:23:00 Item/SKU RIIUPP2 Request Request Record Item Date Time Type Item SKU Offer 12/27/00 8:45:00 Item Offer RIIUPP2 RET Request Request Record Itm Prc Effective Itm Prc Date Time Type Item SKU Offer Date Quantity 12/27/00 8:48:00 Item Price RIIUPP2 RET 12/27/00 0000001 Request Request Record UPC Date Time Type Item SKU Type UPC # 12/27/00 8:53:00 Item UPC RIIUPP2 E8 00000088997764 Number of processed records for request A Add : 4 Total # of records processed: 4

Contents:

• Request type: a code indicating the type of information processed through the item upload.

• A: Add

• C: Change

• D: Delete

• Request date: The date the item upload record was created.

• Request time: The time the item upload record was created.

• Record type: A description of the type of information processed through the item upload.

• Item/SKU

• Item/Offer

• SKU/Offer

• Item Price

• SKU Price

• Vendor Item

• Item UPC

• Item Coordinate

• SKU Cross Reference

• Item: A code for the item associated with the item upload record.

• SKU: A code for the SKU associated with the item upload record.

Additional field for Item/Offer record types:

• Item offer: A code for the offer associated with the Item/Offer record type.

Additional field for SKU/Offer record types:

• SKU offer: A code for the offer associated with the SKU/Offer record type.

Additional fields for Item Price record types:

• Item price offer: A code for the offer associated with the Item price record type.

• Effective date: The date the item price becomes effective.

• Item price quantity: The amount of the item that a customer must order to receive this item offer price.

Additional fields for SKU Price record types:

• SKU price offer: A code for the offer associated with the SKU price record type.

• Effective date: The date the SKU price becomes effective.

• SKU price quantity: The amount of the SKU that a customer must order to receive this SKU offer price.

Additional fields for Vendor Item record types:

• Vendor number: A code for the vendor associated with the Vendor Item record type.

• Vendor item number: A code the vendor uses to identify the item.

Additional fields for Item UPC record types:

• UPC type: The type of UPC code. The UPC type determines the type of validation the system performs against the UPC code.

• UPC number: The UPC code defined for the item/SKU.

Additional fields for Item Coordinate record types:

• Coordinate item: The related item you are coordinating to the primary item for cross-selling purposes.

• Type: A code representing a type of item coordinate, such as mandatory or optional.

• Coordinate SKU: The coordinate item's unique characteristics, such as its color or size.

Additional fields for SKU Cross Reference record types:

• SKU Xref #: A cross-reference number to identify the item/SKU in an external system.

• Xref Type: A code identifying the external system that uses the cross reference number and indicates whether you can add the item/SKU to an order by entering the SKU cross reference number in the Item field.

• Number of processed records: The total number of records processed for a specific request type.

• Total number of records processed: The total number of records processed across all request types.