VI_ExportJobDefinitionWrk             VI Export Job Definition Work   Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: N/A
 SQL Def: Y  SysDB: N                                 "MAS_SYSTEM\VI_ExportJobDefinitionWrk"+%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  InsertAllFields . . . . . . .     1 SYY  Insert All Fields at Setup. . .YESNO
                                                DfltVal:N Valid:Y,N
  22  SkipOverExistingRecords . . .     1 SYN  Skip Over Existing Records. . .YESNO
                                                DfltVal:N Valid:Y,N
  23  SeparateHeaderRecord. . . . .     1 SYN  Separate Header Record. . . . .YESNO
                                                DfltVal:N Valid:Y,N
  24  ConvertDelimToSpace . . . . .     1 SYN  Convert Delimiter to Space. . .YESNO
                                                DfltVal:N Valid:Y,N
  25  PadFieldsWithSpaces . . . . .     1 SYN  Pad Fields With Spaces. . . . .YESNO
                                                DfltVal:N Valid:Y,N
  26  LinkTableName . . . . . . . .    30 SNN  Link Table Name . . . . . . . .
  27  ColumnName. . . . . . . . . .    30 SNN  Column Name . . . . . . . . . .
  28  FileType. . . . . . . . . . .     1 SYN  File Type . . . . . . . . . . .
  29  DataType. . . . . . . . . . .     1 SYN  Data Type . . . . . . . . . . .
  30  FieldType . . . . . . . . . .     1 SYN  Field Type. . . . . . . . . . .
  31  OperationCode . . . . . . . .     1 SYN  Operation Code. . . . . . . . .
  32  NSDMask . . . . . . . . . . .    50 SNN  Mask Format . . . . . . . . . .
  33  SourceOrigLength. . . . . . .  5.0  NNN  Source Original Length. . . . .
  34  SourceSubstring . . . . . . .     1 SYN  Source Substring. . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  35  SourceStartPos. . . . . . . .  5.0  NNN  Source Start Position . . . . .
                                                DfltVal:1 Notes: Relative to
                                                the string field start
                                                position. Default=1
  36  SourceLength. . . . . . . . .  5.0  NNN  Source Length . . . . . . . . .
                                                Notes: Not to exceed
                                                dictionary length. Default =
                                                dictionary length
  37  ExportColPos. . . . . . . . .  5.0  NNN  Export Column Number or Start P
                                                Notes: Start Position for
                                                ASCII, Column Number for
                                                everything else.
  38  ExportFieldLength . . . . . .  5.0  NNN  Export Field Length . . . . . .
                                                Notes: Not limited. Default
                                                = dictionary length
  39  ExportSubstring . . . . . . .     1 SYN  Export Substring. . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  40  ExportLength. . . . . . . . .  5.0  NNN  Export Length . . . . . . . . .
                                                Notes: Limited to Export
                                                Field Length
  41  PadWithSpaces . . . . . . . .     1 SYN  Pad With Spaces . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  42  DefaultValue. . . . . . . . .    60 SNN  Default Value . . . . . . . . .
  43  CalcExpression. . . . . . . .   512 SNN  Calc Expression . . . . . . . .
  44  ConditionalExpression . . . .   512 SNN  Conditional Expression. . . . .
  45  CalculationOnly . . . . . . .     1 SYN  Calculation Only. . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  46  ResetTempVar. . . . . . . . .     1 SYN  Reset Temp Variable . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  47  PartOfODBCIndex . . . . . . .     1 SYN  Part of ODBC Index. . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  48  Condition . . . . . . . . . .     1 SNN  Condition . . . . . . . . . . .
  49  Relation. . . . . . . . . . .     1 SNN  Relation. . . . . . . . . . . .
  50  CaseSensitive . . . . . . . .     1 SYN  Case Sensitive. . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  51  CharacterMatch. . . . . . . .     1 SYN  Character Match . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  52  SelectBegin . . . . . . . . .    60 SNN  Select Begin. . . . . . . . . .
  53  SelectEnd . . . . . . . . . .    60 SNN  Select End. . . . . . . . . . .
  54  OriginalStartPos. . . . . . .  5.0  NNN  Original Start Position . . . .
  55  OriginalLength. . . . . . . .  5.0  NNN  Original Length . . . . . . . .
  56  Substring . . . . . . . . . .     1 SYN  Substring . . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  57  UserInput . . . . . . . . . .     1 SYN  User Input. . . . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  58  RunTimePrompt . . . . . . . .    30 SNN  Run Time Prompt . . . . . . . .
  59  PerformType . . . . . . . . .     2 SNN  Perform Type. . . . . . . . . .
  60  PerformPath . . . . . . . . .   120 SNN  Perform Path. . . . . . . . . .
  61  RangeStart. . . . . . . . . .    40 SNN  Range Start . . . . . . . . . .
  62  RangeEnd. . . . . . . . . . .    40 SNN  Range End . . . . . . . . . . .
  63  SelectionValue. . . . . . . .    40 SNN  Selection Value . . . . . . . .
  64  SelectionMask . . . . . . . .    40 SNN  Selection Mask. . . . . . . . .
  65  SelectionList . . . . . . . .   512 SNN  Selection List. . . . . . . . .
  66  SelectionSeq. . . . . . . . .   300 SNN  Selection Sequence. . . . . . .
  67  SortOrder . . . . . . . . . .     1 SYN  Sort Order. . . . . . . . . . .
                                                DfltVal:A Valid:A,D
  68  StartPosition . . . . . . . .  5.0  NNN  Start Position. . . . . . . . .
  69  Length. . . . . . . . . . . .  5.0  NNN  Length. . . . . . . . . . . . .
  70  SqlStatement. . . . . . . . .  2048 SNN  SQL Statement . . . . . . . . .
  71  Class . . . . . . . . . . . .    30 SNN  Class . . . . . . . . . . . . .
  72  Mask. . . . . . . . . . . . .    30 SNN  Mask. . . . . . . . . . . . . .