     VI_ImportJobDefinitionWrk             VI Import Job Definition Work   Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: N/A
     SQL Def: Y  SysDB: N                                 "MAS_SYSTEM\VI_ImportJobDefinitionWrk"+%S$+".M4T"

     KPRIMARY: SortField

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  SortField . . . . . . . . . .   127 SNN  Sort Field. . . . . . . . . . .
       2  JobName . . . . . . . . . . .    15 SYY  Job Name. . . . . . . . . . . .
       3  ReportPrintSequence . . . . .     1 SNY  Report Print Sequence . . . . .
       4  SequenceNo. . . . . . . . . .     4 SNN  Sequence Number . . . . . . . .
       5  JobType . . . . . . . . . . .     1 SYY  Job Type. . . . . . . . . . . .
                                                    Valid:X,I Notes: X=eXport,
                                                    I=Import
       6  CompiledName. . . . . . . . .    30 SNY  Compiled Name . . . . . . . . .
       7  TableName . . . . . . . . . .    30 SNY  Table Name. . . . . . . . . . .
                                                    Notes: Validated against
                                                    Providex.ddf
       8  MenuName. . . . . . . . . . .    40 SNN  Launcher Menu Name. . . . . . .
       9  JobLongDescription. . . . . .   240 SNN  Job Long Description. . . . . .
      10  FieldDelimiter. . . . . . . .     1 SNN  Field Delimiter . . . . . . . .
                                                    Notes: If delimited import
                                                    file
      11  DelimiterAsciiValue . . . . .     3 SNN  Delimiter Ascii Value . . . . .
      12  ImportFileName. . . . . . . .   120 SNN  Import/Export File Name . . . .
                                                    Notes: Include full or
                                                    relative path
      13  ImportFileType. . . . . . . .     1 SNY  Import/Export File Type . . . .
                                                    DfltVal:D Valid:3,4,A,D,O,F,
                                                    L,X Notes: 3=dbase 3+,
                                                    4=lotus wk4, A=Ascii,
                                                    D=Delimited, O=ODBC, F=dif,
                                                    L=Lotus WK3, X=eXcel 5.0
      14  ImportFileOnHost. . . . . . .     1 SYY  Import File On Host . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      15  NextJobChain. . . . . . . . .    15 SNN  Next Job Chain. . . . . . . . .
      16  WaitHours . . . . . . . . . .  2.0  NNN  Wait Hours. . . . . . . . . . .
      17  WaitMinutes . . . . . . . . .  2.0  NNN  Wait Minutes. . . . . . . . . .
      18  ExecutionLoops. . . . . . . .  2.0  NNN  Execution Loops . . . . . . . .
      19  ODBCDataSourceName. . . . . .    60 SNN  ODBC Data Source Name . . . . .
      20  DataSourceOnHost. . . . . . .     1 SYN  Data Source On Host . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      21  InsertRequiredFields. . . . .     1 SYY  Insert Required Fields at SetupYESNO
                                                    DfltVal:N Valid:Y,N
      22  ColumnName. . . . . . . . . .    30 SNN  Column Name . . . . . . . . . .
      23  DataType. . . . . . . . . . .     1 SYN  Data Type . . . . . . . . . . .
      24  FieldType . . . . . . . . . .     1 SYN  Field Type. . . . . . . . . . .
      25  FileType. . . . . . . . . . .     1 SYN  File Type . . . . . . . . . . .
      26  OperationCode . . . . . . . .     1 SYN  Operation Code. . . . . . . . .
      27  MaskFormat. . . . . . . . . .    20 SNN  Mask Format . . . . . . . . . .
      28  ImportColumnNo. . . . . . . .  5.0  NNN  Import Column Number. . . . . .
      29  ImportStartPos. . . . . . . .  5.0  NNN  Import Start Position . . . . .
      30  ImportLength. . . . . . . . .  5.0  NNN  Import Length . . . . . . . . .
      31  DefaultValue. . . . . . . . .    60 SNN  Default Value . . . . . . . . .
      32  CalcExpression. . . . . . . .   512 SNN  Calc Expression . . . . . . . .
      33  TableAssignName . . . . . . .    30 SNN  Table Assign Name . . . . . . .
      34  TableAssignColumnName . . . .    30 SNN  Table Assign Column Name. . . .
      35  PerformType . . . . . . . . .     2 SNN  Perform Type. . . . . . . . . .
      36  PerformPath . . . . . . . . .   120 SNN  Perform Path. . . . . . . . . .
      37  Condition . . . . . . . . . .     1 SNN  Condition . . . . . . . . . . .
      38  Relation. . . . . . . . . . .     1 SNN  Relation. . . . . . . . . . . .
      39  CaseSensitive . . . . . . . .     1 SYN  Case Sensitive. . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      40  Substring . . . . . . . . . .     1 SYN  Substring . . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      41  StartPosition . . . . . . . .  5.0  NNN  StartPosition . . . . . . . . .
      42  Length. . . . . . . . . . . .  5.0  NNN  Length. . . . . . . . . . . . .
      43  UserInput . . . . . . . . . .     1 SYN  User Input. . . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      44  RangeStart. . . . . . . . . .    40 SNN  Range Start . . . . . . . . . .
      45  RangeEnd. . . . . . . . . . .    40 SNN  Range End . . . . . . . . . . .
      46  SelectionValue. . . . . . . .    40 SNN  Selection Value . . . . . . . .
      47  SelectionList . . . . . . . .   512 SNN  Selection List. . . . . . . . .
      48  SqlStatement. . . . . . . . .  2048 SNN  SQL Statement . . . . . . . . .
      49  ImportSubstring . . . . . . .     1 SYN  Import Substring. . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      50  ImportFieldLength . . . . . .  5.0  NNN  Import Field Length . . . . . .
      51  FieldSubstring. . . . . . . .     1 SYN  Field Substring . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      52  FieldOrigLength . . . . . . .  5.0  NNN  Field Original Length . . . . .
      53  FieldStart. . . . . . . . . .  5.0  NNN  Field Start . . . . . . . . . .
      54  FieldLength . . . . . . . . .  5.0  NNN  Field Length. . . . . . . . . .
      55  Class . . . . . . . . . . . .    30 SNN  Class . . . . . . . . . . . . .
      56  AssignSequence. . . . . . . .  4.0  NNN  Assign Sequence . . . . . . . .
      57  CharacterMatch. . . . . . . .     1 SYN  Character Match . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      58  RunTimePrompt . . . . . . . .    30 SNN  Run Time Prompt . . . . . . . .
      59  IndexType . . . . . . . . . .     1 SNN  Index Type. . . . . . . . . . .
                                                    Valid:K,S,H,L,N
      60  RecordType. . . . . . . . . .     1 SYN  Record Type . . . . . . . . . .
      61  Description . . . . . . . . .    30 SNN  Description . . . . . . . . . .
      62  ImportColPos. . . . . . . . .  5.0  NNN  Import Column/Position. . . . .
      63  StartPos. . . . . . . . . . .  5.0  NNN  Start Position. . . . . . . . .
      64  Value . . . . . . . . . . . .   300 SNN  Value . . . . . . . . . . . . .
      65  ListValues. . . . . . . . . .  1024 SNN  List Values . . . . . . . . . .
      66  ProgramName . . . . . . . . .   120 SNN  Program Name with path. . . . .
      67  SkipOverExistingRecords . . .     1 SYN  Skip Over Existing Records. . .YESNO
                                                    DfltVal:N Valid:Y,N
      68  SeparateHeaderRecord. . . . .     1 SYN  Separate Header Record. . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      69  DateFormatCode. . . . . . . .  2.0  NNN  Date Format Code. . . . . . . .
      70  ConditionalExpression . . . .   512 SNN  Conditional Expression. . . . .
      71  ResetTempVar. . . . . . . . .     1 SYN  Reset Temp Var. . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      72  LibObjectName . . . . . . . .    12 SNN  Lib Object Name . . . . . . . .
      73  SelectionMask . . . . . . . .    40 SNN  Selection Mask. . . . . . . . .
      74  ODBCTableIndex. . . . . . . .     5 SNN  ODBC Table Index. . . . . . . .
                                                    Mask:00000
      75  ODBCTableName . . . . . . . .    60 SNN  ODBC Table Name . . . . . . . .
      76  ODBCFieldIndex. . . . . . . .     5 SNN  ODBC Field Index. . . . . . . .
                                                    Mask:00000
      77  ODBCFieldName . . . . . . . .    60 SNN  ODBC Field Name . . . . . . . .
      78  ODBCFieldType . . . . . . . .    10 SNN  ODBC Field Type . . . . . . . .
                                                    Notes: VARCHAR or DOUBLE
      79  ODBCFieldLength . . . . . . .  5.0  NNN  ODBC Field Length . . . . . . .
                                                    Mask:00000
      80  ODBCLinkTableName1. . . . . .    60 SNN  ODBC Link Table Name 1. . . . .
      81  ODBCLinkTableName2. . . . . .    60 SNN  ODBC Link Table Name 2. . . . .
      82  ODBCLinkFieldName1. . . . . .    60 SNN  ODBC Link Field Name 1. . . . .
      83  ODBCLinkFieldName2. . . . . .    60 SNN  ODBC Link Field Name 2. . . . .
      84  ODBCLinkRelation. . . . . . .     2 SNN  ODBC Link Relation. . . . . . .
      85  IndexedField. . . . . . . . .     1 SYN  Indexed Field . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      86  TableIndex. . . . . . . . . .     5 SNN  Table Index . . . . . . . . . .
                                                    Mask:00000
      87  FieldIndex. . . . . . . . . .     5 SNN  Field Index . . . . . . . . . .
                                                    Mask:00000