00900045-01_ID_OIS_SIS_14.0_R16-2_DE_EN - 第47页

ASM OIS/SIS Databases 14.0 ( R16 - 2) / Interface De scription 12/2016 Edition 47 6 SIS Views 6.1 Views of Versi on 11 6.1.1 V_BOARD11 Vi ew Supplies all column s of the BOARD table in the fol lowing sequence : lIdBoard,…

100%1 / 144
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
46
5.11.11 V_DATAMODEL2 View
Supplies all columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble
5.12 Views of Version 1
The views of version 1.0 are no longer supported.
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
47
6 SIS Views
6.1 Views of Version 11
6.1.1 V_BOARD11 View
Supplies all columns of the BOARD table in the following sequence:
lIdBoard, lLotSize, strBoardName, strOrderId, ucBoardSide, lSubConveyor, dtCreated,
strBoardFullPath, lComponentCount, lPanelLotSize
6.2 Views of Version 7
6.2.1 V_BOARD7 View
Supplies all columns of the BOARD table in the following sequence:
lIdBoard, lLotSize, strBoardName, strOrderId, ucBoardSide, lSubConveyor, dtCreated,
strBoardFullPath, lComponentCount
6.2.2 V_RECIPE7 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.3 Views of Version 6
6.3.1 V_RECIPE6 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
ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition
48
6.3.2 V_BOARD6 View
Supplies all columns of the BOARD table in the following sequence:
lIdBoard, lLotSize, strBoardName, strOrderId, ucBoardSide, lSubConveyor, dtCreated,
strBoardFullPath
6.3.3 V_TRACK6 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.3.4 V_RECIPEADDON6 View
Supplies all columns of the RECIPEADDON table in the following sequence:
lIdRecipe, ucProcessingArea, ucPlacementMode, lBuildTime, lStationTactTime,
lParallelProcessingFactor
6.4 Views of Version 5
6.4.1 V_RECIPE5 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
6.4.2 V_HEAD5 View
Supplies all columns of the HEAD table in the following sequence:
lIdHead, lGantry, ucHead, strHeadType, bBypassed, dtCreated
6.4.3 V_BOARD5 View
Supplies all the columns of the BOARD table in the following sequence:
lIdBoard, lLotSize, strBoardName, strOrderId, ucBoardSide, lSubConveyor, dtCreated