00900135-02_ID_OIS_SIS_15.1_R18-1_DE_EN - 第42页

ASM OIS/SIS Databases 15.1 ( R18 - 1) / Interface De scription 05/2018 Edition 42 5.10.3 V_CO MPONENTSHA PE6 View Supplies all column s of the COMPONENTSHAPE table in the foll owing sequence: lComponentShape, strCompone …

100%1 / 148
ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition
41
5.9.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.9.3 V_RECIPECHANGE7 View
Supplies all columns of the RECIPECHANGE table in the following sequence:
lId, ucConveyor, ucProcessingArea, lSubconveyor, strLineJobGuid, lIdSequence, dtTime,
dtCreated
5.10 Views of Version 6
5.10.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.10.2 V_PARTNUMBER6 View
Supplies all columns of the PARTNUMBER table in the following sequence:
lPartNumber, strPartNumber, dtCreated
ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition
42
5.10.3 V_COMPONENTSHAPE6 View
Supplies all columns of the COMPONENTSHAPE table in the following sequence:
lComponentShape, strComponentShape, dtCreated
5.10.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.10.5 V_EVENT6 View
Supplies all columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated,
ucProcessingMode
5.10.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.10.7 V_USEREVENT6 View
Supplies all columns of the USEREVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated, ucProcessingMode
5.10.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.10.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 15.1 (R18-1) / Interface Description 05/2018 Edition
43
5.11 Views of Version 5
5.11.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.11.2 V_EVENT5 View
Supplies all columns of the EVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated
5.11.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.11.4 V_USEREVENT5 View
Supplies all columns of the USEREVENT table in the following sequence:
lId, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, dtCreated
5.11.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.11.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