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