invoices

efacdb_full · Live EFACS mirror

Type

BASE TABLE

Rows est.

11,322

Size

4.31 MB

Updated

2026-06-04 14:41:58

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	id	varchar(30)	PRI	NO	-	-
2	invoicetype	varchar(4)	PRI	NO	-	-
3	traderid	varchar(20)	MUL	NO	-	-
4	tradertype	varchar(2)	-	NO	-	-
5	traderinvoicereference	varchar(30)	-	YES	-	-
6	taxdate	datetime(6)	-	NO	-	-
7	documentdate	datetime(6)	-	NO	-	-
8	paymentduedate	datetime(6)	-	NO	-	-
9	isdisputed	tinyint(1)	-	NO	-	-
10	settlementdays	double	-	YES	0	-
11	settlediscrate	double	-	YES	0	-
12	currencyid	varchar(3)	MUL	NO	-	-
13	exchangerate	double	-	NO	1	-
14	settlementbasedate	datetime(6)	-	YES	-	-
15	status	varchar(10)	-	NO	NEW	-
16	communicationmethodid	varchar(30)	-	YES	-	-
17	invoicetoaddressid	varchar(30)	-	YES	-	-
18	paymenttoaddress	varchar(30)	-	YES	-	-
19	isdocumentsent	tinyint(1)	-	YES	-	-
20	tradercontactid	varchar(40)	-	YES	-	-
21	eudeliveryid	varchar(3)	-	YES	-	-
22	authorisedby	varchar(36)	-	YES	-	-
23	createdby	varchar(36)	-	YES	-	-
24	createddate	timestamp	-	NO	CURRENT_TIMESTAMP	-
25	modifiedby	varchar(36)	-	YES	-	-
26	modifieddate	datetime(6)	-	YES	-	-
27	modifiedtimestamp	binary(8)	-	NO	-	-
28	auditoperation	varchar(8)	-	YES	-	-
29	discountterms	varchar(40)	-	YES	-	-
30	eutransportid	int	-	YES	-	-
31	shipmentaddressid	varchar(30)	-	YES	-	-
32	companyid	varchar(30)	-	YES	-	-
33	checktotalnett	decimal(19,4)	-	NO	0.0000	-
34	checktotaltax	decimal(19,4)	-	NO	0.0000	-
35	ispaymentauthorised	tinyint(1)	-	YES	-	-
36	olversionnumber	int	-	NO	0	-
37	creditcheckpassed	tinyint(1)	-	NO	0	-
38	comments	varchar(255)	-	YES	-	-
39	consolidateddocumentreference	varchar(50)	-	YES	-	-
40	isadvanceinvoice	tinyint(1)	-	NO	0	-
41	isconsignment	tinyint(1)	-	NO	0	-
42	isgroup	tinyint(1)	-	NO	-	-
43	invoicepaymentprofile	varchar(60)	-	YES	-	-

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.