Chapter 24: Generating the OCC Item Interface File (GOCI)
Overview: The OCC Item Interface file passes inventory, pricing, and offer information to an outside call center.
The OCC Item Interface file can be produced in two ways:
• select F9 at the Generate OCC Item Interface File menu option.
• run the Generate Outside Call Center Item Interface File periodic function. In order to set up this periodic function, use the program name PFR0055. See Work with Periodic Functions Screen.
When you generate the OCC Item Interface file, the system:
• creates an active procedure so that another user cannot submit the OCC Item Interface batch program while the program is already running. An error message similar to the following displays if you try to generate the OCC Item Interface file while the batch program is currently running:
OCC Item Interface file is currently running.
• clears any records that currently exist in the OCC Item Interface file.
• selects all items and SKUs for the company from which you submitted the OCC Item Interface batch program to populate the OCC Item Interface file.
• deletes the active procedure once the OCC Item Interface file has been populated.
In this chapter:
• Generate OCC Item Interface Screen
• OCC Item Interface File (IXOIIP)
Generate OCC Item Interface Screen
How to display this screen: Enter GOCI in the Fast path field at the top of a menu or select Generate OCC Item Interface File from a menu.
INR1608 ENTER Generate OCC Item Interface 11/02/99 9:21:34 KAL Co.
** Press F9 to Generate the OCC Item Interface File. **
F3=Exit F9=Submit F12=Cancel |
OCC Item Interface File (IXOIIP)
Field |
Attributes |
CWDirect Field |
Description |
Item |
Alphanumeric, 12 positions |
Item field from SKU file |
A code that represents the item. |
SKU |
Alphanumeric, 14 positions |
SKU field from SKU file |
A code that represents the SKU for the item. |
Item description |
Alphanumeric, 40 positions |
Item description from Item file |
The CWDirect item description. |
Item price |
Alphanumeric, 7 positions |
Price from Price Table Item Detail file |
This field is zero filled and right justified. Example: 49.99 displays as 00049.99. If the number is greater than 6 positions with a 2-place decimal, the number is truncated. Example: 12345.67 displays as 2345.67. The price defined in the SALE price table for level 1 displays. If a price has not been defined for the SALE price table for level 1, 0000.00 displays. |
Qty |
Numeric, 6 positions |
Calculated field |
The quantity available for this item. The system uses the following calculation to determine the quantity available: on hand - protected - reserved - reserve transfer - backordered = quantity available To determine the quantity for each of the fields in the quantity available calculation, the system adds the fields for all item warehouse records whose allocatable flag is set to Y. |
Availforbo |
Numeric, 6 positions |
Open quantity in PO Layer file |
The quantity on order for this item. To determine the quantity on order, the system adds all records in the PO Layer file with a blank (open) status. |
BO Y/N |
Alphanumeric, 1 position |
Y/N field |
If the backorder quantity in any item/warehouse for this item is greater than zero, this field is Y. If the backorder quantity for each item/warehouse for this item is zero, this field is N. |
Special handling code |
Alphanumeric, 1 position |
Special handling field from SKU/Offer file or Special handling field from Item/Offer file |
For the most recent offer, the system checks the special handling field for the SKU/offer. If a SKU/offer does not exist, the system checks the special handling field for the item/offer. • If the special handling field is set to Y, this field is Y. • If the special handling field is set to N or blank, this field is set to N. Note: The system determines the most recent offer by the SKU/offer whose effective date is closest to, but not after, the current date. |
Special handling description |
Alphanumeric, 36 positions |
Description field from Additional Charge file |
If the special handling code is set to Y, and a special handling code is defined, the description of the code from the Additional Charge file displays. |
Next expected date |
Numeric, 8 positions (YYYYMMDD format) |
Due date field in PO Layer file |
The oldest due date for this item and warehouse in the PO Layer file with a blank (open) status. |
| Chapter 23: Generating the GERS Item Download File (GGID) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 25: Working with the DMT Interface |
SO02_12 CWDirect 18.0 August 2015 OTN