# EmployeeLeaseCarsCurrent: Nmbrs Employee Current Lease Cars - Catalog: `Nmbrs` - Schema: `Views` - Label: Employee Current Lease Cars This is a read-only view. The Nmbrs API may not support changing the data or the Invantive UniversalSQL driver for Nmbrs does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Nmbrs API. ## View Columns The columns of the view `EmployeeLeaseCarsCurrent` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ELR_ADDITIONPERCENTAGE` | `varchar2` | Addition (%) | ☐ | | | `ELR_BRAND` | `varchar2` | Brand | ☐ | | | `ELR_CATALOGVALUE` | `decimal` | Catalog Value | ☐ | | | `ELR_CO2EMISSIONS` | `varchar2` | CO2 Emissions | ☐ | | | `ELR_CONTRACTDURATION` | `int32` | Contract Duration | ☐ | | | `ELR_CONTRACTLEASECOMPANY` | `varchar2` | Contract Lease Company | ☐ | | | `ELR_CONTRACTNUMBER` | `varchar2` | Contract Number | ☐ | | | `ELR_CONTRIBUTIONNOTDEDUCTIBLE` | `decimal` | Contribution Not Deductible | ☐ | | | `ELR_CONTRIBUTIONPRIVATEPERCENTAGE` | `int32` | Contribution Private Use (%) | ☐ | | | `ELR_CONTRIBUTIONPRIVATEUSE` | `decimal` | Contribution Private Use | ☐ | | | `ELR_EMPLOYEEID` | `int32` | Employee ID | ☐ | | | `ELR_ENDDATE` | `datetime` | End Date | ☐ | | | `ELR_FIRSTREGISTRATIONDATE` | `datetime` | First Registration Date | ☐ | | | `ELR_ID` | `int32` | ID | ☑ | | | `ELR_LEASINGPRICEMONTH` | `decimal` | Leasing Price per Month | ☐ | | | `ELR_LICENSEPLATE` | `varchar2` | License Plate | ☐ | | | `ELR_MAXMILEAGE` | `int32` | Maximum Mileage | ☐ | | | `ELR_MODEL` | `varchar2` | Model | ☐ | | | `ELR_PRICELESSMILEAGE` | `decimal` | Priceless Mileage | ☐ | | | `ELR_PRICEMOREMILEAGE` | `decimal` | Price More Mileage | ☐ | | | `ELR_REASONNOCONTRIBUTION` | `int32` | Reason No Contribution | ☐ | | | `ELR_STARTDATE` | `datetime` | Start Date | ☐ | | | `EMP_COMPANY_CODE` | `int64` | Company ID | ☑ | | | `EMP_DISPLAYNAME` | `varchar2` | Display Name | ☐ | | | `EMP_ID` | `int32` | Employee ID | ☑ | | | `EMP_NUMBER` | `int32` | Employee Number | ☑ | |