Appearance
dbo.primeExportConversionReport
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.primeExportConversionReport.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | JobNumber | varchar(20) | no | Human-readable job number/reference used in Prime Ecosystem | |
| 2 | SiteAddress | varchar(255) | yes | Full site/property address for the job | |
| 3 | AuthorisedTotalExclTax | decimal(12,2) | yes | Total authorised job value excluding tax | |
| 4 | QuoteSubmittedDate | datetime | yes | Date the quote was submitted | |
| 5 | CreatedDate | date | yes | Timestamp the record was created | |
| 6 | CurrentStatusType | varchar(50) | yes | Category/type of the current status | |
| 7 | Estimator | varchar(100) | yes | Display name of the estimator | |
| 8 | JobWon | bit | yes | computed | Flag indicating whether the job/quote was won |
| 9 | DaysSinceQuoteSubmitted | int | yes | computed | Number of days since the quote was submitted |
| 10 | LiveQuote | bit | yes | computed | Flag indicating this is a live (active) quote |
| 11 | WonLostStatus | varchar(5) | no | computed | Indicates whether the quote was won or lost |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK__primeExp__A6B9B8831D767C8D | CLUSTERED | yes | yes | JobNumber |
Referenced by
Procedures: dbo.spPrimeUpsertExportConversionReport