Skip to content

dbo.primeExportAssetUtilisation ​

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

Columns ​

#ColumnTypeNullableFlagsDescription
1Assetnvarchar(100)noName/description of the asset
2SerialNumbernvarchar(100)noSerial number of the asset
3InPossessionnvarchar(500)yesIndicates who currently has possession of the item
5JobNumbernvarchar(500)yescomputedHuman-readable job number/reference used in Prime Ecosystem
7InUsebityescomputedFlag indicating whether this record is currently in use
8StaleRecordbitnoFlag indicating the record is stale and needs refreshing

Referenced by ​

Procedures: dbo.spPrimeDeleteExportAssetUtilisation, dbo.spPrimeExportAssetUtilisationSetStale, dbo.spPrimeInsertExportAssetUtilisation