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