Skip to content

dbo.primeExportClosedJobReviewARTotal ​

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

Columns ​

#ColumnTypeNullableFlagsDescription
1JobNumbernvarchar(50)noHuman-readable job number/reference used in Prime Ecosystem
2AuthorisedWorksAccountsReceivableTotalExclTaxdecimal(14,3)noTotal accounts-receivable amount for authorised works, excluding tax

Indexes ​

NameTypeUniquePKKey columnsIncludedFilter
PK_primeExportClosedJobReviewARTotalCLUSTEREDyesyesJobNumber

Referenced by ​

Procedures: dbo.spPrimeExportUpsertClosedJobReviewARTotal