00900223-01_ID_OIS_SIS_17.0_R19-2_EN_DE - 第44页

ASM OIS/SIS Datab ases 17.0 (R19 -2) / Interf ace Description 11/2019 Edition 44 5.13 Vie ws of Version 5 5.13.1 V_BOARD5 View Supplies all colum ns of the BOARD table in the following sequence: lId, dtTime, strRec ipe, …

100%1 / 150
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
43
5.12.3 V_COMPONENTSHAPE6 View
Supplies all columns of the COMPONENTSHAPE table in the following sequence:
lComponentShape, strComponentShape, dtCreated
5.12.4 V_PICKUPERROR6 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, dtCreated, lType
5.12.5 V_EVENT6 View
Supplies all columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated,
ucProcessingMode
5.12.6 V_EVENTANDTEXT6 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, dtCreated,
ucProcessingMode, strName
5.12.7 V_USEREVENT6 View
Supplies all columns of the USEREVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated, ucProcessingMode
5.12.8 V_USEREVENTANDTEXT6 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, dtCreated,
ucProcessingMode, strName
5.12.9 V_STATETRANSITION6 View
Supplies all columns of the STATETRANSITION table in the following sequence:
lId, ucConveyor, ucProcessingArea, sState, dtTime, dtCreated, sEvent, ucProcessingMode
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
44
5.13 Views of Version 5
5.13.1 V_BOARD5 View
Supplies all columns of the BOARD table in the following sequence:
lId, dtTime, strRecipe, strSetup, strBoard, lBoardNumber, ucConveyor, sDuration, dtRecipeStart,
dtSetupStart, strBarcode, ucStatus, dtCreated
5.13.2 V_EVENT5 View
Supplies all columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated
5.13.3 V_EVENTANDTEXT5 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, dtCreated, strName
5.13.4 V_USEREVENT5 View
Supplies all columns of the USEREVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated
5.13.5 V_USEREVENTANDTEXT5 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, dtCreated, strName
5.13.6 V_PICKUPERROR5 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, dtCreated
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/2019 Edition
45
5.13.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.13.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.13.9 V_STATE5 View
Supplies all columns of the STATE table in the following sequence:
strTimeShare, strName, lColor, bDefined
5.13.10 V_STATESHARE5 View
Supplies all columns of the STATESHARE table in the following sequence:
strTimeShare, lState, lPercent
5.13.11 V_DATAMODEL5 View
Supplies all columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble
5.14 Views of Version 4
5.14.1 V_STATION4 View
Supplies all columns of the STATION table in the following sequence:
strLine, strStation, ucProcessingArea, strText, strComputer, lId, lOrder, strMid, bMid