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

ASM OIS/SIS Datab ases 16.0 (R18 -2) / Interf ace Description 11/2018 Edition 53 6.7 Views of Vers ion 5 6.7.1 V_RECIPE5 View Supplies all colum ns of the RECIPE table in t he following sequence: strRecipe, strLine, s tr…

100%1 / 150
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
52
6.5.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.6 Views of Version 6
6.6.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
6.6.2 V_BOARD6 View
Supplies all columns of the BOARD table in the following sequence:
lIdBoard, lLotSize, strBoardName, strOrderId, ucBoardSide, lSubConveyor, dtCreated,
strBoardFullPath
6.6.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.6.4 V_RECIPEADDON6 View
Supplies all columns of the RECIPEADDON table in the following sequence:
lIdRecipe, ucProcessingArea, ucPlacementMode, lBuildTime, lStationTactTime,
lParallelProcessingFactor
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
53
6.7 Views of Version 5
6.7.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.7.2 V_HEAD5 View
Supplies all columns of the HEAD table in the following sequence:
lIdHead, lGantry, ucHead, strHeadType, bBypassed, dtCreated
6.7.3 V_BOARD5 View
Supplies all the columns of the BOARD table in the following sequence:
lIdBoard, lLotSize, strBoardName, strOrderId, ucBoardSide, lSubConveyor, dtCreated
6.7.4 V_TRACK4 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
6.8 Views of Version 4
6.8.1 V_RECIPE4 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
6.9 Views of Version 3
6.9.1 V_RECIPE3 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
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
54
6.9.2 V_TRACK3 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
6.9.3 V_DATAMODEL3 View
Supplies all columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble
6.10 Views of Version 2
This view version is not used.
6.11 Views of Version 1
6.11.1 V_RECIPE View
Supplies all columns of the RECIPE table in the following sequence:
strRecipe, strLine, strStation, ucConveyor, strBoard, strSetup, dtStart, dtEnd, lIdTrack
6.11.2 V_TRACK View
Supplies all columns of the TRACK table in the following sequence:
lIdTrack, sFeederType, ucTable, sTrack, ucTower, sLevel, sReceptacle, strPartNumber,
strComponentShape
6.11.3 V_DATAMODEL View
Supplies all columns of the DATAMODEL table in the following sequence:
strName, lLong, strString, dtTime, dDouble