Using the (+L) Screen

Custom Pricing Files

When the (+L) Create eGate Upload Files Screen is used to create custom pricing. Four files are created:

• Price file (PRCE)

• Item file (ITEM)

• Vendor file (VEND)

• Category file (CATG).

Since these files are converted to an ASCII text file, the file name is limited to eight characters. Four of these characters are used as a file prefix. The file prefixes are listed above. The program attaches the appropriate prefixes to each file.

The first file created is the Price file. The Price file contains a record for every item that is either a contract item for this customer or an item that falls within the limits that you set. The Item file, Vendor file, and Category file contain information only for items setup in your inventory that meet the limits that you set in the (+L) screen.

Each of these four files are described below. After you read the descriptions of these files, you can decide which files to transfer to your e-commerce connection based on the information they requested.

The Price file contains a record for each item that is either included on the customer's contract or included within the set limits. This file also contains the following information:

•  Item list price

•  Selling price of the item

•  Company name (from the company field in the (E) screen)

•  Alias number (if applicable).

The contents of this file are sorted by prefix and stock number order. All items with the same prefix are grouped together, and arranged by stock number within each prefix.

When using this custom pricing program, you use the File Suffix field to specify which customer to use for which files. For example, if your customer is A&A Office Products, in the File Suffix field, type AAOP. The name of the Price file for A&A Office Products would be PRCEAAOP.

The Item file contains only items that are setup in your inventory that meet the limits that you set in the (+L) screen. This file also contains the following information:

• Item description   

• Substitute item number

• Company field   

• List price

• Product code    

• Selling price

• UPC number    

• Retail unit of measure.

• Customer alias number

• The contents of this file are sorted by prefix and stock number order.

When using this custom pricing program, you use the File Suffix field to specify which customer to use for which files. For example, if your customer is A&A Office Products, in the File Suffix field, type AAOP. The name of the Item file for A&A Office Products would be ITEMAAOP.

The Vendor file contains a listing of vendors who have items in the item file. This file is sorted in company name order (from the company field in the (E) screen).

This file also contains the Vendor number from the Direct Buy record as well as the full vendor name from the Vendor Master File (V-MASTER), if the following conditions are met.

Note: The contents of the V-MASTER file can be viewed in the (C) Vendor Master screen.

• For the Vendor number from the Direct Buy record to be included in this file, the item must have a Direct Buy record with the vendor name entered. For the full vendor name to be added to the file, the vendor in the Direct Buy record must match a vendor number in the V-MASTER file. When the program finds a match between the vendor in the item's Direct Buy record and a vendor number in the V-MASTER file, then the full vendor name is moved to the vendor file.

• When using this custom pricing program, you use the File Suffix field to specify which customer to use for which files. For example, if your customer is A&A Office Products, in the File Suffix field, type AAOP. The name of the Vendor file for A&A Office Products would be VENDAAOP.

The Category file contains the product codes from the SIC field. The extended description corresponding to that SIC code is added to the Category file. Therefore, the SIC codes and their extended descriptions must be entered for all items that are in the inventory database. After SIC codes have been entered in the SIC field of the (E) screen, you can enter extended descriptions for these items in the (EX) Extended Descriptions screen. The Category file only contains one entry for each SIC code and extended description.

Note: You can load the SIC codes using the O/PUS update if your wholesaler makes them available.

When using this custom pricing program, you use the File Suffix field to specify which customer to use for which files. For example, if your customer is A&A Office Products, in the File Suffix field, type AAOP. The name of the Category file for A&A Office Products would be CATGAAOP.