dbo.primeExportPastInvoices

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

Columns

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

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__primeExp__0CE656A5777EC1FC	CLUSTERED	yes	yes	Job_Number

Referenced by

Procedures: dbo.spPrimeUpsertExportPastInvoices