00900223-01_ID_OIS_SIS_17.0_R19-2_EN_DE.pdf - 第43页
ASM OIS/SIS Datab ases 17.0 (R19 -2) / Interf ace Description 11/2019 Edition 43 5.12.3 V_COMPONENTSHAPE6 View Supplies all colum ns of the COMPONENTSHA PE tabl e in the following sequence : lComponentShape, s trComponen…
ASM OIS/SIS Databases 17.0 (R19-2) / Interface Description 11/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 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