VI_ImportJobDefinitionWrk VI Import Job Definition Work Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N "MAS_SYSTEM\VI_ImportJobDefinitionWrk"+%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 InsertRequiredFields. . . . . 1 SYY Insert Required Fields at SetupYESNO
DfltVal:N Valid:Y,N
22 ColumnName. . . . . . . . . . 30 SNN Column Name . . . . . . . . . .
23 DataType. . . . . . . . . . . 1 SYN Data Type . . . . . . . . . . .
24 FieldType . . . . . . . . . . 1 SYN Field Type. . . . . . . . . . .
25 FileType. . . . . . . . . . . 1 SYN File Type . . . . . . . . . . .
26 OperationCode . . . . . . . . 1 SYN Operation Code. . . . . . . . .
27 MaskFormat. . . . . . . . . . 20 SNN Mask Format . . . . . . . . . .
28 ImportColumnNo. . . . . . . . 5.0 NNN Import Column Number. . . . . .
29 ImportStartPos. . . . . . . . 5.0 NNN Import Start Position . . . . .
30 ImportLength. . . . . . . . . 5.0 NNN Import Length . . . . . . . . .
31 DefaultValue. . . . . . . . . 60 SNN Default Value . . . . . . . . .
32 CalcExpression. . . . . . . . 512 SNN Calc Expression . . . . . . . .
33 TableAssignName . . . . . . . 30 SNN Table Assign Name . . . . . . .
34 TableAssignColumnName . . . . 30 SNN Table Assign Column Name. . . .
35 PerformType . . . . . . . . . 2 SNN Perform Type. . . . . . . . . .
36 PerformPath . . . . . . . . . 120 SNN Perform Path. . . . . . . . . .
37 Condition . . . . . . . . . . 1 SNN Condition . . . . . . . . . . .
38 Relation. . . . . . . . . . . 1 SNN Relation. . . . . . . . . . . .
39 CaseSensitive . . . . . . . . 1 SYN Case Sensitive. . . . . . . . .YESNO
DfltVal:N Valid:Y,N
40 Substring . . . . . . . . . . 1 SYN Substring . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
41 StartPosition . . . . . . . . 5.0 NNN StartPosition . . . . . . . . .
42 Length. . . . . . . . . . . . 5.0 NNN Length. . . . . . . . . . . . .
43 UserInput . . . . . . . . . . 1 SYN User Input. . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
44 RangeStart. . . . . . . . . . 40 SNN Range Start . . . . . . . . . .
45 RangeEnd. . . . . . . . . . . 40 SNN Range End . . . . . . . . . . .
46 SelectionValue. . . . . . . . 40 SNN Selection Value . . . . . . . .
47 SelectionList . . . . . . . . 512 SNN Selection List. . . . . . . . .
48 SqlStatement. . . . . . . . . 2048 SNN SQL Statement . . . . . . . . .
49 ImportSubstring . . . . . . . 1 SYN Import Substring. . . . . . . .YESNO
DfltVal:N Valid:Y,N
50 ImportFieldLength . . . . . . 5.0 NNN Import Field Length . . . . . .
51 FieldSubstring. . . . . . . . 1 SYN Field Substring . . . . . . . .YESNO
DfltVal:N Valid:Y,N
52 FieldOrigLength . . . . . . . 5.0 NNN Field Original Length . . . . .
53 FieldStart. . . . . . . . . . 5.0 NNN Field Start . . . . . . . . . .
54 FieldLength . . . . . . . . . 5.0 NNN Field Length. . . . . . . . . .
55 Class . . . . . . . . . . . . 30 SNN Class . . . . . . . . . . . . .
56 AssignSequence. . . . . . . . 4.0 NNN Assign Sequence . . . . . . . .
57 CharacterMatch. . . . . . . . 1 SYN Character Match . . . . . . . .YESNO
DfltVal:N Valid:Y,N
58 RunTimePrompt . . . . . . . . 30 SNN Run Time Prompt . . . . . . . .
59 IndexType . . . . . . . . . . 1 SNN Index Type. . . . . . . . . . .
Valid:K,S,H,L,N
60 RecordType. . . . . . . . . . 1 SYN Record Type . . . . . . . . . .
61 Description . . . . . . . . . 30 SNN Description . . . . . . . . . .
62 ImportColPos. . . . . . . . . 5.0 NNN Import Column/Position. . . . .
63 StartPos. . . . . . . . . . . 5.0 NNN Start Position. . . . . . . . .
64 Value . . . . . . . . . . . . 300 SNN Value . . . . . . . . . . . . .
65 ListValues. . . . . . . . . . 1024 SNN List Values . . . . . . . . . .
66 ProgramName . . . . . . . . . 120 SNN Program Name with path. . . . .
67 SkipOverExistingRecords . . . 1 SYN Skip Over Existing Records. . .YESNO
DfltVal:N Valid:Y,N
68 SeparateHeaderRecord. . . . . 1 SYN Separate Header Record. . . . .YESNO
DfltVal:N Valid:Y,N
69 DateFormatCode. . . . . . . . 2.0 NNN Date Format Code. . . . . . . .
70 ConditionalExpression . . . . 512 SNN Conditional Expression. . . . .
71 ResetTempVar. . . . . . . . . 1 SYN Reset Temp Var. . . . . . . . .YESNO
DfltVal:N Valid:Y,N
72 LibObjectName . . . . . . . . 12 SNN Lib Object Name . . . . . . . .
73 SelectionMask . . . . . . . . 40 SNN Selection Mask. . . . . . . . .
74 ODBCTableIndex. . . . . . . . 5 SNN ODBC Table Index. . . . . . . .
Mask:00000
75 ODBCTableName . . . . . . . . 60 SNN ODBC Table Name . . . . . . . .
76 ODBCFieldIndex. . . . . . . . 5 SNN ODBC Field Index. . . . . . . .
Mask:00000
77 ODBCFieldName . . . . . . . . 60 SNN ODBC Field Name . . . . . . . .
78 ODBCFieldType . . . . . . . . 10 SNN ODBC Field Type . . . . . . . .
Notes: VARCHAR or DOUBLE
79 ODBCFieldLength . . . . . . . 5.0 NNN ODBC Field Length . . . . . . .
Mask:00000
80 ODBCLinkTableName1. . . . . . 60 SNN ODBC Link Table Name 1. . . . .
81 ODBCLinkTableName2. . . . . . 60 SNN ODBC Link Table Name 2. . . . .
82 ODBCLinkFieldName1. . . . . . 60 SNN ODBC Link Field Name 1. . . . .
83 ODBCLinkFieldName2. . . . . . 60 SNN ODBC Link Field Name 2. . . . .
84 ODBCLinkRelation. . . . . . . 2 SNN ODBC Link Relation. . . . . . .
85 IndexedField. . . . . . . . . 1 SYN Indexed Field . . . . . . . . .YESNO
DfltVal:N Valid:Y,N
86 TableIndex. . . . . . . . . . 5 SNN Table Index . . . . . . . . . .
Mask:00000
87 FieldIndex. . . . . . . . . . 5 SNN Field Index . . . . . . . . . .
Mask:00000