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