dbo.primeExportClosedJobReviewCosts

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

Columns

#	Column	Type	Nullable	Flags	Description
1	JobNumber	nvarchar(50)	no		Human-readable job number/reference used in Prime Ecosystem
2	WorkOrderCost	decimal(14,3)	no		Cost of the work order
3	Supervisor	nvarchar(512)	yes		Display name of the supervisor
4	WorkOrdersSellTotal	decimal(14,3)	yes		Total sell (billed) value of work orders
5	Tags	nvarchar(512)	yes		Comma-separated list of tags
6	Expenses	decimal(14,3)	yes		Expense amount incurred

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_primeExportClosedJobReviewCosts	CLUSTERED	yes	yes	JobNumber

Referenced by

Procedures: dbo.spPrimeExportUpsertClosedJobReviewCosts