00900170-01_ID_OIS_SIS_16.0_R18-2_EN_DE.pdf - 第49页

ASM OIS/SIS Datab ases 16.0 (R18 -2) / Interf ace Description 11/2018 Edition 49 5.15.11 V_DATAMODEL2 View Supplies all colum ns of the DATAMODEL ta ble in the follo wing sequence: strName, lLong, str String, dtTime, dDo…

100%1 / 150
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
48
5.15.4 V_USEREVENT2 View
Supplies all columns of the USEREVENT table in the following sequence:
lIp, dtTime, lBoardNumber, ucConveyor, ucProcessingArea, sEvent
5.15.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.15.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.15.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.15.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.15.9 V_STATE2 View
Supplies all columns of the STATE table in the following sequence:
strTimeShare, strName, lColor, bDefined
5.15.10 V_STATESHARE2 View
Supplies all columns of the STATESHARE table in the following sequence:
strTimeShare, lState, lPercent
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
49
5.15.11 V_DATAMODEL2 View
Supplies all columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble
5.16 Views of Version 1
The views of version 1.0 are no longer supported.
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
50
6 SIS Views
6.1 Views of Version 16.0
***
The so marked attributes were extended from int to bigint.
6.1.1 V_RECIPE_160 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
6.1.2 V_RECIPEADDON_160 View
Supplies all columns of the RECIPEADDON table in the following sequence:
***lIdRecipe, ucProcessingArea, ucPlacementMode, lBuildTime, lStationTactTime,
lParallelProcessingFactor, SteppingActive
6.1.3 V_BOARD_160 View
Supplies all columns of the BOARD table in the following sequence:
***lIdBoard, lLotSize, strBoardName, strOrderId, ucBoardSide, lSubConveyor, dtCreated,
strBoardFullPath, lComponentCount, lPanelLotSize
6.1.4 V_TRACK_160 View
Supplies all columns of the TRACK table in the following sequence:
***lIdTrack, sFeederType, ucTable, sTrack, ucTower, sLevel, sReceptacle, strPartNumber,
strComponentShape, lFeederType, strFeederTypeName, lTableType, strTableTypeName,
dtCreated, ucUsed, strComponentFullPath, strComponentShapeFullPath
6.1.5 V_HEAD_160 View
Supplies all columns of the HEAD table in the following sequence:
***lIdHead, lGantry, ucHead, strHeadType, bBypassed, dtCreated