EndOfLifeReason Table

EndOfLifeReason is a static table storing the collection of all reasons for disposing of an asset.

Table 1. Database columns for EndOfLifeReason table

Database Column

Details

EndOfLifeReasonID

Type: integer. Key. Generated ID

A unique identifier for each EndOfLifeReason. Possible values and the corresponding default strings are:

  • 1 = [empty string]
  • 2 = Lost
  • 3 = Stolen
  • 4 = Disposed
  • 5 = Sold
  • 6 = Donated
  • 7 = Broken.
ResourceName

Type: text (max 50 characters). Key

The unique name of the localizable resource string representing an end-of-life reason. Foreign key to the ComplianceResourceString table.

DefaultValue

Type: text (max 100 characters)

The text to display if the reason resource string has no translation.