     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. . . . .