dbo.primeExportWIPJobsWithoutForecast

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.primeExportWIPJobsWithoutForecast.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	Job_Number	varchar(20)	yes		Human-readable job number/reference used in Prime Ecosystem
4	Current_Status	varchar(50)	yes		Current status of the job/record
5	Site_Address	text(16)	yes		Full site/property address for the job
6	Jobs_Authorised_Total_Inc_Tax	decimal(15,2)	yes		Total authorised job value including tax
7	Authorised_Locked_Estimate_Count	int	yes		Count of authorised/locked estimates for this job
8	Authorised_Works_Orders_Total	decimal(15,2)	yes		Total value of authorised work orders
9	Accounts_Payable_Invoice_Total_Authorised_Works	decimal(15,2)	yes		Total accounts-payable invoice amount for authorised works
10	Accounts_Receivable_Total	decimal(15,2)	yes		Total accounts-receivable amount
11	Authorised_Works_Accounts_Receivable_Total	decimal(15,2)	yes		Total accounts-receivable amount for authorised works
12	Excess_Amount	decimal(10,2)	yes		Insurance excess amount payable by the customer
13	Assigned	varchar(100)	yes		Display name of the user this job/record is assigned to

Referenced by

Procedures: dbo.spPrimeUpsertExportWIPJobsWithoutForecast