Import Field Properties

 

Window Details

 

How Do I...

Navigation

 

Check an Expression

Overview

 

 

 

Fields

 

 

 

 

Related Topics

 

 

Import Job Maintenance

Expression Builder (Import)

 

 

 

Navigation

Select Visual Integrator Main menu > Import Job Maintenance. In the Import Job Selection window, enter a job name and table name, and then click Accept. In the Import Job Maintenance window, click the Data tab and then double-click a field in the data field list box.

Overview

The following information applies only to import jobs for modules other than Material Requirements Planning and Work Order.

Use Import Field Properties to edit import information for the data field. The primary purpose of this task is to map the source of the import data to the data field.

Fields

 

Column Name

Record Substring Length

File Type

Record Substring Max

Data Type

Table Name

Operation

Column Name

Col/Pos

Default

Field Type

Prompt

Source Substring

Date Mask

Source Substring Start Pos

Calculation

Source Substring Length

Conditional

Source Substring Max

Assign Temp On

Record Substring

Clear on each Record

Record Substring Start Pos