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