source_worksorders

efacdb_full · Source/staging extracts

Back to EFACS Browser

Type

BASE TABLE

Rows est.

Size

0.02 MB

Updated

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	id	varchar(12)	PRI	NO	-	-
2	partid	varchar(20)	-	YES	-	-
3	quantity	double	-	YES	-	-
4	duedate	varchar(52)	-	YES	-	-
5	earliestallowedstartdate	varchar(52)	-	YES	-	-
6	traderid	varchar(255)	-	YES	-	-
7	priority	int	-	YES	-	-
8	status	varchar(18)	-	YES	-	-
9	lateststartdate	varchar(255)	-	YES	-	-
10	totaltime	double	-	YES	-	-
11	levelintree	int	-	YES	-	-
12	parentworksorderid	varchar(255)	-	YES	-	-
13	baseworksorder	varchar(255)	-	YES	-	-
14	description	varchar(255)	-	YES	-	-
15	cpearlydate	varchar(255)	-	YES	-	-
16	orderid	varchar(255)	-	YES	-	-
17	originalquantity	double	-	YES	-	-
18	actualfinishdate	varchar(52)	-	YES	-	-
19	actualstartdate	varchar(52)	-	YES	-	-
20	expectedcompletiondate	varchar(255)	-	YES	-	-
21	actualbookedtime	double	-	YES	-	-
22	plannedcost	varchar(20)	-	YES	-	-
23	actualcost	varchar(20)	-	YES	-	-
24	contractid	varchar(255)	-	YES	-	-
25	plannedcompletiontime	double	-	YES	-	-
26	quantitycompleted	double	-	YES	-	-
27	bommethod	varchar(8)	-	YES	-	-
28	routingmethod	varchar(2)	-	YES	-	-
29	materialavailabilitydate	varchar(255)	-	YES	-	-
30	partrevisionid	varchar(10)	-	YES	-	-
31	isroutecardprinted	int	-	YES	-	-
32	isjobticketprinted	int	-	YES	-	-
33	ispicklistprinted	int	-	YES	-	-
34	orderitemnumber	varchar(255)	-	YES	-	-
35	createdby	varchar(14)	-	YES	-	-
36	createddate	varchar(38)	-	YES	-	-
37	modifiedby	varchar(22)	-	YES	-	-
38	modifieddate	varchar(52)	-	YES	-	-
39	auditoperation	varchar(255)	-	YES	-	-
40	modifiedtimestamp	varchar(32)	-	YES	-	-
41	usecurrentrevision	int	-	YES	-	-
42	tradertype	varchar(255)	-	YES	-	-
43	type	varchar(26)	-	YES	-	-
44	source	varchar(255)	-	YES	-	-
45	originalworksorderid	varchar(255)	-	YES	-	-
46	ordertype	varchar(255)	-	YES	-	-
47	caseid	varchar(255)	-	YES	-	-
48	companyid	varchar(20)	-	YES	-	-
49	costhead	varchar(255)	-	YES	-	-
50	olversionnumber	int	-	YES	-	-
51	kitstatus	varchar(24)	-	YES	-	-
52	salesorderallocation	varchar(255)	-	YES	-	-
53	uuid	varchar(72)	-	YES	-	-

Indexes

Name	Unique	Columns
PRIMARY	Yes	id

Foreign Keys

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.