00900045-01_ID_OIS_SIS_14.0_R16-2_DE_EN - 第40页

ASM OIS/SIS Databases 14.0 ( R16 - 2) / Interface De scription 12/2016 Edition 40 5.7.3 V_COMPONENTSH APE6 Vi ew Supplies all column s of the COMPONENTSHAPE table in the foll owing sequence: lComponentShape, strCompone n…

100%1 / 144
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
39
5.6.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
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.6.3 V_RECIPECHANGE7 View
Supplies all columns of the RECIPECHANGE table in the following sequence:
lId, ucConveyor, ucProcessingArea, lSubconveyor, strLineJobGuid, lIdSequence, dtTime,
dtCreated
5.7 Views of Version 6
5.7.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.7.2 V_PARTNUMBER6 View
Supplies all columns of the PARTNUMBER table in the following sequence:
lPartNumber, strPartNumber, dtCreated
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
40
5.7.3 V_COMPONENTSHAPE6 View
Supplies all columns of the COMPONENTSHAPE table in the following sequence:
lComponentShape, strComponentShape, dtCreated
5.7.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.7.5 V_EVENT6 View
Supplies all columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated,
ucProcessingMode
5.7.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.7.7 V_USEREVENT6 View
Supplies all columns of the USEREVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated, ucProcessingMode
5.7.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.7.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 14.0 (R16-2) / Interface Description 12/2016 Edition
41
5.8 Views of Version 5
5.8.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.8.2 V_EVENT5 View
Supplies all columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated
5.8.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.8.4 V_USEREVENT5 View
Supplies all columns of the USEREVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated
5.8.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.8.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