     VI_JobExportElements                    Job Export Elements           Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: N/A
     SQL Def: Y  SysDB: Y                                               MAS_SYSTEM\VI_JobExportElements.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  LinkTableName . . . . . . . .    30 SNN  Link Table Name . . . . . . . .
       4  ColumnName. . . . . . . . . .    30 SNY  Column Name . . . . . . . . . .
       5  FileType. . . . . . . . . . .     1 SYN  File Type . . . . . . . . . . .
                                                    DfltVal:S Valid:H,L,S
       6  DataType. . . . . . . . . . .     1 SNY  Data Type . . . . . . . . . . .
                                                    Valid:S,N Notes: S=String,
                                                    N=Number
       7  FieldType . . . . . . . . . .     1 SYY  Field Type. . . . . . . . . . .
                                                    Valid:D,S,T,X,Y Notes:
                                                    D=Date, S=Standard, T=Temp,
                                                    X=Xreference, Y=Yesno
       8  Class . . . . . . . . . . . .    30 SYN  Class . . . . . . . . . . . . .
       9  OperationCode . . . . . . . .     1 SYY  Operation Code. . . . . . . . .
                                                    DfltVal:A Valid:A,C,T Notes:
                                                    Dflt:A A=Assign, C=Calculate,
                                                     T= run Time assign
      10  NSDMask . . . . . . . . . . .    50 SNN  Numeric/String/Date Mask. . . .
      11  SourceOrigLength. . . . . . .  5.0  NNN  Source Length from Dictionary .
                                                    Notes: From Providex
                                                    Dictionary
      12  SourceSubstring . . . . . . .     1 SYN  Source Substring. . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    Dflt:N
      13  SourceStartPos. . . . . . . .  5.0  NNN  Source Start Position . . . . .
                                                    Notes: Default = 1
      14  SourceLength. . . . . . . . .  5.0  NNN  Source Length . . . . . . . . .
                                                    Notes: Default = SourceOrigLe
                                                    ngth
      15  ExportColPos. . . . . . . . .  5.0  NNY  Export Column/Position. . . . .
                                                    Notes: Delimited Column
                                                    Number, ODBC Field Number,
                                                    ASCII Start Position
      16  ExportFieldLength . . . . . .  5.0  NNN  Maximum Exported Field Length .
                                                    Notes: Default - OrigSourceLe
                                                    ngth, but not limited in
                                                    size.
      17  ExportSubstring . . . . . . .     1 SYN  Export Substring. . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    Dflt:N
      18  ExportStartPos. . . . . . . .  5.0  NNY  Export Start Position . . . . .
                                                    Notes: Default = 1
      19  ExportLength. . . . . . . . .  5.0  NNY  Export Length . . . . . . . . .
                                                    Notes: Default = ExportFieldS
                                                    ize
      20  PadWithSpaces . . . . . . . .     1 SYN  Pad Exported Fields With SpacesYESNO
                                                    DfltVal:N Valid:Y,N
      21  DefaultValue. . . . . . . . .    60 SNN  Default Value . . . . . . . . .
                                                    Notes: If exported field is
                                                    blank
      22  CalcExpression. . . . . . . .   512 SNN  Calc Expression . . . . . . . .
      23  ConditionalExpression . . . .   512 SNN  Conditional Expression. . . . .
      24  CalculationOnly . . . . . . .     1 SYN  Calculation Only. . . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N Notes:
                                                    Dflt:N
      25  RunTimePrompt . . . . . . . .    30 SNN  Run Time Input Prompt . . . . .
      26  ResetTempVar. . . . . . . . .     1 SYN  Reset Temp Variable Each RecordYESNO
                                                    DfltVal:N Valid:Y,N
      27  PartOfODBCIndex . . . . . . .     1 SYN  Part of ODBC Index. . . . . . .YESNO
                                                    DfltVal:N Valid:Y,N
      28  ODBCFieldData . . . . . . . .    60 SNN  ODBC Field Data . . . . . . . .
      29  ODBCFieldType . . . . . . . .    10 SYN  ODBC Field Type . . . . . . . .
                                                    Notes: BIT(Y/N), COUNTER
                                                    (auto number), CURRENCY,
                                                    DATETIME, LONG (number),
                                                    LONGBINARY (OLE object),
                                                    LONGTEXT(memo), TEXT
      30  LibObjectName . . . . . . . .    12 SNN  Lib Object Name . . . . . . . .
      31  TableReferenceNo. . . . . . .     2 SNN  Table Reference Number. . . . .