Show/Hide All
This field displays the name of the column, and can only be viewed.
This field displays the table's file type, and can only be viewed.
This field displays the data type of the data field. If the field is a temporary field, select a data type. If the field is not a temporary field, the data type can only be viewed.
Select the type of operation to perform on the import field.
Select Replace to import the field from the source file.
Select Assign to assign the field a constant value for all records imported. Enter the value in the Default field.
Select File Assign to assign values from another table, when the key to that table is available from the record. Enter the name of the table in the Table Name field.
Select Run Assign to assign a constant value for all records imported at the time the import is started. in the Prompt field, enter the prompt to be displayed when entering the value at run time.
Select Incr Assign to assign a starting numeric value, which will be incremented by 1 for each record imported.
Select Calculated to assign the field using a valid expression entered in the Calculation field.
Select Next for fields that can receive a "next" number, such as a sales order number, invoice number, or transaction number. You can also use "next" number when generating new customers during the import into AR_Customer table.
If the source is a file type other than ASCII, enter a column number to assign a position for the field. Click Recalc to renumber this and all subsequent fields that have a Replace operation. The Recalc button is availab le only for file types other than ODBC.
If the source is ODBC, specify the source data field that will be imported into the software. Click the Lookup button to list available fields. The Lookup button is available only for the ODBC file type.
This field displays the field type of the data field, and can only be viewed.
Select this check box to import data from part of a field in the source file. For example, you can import just the area code portion of a phone number. Importing data from part of a field may be useful to parse data in ASCII files.
After selecting this check box, type a starting position and length for the substring in the Source Substring Start Pos and Source Substring Length fields.
Clear this check box if you do not want to import data from part of a field.
Type the starting position of the field to assign when the Source Substring check box is selected.
After typing the starting position, type a length for the substring in the Source Substring Length field.
Type the portion of the field to assign when the Source Substring check box is selected. The length cannot exceed the value in the Source Substring Max field.
Type the maximum length from the start of the data field. The value in the Source Substring Length field cannot exceed the value in this field. The default value is the length defined for the field in the data dictionary.
Select this check box to import data to replace part of a field. For example, you can replace just the area code portion of a phone number.
After selecting this check box, type a starting position and length for the substring in the Record Substring Start Pos and Record Substring Length fields.
Clear this check box if you do not want to import data to replace part of a field.
Warning Do not select this check box for validated fields.
Type the starting position of the field to assign when the Record Substring check box is selected.
After typing the starting position, type a length for the substring in the Record Substring Length field.
Type the portion of the field to assign when the Record Substring check box is selected. The length cannot exceed the value in the Record Substring Max field.
This field displays the maximum length from the start of the data field, as defined in the data dictionary, and can only be viewed. The value in the Record Substring Length field cannot exceed the value in this field. The maximum length for temporary fields is 60.
Enter the name of the table to use to assign the import value, or click the Lookup button to list the available tables. Only tables logically linked to the main import file appear. This field is available only if File Assign is selected in the Operation field.
Note Make assignments to the fields representing the key to the linked table before making a file assign. For example, if you are file assigning a purchase order number from the customer file, the ARDivisionNo and Custom erNo fields must already be assigned and imported into the record.
Enter the name of the column to use to assign the import value, or click the Lookup button to list column names for the table selected in the Table Name field. This field is available only if File Assign is selected in the Operation field.
Note Make assignments to the fields representing the key to the linked table before making a file assign. For example, if you are file assigning a purchase order number from the customer file, the ARDivisionNo and CustomerNo fields must already be assigned and imported into the record.
Type the value to assign to the field if the source field is empty. This value is also assigned when Assign is selected in the Operation field. When Replace is selected in the Operation field, this value will only be used if the source field is empty.
Type the prompt to display when entering the value for this data field at run time. You will be prompted for the value in the start of the import job. The prompt can contain up to 30 characters. This field is available only if Run Assign is selected in the Operation field.
Select the import mask used to specify the format of the date information to import. Select the date format based on the related date in the source file record. This field is available only if the field selected is a date-type field.
Enter a valid calculation expression to perform for the data item. This field is available only if Calculated is selected in the Operation field. Click the Expression Builder button to access the Expression Builder feature to build a calculation expression by selecting from a list of data items and operators.
The string or numeric data type used in the expression must be the same as the column name the expression applies to.
Note The calculation expression entered in this field is tested as ColumnName = Expression. This differs from the entry in the Conditional field, which is tested as If Expression THEN ASSIGN = 1 ELSE ASSIGN = 0. In both cases, the user supplies only the expression. A conditional expression often has a = sign or other operator in the expression, while a calculated expression never does.
1000*(AR_Customer.AgingCategory3+AR_Customer.AgingCategory4<>0)
The expression in the parentheses evaluates to 1 or 0 (true or false).
Enter a valid expression to use to determine whether or not to assign the field. The expression must be a true/false expression, and the data type on both sides of any operator must be the same. If the expression evaluates to non-zero or true, the field assignment is made. If the expression evaluates to zero or false, the field assignment is not made. Conditional expressions should be used when the same column name is used more than once for the same import.
Click the Expression Builder button to access the Expression Builder feature to build a conditional expression by selecting from a list of data items and operators.
Note The conditional expression entered in this field is tested as If Expression THEN ASSIGN = 1 ELSE ASSIGN = 0. This differs from the entry in the Calculated field, which is tested as ColumnName = Expression. In both cases, the user supplies only the expression. A conditional expression often has a = sign or other operator in the expression, while a calculated expression never does.
Selectwhen to assign the temporary variable.
Select Key Assigns Only to assign the temporary variable at the same time the field or fields that make up the key to the record are assigned.
Select Header Record to assign the temporary variable at the same time the non-key fields in the header or standard record are assigned.
Select Line Record to assign the temporary variable at the same time the line fields are assigned. This option is available only if the import is a header-line table pair.
This field is available only for temporary fields.
Note Usually, all temporary variables can be assigned with the key fields (Key Assigns Only), so that the value assigned is available for all remaining assignments (header and line fields). But, in some cases, making the assignment too early can result in a null value, because the expression assigning the temporary variable relies on previous assignments having been made. Thus, it is important that you take any such dependencies into consideration when selecting an option in this field.
Select this check box to clear the value of the temporary field after each record is processed. For header files, the reset will occur when the header record is written. For non-header line files, the reset will occur when each record is written. Clear this check box if you do not want to clear the value of the temporary field after each record is processed. This field is available only for temporary fields using the Calculated operation.
