Small Traceability für Asus.pdf - 第27页

SOKO 2 Retrofit instructions SOKO Small Traceability ASUS (S TA ) on the basis of station software version 505.03 SP 1 11/2005 Edition 27 2.5 Interfaces 2 2 2.5.1 Dat abase interface The following descriptions describe t…

2 Retrofit instructions SOKO Small Traceability ASUS (STA) on the basis of station software version 505.03 SP 1 SOKO

11/2005 Edition

2.4 Safety instructions

WARNING

The safety instructions from the “Operational safety” chapter of the user manual and servicing in-

structions take precedence over these instructions. 2

The SIPLACE placement machines are supplied with mains voltage.

Consequently parts of these systems carry dangerous voltages! This voltage is present at certain

modules inside the machine base, even when the machine is switched off at the main power

switch.

Incorrect handling of the placement machine or touching live parts of the machine can result in

death or severe injury, and considerable damage to equipment.

BEFORE starting any work, shut down the operating system correctly, then switch the machine

OFF at the main power switch and disconnect from the main power supply. In addition, the com-

pressed air supply must be switched off at the compressed air unit's main valve in the machine

base and vented by actuating the needle valve on the compressed air unit.

There is DANGER for heart pacemaker wearers in the vicinity of the linear motors, as described

in detail in the "Special safety instructions for working in the vicinity of strong magnetic fields"

section of the user manual and service manual.

Always follow the accident prevention regulations, DIN or other standards and special safety

rules applicable in your country.

Pay attention to the information concerning residual voltages in the Operational Safety chapter.

Follow the ESD regulations as described in the operational safety section of the operating

instructions.

During the retrofit, always secure the machine to prevent access by other people and to prevent

it being switched on again. The procedure is described in the “Locking the machine…” section of

the user manual.

Working with the SITEST program further increases the risk of accident.

The SITEST program must only be used by authorized and trained personnel.

SOKO 2 Retrofit instructions SOKO Small Traceability ASUS (STA) on the basis of station software version 505.03 SP 1

11/2005 Edition

2.5 Interfaces

2.5.1 Database interface

The following descriptions describe the structure of the ASUS database. 2

A specific record is read from the table "REEL". This record depends on the content of the field

RID (ReelId) which is compared with the scanned barcode (without prefix).

The contents of the fields SPN ( = component name) and QTY (= container size) are read and

processed internally.

TABLE [REEL] ( 2

[RID] [varchar] (30) NOT NULL , 2

[SPN] [varchar] (50) NULL , 2

[COMPANY] [varchar] (30) NULL , 2

[QTY] [int] (4) NULL , 2

[RSTATION] [varchar] (30) NULL , 2

[RATSLOT] [int] (4) NULL , 2

[RID_SCAN_STA] [varchar] (30) NULL , 2

[TIMESTAMP] [datetime] (8) NULL CONSTRAINT [DF_REEL_TIMESTAMP] DEFAULT 2

(getdate()), 2

[ORIG_QTY] [int] (4) NULL , 2

[CTimeStamp] [datetime] NULL (8) CONSTRAINT [DF_REEL_CTimeStamp] DEFAULT (get-

date()), 2

Machines SQL server ASUS

SIPLACE Pro /

Line control

2 Retrofit instructions SOKO Small Traceability ASUS (STA) on the basis of station software version 505.03 SP 1 SOKO

11/2005 Edition

[BMRID] [int] (4) NULL CONSTRAINT [DF_REEL_BMRID] DEFAULT (0), 2

[TRACE] [varchar] (255) NULL , 2

[KITID] [varchar] (30) NULL , 2

[LOT] [varchar] (30) NULL , 2

[DATECODE] [varchar] (30) NULL , 2

[SUPPLIER] [varchar] (30) NULL , 2

[EXPIRE] [datetime] (8) NULL , 2

[EVALUE] [real] (4) NULL , 2

[EUNIT] [varchar] (30) NULL , 2

[FLRLIFE_ID] [varchar] (15) NULL , 2

[FLRLIFE_REMAIN_PCT] [int] (4) NULL , 2

[POLARITY] [int] (4) NULL , 2

[rowguid] [uniqueidentifier] (16) ROWGUIDCOL NULL CONSTRAINT [DF_REEL_rowguid] DE-

FAULT (newid()) 2

After successful verification, a record is written to the table "TRACE_LOG". 2

TABLE [TRACE_LOG] 2

[PCBID] [varchar] (50) NOT NULL , 2

[RID] [varchar] (30) NOT NULL , 2

[MPROG] [varchar] (255) NOT NULL , 2

[QTY] [int] (4) NULL , 2

[FCODE] [varchar] (20) NULL , 2

[LOC] [varchar] (30) NULL , 2

[TRACE_STATION] [varchar] (50) NOT NULL , 2

[TIMESTAMP] [datetime] (8) Null 2

[KITID] [varchar] (30) NULL , 2

[PROGQTY] [int] (4) NULL 2