DATA COLLECTION TABLES
|
Time Card
|
Data Collection
|
Auto Data Collection (ADC)
|
|
STARTS:
SF010600 (Summary)
SF010601 (Detail)
Posts to the following tables and clears out of the ones above
|
|
STARTS:
SF010500 (Starts here for a second)
Moves to:
SF010501 Immediately after saving.
On record for Start
One record for End
When Match is found it removes from the SF010501 and ends up below
|
|
ENDS:
SF010014 (Totals- Summary)
SF010115 (Detail)
|
STARTS/ENDS:
SF010014 (Totals- Summary)
SF010115 (Detail)
SF010200 when DC Transaction Posts
|
ENDS:
SF010014 (Totals- Summary)
SF010115 (Detail)
|
Note: All 3 options have the same resting place when completed. SF010014 and SF010115
All three options once processed will sit in DC Transactions window waiting for you to post to Payroll (Manufacturing >> Transactions >> WIP >> DC Transactions)
More information on ADC – SDK information (related to all supported versions:
You can import records directly to the SF010500 table if labor is collected by some other process. Here is a chart showing the fields in this table and related field values:
Data Entry directly to table through automated device.
Table Name: ADC_Input_Records (SF010500)
Validations: The validations that must be performed on each field prior to inserting data into the table are listed along with a description of the fields below.
Table Field Descriptions:
Field Name
|
Physical (SQL) Field Name
|
Values to Enter
|
System defaults (if empty)
|
|
Data Entry Type ADC
|
DATAENTRYTYPEADC_I
|
1 for Direct Labor
2 for Machine
|
1 (Direct Labor)
|
|
Manufacture Order
|
MANUFACTUREORDER_I
|
Manufacturing Order Number
|
None but required
|
|
rtseqnum
|
RTSEQNUM_I
|
Sequence of the MO routing
|
None but required
|
|
done_cb
|
DONECB_I
|
0 if sequence is not done
1 if this sequence is done.
|
None for a Finish Transaction; 0 for a Start Transaction
|
|
Number Scrapped
|
NUMBERSCRAPPED_I
|
Number scrapped
|
None
|
|
Employee ID
|
EMPLOYID
|
Employee ID number
|
None; required for Direct Labor trans
|
|
Machine ID IC
|
MACHINEID_I
|
Machine ID number
|
None; required for Machine trans
|
|
Transaction Type
|
TRXTYPE
|
0 for Start transaction
1 for Finish transaction
|
0 (Start)
|
|
ADCDate
|
ADCDATE_I
|
Enter transaction date
|
System date
|
|
ADCTime
|
ADCTIME_I
|
Enter transaction time
|
System time
|
|
Setup CB
|
SETUPCB_I
|
0 if transaction not labor setup
1 if transaction is labor setup
|
0 (NOT labor setup)
|
|
Pieces
|
PIECES_I
|
Enter pieces completed
|
None
|
|
Rejects
|
REJECTS_I
|
Enter pieces rejected
|
None
|
|
ADC Device ID
|
ADCDEVICEID_I
|
Enter ADC Device ID
|
None
|
|
Pay Code Rate 1
|
PAYCODERATE1_I
|
Enter Pay Code associated with time being recorded
|
None
|
|
Labor Code
|
LABORCODE_I
|
Enter payroll Labor Code associated with Pay Code
|
None
|
Validation Details:
‘Manufacture Order’
Manufacturing Order must exist in the system. Check this from table MOP_Order_MSTR (physical name WO010032) using key 1 (Manufacture Order).
Manufacturing Order must have status of Released or Partially Received. Check this from table MOP_Order_MSTR (physical name WO010032). Check field 'Manufacture Order Status' of file MOP_Order_MSTR – if its value is not 3 or 7, the MO is not Released or Partially Received.
Manufacturing Order is not done. Check this from table MOP_Routing_Line (physical name WR010130). For the ‘Manufacture Order’, go through all the sequences (field rtseqnum) and check the field done_cb. If all the sequences for the MO are done, then the MO is done.
‘rtseqnum’
The sequence must be part of the Manufacturing Order. Check this from table MOP_Routing_Line (physical name WR010130). The sequence must exist in this table for the Manufacturing Order. Use fields ‘Manufacture Order’ and ‘rtseqnum’ to check this.
The sequence is not set to be backflushed. Check this from table MOP_Routing_Line (physical name WR010130). If the field ‘Auto Backflush Labor’ or the field ‘Auto Backflush Machine’ are false, then the sequence is not set to be backflushed.
‘Employee ID’
Employee ID must exist in the system. Check this by using the ‘Employee ID’ field of file UPR_MSTR (physical name UPR00100).
‘Machine ID’
Machine ID must exist in the system. Check this by using the ‘Machine ID’ field of file Machine_MSTR (physical name MM010032).
The above listed validations are the only ones required to be done on the data entered into the table through an automated device. Other fields will be filled by the system—for example, the labor code, pay code, and job number. Also, if the date and time fields are empty, the system will fill these with system date and time.
Manual Data Entry into the Automated Data Collection Form
The Automated Data Collection window can be accessed manually and populated. This window provides a user interface and captures the same information as may be pushed into the SF010500 table as listed above.