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