orders_20260303

efacdb_full · Backups, snapshots and deleted-row stores

Back to EFACS Browser

Type

BASE TABLE

Rows est.

214,494

Size

107.84 MB

Updated

2026-02-27 15:03:53

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	id	varchar(30)	PRI	NO	-	-
2	createddate	timestamp	-	YES	CURRENT_TIMESTAMP	-
3	traderid	varchar(20)	MUL	YES	-	-
4	tradertype	varchar(2)	-	YES	-	-
5	orderdate	timestamp	-	NO	CURRENT_TIMESTAMP	-
6	status	varchar(20)	-	NO	-	-
7	tradercontactid	varchar(40)	-	YES	-	-
8	responsibility	varchar(36)	-	YES	-	-
9	createdby	varchar(36)	-	YES	-	-
10	invoiceaddressid	varchar(30)	-	NO	-	-
11	deliveryaddressid	varchar(30)	-	YES	-	-
12	acknowledgementaddressid	varchar(30)	-	NO	-	-
13	orderaddressid	varchar(30)	-	YES	-	-
14	currencyid	varchar(3)	-	YES	-	-
15	exchangerate	double	-	NO	1	-
16	eudeliveryid	varchar(3)	-	YES	-	-
17	eutransportid	smallint	-	YES	1	-
18	documentsent	tinyint(1)	-	NO	0	-
19	documentduedate	datetime(6)	-	YES	-	-
20	communicationmethodid	varchar(30)	-	YES	-	-
21	traderorderreference	varchar(30)	-	YES	-	-
22	pricelistid	varchar(20)	-	YES	-	-
23	acceptsplitorder	tinyint(1)	-	NO	0	-
24	revision	smallint	-	YES	1	-
25	chasedate	datetime(6)	-	YES	-	-
26	ordertype	varchar(2)	PRI	NO	-	-
27	isapproved	tinyint(1)	-	NO	0	-
28	communicationcontactid	varchar(40)	-	YES	-	-
29	validtilldate	datetime(6)	-	YES	-	-
30	modifiedby	varchar(36)	-	YES	-	-
31	modifieddate	datetime(6)	-	YES	-	-
32	auditoperation	varchar(8)	-	YES	-	-
33	modifiedtimestamp	binary(8)	-	NO	-	-
34	schedulerevision	varchar(20)	-	YES	-	-
35	ordercategory	varchar(20)	-	YES	-	-
36	contractquantity	double	-	YES	-	-
37	reasoncode	varchar(30)	MUL	YES	-	-
38	companyid	varchar(30)	-	YES	-	-
39	settlementdays	double	-	YES	0	-
40	settlediscrate	double	-	YES	0	-
41	thresholddiscpercent	double	-	NO	0	-
42	olversionnumber	int	-	NO	0	-
43	isproformasent	tinyint(1)	-	YES	-	-
44	isproformapaid	tinyint(1)	-	YES	-	-
45	creditcheckpassed	tinyint(1)	-	NO	0	-
46	probabilityid	varchar(20)	-	YES	-	-
47	source	varchar(30)	-	YES	-	-
48	quoterejectcode	varchar(20)	-	YES	-	-
49	quoterejectcompetitor	varchar(30)	-	YES	-	-
50	markup	double	-	YES	-	-
51	markuppercentage	double	-	YES	-	-
52	outcome	varchar(8)	-	NO	-	-
53	rejectioncomment	varchar(255)	-	YES	-	-
54	losttocompetitor	tinyint(1)	-	YES	-	-
55	quotationexpired	tinyint(1)	-	YES	-	-
56	opportunityid	int	-	YES	-	-
57	despatchtypeid	varchar(20)	-	YES	-	-
58	issuspended	tinyint(1)	-	NO	-	-
59	suspensionreasoncode	varchar(20)	-	YES	-	-
60	deliverystreet	varchar(255)	-	YES	-	-
61	deliverycity	varchar(80)	-	YES	-	-
62	deliverycounty	varchar(80)	-	YES	-	-
63	deliverypostcode	varchar(15)	-	YES	-	-
64	deliverycountryid	varchar(3)	-	YES	-	-
65	deliveryareacodeid	varchar(30)	-	YES	-	-
66	uuid	varchar(36)	UNI	NO	-	-
67	deliveryaddresstype	varchar(18)	-	YES	-	-
68	requestedondate	datetime(6)	-	YES	-	-
69	requiredbydate	datetime(6)	-	YES	-	-
70	orderexpecteddate	datetime(6)	-	YES	-	-
71	isproformaposted	tinyint(1)	-	YES	-	-
72	isproforma	tinyint(1)	-	YES	0	-
73	invoicepaymentprofileid	varchar(36)	-	YES	-	-
74	discountterms	varchar(255)	-	YES	-	-
75	paymenttoaddress	varchar(40)	-	YES	-	-

Indexes

Name	Unique	Columns
idx_ouuid	Yes	uuid
PRIMARY	Yes	id, ordertype
ix_orders_traders	No	traderid, tradertype
ix_ords_clust	No	traderid, status, ordertype
ix_reasoncode	No	reasoncode

Status Counts

Status	Count
COMPLETE	192,532
REJECTED	9,358
NEW	9,154
CANCELLED	7,227
ACTIVE	661

Foreign Keys

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.