OEE Coach Software Help

Field definition ERP Feeder

Table of Contents

The ERP Feeder basically feeds the same data as the OEE Coach Export function. The export function does this as a batch, on demand and filtered by the user.

The ERP Feeder feeds this data-set live in order to keep eny external system -like the ERP system- updated.

The exporte data- set is as follows:

Data Definition

Nr	Name	Type	Description
1	Id	Integer	ID of the feed
2	CycleId	Integer	ID of the shiftdata
3	CycleDateTime	DateTime	Startmoment of the shift
4	WeekNr	Integer	Number of the week
5	Date	DateTime	Startmoment of the Activity
6	MachineId	Integer	ID of the machine
7	Duration	Integer	Actual Duration of the shift in Minutes
8	MachineName	String	Name of the machine
9	ShiftId	Integer	ID of the shiftname
10	ShiftName	String	Name of the shift
11	TeamId	Integer	ID of the Team
12	TeamName	String	Name of the Team
13	CycleActivityId	Integer	ID of the Activity in this cycle (shift)
14	ActivityId	Integer	ID of the Activity (in mastertable)
15	ActivityName	String	Name of the Activity
16	ActivityDuration	Integer	Duration of the Activity in seconds
17	ActivityStart	DateTime	Startmoment of the activity
18	ActivityEnd	DateTime	Endmoment of the activity
19	ActualOperators	Num	Actual Amount of operators during this activity
20	PlannedOperators	Num	Actual Amount of operators during this activity
21	ActivityType	String	Category of Activity: P/W/F/L/U
22	OrderNumber	String	Ordernumber to this activity
23	CycleActivityProductId	Integer	ID of product to this activity in this cycle
24	ProductId	Integer	ID of product (as in matertabel Products)
25	ProductName	String	Name of the product (as in matertabel Products)
26	ProductDescription	String	Description of the product (as in matertabel Products)
27	ProductType	String	Category of the product: G/S/R/SS
28	OutputParameter1	Num	NA
29	OutputParameter1	Num	NA
30	OutputParameter1	Num	NA
31	OutputParameter1	Num	NA
32	ActualOutput	Num	Actual amount of produced items
33	SetSpeed	Num	Amount of items the machine was set to produce
34	TheoreticalSpeed	Num	Theoretical maximum speed for this product on this machine
35	ActivityRemark	String	Remarks given to this activity
36	ProductRemark	String	Remarks given to this output