VI_JobLog VI Import Job Log Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: Y SysDB: N MAS_SYSTEM\VI_JobLog.M4T
KPRIMARY: RecordNo+IndexNo
KFIELDNAME: FieldName+RecordNo+IndexNo
Fld Column Name M/L TUR Description/Notes Class
1 RecordNo. . . . . . . . . . . 10 SNY Record Number . . . . . . . . .
Mask:0000000000 Notes:
0000000000 = Totals Summary
Record
2 IndexNo . . . . . . . . . . . 8 SNY Index Number. . . . . . . . . .
Mask:00000000 Notes:
0000000000 = Message Summary
for Each Record
3 FieldName . . . . . . . . . . 120 SNN Field Name. . . . . . . . . . .
4 FieldData . . . . . . . . . . 512 SNN Field Data or Summary Message .
5 DataType. . . . . . . . . . . 1 SYN Data Type . . . . . . . . . . .
Valid:S,N
6 FieldType . . . . . . . . . . 1 SYN Field Type. . . . . . . . . . .
Valid:D,N,S,T,Y Notes:
D=Date, N=Number, S=String,
T=Temp Var., Y=Yesno
7 ResultFlag. . . . . . . . . . 1 SYN Result Flag . . . . . . . . . .
Valid:P,F,S Notes: Import:
P=Passed, F=Failed,
S=Skipped; Export: P-selected
, F=not used, S=not Selected
8 ExistsInRecord. . . . . . . . 1 SYN Data Exists In Record . . . . .YESNO
DfltVal:N Valid:Y,N
9 RecordTotal . . . . . . . . . 10.0 NNN Total Records Processed . . . .
Mask:0000000000
10 RecordsPassed . . . . . . . . 10.0 NNN Total Records Imported or Expor
Mask:0000000000
11 RecordsSkipped. . . . . . . . 10.0 NNN Records Skipped . . . . . . . .
Mask:0000000000 Notes:
Export:Not Selected
12 RecordsFailed . . . . . . . . 10.0 NNN Records Failed. . . . . . . . .
Mask:0000000000 Notes:
Records Failed (Import Only)
13 RecordsPassedInvalidFields. . 10.0 NNN Records Passed With Invalid Fie