dbo.A&GPredefinedEstimateItems

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.A&GPredefinedEstimateItems.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	predefined_item_id	uniqueidentifier	no		Primary key identifying this predefined estimate line item (A&G estimating template).
2	item_type	nvarchar(50)	yes		Category/classification of the estimate item (e.g. material, labour, trade type).
3	reference_code	uniqueidentifier	yes		Reference identifier linking this item to its source record in the estimating system.
4	estimate_template_category	nvarchar(255)	yes		Category grouping within the estimate template that this item belongs to.
5	estimate_item_type	nvarchar(100)	yes		Type/sub-category of the estimate item within its template category.
6	description	nvarchar(MAX)	no		Plain-English description of the estimate line item shown to estimators.
7	notes	nvarchar(MAX)	yes		Free-text notes about the predefined estimate item.
8	trade	nvarchar(255)	yes		Trade this estimate item applies to (e.g. carpentry, plumbing, electrical).
9	material_unit	nvarchar(50)	yes		Unit of measure for materials on this item (e.g. "m2", "each", "lm").
10	material_cost	decimal(18,2)	no		Unit cost of materials for this estimate item.
11	material_quantity	decimal(18,4)	no		Default quantity of materials required for this estimate item.
12	material_markup_percentage	decimal(9,4)	no		Markup percentage applied to material cost for this estimate item.
13	labour_unit	nvarchar(50)	yes		Unit of measure for labour on this item (e.g. "hour").
14	labour_cost	decimal(18,2)	no		Unit cost of labour for this estimate item.
15	labour_quantity	decimal(18,4)	no		Default quantity of labour hours required for this estimate item.
16	labour_markup_percentage	decimal(9,4)	no		Markup percentage applied to labour cost for this estimate item.
17	tax	decimal(9,4)	no		Tax rate percentage (e.g. GST) applied to this estimate item.
18	external_system	nvarchar(100)	yes		Name of the external estimating system this predefined item originates from.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__A&GPrede__66E4D654EB7EB018	CLUSTERED	yes	yes	predefined_item_id