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