dbo.EthNonPrefinedItems

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Estimate	nvarchar(100)	yes		Reference/label of the estimate this non-pre-defined line item belongs to.
2	Category Label	nvarchar(50)	yes		Display label of the estimate category the item was added under.
3	Category Notes	nvarchar(50)	yes		Free-text notes recorded against the estimate category.
4	Trade	nvarchar(50)	yes		Trade (e.g. plumbing, electrical, carpentry) the line item relates to.
5	Item Description	nvarchar(MAX)	yes		Description of the non-pre-defined (manually entered/non-catalog) line item.
6	Item Notes	nvarchar(MAX)	yes		Free-text notes recorded against the line item.
7	material Unit	nvarchar(50)	yes		Unit of measure used for the material portion of the item (e.g. each, m2, lm).
8	material Quantity	decimal(18,2)	yes		Quantity of material used for the item, in material Unit.
9	material Cost	decimal(18,2)	yes		Cost of materials for the line item.
10	labour Unit	nvarchar(50)	yes		Unit of measure used for the labour portion of the item (e.g. hour, each).
11	labour Quantity	decimal(18,2)	yes		Quantity of labour for the item, in labour Unit.
12	labour Cost	decimal(18,2)	yes		Cost of labour for the line item.