     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. . . . . . . . . . . . . .