zBSC_workings_02_stepcosts

efacdb_full · Custom/model/helper tables

Type

BASE TABLE

Rows est.

96,002

Size

26.56 MB

Updated

Columns

Full schema, no data mutation.

#	Name	Type	Key	Nullable	Default	Comment
1	partid	varchar(64)	PRI	NO	-	-
2	sm	varchar(32)	-	YES	-	-
3	iscalculated	tinyint(1)	-	NO	0	-
4	batchsize	decimal(18,6)	-	YES	-	-
5	surplusN_raw	decimal(18,6)	-	YES	-	-
6	surplusN	decimal(18,6)	-	YES	-	-
7	unallocatedsurplusbatchsize	decimal(18,6)	-	YES	-	-
8	deductibleqty	decimal(18,6)	-	NO	0.000000	-
9	externalqtypa	decimal(18,6)	-	NO	0.000000	-
10	totalqtypa	decimal(18,6)	-	NO	0.000000	-
11	cost_of_capital_annual	decimal(18,6)	-	NO	0.000000	-
12	run_time_hr_per_unit	decimal(18,6)	-	YES	-	-
13	set_time_hr_per_batch	decimal(18,6)	-	YES	-	-
14	run_cost_per_unit_mac	decimal(18,6)	-	YES	-	-
15	run_cost_per_unit_lab	decimal(18,6)	-	YES	-	-
16	set_cost_per_batch_macoff	decimal(18,6)	-	YES	-	-
17	set_cost_per_batch_macon	decimal(18,6)	-	YES	-	-
18	material_cost_per_unit	decimal(18,6)	-	YES	-	-
19	stepCostperunitMat	decimal(18,6)	-	YES	-	-
20	stepCostperunitRunMac	decimal(18,6)	-	YES	-	-
21	stepCostperunitRunLab	decimal(18,6)	-	YES	-	-
22	stepCostperunitSetMacoff	decimal(18,6)	-	YES	-	-
23	stepCostperunitSetMacon	decimal(18,6)	-	YES	-	-
24	stepCostperunitStock	decimal(18,6)	-	YES	-	-

Name	Unique	Columns
PRIMARY	Yes	partid

EFACS has few enforced keys; many relationships are conventional.

Column	References
No enforced foreign keys found for this table.