Chapter 22: Generating the Point of Sale Download File (GGPD) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 24: Generating the OCC Item Interface File (GOCI) |
Chapter 23: Generating the GERS Item Download File (GGID)
Purpose: Use the Item Download file to download item, SKU and vendor information to the GERS Point of Sale system.
The Item Download file can be produced in two ways:
• enter a date and select F9 at the GERS Download File Screen.
• run the periodic function Generate GERS Item Download. In order to set up this periodic function, use the function name GGERSDN and the program name INR1229. See Work with Periodic Functions Screen.
When you generate the GERS Item Download file, the system selects items that contain a Last change date that is greater than or equal to the date specified for the item download. The Last change date field is updated each time an item, SKU, or vendor item is created or changed.
If the item already exists in the Item Download file, the system overwrites the record with the current information.
If the item does not exist in the Item Download file, the system adds the record to the existing file.
Selecting SKUs for Download
The system selects SKUs based on the first 4 positions of the SKU code. If you are using split SKUs (the Split SKU Inventory (A26) system control value is set to Y), the system downloads SKUs based on SKU Element 1 only.
Example: You sell evening gloves in colors white and black and in sizes short and long. The SKUs for item GL1089 are:
• BLCK LONG
• BLCK SHRT
• WHTE LONG
• WHTE SHRT
When you generate the Item Download file, the system downloads the following records for GL1089:
• GL1089 BLCK
• GL1089 WHTE
In this chapter:
• GERS Item Download File (IXGIDS)
How to display this screen: Enter GGID in the Fast path field at the top of any menu or select Generate GERS Item Download from a menu.
INR1228 ENTER GERS Download File 10/02/98 8:42:42 KAL Company
Date . . . . 100298
F3=Exit F9=Accept F12=Cancel |
Field |
Description |
Date |
The date the system uses to select items and SKUs to populate the GERS Item Download file. The system selects items that contain a Last change date that is greater than or equal to the date you enter. Numeric, 6 positions (MMDDYY format); required. |
GERS Item Download File (IXGIDS)
GERS Field |
GERS Field Attributes |
CWDirect File |
CWDirect Field |
CWDirect Field Attributes |
Field Description |
Item Code |
Alphanumeric, 12 positions |
SKU file |
Item number; SKU code |
Alphanumeric, 12 positions; Alphanumeric, 14 positions |
The first 5 positions of the item number + the first 4 positions of the SKU code. |
Vendor Number |
Numeric, 6 positions |
Item file |
Vendor number |
Numeric, 7 positions |
The first 5 positions of the vendor code defined in the Vendor field for the item. |
Vendor Item Number |
Alphanumeric, 20 positions |
Vendor Item file |
Vendor item number |
Alphanumeric, 20 positions |
The vendor item number for the vendor defined in the Vendor field for the item. If this item contains SKUs, the vendor SKU number displays. |
Sub Class |
Alphanumeric, 6 positions |
SKU file |
Item number |
Alphanumeric, 12 positions |
The first 5 positions of the item number. |
List Price (Initial) |
Numeric, 10 positions with a 2-place decimal |
SKU file |
List price |
Numeric, 7 positions with a 2-place decimal |
The list price defined in the List price field for the item or SKU. |
List Price |
Numeric, 10 positions with a 2-place decimal |
SKU file |
List price |
Numeric, 7 positions with a 2-place decimal |
The list price defined in the List price field for the item or SKU. |
Item Description |
Alphanumeric, 20 positions |
Item file |
Item description |
Alphanumeric, 40 positions |
The first 20 positions of the item description. |
SKU Description |
Alphanumeric, 20 positions |
SKU file |
SKU description |
Alphanumeric, 40 positions |
The first 20 positions of the SKU description. |
Low Price |
Numeric, 10 positions with a 2-place decimal |
SKU file |
Lowest price |
Numeric, 7 positions with a 2-place decimal |
The price defined in the Low price field for the item or SKU. This field represents the manufacturer's suggested retail price. |
SKU |
Alphanumeric, 12 positions |
SKU file |
Item number; SKU code |
Alphanumeric, 12 positions; Alphanumeric, 14 positions |
The first 5 positions of the item number + the first 4 positions of the SKU code + 01. |
Color |
Alphanumeric, 6 positions |
SKU file |
SKU description |
Alphanumeric, 40 positions |
Positions 22-27 of the SKU description. |
Size |
Alphanumeric, 6 positions |
SKU file |
SKU description |
Alphanumeric, 40 positions |
Positions 29-34 of the SKU description. |
UPC |
Alphanumeric, 1 position |
|
This field does not map to a field in CWDirect. |
|
U displays in this field. |
UPC Code |
Alphanumeric, 14 positions |
SKU file |
Retail reference number |
Numeric, 15 positions |
The last 14 positions of the Retail reference number field. |
Unit Of Measure |
Alphanumeric, 3 positions |
|
This field does not map to a field in CWDirect. |
|
EA displays in this field. |
Quantity |
Numeric, 5 positions |
|
This field does not map to a field in CWDirect. |
|
1 displays in this field. |
Weight |
Numeric, 10 positions with a 3-place decimal |
SKU file |
Selling weight override |
Numeric, 7 positions with a 3-place decimal |
The value defined in the Selling weight field for the item or SKU. If a SKU selling weight has not been defined, the system defaults the selling weight defined for the item. |
Chapter 22: Generating the Point of Sale Download File (GGPD) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 24: Generating the OCC Item Interface File (GOCI) |
SO02_11 CWDirect 18.0 August 2015 OTN