source_routingoperations

efacdb_full · Source/staging extracts

Type

BASE TABLE

Rows est.

1,316

Size

1.52 MB

Updated

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	partid	varchar(40)	PRI	NO	-	-
2	methodid	varchar(2)	PRI	NO	-	-
3	operationnumber	int	PRI	NO	-	-
4	workcentreid	varchar(16)	-	YES	-	-
5	operatorskill	int	-	YES	-	-
6	settime	double	-	YES	-	-
7	runtime	double	-	YES	-	-
8	transfertime	double	-	YES	-	-
9	perquantity	int	-	YES	-	-
10	description	varchar(86)	-	YES	-	-
11	drawingreference	varchar(255)	-	YES	-	-
12	overlappercentage	int	-	YES	-	-
13	alternativeoperation	varchar(255)	-	YES	-	-
14	alternativeoperationpreference	int	-	YES	-	-
15	losspercentage	double	-	YES	-	-
16	numberofoperators	double	-	YES	-	-
17	fixedsubcontractcost	double	-	YES	-	-
18	unitsubcontractcost	double	-	YES	-	-
19	numberofsetters	double	-	YES	-	-
20	setterskill	int	-	YES	-	-
21	fiscalstandardsettime	double	-	YES	-	-
22	fiscalstandardruntime	double	-	YES	-	-
23	fiscalstandardperquantity	int	-	YES	-	-
24	fiscalstandardnumberofsetters	double	-	YES	-	-
25	fiscalstdnumberofoperators	double	-	YES	-	-
26	fiscalstdfixedsubcontractcost	double	-	YES	-	-
27	fiscalstdunitsubcontractcost	double	-	YES	-	-
28	goingtosettime	double	-	YES	-	-
29	goingtoruntime	double	-	YES	-	-
30	goingtoperquantity	int	-	YES	-	-
31	goingtonumberofsetters	double	-	YES	-	-
32	goingtonumberofoperators	double	-	YES	-	-
33	goingtofixedsubcontractcost	double	-	YES	-	-
34	goingtounitsubcontractcost	double	-	YES	-	-
35	standardoperation	varchar(255)	-	YES	-	-
36	createdby	varchar(14)	-	YES	-	-
37	createddate	varchar(52)	-	YES	-	-
38	modifiedby	varchar(255)	-	YES	-	-
39	modifieddate	varchar(255)	-	YES	-	-
40	auditoperation	varchar(255)	-	YES	-	-
41	modifiedtimestamp	varchar(32)	-	YES	-	-
42	companyid	varchar(20)	-	YES	-	-
43	olversionnumber	int	-	YES	-	-

Name	Unique	Columns
PRIMARY	Yes	partid, methodid, operationnumber

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.