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

ASM OIS/SIS Databases 15.1 ( R18 - 1) / Interface De scription 05/2018 Edition 20 4.5.1.9 COMPONENTSHAPE Table COMPONENTSHAPE OIS name Data type Byte CI I P Identificati on number of the c omponent sh ape name lComponent…

100%1 / 148
ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition
19
4.5.1.7 USEDCOMPONENTS Table
USEDCOMPONENTS OIS name Data
type
Byte CI I P
Identification number of the station
(reference to STATION table)
lId int 4
Date/time at which the data record was created.
Station time
dtTime datetime 8
Serial number of manufactured PCB lBoardNumber int 4
Number of attempts to access this track sAccessTotal smallint 2
Number of rejected parts because of ident error sRejectIdent smallint 2
Number of TrackEmpty pickup attempts sTrackEmpty smallint 2
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
Number of rejected parts because of vacuum error sRejectVacuum smallint 2
Time when the data is written. Server Time dtCreated datetime 8
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
Number of successfully placed components on this
track
sPlacedComponents smallint 2
4.5.1.8 PARTNUMBER Table
PARTNUMBER OIS name Data type Byte CI I P
Identification number of the component name lPartNumber int 4
Name of the component, including path strPartNumber nvarchar(128) 256
Time when the data is written. Server Time dtCreated datetime 8
ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition
20
4.5.1.9 COMPONENTSHAPE Table
COMPONENTSHAPE OIS name Data type Byte CI I P
Identification number of the component shape
name
lComponentShape int 4
Name of the component shape, including path strComponentShape nvarchar(128) 256
Time when the data is written. Server Time dtCreated datetime 8
4.5.1.10 STATION Table
STATION OIS name Data type Byte I P
Name of the line strLine nvarchar(1024) 2048
Name of the station strStation nvarchar(128) 256
Number of placement areas ucProcessingArea tinyint 1
Text for the user strText nvarchar(32) 64
TCP/IP address or computer name of station strComputer nvarchar(255) 510
Identification number of the station lId int 4
Position of the stations within the line lOrder int 4
Machine identification MID strMid nvarchar(50) 100
Is a machine identification available? bMid bit 1
Full path of the line strLineFullPath nvarchar(1024) 2048
Full path of the station strStationFullPath nvarchar(1024) 2046
Station software version as a string strSWVersion nvarchar(128) 256
Station type name as a string. The available
station types are maintained and displayed in
SIPLACE Pro.
strTypeName nvarchar(128) 256
Type of the station (printer or station) Species int 4
Host name of the station strComputerName nvarchar(255) 510
Time when the data is written. Server time dtCreated datetime 8
Definition of Species values
0: Place
1: Print
ASM OIS/SIS Databases 15.1 (R18-1) / Interface Description 05/2018 Edition
21
4.5.1.11 STATE Table
STATE OIS name Data type Byte I P
8 user-defined states (T
1
– T
8
), availability (T
b
) and
the definition "show table states" (T
9
)
strTimeShare nvarchar(32) 64
Name of share of time strName nvarchar(32) 64
Color of share of time lColor int 4
Show share of time bDefined bit 1
4.5.1.12 STATESHARE Table
STATESHARE OIS name Data type Byte I P
8 user-defined states (T
1
– T
8
), availability (T
b
) and
the definition "show table states" (T
9
)
strTimeShare nvarchar(32) 64
Machine state, individual states of the state
machine
lState int 4
Share of time lPercent int 4
4.5.1.13 DATAMODEL Table
DATAMODEL OIS name Data type Byte I P
Name of the entry strName nvarchar(32) 64
Value 1 of data type int lLong int 4
Value 2 of data type string strString nvarchar(255) 510
Value 3 of data type datetime dtTime datetime 8
Value 4 of data type double e dDouble float 8
4.5.1.14 SHIFTWORK Table
SHIFTWORK OIS name Data type Byte I P
Name of shift strName nvarchar(32) 64
Starting time of shift dtStart datetime 8
4.5.1.15 EVENTTEXT Table
EVENTTEXT OIS name Data type Byte I P
Event number sEvent smallint 2
Event name strName nvarchar(32) 64