VI_JobImportRecordTypes Job Import Record Types Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: Y MAS_SYSTEM\VI_JobImportRecordTypes.M4T
KPRIMARY: JobName+SequenceNo
Fld Column Name M/L TUR Description/Notes Class
1 JobName . . . . . . . . . . . 15 SNY Job Name. . . . . . . . . . . .
2 SequenceNo. . . . . . . . . . 4 SNN Sequence Number . . . . . . . .
Mask:0000
3 IndexType . . . . . . . . . . 1 SNN IndexType . . . . . . . . . . .
Valid:K,S,H,L,N,D Notes:
K=sKip record, S=Standard
record, H=Header record,
L=Line record, N=change Next
on, D=Distribution
4 RecordType. . . . . . . . . . 1 SNY Record Type . . . . . . . . . .
5 Description . . . . . . . . . 30 SNN Record Type Description . . . .
6 ColumnName. . . . . . . . . . 30 SNY Record Type Column Name . . . .
7 ImportColPos. . . . . . . . . 5.0 NNN Import Column or Position . . .
8 StartPos. . . . . . . . . . . 5.0 NNN Start Position. . . . . . . . .
9 Length. . . . . . . . . . . . 5.0 NNN Length. . . . . . . . . . . . .
10 Relation. . . . . . . . . . . 1 SYN Relation. . . . . . . . . . . .
Valid:1-6,S,R,L,P Notes:
1=equal, 2=not equal, 3=less
than, 4=greater than, 5=L.T.
or equal to, 6=G.T. or equal
to, S=Search, R=Range,
L=List, P=Perform
11 Value . . . . . . . . . . . . 60 SNN Value . . . . . . . . . . . . .
Notes: For relations 1-6 and
Search
12 RangeStart. . . . . . . . . . 30 SNN Range Start . . . . . . . . . .
13 RangeEnd. . . . . . . . . . . 30 SNN RangeEnd. . . . . . . . . . . .
14 ListValues. . . . . . . . . . 1024 SNN List Values . . . . . . . . . .
15 ProgramName . . . . . . . . . 120 SNN Program Name. . . . . . . . . .
Notes: Include path ( and
label for Perform )