Appearance
dbo.primeExportAssetUtilisation
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.primeExportAssetUtilisation.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | Asset | nvarchar(100) | no | Name/description of the asset | |
| 2 | SerialNumber | nvarchar(100) | no | Serial number of the asset | |
| 3 | InPossession | nvarchar(500) | yes | Indicates who currently has possession of the item | |
| 5 | JobNumber | nvarchar(500) | yes | computed | Human-readable job number/reference used in Prime Ecosystem |
| 7 | InUse | bit | yes | computed | Flag indicating whether this record is currently in use |
| 8 | StaleRecord | bit | no | Flag indicating the record is stale and needs refreshing |
Referenced by
Procedures: dbo.spPrimeDeleteExportAssetUtilisation, dbo.spPrimeExportAssetUtilisationSetStale, dbo.spPrimeInsertExportAssetUtilisation

