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