stockbatches_deleted_20260317_092156

efacdb_full · Backups, snapshots and deleted-row stores

Type

BASE TABLE

Rows est.

8,740

Size

2.52 MB

Updated

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	partid	varchar(30)	-	YES	-	-
2	warehouseid	varchar(30)	-	NO	-	-
3	locationid	varchar(30)	-	NO	-	-
4	quantity	double	-	NO	0	-
5	origin	varchar(30)	-	YES	-	-
6	serialnumber	varchar(30)	-	YES	-	-
7	orderid	varchar(30)	-	YES	-	-
8	orderitemnumber	int	-	YES	-	-
9	ordertype	varchar(2)	-	YES	-	-
10	grn	varchar(30)	-	YES	-	-
11	receiveddate	datetime(6)	-	NO	-	-
12	unitvalue	double	-	NO	-	-
13	contractid	varchar(30)	-	YES	-	-
14	costhead	varchar(8)	-	YES	-	-
15	lastcounteddate	datetime(6)	-	NO	-	-
16	partrevisionid	varchar(30)	-	NO	-	-
17	originalbatchnumber	int	-	NO	0	-
18	status	varchar(20)	-	YES	-	-
19	createdby	varchar(36)	-	YES	-	-
20	createddate	timestamp	-	YES	CURRENT_TIMESTAMP	-
21	modifiedby	varchar(36)	-	YES	-	-
22	modifieddate	datetime(6)	-	YES	-	-
23	modifiedtimestamp	binary(8)	-	NO	-	-
24	isfrozen	tinyint(1)	-	NO	0	-
25	traderid	varchar(20)	-	YES	-	-
26	tradertype	varchar(2)	-	YES	-	-
27	consignmenttype	varchar(14)	-	NO	STANDARD	-
28	companyid	varchar(30)	-	YES	-	-
29	shipmenttype	varchar(2)	-	YES	-	-
30	shipmentid	varchar(30)	-	YES	-	-
31	shipmentitem	int	-	NO	0	-
32	batchid	varchar(30)	-	YES	-	-
33	bestbefore	datetime(6)	-	YES	-	-
34	classification	varchar(30)	-	YES	-	-
35	batchnumber	int	-	NO	-	-
36	olversionnumber	int	-	NO	0	-
37	committedquantity	double	-	NO	0	-
38	landedcostunitvalue	double	-	NO	0	-
39	auditoperation	varchar(8)	-	YES	-	-
40	uuid	varchar(36)	-	NO	-	-

Name	Unique	Columns
No indexes found.

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.