dbo.PrimeLockedEstimatesThisYear

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

Columns

#	Column	Type	Nullable	Flags	Description
1	JobNumber	varchar(50)	yes		Human-readable job number/reference used in Prime Ecosystem
2	JobType	nvarchar(50)	yes		Type/category of job (e.g. Insurance, Commercial, Make Safe)
3	FilterTags	nvarchar(500)	yes		Comma-separated display list of filter tags applied to this record
4	fullName	nvarchar(200)	yes		Contact's full name
5	client	nvarchar(255)	yes		Display name of the client
6	EstimateID	uniqueidentifier	yes		Foreign key to the related estimate
7	jobId	uniqueidentifier	yes		Foreign key to primeJobs
8	Estimate_Label	nvarchar(255)	yes		Display label/name of the estimate
9	Estimate_Description	nvarchar(MAX)	yes		Description of the estimate
10	estimateStatus	nvarchar(50)	yes		Status of the estimate (e.g. Draft, Locked, Authorised)
11	isVariation	bit	yes		Flag indicating this is a variation to the original scope of work
12	estimateType	nvarchar(100)	yes		Type/category of the estimate
13	totalIncludingTax	decimal(18,2)	yes		Total amount including tax
14	authorisedTotalExcludingTax	decimal(18,2)	yes		Total authorised (approved) job value excluding tax
15	authorisedTotalIncludingTax	decimal(18,2)	yes		Total authorised (approved) job value including tax
16	Estimate_CreatedAt	datetime	yes		Timestamp the record was created
17	Estimate_CreatedBy	nvarchar(100)	yes		User/system that created the record
18	Estimate_UpdatedAt	datetime	yes		Timestamp the record was last updated
19	Estimate_UpdatedBy	nvarchar(100)	yes		User/system that last updated the record
20	Estimate_Version	bigint	yes		Optimistic-concurrency row version number of the estimate
21	Category_CategoryID	uniqueidentifier	yes		Foreign key reference to the related Category_Category record
22	Category_EstimateID	uniqueidentifier	yes		Foreign key reference to the related Category_Estimate record
23	Category_Type	nvarchar(50)	yes		Type/classification of the estimate category
24	Category_Label	nvarchar(255)	yes		Display label of the estimate category
25	Category_Description	nvarchar(MAX)	yes		Description of the estimate category
26	Category_MaterialMargin	decimal(10,6)	yes		Margin percentage applied to material cost for this category
27	Category_LabourMargin	decimal(10,6)	yes		Margin percentage applied to labour cost for this category
28	ItemID	uniqueidentifier	yes		Foreign key to the related line item
29	Item_CategoryID	uniqueidentifier	yes		Foreign key reference to the related Item_Category record
30	Item_Authorised	bit	yes		Flag indicating whether this estimate item has been authorised
31	trade	nvarchar(100)	yes		Trade/skill category (e.g. Plumbing, Electrical, Carpentry)
32	Item_Description	nvarchar(MAX)	yes		Description of the estimate item
33	notes	nvarchar(MAX)	yes		Free-text internal notes
34	materialUnit	nvarchar(50)	yes		Unit of measure for material quantity
35	materialQuantity	decimal(18,2)	yes		Quantity of materials
36	materialCost	decimal(18,2)	yes		Cost of materials
37	materialTotal	decimal(18,2)	yes		Total material amount
38	materialMarkup	decimal(10,6)	yes		Markup percentage applied to material cost
39	materialMarkupTotal	decimal(18,2)	yes		Total markup amount applied to materials
40	labourUnit	nvarchar(50)	yes		Unit of measure for labour quantity
41	labourQuantity	decimal(18,2)	yes		Quantity of labour (hours/units)
42	labourCost	decimal(18,2)	yes		Cost of labour
43	labourTotal	decimal(18,2)	yes		Total labour amount
44	labourMarkup	decimal(10,6)	yes		Markup percentage applied to labour cost
45	labourMarkupTotal	decimal(18,2)	yes		Total markup amount applied to labour
46	tax	decimal(10,2)	yes		Tax amount
47	Item_MaterialMargin	decimal(10,6)	yes		Margin percentage applied to material cost for this item
48	Item_LabourMargin	decimal(10,6)	yes		Margin percentage applied to labour cost for this item
49	additionalMargin	decimal(18,2)	yes		Additional margin percentage applied on top of standard margin

Referenced by

Procedures: dbo.spPrimeBuildLockedEstimatesThisYear