dbo.primeExportCurrentMonthSalesForecastList

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Supervisor	varchar(100)	yes		Display name of the supervisor
2	Case_Manager	varchar(100)	yes		Display name of the case manager
3	Assigned	varchar(100)	yes		Display name of the user this job/record is assigned to
4	Invoice_Number	varchar(50)	no		Invoice number/reference
5	Job_Number	varchar(50)	yes		Human-readable job number/reference used in Prime Ecosystem
6	Site_Address	text(16)	yes		Full site/property address for the job
7	Invoice_Invoiced_Date	date	yes		Date the invoice was issued
8	Invoice_Amount_Excl_Tax	decimal(15,4)	yes		Invoice amount excluding tax
9	Status	varchar(20)	yes		Current status of this record
10	Notes	text(16)	yes		Free-text internal notes

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__primeExp__541A9041EA524A1E	CLUSTERED	yes	yes	Invoice_Number

Referenced by

Procedures: dbo.spPrimeUpsertExportCurrentMonthSalesForecastList