00194923-01_OIS_DB.pdf - 第13页

OIS Datenbank Version 4.1 Schnittstellenbeschreibung OIS Database Version 4.1 Interface Description 13 von 47 4.7 V iews of V e rsion 2 4.7.1 V_BOARD2 view Supplies all the columns o f the BOARD table in the following se…

100%1 / 47
Schnittstellenbeschreibung OIS Datenbank Version 4.1
Interface Description OIS Database Version 4.1
12 von 47
4.6.4 V_USEREVENT3 view
Supplies all the columns of the USEREVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
4.6.5 V_USEREVENTANDTEXT3 view
Supplies all the 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
4.6.6 V_PICKUPERROR3 view
Supplies all the columns of the PICKUPERROR table in the following sequence:
lId, dtTime, lBoardNumber, lError, strPartNumber, strComponentShape, ucTable, sTrack, ucTower, sLevel,
sReceptacle, ucHead, ucSegment, sNozzle
4.6.7 V_USEDCOMPONENTS3 view
Supplies all the columns of the USEDCOMPONENTS table in the following sequence:
lId, dtTime, lBoardNumber, sAccessTotal, sRejectIdent, sRejectVacuum, ucTable, sTrack, ucTower, sLevel,
sReceptacle
4.6.8 V_STATION3 view
Supplies all the columns of the STATION table in the following sequence:
strLine, strStation, ucProcessingArea, strText, strComputer, lId, lOrder
4.6.9 V_STATE3 view
Supplies all the columns of the STATE table in the following sequence:
strTimeShare, strName, lColor, bDefined
4.6.10 V_STATESHARE3 view
Supplies all the columns of the STATESHARE table in the following sequence:
strTimeShare, lState, lPercent
4.6.11 V_DATAMODEL3 view
Supplies all the columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble
OIS Datenbank Version 4.1 Schnittstellenbeschreibung
OIS Database Version 4.1 Interface Description
13 von 47
4.7 Views of Version 2
4.7.1 V_BOARD2 view
Supplies all the columns of the BOARD table in the following sequence:
sVersion, lIp, dtTime, strRecipe, strSetup, strBoard, lBoardNumber, ucConveyor, sDuration, dtRecipeStart,
dtSetupStart, strBarcode, bAbort
4.7.2 V_EVENT2 view
Supplies all the columns of the EVENT table in the following sequence:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
4.7.3 V_EVENTANDTEXT2 view
Supplies all the 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
4.7.4 V_USEREVENT2 view
Supplies all the columns of the USEREVENT table in the following sequence:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
4.7.5 V_USEREVENTANDTEXT2 view
Supplies all the 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
4.7.6 V_PICKUPERROR2 view
Supplies all the columns of the PICKUPERROR table in the following sequence:
lIp, dtTime, lBoardNumber, lError, strPartNumber, strComponentShape, ucTable, sTrack, ucTower, sLevel,
sReceptacle, ucHead, ucSegment, sNozzle
4.7.7 V_USEDCOMPONENTS2 view
Supplies all the columns of the USEDCOMPONENTS table in the following sequence:
lIp, dtTime, lBoardNumber, sAccessTotal, sAccessError, ucTable, sTrack, ucTower, sLevel, sReceptacle
Schnittstellenbeschreibung OIS Datenbank Version 4.1
Interface Description OIS Database Version 4.1
14 von 47
4.7.8 V_STATION2 view
Supplies all the columns of the STATION table in the following sequence:
lVersion, strLine, strStation, ucProcessingArea, strText, strIP, lOrder
Note
The strIP column returns the OIS-internal IP address. This may differ from the actual IP address of the
machine.
4.7.9 V_STATE2 view
Supplies all the columns of the STATE table in the following sequence:
strTimeShare, strName, lColor, bDefined
4.7.10 V_STATESHARE2 view
Supplies all the columns of the STATESHARE table in the following sequence:
strTimeShare, lState, lPercent
4.7.11 V_DATAMODEL2 view
Supplies all the columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble
4.8 Views of Version 1
The views of version 1.0 will no longer be supported.