     VI_JobHeader                             Job Header                   Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: N/A
     SQL Def: Y  SysDB: Y                                                       MAS_SYSTEM\VI_JobHeader.M4T

     KPRIMARY: JobName

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  JobName . . . . . . . . . . .    15 SYY  Job Name. . . . . . . . . . . .
       2  JobType . . . . . . . . . . .     1 SYY  Job Type. . . . . . . . . . . .
                                                    Valid:X,I Notes: X=eXport,
                                                    I=Import
       3  CompiledName. . . . . . . . .     6 SNY  Compiled Name . . . . . . . . .
       4  JobCompiled . . . . . . . . .     1 SYY  Job Compiled. . . . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
       5  CurrentState. . . . . . . . .     1 SYY  Current State . . . . . . . . .
                                                    DfltVal:0 Valid:0,1,2,3
                                                    Notes: 0=not running,
                                                    1=waiting for next cycle,
                                                    2=running, 3=stop cycle
       6  UserCode. . . . . . . . . . .     3 SYN  User Code . . . . . . . . . . .
       7  LastCompanyCode . . . . . . .     3 SYN  Last Company Code . . . . . . .
       8  TableName . . . . . . . . . .    30 SNY  Table Name. . . . . . . . . . .
                                                    Notes: Validated against
                                                    Providex.ddf
       9  MenuName. . . . . . . . . . .    40 SNN  Launcher Menu Name. . . . . . .
      10  JobLongDescription. . . . . .   240 SNN  Job Long Description. . . . . .
      11  FieldDelimiter. . . . . . . .     1 SNN  Field Delimiter . . . . . . . .
                                                    Notes: If delimited import
                                                    file
      12  DelimiterAsciiValue . . . . .     3 SNN  Delimiter Ascii Value . . . . .
      13  ImportFileName. . . . . . . .   120 SNN  Import/Export File Name . . . .
                                                    Notes: Include full or
                                                    relative path
      14  ImportFileType. . . . . . . .     1 SNY  Import/Export File Type . . . .
                                                    DfltVal:D Valid:3,4,A,D,O,E,
                                                    L,X Notes: 3=dbase 3+,
                                                    4=lotus wk4, A=Ascii,
                                                    D=Delimited, O=ODBC, E=Excel
                                                    (Version 12), L=Lotus WK3,
                                                    X=eXcel 5.0
      15  ImportFileOnHost. . . . . . .     1 SYY  Import File On Host . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      16  JobPassword . . . . . . . . .     7 SNN  Job Password. . . . . . . . . .
      17  NextJobChain. . . . . . . . .    15 SNN  Next Job Chain. . . . . . . . .
      18  WaitHours . . . . . . . . . .  2.0  NNN  Wait Hours. . . . . . . . . . .
                                                    Mask:00
      19  WaitMinutes . . . . . . . . .  2.0  NNN  Wait Minutes. . . . . . . . . .
                                                    Mask:00
      20  ExecutionLoops. . . . . . . .  2.0  NNN  Execution Loops . . . . . . . .
                                                    Mask:00
      21  CurrentExecutionLoop. . . . .  2.0  NNN  Current Execution Loop. . . . .
                                                    Mask:00
      22  InsertRequiredFields. . . . .     1 SYY  Insert Required Fields at SetupYESNO
                                                    DfltVal:Y Valid:Y,N Notes:
                                                    Not Currently Used
      23  InsertAllFields . . . . . . .     1 SYY  Insert All Fields . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      24  SkipOverExistingRecords . . .     1 SYY  Skip Over Existing Records. . .YESNO
                                                    DfltVal:N Valid:Y,N
      25  ODBCDataSourceName. . . . . .    60 SNN  ODBC Data Source Name . . . . .
      26  DataSourceOnHost. . . . . . .     1 SYY  Data Source On Host . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      27  ODBCLoginUserName . . . . . .    15 SNN  ODBC Login User Name. . . . . .
      28  ODBCLoginPassword . . . . . .    15 SNN  ODBC Login Password . . . . . .
      29  DateCreated . . . . . . . . .     8 SNY  Date Created. . . . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      30  TimeCreated . . . . . . . . .     8 SNY  Time Created. . . . . . . . . .
                                                    Read Only:Y
      31  UserCreatedKey. . . . . . . .    10 SNY  User Created Key. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
      32  DateUpdated . . . . . . . . .     8 SNN  Date Updated. . . . . . . . . .DATE
                                                    Read Only:Y Notes: YYYYMMDD
      33  TimeUpdated . . . . . . . . .     8 SNN  Time Updated. . . . . . . . . .
                                                    Read Only:Y
      34  UserUpdatedKey. . . . . . . .    10 SNN  User Updated Key. . . . . . . .USER
                                                    Read Only:Y Mask:0000000000
      35  SeparateHeaderRecord. . . . .     1 SYY  Separate Header Record. . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      36  ConvertDelimToSpace . . . . .     1 SYY  Convert Delimiter To Space. . .YESNO
                                                    DfltVal:N Valid:Y,N
      37  PadFieldsWithSpaces . . . . .     1 SYY  Pad Fields With Spaces. . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      38  ExportNamesAsFirstRecord. . .     1 SYY  Export Names As First Record. .YESNO
                                                    DfltVal:N Valid:Y,N
      39  DisplayReadOnlyFields . . . .     1 SYY  Display Read Only Fields. . . .YESNO
                                                    DfltVal:N Valid:Y,N
      40  WrapStringInQuotes. . . . . .     1 SYY  Wrap String In Quotes . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      41  SkipSourceDataTruncation. . .     1 SYY  Skip Source Data Truncation . .YESNO
                                                    DfltVal:N Valid:Y,N