00900170-01_ID_OIS_SIS_16.0_R18-2_EN_DE - 第126页

ASM OIS/SIS Daten banken 16.0 (R18- 2) / Schnitts tellenbeschreibung Ausgabe 11/2018 52 6.2 Views der Version 14.1 6.2.1 View V_RECIPE141 Liefert alle Spalten der T abelle RECIPE in fol gender Reihenfolge: strRecipe, str…

100%1 / 150
ASM OIS/SIS Datenbanken 16.0 (R18-2) / Schnittstellenbeschreibung Ausgabe 11/2018
51
6 SIS Views
6.1 Views der Version 16.0
***
Die so gekennzeichneten Attribute wurden von int zu bigint erweitert.
6.1.1 View V_RECIPE_160
Liefert alle Spalten der Tabelle RECIPE in folgender Reihenfolge:
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 View V_RECIPEADDON_160
Liefert alle Spalten der Tabelle RECIPEADDON in folgender Reihenfolge:
***lIdRecipe, ucProcessingArea, ucPlacementMode, lBuildTime, lStationTactTime,
lParallelProcessingFactor, SteppingActive
6.1.3 View V_BOARD_160
Liefert alle Spalten der Tabelle BOARD in folgender Reihenfolge:
***lIdBoard, lLotSize, strBoardName, strOrderId, ucBoardSide, lSubConveyor, dtCreated,
strBoardFullPath, lComponentCount, lPanelLotSize
6.1.4 View V_TRACK_160
Liefert alle Spalten der Tabelle TRACK in folgender Reihenfolge:
***lIdTrack, sFeederType, ucTable, sTrack, ucTower, sLevel, sReceptacle, strPartNumber,
strComponentShape, lFeederType, strFeederTypeName, lTableType, strTableTypeName,
dtCreated, ucUsed, strComponentFullPath, strComponentShapeFullPath
6.1.5 View V_HEAD_160
Liefert alle Spalten der Tabelle HEAD in folgender Reihenfolge:
***lIdHead, lGantry, ucHead, strHeadType, bBypassed, dtCreated
ASM OIS/SIS Datenbanken 16.0 (R18-2) / Schnittstellenbeschreibung Ausgabe 11/2018
52
6.2 Views der Version 14.1
6.2.1 View V_RECIPE141
Liefert alle Spalten der Tabelle RECIPE in folgender Reihenfolge:
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.3 Views der Version 13.0
6.3.1 View V_RECIPE13
Liefert alle Spalten der Tabelle RECIPE in folgender Reihenfolge:
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.3.2 View V_RECIPEADDON13
Liefert alle Spalten der Tabelle RECIPEADDON in folgender Reihenfolge:
lIdRecipe, ucProcessingArea, ucPlacementMode, lBuildTime, lStationTactTime,
lParallelProcessingFactor, SteppingActive
6.4 Views der Version 11
6.4.1 View V_BOARD11
Liefert alle Spalten der Tabelle BOARD in folgender Reihenfolge:
lIdBoard, lLotSize, strBoardName, strOrderId, ucBoardSide, lSubConveyor, dtCreated,
strBoardFullPath, lComponentCount, lPanelLotSize
6.5 Views der Version 7
6.5.1 View V_BOARD7
Liefert alle Spalten der Tabelle BOARD in folgender Reihenfolge:
lIdBoard, lLotSize, strBoardName, strOrderId, ucBoardSide, lSubConveyor, dtCreated,
strBoardFullPath, lComponentCount
ASM OIS/SIS Datenbanken 16.0 (R18-2) / Schnittstellenbeschreibung Ausgabe 11/2018
53
6.5.2 View V_RECIPE7
Liefert alle Spalten der Tabelle RECIPE in folgender Reihenfolge:
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 der Version 6
6.6.1 View V_RECIPE6
Liefert alle Spalten der Tabelle RECIPE in folgender Reihenfolge:
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 View V_BOARD6
Liefert alle Spalten der Tabelle BOARD in folgender Reihenfolge:
lIdBoard, lLotSize, strBoardName, strOrderId, ucBoardSide, lSubConveyor, dtCreated,
strBoardFullPath
6.6.3 View V_TRACK6
Liefert alle Spalten der Tabelle TRACK in folgender Reihenfolge:
lIdTrack, sFeederType, ucTable, sTrack, ucTower, sLevel, sReceptacle, strPartNumber,
strComponentShape, lFeederType, strFeederTypeName, lTableType, strTableTypeName,
dtCreated, ucUsed, strComponentFullPath, strComponentShapeFullPath
6.6.4 View V_RECIPEADDON6
Liefert alle Spalten der Tabelle RECIPEADDON in folgender Reihenfolge:
lIdRecipe, ucProcessingArea, ucPlacementMode, lBuildTime, lStationTactTime,
lParallelProcessingFactor