00900135-02_ID_OIS_SIS_15.1_R18-1_DE_EN - 第29页

ASM OIS/SIS Databases 15.1 ( R18 - 1) / Interface De scription 05/2018 Edition 29 4.5.1.25 Splic eEvent Table SpliceEvent OIS n ame Dat a typ e Byt e CI I P Identificati on number of the s tation (reference t o STATION t…

ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 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 values

0: Undefined

1: True

2: False

ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition

4.5.1.25 SpliceEvent Table

SpliceEvent OIS name Data type Byte CI I P

Identification number of the station

(reference to STATION table)

lId int 4

Table/location from which the component was

retrieved

ucTable tinyint 1

Track number sTrack smallint 2

Division sDivision smallint 2

Identification number of the component name lPartNumber int 4

Date/time at which the data record was created.

Station time

dtTime datetime 8

Time when the splice occurred at the station dtSpliceTime datetime 8

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

Sequence ID (internal use) lIdSequence int 4

ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 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