00900170-02_ID_OIS_SIS_16.1_R19-1_EN_DE - 第41页
ASM OIS/SIS Datab ases 16.1 (R19 -1) / Interf ace Description 05/2019 Edition 41 5.9 Views of Vers ion 9 5.9.1 V_BOARD9 View Supplies all colum ns of the BOARD table in the following sequence: lId, dtTime, strRec ipe, st…
ASM OIS/SIS Databases 16.1 (R19-1) / Interface Description 05/2019 Edition
40
5.7 Views of Version 11
5.7.1 V_PANEL11 View
Supplies all columns of the Panel table in the following sequence:
lIdPanel, lCountProduced, lCountOmitted, CountAssembledAsPCB, strPlacementListName
5.7.2 V_BOARD11 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, lIdPanel
5.8 Views of Version 10
5.8.1 V_USEDCOMPONENTS10 View
Supplies all joined columns of the CompBlock, CompDetail and CompPosition tables in the
following sequence:
lId, dtTime, lBoardNumber, sAccessTotal, sRejectIdent, sRejectVacuum, ucTable, sTrack,
ucTower, sLevel, sReceptacle, dtCreated, lPartNumber, lComponentShape, lFeederType,
strFeederId
5.8.2 V_PlocState10 View
Supplies all columns of the PlocState table in the following sequence:
lId, ucConveyor, ucProcessingArea, sState, lIdSequence, dtTime
5.8.3 V_GantryState10 View
Supplies all columns of the GantryState table in the following sequence:
lId, ucNumber, ucProcessingArea, sState, sErrorReason, lBoardNumber, lIdSequence, dtTime
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