00900045-02_ID_OIS_SIS_14.1_R17-1_DE_EN.pdf - 第45页

ASM OIS/SIS Databases 14.1 ( R17 - 1) / Interface De scription 06/2017 Edition 45 5.12 Views of Version 3 5.12.1 V_BO ARD3 View Supplies all column s of the BOARD table in the fol lowing sequence : lId, dtTime, strReci p…

100%1 / 148
ASM OIS/SIS Databases 14.1 (R17-1) / Interface Description 06/2017 Edition
44
5.10.7 V_USEDCOMPONENTS5 View
Supplies all columns of the USEDCOMPONENTS table in the following sequence:
lId, dtTime, lBoardNumber, sAccessTotal, sRejectIdent, sRejectVacuum, ucTable, sTrack,
ucTower, sLevel, sReceptacle, dtCreated
5.10.8 V_STATION5 View
Supplies all columns of the STATION table in the following sequence:
strLine, strStation, ucProcessingArea, strText, strComputer, lId, lOrder, strMid, bMid
5.10.9 V_STATE5 View
Supplies all columns of the STATE table in the following sequence:
strTimeShare, strName, lColor, bDefined
5.10.10 V_STATESHARE5 View
Supplies all columns of the STATESHARE table in the following sequence:
strTimeShare, lState, lPercent
5.10.11 V_DATAMODEL5 View
Supplies all columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble
5.11 Views of Version 4
5.11.1 V_STATION4 View
Supplies all columns of the STATION table in the following sequence:
strLine, strStation, ucProcessingArea, strText, strComputer, lId, lOrder, strMid, bMid
ASM OIS/SIS Databases 14.1 (R17-1) / Interface Description 06/2017 Edition
45
5.12 Views of Version 3
5.12.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.12.2 V_EVENT3 View
Supplies all columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
5.12.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.12.4 V_USEREVENT3 View
Supplies all columns of the USEREVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
5.12.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.12.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.12.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 14.1 (R17-1) / Interface Description 06/2017 Edition
46
5.12.8 V_STATION3 View
Supplies all columns of the STATION table in the following sequence:
strLine, strStation, ucProcessingArea, strText, strComputer, lId, lOrder
5.12.9 V_STATE3 View
Supplies all columns of the STATE table in the following sequence:
strTimeShare, strName, lColor, bDefined
5.12.10 V_STATESHARE3 View
Supplies all columns of the STATESHARE table in the following sequence:
strTimeShare, lState, lPercent
5.12.11 V_DATAMODEL3 View
Supplies all columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble
5.13 Views of Version 2
5.13.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.13.2 V_EVENT2 View
Supplies all columns of the EVENT table in the following sequence:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
5.13.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