00900223-01_ID_OIS_SIS_17.0_R19-2_EN_DE.pdf - 第47页
ASM OIS/SIS Datab ases 17.0 (R19 -2) / Interf ace Description 11/2019 Edition 47 5.15.8 V_STATION3 View Supplies all colum ns of the STATION table in the following sequence: strLine, strStation, ucPr ocessingArea, str Te…
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
46
5.15 Views of Version 3
5.15.1 V_BOARD3 View
Supplies all columns of the BOARD table in the following sequence:
lId, dtTime, strRecipe, strSetup, strBoard, lBoardNumber, ucConveyor, sDuration, dtRecipeStart,
dtSetupStart, strBarcode, ucStatus
5.15.2 V_EVENT3 View
Supplies all columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
5.15.3 V_EVENTANDTEXT3 View
Supplies all columns of the EVENT table as well as the appropriate event name for the
corresponding event number from the EVENTTEXT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, strName
5.15.4 V_USEREVENT3 View
Supplies all columns of the USEREVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
5.15.5 V_USEREVENTANDTEXT3 View
Supplies all columns of the USEREVENT table as well as the appropriate event name for the
corresponding event number from the EVENTTEXT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, strName
5.15.6 V_PICKUPERROR3 View
Supplies all columns of the PICKUPERROR table in the following sequence:
lId, dtTime, lBoardNumber, lError, strPartNumber, strComponentShape, ucTable, sTrack, ucTower,
sLevel, sReceptacle, ucHead, ucSegment, sNozzle
5.15.7 V_USEDCOMPONENTS3 View
Supplies all columns of the USEDCOMPONENTS table in the following sequence:
lId, dtTime, lBoardNumber, sAccessTotal, sRejectIdent, sRejectVacuum, ucTable, sTrack,
ucTower, sLevel, sReceptacle
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
47
5.15.8 V_STATION3 View
Supplies all columns of the STATION table in the following sequence:
strLine, strStation, ucProcessingArea, strText, strComputer, lId, lOrder
5.15.9 V_STATE3 View
Supplies all columns of the STATE table in the following sequence:
strTimeShare, strName, lColor, bDefined
5.15.10 V_STATESHARE3 View
Supplies all columns of the STATESHARE table in the following sequence:
strTimeShare, lState, lPercent
5.15.11 V_DATAMODEL3 View
Supplies all columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble
5.16 Views of Version 2
5.16.1 V_BOARD2 View
Supplies all columns of the BOARD table in the following sequence:
sVersion, lIp, dtTime, strRecipe, strSetup, strBoard, lBoardNumber, ucConveyor, sDuration,
dtRecipeStart, dtSetupStart, strBarcode, bAbort
5.16.2 V_EVENT2 View
Supplies all columns of the EVENT table in the following sequence:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
5.16.3 V_EVENTANDTEXT2 View
Supplies all columns of the EVENT table as well as the appropriate event name for the
corresponding event number from the EVENTTEXT table in the following sequence:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, strName
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
48
5.16.4 V_USEREVENT2 View
Supplies all columns of the USEREVENT table in the following sequence:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
5.16.5 V_USEREVENTANDTEXT2 View
Supplies all columns of the USEREVENT table as well as the appropriate event name for the
corresponding event number from the EVENTTEXT table in the following sequence:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, strName
5.16.6 V_PICKUPERROR2 View
Supplies all columns of the PICKUPERROR table in the following sequence:
lIp, dtTime, lBoardNumber, lError, strPartNumber, strComponentShape, ucTable, sTrack, ucTower,
sLevel, sReceptacle, ucHead, ucSegment, sNozzle
5.16.7 V_USEDCOMPONENTS2 View
Supplies all columns of the USEDCOMPONENTS table in the following sequence:
lIp, dtTime, lBoardNumber, sAccessTotal, sAccessError, ucTable, sTrack, ucTower, sLevel,
sReceptacle
5.16.8 V_STATION2 View
Supplies all columns of the STATION table in the following sequence:
lVersion, strLine, strStation, ucProcessingArea, strText, strIP, lOrder
NOTICE
The strIP column returns the OIS-internal IP address. This may differ from the actual IP
address of the machine.
5.16.9 V_STATE2 View
Supplies all columns of the STATE table in the following sequence:
strTimeShare, strName, lColor, bDefined
5.16.10 V_STATESHARE2 View
Supplies all columns of the STATESHARE table in the following sequence:
strTimeShare, lState, lPercent