zCRU_BOM_Flat

efacdb_full · Useful derived outputs

Derived flattened BOM for fast where-used/explosion queries.

Type

BASE TABLE

Rows est.

2,240,169

Size

221.30 MB

Updated

2026-04-03 13:51:11

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	rootpart	varchar(30)	MUL	YES	-	-
2	childpart	varchar(30)	MUL	YES	-	-
3	lvl	bigint	-	YES	-	-
4	qty_mult	decimal(30,10)	-	YES	-	-

Name	Unique	Columns
zCRU_idx_bomflat_child	No	childpart
zCRU_idx_bomflat_root	No	rootpart

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.