Appearance
dbo.primeExportClosedJobReviewARTotal
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.primeExportClosedJobReviewARTotal.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | JobNumber | nvarchar(50) | no | Human-readable job number/reference used in Prime Ecosystem | |
| 2 | AuthorisedWorksAccountsReceivableTotalExclTax | decimal(14,3) | no | Total accounts-receivable amount for authorised works, excluding tax |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK_primeExportClosedJobReviewARTotal | CLUSTERED | yes | yes | JobNumber |
Referenced by
Procedures: dbo.spPrimeExportUpsertClosedJobReviewARTotal

