Vendor Catalogue Definition File

Using the file layout supplied by the Vendor, the description and the size of each information field in the file must be defined before the Vendor Parts Price file can be imported in the Vendor Parts Standard Import utility.

The prompts are:

VENDOR #

Enter the vendor number assigned to this supplier or select it from the Vendor Search window.

FILE NAME

Enter the file name assigned to the Vendor Price file, exactly as it was copied into the pro4data directory.
In LINUX, this must be in lower case.
e.g. wdcat99.txt

In Add mode, enter the new Vendor Price text file name.

In Change mode, the current name of the Vendor Price text file displays.
This can be over-typed with the correct text file name as required.

File Definitions:

DESCRIPTION

The following four field descriptions display:

PRODUCT #
DESCRIPTION
COST
LIST

FROM COLUMN

Enter the starting column number for each of these four fields per the file layout.

TO COLUMN

Enter the ending column number for each field per the file layout.

ASSIGN DECIMAL

This field is used to determine how many decimal places the imported values should be given, as explained by the following examples:

• In the import text File, the value for the Cost field is 1000 but the actual value is 10.00 (10 dollars).
  To get the actual value of 10.00, put a "2" in the Assign Decimal for the Cost Field.
• If the value in the import text file already includes decimal places such as 10.12, do NOT put a "2" is put in the Assign Decimal field, or the value for the Cost field will be interpreted as 0.1012
• If the Assign Decimal field is left blank, then the value will be imported exactly as it is from the import file.

Additional Descriptions:

Eight additional description fields and column positions can be added according to the information contained in the text file, and explained on the file layout supplied by the vendor.

Finished ?

Click ACCEPT to accept, or CANCEL to abort.

The Vendor Parts Standard Import utility can now be used to import the Vendor Price file according to these field definitions.