zCRT_inputs_VolumeSetLines

efacdb_full · Custom/model/helper tables

Type

BASE TABLE

Rows est.

7,079

Size

0.69 MB

Updated

2026-04-02 21:27:15

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	label_id	int	PRI	NO	-	-
2	partid	varchar(30)	PRI	NO	-	-
3	qty	double	-	NO	-	-
4	original_price	decimal(19,4)	-	YES	-	-

Name	Unique	Columns
PRIMARY	Yes	label_id, partid
idx_vsl_partid	No	partid

EFACS has few enforced keys; many relationships are conventional.

Column	References
label_id	zCRT_inputs_VolumeSets.label_id