Show/Hide All
This field displays the name of the table, and can only be viewed.
This field displays the data type (Number or String) 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.
This field displays the name of the column, and can only be viewed.
This field displays the field type of the data field, and can only be viewed.
Select the type of operation to perform on the export field.
Select Assign to assign a field from the export record. Use this operation for temporary fields to assign a constant value in the Default field or to enter a conditional expression in the Conditional field. Temporary fields with this operation are exported.
Select Run Assign to assign a constant value to a selected column name or temporary field, for all records exported at the time the export is started. At the Prompt field, enter the prompt to be displayed when entering the value at run time. Temporary fields with this operation are exported.
Select Calculated to assign a column name field or temporary field using a valid expression entered in the Calculation field. The expression may contain other temporary fields. Use this operation to assign a value to a temporary field when the field should not be exported but is used in calculation or conditional expressions for other fields.
This field determines the order of the data to export. If the source is a file type other than ASCII, enter a column number to assign a position for the field. For ASCII files, enter the starting position in the source file record where the data begins.
Click Recalc to renumber this and all subsequent fields that have an Assign operation. The Recalc button is av ailable only for file types other than ODBC.
If the source is ODBC, enter the source data field to export. Click the Lookup button to list available fields.
Select this check box to export data from part of a field. For example, you can export 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 Source Substring Start Pos and Source Substring Length fields.
Clear this check box if you do not want to export data from part of a field.
Type the starting position of the field to export 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 export when the Source Substring check box is selected. The value in this field 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 export data into part of a field. For example, you can export just the area code portion of a phone number. This field is primarily for use when exporting ASCII files.
After selecting this check box, type a starting position and length for the substring in the Export Substring Start Pos and Export Substring Length fields.
Clear this check box if you do not want to export data into part of a field.
Type the starting position of the field to be exported into when the Export Substring check box is selected. This field is primarily for use when exporting ASCII files.
After typing the starting position, type a length for the substring in the Export Substring Length field.
Type the portion of the field to be exported into when the Export Substring check box is selected. The length cannot exceed the value in the Export Substring Max field. This field is primarily for use when exporting ASCII files.
Type the maximum length from the start of the data field. The value in the Export Substring Length field cannot exceed the value in this field. The default value is the length defined in the data dictionary, and can be changed.
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.
Type the prompt to display when entering the value for this data field at run time. You will be prompted for the value at the start of the export job. The prompt can contain up to 30 characters. This field is available only if Run Assign is selected in the Operation field.
Enter the mask to use for numeric and date fields. For numeric fields, enter the mask using the ###,###.00- format where # indicates space-filled digits and 0 indicates zero-filled digits. Commas and periods can be specified in the appropriate positions. DB, CR, -, and + can be used to indicate positive or negative values.
For date fields, click the Date Format button to access the Date Format window. The default date mask is MM/DD/YYYY. For more information, seeDate Format.
Enter a valid calculation expression to perform for the data item. 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. This field is available only if Calculated is selected in the Operation field.
The calculation expression consists of valid numeric data items, dates, and/or numeric constants separated by arithmetic operators. The string or numeric data type used in the expression must be the same as the column name the expression applies to. A calculation expression, if not null, will override any default value. If it is null or blank, the default value will be assigned instead.
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 perform for the data item. The conditional expression consists of valid field names, conditional operators, functions, and constant values. 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.
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 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.
Select this check box to add spaces to extend the field to its maximum length. Clear this check box if you do not want to add spaces to the field.
Select this check box to clear the temporary field value for each new record. Clear this check box if you want the temporary field value to carry from one record to the next.
