Small Traceability für Asus - 第28页

2 Retrofit instructions SOKO Small Traceability ASUS (STA) on the basis of station software version 505.03 SP 1 SOKO 11/2005 Edition 28 [BMRID] [int] (4) NULL CONSTRAINT [DF_REEL_BMRID] DEF AUL T (0), 2 [TRACE] [varchar]…

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

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

11/2005 Edition

These are the contents: 2

The database interface can be configured to a limited extent. For details, see the section on Con-

figuration. 2

PCBID “TIMESTAMP” by default

RID the scanned ReelId (without prefix)

MPROG

Panel name on Conv1# Panel name on Conv2,

only one panel name if both are the same

QTY Container size

LOC Table_no#Track_no#Division#Level#Tower

TRACE_STATION Line_name#Station_name