invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeeLeaseCarsCurrent: Nmbrs Employee Current Lease Cars

read only

  • Catalog: Nmbrs
  • Schema: Views
  • Label: Employee Current Lease Cars

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 48

The result can be cached on the client.

Table Columns

The columns of the table EmployeeLeaseCarsCurrent are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks 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

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: