VI_JobImportElements                    Job Import Elements           Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: N/A
 SQL Def: Y  SysDB: Y                                               MAS_SYSTEM\VI_JobImportElements.M4T

 KPRIMARY: JobName+SequenceNo
 KCOLUMNNAME: ColumnName+JobName+SequenceNo

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  JobName . . . . . . . . . . .    15 SYY  Job Name. . . . . . . . . . . .
   2  SequenceNo. . . . . . . . . .     4 SNY  Sequence Number . . . . . . . .
                                                Mask:0000 FmtType:ZEROFILL
   3  ColumnName. . . . . . . . . .    30 SNY  Column Name . . . . . . . . . .
   4  DataType. . . . . . . . . . .     1 SNY  Data Type . . . . . . . . . . .
                                                Valid:S,N Notes: S=String,
                                                N=Number
   5  FieldType . . . . . . . . . .     1 SYY  Field Type. . . . . . . . . . .
                                                Valid:D,S,T,Y Notes: D=Date,
                                                S=Standard, T=Temp variable,
                                                Y=Yesno
   6  FileType. . . . . . . . . . .     1 SYY  File Type . . . . . . . . . . .
                                                DfltVal:S Valid:K,H,L,S,T
                                                Notes: K=Key assigns only,
                                                H=Header record, L=Line
                                                record, S=Standard record,
                                                T=Tier 3 record
   7  OperationCode . . . . . . . .     1 SYY  Operation Code. . . . . . . . .
                                                Valid:A,R,I,F,C,T,N Notes:
                                                A=Assign, R=Replace,
                                                I=Increment assign, F=File
                                                assign, C=Calculate, T= run
                                                Time, N=Next
   8  MaskFormat. . . . . . . . . .    20 SNN  Mask Format . . . . . . . . . .
   9  DateFormatCode. . . . . . . .  2.0  NNY  DateFormatCode. . . . . . . . .
  10  ImportColumnNo. . . . . . . .  5.0  NNY  Import Column No. or ASCII Star
  11  ImportStartPos. . . . . . . .  5.0  NNY  Import Start Position . . . . .
                                                Notes: Relative to Import
                                                Column No
  12  ImportLength. . . . . . . . .  5.0  NNY  Import Length . . . . . . . . .
                                                Notes: Up to dictionary
                                                length (Tempxxx = 60)
  13  DefaultValue. . . . . . . . .    60 SNN  Default Value . . . . . . . . .
                                                Notes: If imported field is
                                                blank
  14  CalcExpression. . . . . . . .   512 SNN  Calc Expression . . . . . . . .
  15  ConditionalExpression . . . .   512 SNN  Conditional Expression. . . . .
  16  RunTimePrompt . . . . . . . .    30 SNN  Run Time Input Prompt . . . . .
  17  ResetTempVar. . . . . . . . .     1 SYN  Reset Temp Variable Each RecordYESNO
                                                DfltVal:N Valid:Y,N
  18  TableAssignName . . . . . . .    30 SNN  Table Assign Name . . . . . . .
  19  TableAssignColumnName . . . .    30 SNN  Table Assign Column Name. . . .
  20  LibObjectName . . . . . . . .    12 SNN  Lib Object Name . . . . . . . .
  21  ImportSubstring . . . . . . .     1 SYN  Import Substring. . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  22  ImportFieldLength . . . . . .  5.0  NNN  Import Field Length . . . . . .
  23  FieldSubstring. . . . . . . .     1 SYN  Field Substring . . . . . . . .YESNO
                                                DfltVal:N Valid:Y,N
  24  FieldOrigLength . . . . . . .  5.0  NNN  Field Original Length . . . . .
  25  FieldStart. . . . . . . . . .  5.0  NNN  Field Start . . . . . . . . . .
  26  FieldLength . . . . . . . . .  5.0  NNN  Field Length. . . . . . . . . .
  27  Class . . . . . . . . . . . .    30 SYN  Class . . . . . . . . . . . . .
  28  AssignSequence. . . . . . . .  4.0  NNN  Assign Sequence Number. . . . .
  29  TableReferenceNo. . . . . . .     2 SNN  Table Reference Number. . . . .