source_shipments

efacdb_full · Source/staging extracts

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(16)	PRI	NO	-	-
2	createddate	varchar(38)	-	YES	-	-
3	shipmentdate	varchar(52)	-	YES	-	-
4	traderid	varchar(16)	-	YES	-	-
5	tradertype	varchar(2)	-	YES	-	-
6	despatchfromaddressid	varchar(255)	-	YES	-	-
7	toaddressid	varchar(46)	-	YES	-	-
8	invoiceaddressid	varchar(22)	-	YES	-	-
9	commentline	varchar(255)	-	YES	-	-
10	isdocumentsent	int	-	YES	-	-
11	numberofcases	int	-	YES	-	-
12	grossweight	double	-	YES	-	-
13	nettweight	double	-	YES	-	-
14	eudeliveryid	varchar(6)	-	YES	-	-
15	eutransportid	int	-	YES	-	-
16	isacknowledged	int	-	YES	-	-
17	traderdeliveryreference	varchar(255)	-	YES	-	-
18	storeslistproduced	int	-	YES	-	-
19	shipmenttype	varchar(4)	PRI	NO	-	-
20	status	varchar(16)	-	YES	-	-
21	createdby	varchar(16)	-	YES	-	-
22	modifiedby	varchar(16)	-	YES	-	-
23	modifieddate	varchar(52)	-	YES	-	-
24	auditoperation	varchar(255)	-	YES	-	-
25	modifiedtimestamp	varchar(32)	-	YES	-	-
26	currencyid	varchar(6)	-	YES	-	-
27	companyid	varchar(20)	-	YES	-	-
28	olversionnumber	int	-	YES	-	-
29	sitetraderid	varchar(40)	-	YES	-	-
30	sitetradertype	varchar(4)	-	YES	-	-
31	creditcheckpassed	int	-	YES	-	-
32	carriagedetailid	varchar(255)	-	YES	-	-
33	deliverysource	varchar(20)	-	YES	-	-
34	addresstype	varchar(16)	-	YES	-	-
35	engineerid	varchar(255)	-	YES	-	-
36	street	varchar(316)	-	YES	-	-
37	city	varchar(54)	-	YES	-	-
38	county	varchar(54)	-	YES	-	-
39	postcode	varchar(30)	-	YES	-	-
40	countryid	varchar(6)	-	YES	-	-
41	areaid	varchar(8)	-	YES	-	-
42	pickedby	varchar(255)	-	YES	-	-
43	consignmentid	varchar(255)	-	YES	-	-
44	despatchtypeid	varchar(255)	-	YES	-	-
45	pickstatus	varchar(255)	-	YES	-	-

Name	Unique	Columns
PRIMARY	Yes	id, shipmenttype

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.