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