00900170-02_ID_OIS_SIS_16.1_R19-1_EN_DE - 第42页
ASM OIS/SIS Datab ases 16.1 (R19 -1) / Interf ace Description 05/2019 Edition 42 5.11.2 V_ PICKUPERROR7 View Supplies all colum ns of the PICKUPERROR table in the following sequence : lId, dtTime, lBoardNum ber, lError, …
ASM OIS/SIS Databases 16.1 (R19-1) / Interface Description 05/2019 Edition
41
5.9 Views of Version 9
5.9.1 V_BOARD9 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, lPanel, lSubConveyor, ucBoardSide, strLineJobId,
lBuildTimePA1, lBuildTimePA2
5.9.2 V_EVENT9 View
Supplies all columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated,
ucProcessingMode, lIdSequence, ucSubConveyor
5.9.3 V_STATION9 View
Supplies all columns of the STATION table in the following sequence:
strLine, strStation, ucProcessingArea, strText, strComputer, lId, lOrder, strMid, bMid,
strLineFullPath, strStationFullPath, strSWVersion, strTypeName
5.10 Views of Version 8
5.10.1 V_BOARD8 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, lPanel, lSubConveyor, ucBoardSide, strLineJobId
5.10.2 V_Event8 View
Supplies all columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated,
ucProcessingMode, lIdSequence
5.11 Views of Version 7
With version 7 two new views have been added that reflect the changes due to "Quad Lane"
conveyor mode.
5.11.1 V_BOARD7 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, lPanel, lSubConveyor
ASM OIS/SIS Databases 16.1 (R19-1) / Interface Description 05/2019 Edition
42
5.11.2 V_ PICKUPERROR7 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, lGantry
NOTICE
With introduction of the lGantry column, the semantic of the ucHead column has
changed. The content of the ucHead column has moved into the lGantry column.
The ucHead now relates to the head position where the head is mounted on the gantry.
I.e. a gantry may carry one or two heads. For gantries with only one head, the head
value is always "1". For gantries that are able to carry two heads the following definition
of ucHead is used:
Definition of ucHead values
1:
The head is located on the right position of the gantry
2:
The head is located on the left position of the gantry
5.11.3 V_RECIPECHANGE7 View
Supplies all columns of the RECIPECHANGE table in the following sequence:
lId, ucConveyor, ucProcessingArea, lSubconveyor, strLineJobGuid, lIdSequence, dtTime,
dtCreated
5.12 Views of Version 6
5.12.1 V_USEDCOMPONENTS6 View
Supplies all columns of the USEDCOMPONENTS table in the following sequence:
lId, dtTime, lBoardNumber, sAccessTotal, sRejectIdent, sRejectVacuum, ucTable, sTrack,
ucTower, sLevel, sReceptacle, dtCreated, lPartNumber, lComponentShape, lFeederType
5.12.2 V_PARTNUMBER6 View
Supplies all columns of the PARTNUMBER table in the following sequence:
lPartNumber, strPartNumber, dtCreated
ASM OIS/SIS Databases 16.1 (R19-1) / Interface Description 05/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