
3.DATABASE SPECIFICATIONS USER CUSTOMIZE B-75074EN/04
- 432 -
iii. Check if there is a record that matches the machine ID and
sequence ID acquired in step i and the machining start time
acquired in step ii. If such a record is not found, the
processing is ended.
iv. If such a record is found, check if data is already stored in the
fields of the machining end time, machining end state ID, and
user area ID of the record. If data is already stored, the
processing is ended.
v. If data is not stored, store the machining end time, machining
end state ID, and user area ID acquired in step i above in that
record on the table.
Do not modify the design and data of the table.
Field name Data type Description
ID Auto number AutoNumber
McnID Numeric type Machine ID (1 to 999)
WorkID Numeric type Workpiece ID (0 to 99,999,999)
Onum Numeric type O number (0 to 99,999,999)
FirstClock Date/time type Machining start time
LastClock Data/time type Machining end time
LastID Numeric type Machining end state ID (0 to 9,999)
UserID Numeric type User area ID (0 to 9,999)
Snum Numeric type Sequence number for each machine (1 to 99,999,999)
Method of collecting data on the Workpieces Process Result screen
(end state display)
Calculate the number of records by specifying necessary conditions
among McnID, WorkID, FirstClock, and LastID. For one-month
display on a workpiece-by-workpiece basis, for example, calculate the
number of records by specifying the values of WorkID, FirstClock, and
LastID.