Field Properties (Temporary Fields)
Show/Hide All
This field displays the name of the temporary field. This field can only be viewed. The field names are assigned automatically, along with the descriptions.
Name
Description
TEMP01
Temporary Field #01
TEMP02
Temporary Field #02
Select a data type for the temporary field.
Select the operation type for the temporary field.
Select Assign to assign a specified value to the field.
Select Calculated to perform a calculation to assign a value to the field. It will be exported unless the Calculation Only check box is selected.
Select Runtime to prompt the user for the value to be assigned when the job is run.
Select this check box if the temporary field is used only to store a calculated value without exporting the value to the target file. The calculated results can be used to accumulate totals or counters. The value in the temporary field can be referenced by other calculations.
Select this check box to clear the temporary field value for each new record. Clear this check box if you want calculation results from previous calculations to carry from one record to the next.
Enter the source data field, or click the Lookup button to list all available fields.
Type the value to assign to the temporary field.
Type 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 Format Date button to activate the Date Format feature.
######0.00-
Type a valid calculation expression to perform for the field. The calculation expression consists of valid numeric data items, dates, and/or numeric constants separated by arithmetic operators. The field names must be enclosed in curly brackets { }. This field is available only if Calculated is selected in the Operation field.
Click the Tools button to access the Expression Builder, which allows you to build a calculation expression by selecting from a list of data items and operators.
Type the prompt to display for runtime fields when the job is executed. Click the Case Change button to change the text from uppercase to lowercase, and vice versa. This field is available only if Runtime is selected in the Operation field.
Type the initial (default) value to assign to a runtime field. This field is available only if Runtime is selected at the Operation field.
