00900045-02_ID_OIS_SIS_14.1_R17-1_DE_EN.pdf - 第48页

ASM OIS/SIS Databases 14.1 ( R17 - 1) / Interface De scription 06/2017 Edition 48 5.13.11 V_DATAMODEL2 Vie w Supplies all column s of the DATAMODEL table in the followin g sequence: strName, lLong, strString, dtTim e, dD…

100%1 / 148
ASM OIS/SIS Databases 14.1 (R17-1) / Interface Description 06/2017 Edition
47
5.13.4 V_USEREVENT2 View
Supplies all columns of the USEREVENT table in the following sequence:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
5.13.5 V_USEREVENTANDTEXT2 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:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent, strName
5.13.6 V_PICKUPERROR2 View
Supplies all columns of the PICKUPERROR table in the following sequence:
lIp, dtTime, lBoardNumber, lError, strPartNumber, strComponentShape, ucTable, sTrack, ucTower,
sLevel, sReceptacle, ucHead, ucSegment, sNozzle
5.13.7 V_USEDCOMPONENTS2 View
Supplies all columns of the USEDCOMPONENTS table in the following sequence:
lIp, dtTime, lBoardNumber, sAccessTotal, sAccessError, ucTable, sTrack, ucTower, sLevel,
sReceptacle
5.13.8 V_STATION2 View
Supplies all columns of the STATION table in the following sequence:
lVersion, strLine, strStation, ucProcessingArea, strText, strIP, lOrder
NOTICE
The strIP column returns the OIS-internal IP address. This may differ from the actual IP
address of the machine.
5.13.9 V_STATE2 View
Supplies all columns of the STATE table in the following sequence:
strTimeShare, strName, lColor, bDefined
5.13.10 V_STATESHARE2 View
Supplies all columns of the STATESHARE table in the following sequence:
strTimeShare, lState, lPercent
ASM OIS/SIS Databases 14.1 (R17-1) / Interface Description 06/2017 Edition
48
5.13.11 V_DATAMODEL2 View
Supplies all columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble
5.14 Views of Version 1
The views of version 1.0 are no longer supported.
ASM OIS/SIS Databases 14.1 (R17-1) / Interface Description 06/2017 Edition
49
6 SIS Views
6.1 Views of Version 14.1
6.1.1 V_RECIPE141 View
Supplies all columns of the RECIPE table in the following sequence:
strRecipe, strLine, strStation, ucConveyor, strBoard, strSetup, dtStart, dtEnd, lIdTrack, lLotSize,
strMid, bMid, strOrderId, lCycleTime, lOrder, strBoardSide, strStationTypeName, lStationType,
bComponentBarcode, bStationCycleTime, lStationCycleTime, bParallelProcessingFactor,
lParallelProcessingFactor, strLineJobId, lIdHead, lIdBoard, bBypassed, dtCreated, lIdRecipe,
strSetupFullPath, strRecipeFullPath, strLineFullPath, strStationFullPath, lACUpdateCount,
ucRecipeStatus, ucConveyorMode, LBOActive, LBOActiveStationInLine, DownloadMode,
ucProductionMode
6.2 Views of Version 13.0
6.2.1 V_RECIPE13 View
Supplies all columns of the RECIPE table in the following sequence:
strRecipe, strLine, strStation, ucConveyor, strBoard, strSetup, dtStart, dtEnd, lIdTrack, lLotSize,
strMid, bMid, strOrderId, lCycleTime, lOrder, strBoardSide, strStationTypeName, lStationType,
bComponentBarcode, bStationCycleTime, lStationCycleTime, bParallelProcessingFactor,
lParallelProcessingFactor, strLineJobId, lIdHead, lIdBoard, bBypassed, dtCreated, lIdRecipe,
strSetupFullPath, strRecipeFullPath, strLineFullPath, strStationFullPath, lACUpdateCount,
ucRecipeStatus, ucConveyorMode, LBOActive, LBOActiveStationInLine, DownloadMode
6.2.2 V_RECIPEADDON13 View
Supplies all columns of the RECIPEADDON table in the following sequence:
lIdRecipe, ucProcessingArea, ucPlacementMode, lBuildTime, lStationTactTime,
lParallelProcessingFactor, SteppingActive