zCRU_PartWorkcentreSummary

efacdb_full · Custom/model/helper tables

Type

BASE TABLE

Rows est.

289,443

Size

30.06 MB

Updated

2026-04-03 13:52:16

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	partid	varchar(30)	MUL	NO	-	-
2	workcentreid	varchar(8)	-	NO	-	-
3	settime_min	double	-	NO	-	-
4	runtime_min	double	-	NO	-	-
5	setcost	double	-	NO	-	-
6	oprcost	double	-	NO	-	-

Name	Unique	Columns
zCRU_idx_partworkcentre_partnum	No	partid

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.