EmployeeLeaseCarsCurrentByEmployee: Nmbrs Employee Current Leasecar
read only XML
- Catalog:
Nmbrs - Schema:
Employees - Label: Employee Current Leasecar
Can only retrieve data.
API Source
- XML service:
EmployeeService.asmx - XML topic:
LeaseCar_GetCurrent - XML path:
/nes:LeaseCar_GetCurrentResult
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 49 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
Employee |
number |
Numeric ID of employee. |
Table Columns
The columns of the table EmployeeLeaseCarsCurrentByEmployee 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 |
|---|---|---|---|---|---|
ADDITIONPERCENTAGE |
varchar2 |
Addition (%) | / |
||
BRAND |
varchar2 |
Brand | / |
||
CATALOGVALUE |
decimal |
Catalog Value | / |
||
CO2 |
varchar2 |
CO2 Emissions | / |
||
CONTRACTDURATION |
int32 |
Contract Duration | / |
||
CONTRACTLEASECOMPANY |
varchar2 |
Contract Lease Company | / |
||
CONTRACTNUMBER |
varchar2 |
Contract Number | / |
||
CONTRIBUTIONNOTDEDUCTIBLE |
decimal |
Contribution Not Deductible | / |
||
CONTRIBUTIONPRIVATEPERCENTAGE |
int32 |
Contribution Private Use (%) | / |
||
CONTRIBUTIONPRIVATEUSE |
decimal |
Contribution Private Use | / |
||
EMPLOYEEID |
int32 |
Employee ID | |||
ENDDATE |
datetime |
End Date | / |
||
FIRSTREGISTRATIONDATE |
datetime |
First Registration Date | / |
||
ID |
int32 |
ID | / |
||
LEASINGPRICEMONTH |
decimal |
Leasing Price per Month | / |
||
LICENSEPLATE |
varchar2 |
License Plate | / |
||
MAXMILEAGE |
int32 |
Maximum Mileage | / |
||
MODEL |
varchar2 |
Model | / |
||
PRICELESSMILEAGE |
decimal |
Priceless Mileage | / |
||
PRICEMOREMILEAGE |
decimal |
Price More Mileage | / |
||
REASONNOCONTRIBUTION |
int32 |
Reason No Contribution | / |
||
STARTDATE |
datetime |
Start Date | / |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: