Record Properties - Fields

 

Record Properties

Expand/Collapse all Show/Hide All

Record Type

This field displays the selected record type, and can only be viewed.

 

Field

Type a source field.

 

Column Name

This field displays the name of the column, and can only be viewed.

 

Start

Type the starting position within the data field to evaluate. The default value for this field is 1.

 

Length

Type the length of the portion of the data field to evaluate.

 

Relation

Select the type of relationship to use to evaluate the record type. The following options are available.

The Search option allows you to enter part of the field for which to search. The Program option allows you to enter a ProvideX program name to run to identify the record type.

Expand/Collapse item Example - Using the Search option

You could select that a record is an item record when the imported field contains XYZ. If the text XYZ is contained anywhere within the data field, the record is identified.

 

 

Value

Type the value to use to identify the record type. If the data stored in the source record compares to the value entered in the Value field using the relationship selected, the record will be imported. This field is available only if you select an option other than List, Range, or Program in the Relation field.

 

Beg/End

Type the starting and ending values to use for the Range relation. If the data stored in the source record is equal to or within the range of the two values, the record will be imported. These fields are available only if Range is selected in the Relation field.

 

Program

Type the path and name of the external program to execute. This field is available only if Program is selected in the Relation field.

 

List

Type the list of values to use for the List relation. If the data stored in the source record is equal to one of the values in the list, the record will be imported. This field is available only if List is selected in the Relation field.