LeaseEndReason Table

LeaseEndReason is a static table listing all the reasons that a company terminates a lease.

Table 1. Database columns for LeaseEndReason table

Database Column



Type: integer. Key. Generated ID

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

  • 1 = [empty string]
  • 2 = Lease Ended - Asset Returned
  • 3 = Early Termination - Asset Returned
  • 4 = Buyout
  • 5 = Early Buyout
  • 6 = Trade.

Type: text (max 256 characters). Key

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


Type: text (max 100 characters)

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