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