dbo.primeExportRestorationSales

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

Columns

#	Column	Type	Nullable	Flags	Description
1	JobNumber	nvarchar(50)	yes		Human-readable job number/reference used in Prime Ecosystem
2	Supervisor	nvarchar(100)	yes		Display name of the supervisor
3	SiteAddress	nvarchar(255)	yes		Full site/property address for the job
4	WorkOrderNumber	nvarchar(50)	yes		Work order number/reference
5	WorkOrderType	nvarchar(100)	yes		Type/category of work order
6	WorkOrderAssigned	nvarchar(100)	yes		Display name of who the work order is assigned to
7	WorkOrderSellTotalIncTax	decimal(18,2)	yes		Total sell (billed) value of the work order including tax
8	Status	nvarchar(50)	yes		Current status of this record
9	WorkOrderCreatedDate	datetime	yes		Date the work order was created
10	Completion	date	yes		Date/percentage the work was completed

Referenced by

Procedures: dbo.spPrimeUpsertExportRestorationSales