00900170-02_ID_OIS_SIS_16.1_R19-1_EN_DE - 第40页

ASM OIS/SIS Datab ases 16.1 (R19 -1) / Interf ace Description 05/2019 Edition 40 5.7 Views of Vers ion 11 5.7.1 V_PANEL11 View Supplies all colum ns of the Panel table in the f ollowing sequence : lIdPanel, lCountProduc …

100%1 / 150
ASM OIS/SIS Databases 16.1 (R19-1) / Interface Description 05/2019 Edition
39
5.4.3 V_EVENTANDTEXT14 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.4.4 V_STATETRANSITION141 View
Supplies all columns of the STATETRANSITION table in the following sequence:
lId, ucConveyor, ucProcessingArea, sState, dtTime, dtCreated, sEvent, ucProcessingMode
5.4.5 V_STATETRANSITIONANDTEXT141 View
Supplies all columns of the STATETRANSITION table with the appropriate event name and state
name from the EVENTTEXT and STATETEXT table in the following sequence:
lId, ucConveyor, sucProcessingArea, dtTime, sEvent, sState, EventName, StateName
5.4.6 V_SPLICEEVENT141 View
Supplies all columns of the SpliceEvent table with the appropriate component name from the
PARTNUMBER table in the following sequence:
lId, ucTable, sTrack, sDivision, dtSpliceTime, dtTime, dtCreated, , strPartNumber
5.5 Views of Version 14.0
5.5.1 V_STATION14 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, Species
5.6 Views of Version 12
5.6.1 V_USEDCOMPONENTS12 View
Supplies all joined columns of the CompBlock, CompDetail and CompPosition tables in the
following sequence:
lId, dtTime, dtCreated, lBoardNumber, sAccessTotal, sRejectIdent, sRejectVacuum, sTrackEmpty,
sPlacedComponents, sAbsenceAfterPick, sAbsenceBeforePlacement, sMaterialDefect,
sTreatmentError, sDroppedError, sIdentError, sPresenceAfterPlacement, sPickupRetries,
sAttritionInfoVersion, ucTable, sTrack, ucTower, sLevel, sReceptacle, lPartNumber,
lComponentShape, lFeederType, strFeederId
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