What do you want to do?
You can Create, Amend or Delete records in the file ZZ.MS.advpf. After creating a new record the form provides an opportunity to start with a blank record or using the last record saved as template for the new record. The ellipsis buttons previews the possible choices.
Code: Arbitrary 3 character code to act as the key to the record. This ID should be entered by the user.
Description: Short description of the current code.
Franchise Letter: Parts franchise letter. It must exist in the Stock management Franchise table.
GFT Record ID: This record is used to pick up the file for this supplier.
Conversion Map ID: ID of the conversion mapping used by this supplier.
BUTTONS:
Mapping Configuration Accesses the next form. The contents are explained in the next point of this document.
You can Create, Amend or Delete records in the file ZZ.MS.advmd. After creating a new record the form provides an opportunity to start using a blank record or using the last record saved as template for the new record. The ellipsis buttons previews the possible choices.
Header Rows: Number of header rows there are in the file. It can be set to zero to define no header records in the file.
Trailer Rows: Number of trailer rows there are in the file. It can be set to zero to define no trailer records in the file.
File Type: There are two choices for this field:
- C - CSV format (default value)
- F - Fixed format
Maximum Length: Maximum length of the rows in the input file and can only be specified if the File Type is set to Fixed.
Separator: Type the character used in the input file as field separator. This can be any character with graphical representation. For example the TAB character is not allowed.
Minimum Elements: Type the minimum element number of fields in a row of the input file when the file type is C (csv format). If a row has fewer fields than the number set in this field the row is rejected.
BUTTONS:
Supplier Formats: Returns the user to the Supplier format form.
Mapping Detail: Accesses the next form. The contents are explained in the next point of this document. Only enabled if there is a record selected in the current form.
You can Create, Amend or Delete records in the file ZZ.MS.advml. After creating a new record the form provides an opportunity to start using a blank record or using the last record saved as template for the new record. The ellipsis buttons previews the possible choices.
Mapping Id: The value of this field is derived from the previous form where its mandatory to select a record to access this form.
Field Name: Type the field of the file 00.MS.advno you want to set up. (The program will not allow you to assign some specifics fields).
Element Number: If the selected field is an array then type here the number of the element of the array you wan to set up.
Field Definition: Text field when the program shows the description, type, image and number of elements from the field definition in the 00.MS.advno file.
Assignation Type: Choose the type of assignation you want for the current field. The choices are M (mapping field), F (fixed value) and P (prompt value). According to the value you choose in this field the program will activate or deactivate several fields in the form.
This option let you assign a value from the input file to the field you are setting in the ZZ.MS.advno file. The value assigned to the field depends on the value you set in the field Line Number.
- Fixed Field This option let you assign a fixed value to all the records to the field you are setting in the ZZ.MS.advno file. This value is fixed and specified in the Fixed Value field and will not change for the current input file.
- Prompted Field This option let you type the value you want to assign to the field you are setting when the program reads the input file. The program will ask you for the value for each detail record read from the input file. If the input file has 20 detail rows the question will be done 20 times. The option to assign the same value to all records exits as explained below.
Line Number: Type the line number of the input file from which you want to read the value to assign to the current field.
- Line Number equal to zero If you do not type a value in this field the program assumes that the value of the field is read from the detail rows of the input file.
- Line Number over zero If you type a value (positive number) in this field the program assumes that the value of the field is read from a header row. Specifically from the line number.
- Line number under zero If you type a value (negative number) in this field the program assumes that the value of the field is read from a trailer row. Specifically from the line number you type here in reversed order. It means that value -1 is the last row in the file, not the first trailer row of the file.
Field Number: If the input file is a csv format type the field number (in order) from the input file where the information you want is located. If you type 4 then the program assumes you want to assign the 4th field from the row of the input file in order starting on the left side.
Start Position: If the input file is a fixed format type the exact position of the row from the input file where the information you want is located. If you type 43 then the program assumes you want a value from the row of the input file that starts in the 43rd character starting on the left side.
Length: If the input file is a fixed format, type the exact length of the information you want to assign to the current field. The length includes the value of the field start position as part of the information you want to assign to the current field.
Operator: If you want to do a mathematical operation with the value read from the input file select what kind of operation you want to do. The operation is done before the value is assigned to the current field.
Operator Value: Type the value that you want to operate. This value is used with the previous field value.
Fixed Value: If the assignation type to the current field is fixed, type the value you want to assign to the current field.
Prompt Text: If the assignation type to the current field is prompt, type the label of the form to derive the value for the current field. It assists the user to understand the kind of information required
BUTTONS:
Fields List: Opens a standard form, a selection list of field names. The button is only available after the Create option is used.
Detail: Opens a new form that displays the whole configuration of the current Map Id.
Mapping Configuration: Returns you to the 'Mapping Configuration for Input Files' form.
Supplier Formats: Returns you to the Supplier format form.