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

ASM OIS/SIS Datab ases 16.0 (R18 -2) / Interf ace Description 11/2018 Edition 33 4.5.2.2 TR A CK Table TRACK SIS name Data type Byte I P Reference number of the setup. The reference number is equal for all elements of a …

100%1 / 150
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
32
Definition of ucRecipeStatus values
0:
Undefined
1:
Recipe is active:
triggered by recipe download (SIS Server)
2:
Recipe is active:
triggered by detection of alternative components
3:
Recipe is closed:
triggered by subsequent recipe download
4:
Recipe is closed:
triggered by detection of alternative components
5:
Recipe is closed:
triggered by the reception of a board produced based on a subsequent recipe
Definition of ucConveyorMode values
1:
Single lane conveyor
2:
Asynchronous dual lane conveyor
3:
Synchronous dual lane conveyor
4:
Quad Lane in single lane conveyor
5:
Quad Lane in asynchronous conveyor mode
6:
Quad Lane in synchronous conveyor mode
Definition of DownloadMode values
0:
Unknown
1:
LineWiseDownload
2:
StationWiseDownload
3:
BarcodeDrivenAutoDownload
Definition of ucProductionMode values
0:
Unknown
1:
Normal production
2:
New production introduction
Obsolete Columns in RECIPE Table
To meet the requirements of new features like Quad Lane support, a recipe may contain assembly
information for more than one board. Until now there was a 1:1 relation between recipe and board.
The board attributes were contained in the RECIPE table. With a 1: n relation between recipe and
boards this is no longer possible.
Starting with SIS data model version 106, the board related information is stored in the SIS BOARD
table. For compatibility reasons, the attributes of the first board entries are stored in the RECIPE
table (using the obsolete marked columns) as well.
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
33
4.5.2.2 TRACK Table
TRACK
SIS name
Data type
Byte
I
P
Reference number of the setup.
The reference number is equal for all
elements of a station´s setup.
lIdTrack
bigint
8
✓
Feeder type
sFeederType
smallint
2
Table/location
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
Name of the component
strPartNumber
nvarchar(128)
256
Name of the component shape
strComponentShape
nvarchar(128)
256
SIPLACE Pro number for feeder type
lFeederType
long
4
SIPLACE Pro name for feeder type
strFeederTypeName
nvarchar(128)
256
SIPLACE Pro number for table type
lTableType
long
4
SIPLACE Pro name for table type
strTableTypeName
nvarchar(128)
256
Time when the data is written. Local server
Time
dtCreated
datetime
8
SIPLACE Pro used flag
ucUsed
tinyint
1
This ID uniquely identifies the track entry
within the TRACK table
lIdTrackEntry
bigint
8
Full path of the component (part number)
name
strComponentFullPath
nvarchar(1024)
2048
Full path of the component shape name
strComponentShapeFullPath
nvarchar(1024)
2048
Definition of ucUsed
The ucUsed values indicate whether a track is used by the referred recipe.
Possible values of ucUsed:
0:
Undefined
1:
True
2:
False
ASM OIS/SIS Databases 16.0 (R18-2) / Interface Description 11/2018 Edition
34
4.5.2.3 DATAMODEL Table
DATAMODEL
SIS 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
dDouble
float
8
4.5.2.4 BOARD Table
The BOARD table contains all board related entries. The link between the RECIPE table entry and
the BOARD table entries is the lIdBoard attribute. I.e. if a recipe gets downloaded the board
information is extracted and stored separately in the BOARD table. All new board entries are
getting stored with the same lIdBoard identifier. This identifier is also contained in the RECIPE
table entry to establish the link between the RECIPE table entry and BOARD table entries.
BOARD
SIS name
Data type
Byte
CI
I
P
Board ID
lIdBoard
bigint
8
✓
Size of the lot
lLotSize
int
4
Board name as string
strBoardName
nvarchar(128)
256
Order ID
strOrderId
nvarchar(256)
512
Board side
ucBoardSide
tinyint
1
Subconveyor ID
lSubConveyor
int
4
Time when the data is written. Local server
time
dtCreated
datetime
8
Full path of the board name
strBoardFullPath
nvarchar(1024)
2048
Count of components
lComponentCount
int
4
Total count of panels. I.e. the number of
panels of this type that have to be produced.
lPanelLotSize
int
4
Definition of ucBoardSide
The ucBoardSide describes whether the top or bottom side of the board has been processed.
Possible values of ucBoardSide:
0:
Undefined
1:
Top side
2:
Bottom side