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

ASM OIS/SIS Databases 14.0 ( R16 - 2) / Interface De scription 12/2016 Edition 29 4.5.2 SIS Tables 4.5.2.1 RECIPE Table RECIPE SIS name Data type B yt e I P Name of the reci pe strRecipe nvarchar(128) 256 Name of the lin…

ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition

4.5.1.23 CompPosition Table

CompPosition OIS name Data type Byte CI I P

Identification number of the station

(reference to STATION table)

lId int 4

Reference number of the entry lIdPosition int 4

Table/location from which the component was

retrieved

ucTable tinyint 1

Track number sTrack smallint 2

Tower (MTC only, otherwise dummy) ucTower tinyint 1

Level (WPC or MTC only, otherwise dummy) sLevel smallint 2

Division sReceptacle smallint 2

Identification number of the component name

(available with station software version 701 and

higher)

lPartNumber int 4

Identification number of the component shape

name (available with station software version

701 and higher)

lComponentShape int 4

SIPLACE Pro number for feeder type (available

with station software version 701 and higher)

lFeederType long 4

Time when the data is written. Server time dtCreated datetime 8

Unique feeder ID strFeederId nvarchar(128) 256

4.5.1.24 Panel Table

Panel OIS name Data type Byte CI I P

Reference (from BOARD table).

Note: This reference may occur several times

since a board may have several panel groups.

lIdPanel int 4

Count of produced panels lCountProduced int 4

Count of omitted panels lCountOmitted int 1

Encoding whether the panel entry is intended to

be counted as assembled PCB (based on

SIPLACE Pro setting)

CountAsAssembledPCB tinyint 2

Name of the concerned placement list strPlacementListName nvarchar(256) 512

Definition of CountAsAssembledPCB

Possible values of CountAsAssembledPCB:

0: Undefined

1: True

2: False

ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition

4.5.2 SIS Tables

4.5.2.1 RECIPE Table

RECIPE SIS name Data type Byte I P

Name of the recipe strRecipe nvarchar(128) 256

Name of the line strLine nvarchar(1024) 2048

Name of the station strStation nvarchar(128) 256

Conveyor belt 1 / 2 ucConveyor tinyint 1

Name of the PCB

Obsolete due to new BOARD table!

strBoard nvarchar(128) 256

Name of the setup strSetup nvarchar(128) 256

Start time of the recipe. Server time. dtStart datetime 8 

End time of the recipe. Server time. dtEnd datetime 8

Reference number to the corresponding

setup in the TRACK table

lIdTrack int 4 

Number of boards to produce

Obsolete due to new BOARD table!

lLotSize long 4

Machine identification MID strMid nvarchar(50) 100

Is a machine identification available? bMid bit 1

Extra ID for production schedule

Obsolete due to new BOARD table!

strOrderId string 512

Cycle time in [ms] calculated from the

optimizer

lCycleTime long 4

Position of the stations within a line lOrder long 4

Top or bottom side of the board [Top,

Bottom]

Obsolete due to new BOARD table

strBoardSide nvarchar(128) 256

SIPLACE Pro name for station type strStationTypeName nvarchar(128) 256

SIPLACE Pro number for station type lStationType long 4

Is the recipe produced with component

barcode?

bComponentBarcode boolean 1

Indicates whether SIPLACE Pro has set the

StationCycleTime value

bStationCycleTime boolean 1

Station Cycle time in [ms] for the PCB

processing calculated from the optimizer

lStationCycleTime long 4

Indicates whether SIPLACE Pro has set the

ParallelProcessingFactor value

bParallelProcessingFactor boolean 1

ASM OIS/SIS Databases 14.0 (R16-2) / Interface Description 12/2016 Edition

Value 2 if this station works in I-Placement

mode

Value n if this station is in a cluster of n

parallel machines

Value 2*n if this station works in I-Placement

mode and is in a cluster of n parallel

machines

Otherwise value 1

lParallelProcessingFactor long 4

Unique ID for line job strLineJobGuid nvarchar(36) 72

Head ID, reference to HEAD table lIdHead int 4

Board ID, reference to BOARD table lIdBoard int 4

Bypassed flag bBypassed

bit 1

Time when the data is written. Server time dtCreated DATETIME 8

Unique ID for this recipe lIdRecipe int 4

Full path of the setup name strSetupFullPath nvarchar(1024) 2048

Full path of the recipe name strRecipeFullPath nvarchar(1024) 2048

Full path of the line name strLineFullPath nvarchar(1024) 2048

Full path of the station name strStationFullPath nvarchar(1024) 2048

Internal ID regarding the whispering ability of

the line

ucPosInBIDCluster tinyint 1

Counts up updates for this recipe triggered

by detection of alternative components

lACUpdateCount int 4

Status of the recipe entry ucRecipeStatus tinyint 1

Conveyor mode of the recipe ucConveyorMode tinyint 1

Definition of ucPosInBIDCluster

The ucPosInBIDCluster values describe the position of a station in a BID cluster.

Possible values of ucPosInBIDCluster:

0: Unknown

1: Station not in BID Cluster

2: First position

3: Middle position (neither first not last position)

4: Last position