---
title: "EmployeeLeaseCarsV2ByCompanyYearPeriod (Nmbrs)"
description: "Lease Cars by Company, Year and Period"
language: de
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/de/datamodels/nmbrs/Nmbrs.Employees.EmployeeLeaseCarsV2ByCompanyYearPeriod
original: https://documentation.invantive.eu/en/datamodels/nmbrs/Nmbrs.Employees.EmployeeLeaseCarsV2ByCompanyYearPeriod
updated: 2026-11-18T23:38:02Z
license: https://documentation.invantive.eu/de/
---

# EmployeeLeaseCarsV2ByCompanyYearPeriod: Nmbrs Leasingautos nach Unternehmen, Jahr und Periode

`read only` `per partition` `XML`

- Katalog: `Nmbrs`
- Schema: `Employees`
- Bezeichnung: Leasingautos nach Unternehmen, Jahr und Periode

Die Daten in dieser Tabelle sind nach dem Wert der Spalte `COMPANY_CODE` aufgeteilt.

Es können nur Daten abgerufen werden.

## API-Quelle

- XML-Dienst: `EmployeeService.asmx`
- XML-Thema: `LeaseCar2_GetAll_EmployeesByCompany`
- XML-Pfad: `/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar`

## Leistungsmerkmale

| Characteristic | Value |
|---|---:|
| Durchschnittliche Zugriffsverzögerung (ms) | 48 |

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

## Parameter

| Name | Datentyp | Required | Default | Documentation |
|---|---|:---:|---|---|
| `Period` | `number` | [x] |  | Abrechnungsperiode innerhalb des Jahres. |
| `Year` | `number` | [x] |  | Lohnjahr. |

## Tabellenspalten

Die Spalten der Tabelle `EmployeeLeaseCarsV2ByCompanyYearPeriod` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ADDITIONPERCENTAGE` | `varchar2` | Zusatz (%) | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:AdditionPercentage` |  |
| `BRAND` | `varchar2` | Brand | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:Brand` |  |
| `CATALOGVALUE` | `decimal` | Katalogwert | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:CatalogValue` |  |
| `CO2EMISSIONS` | `varchar2` | CO₂-Emissionen | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:CO2Emissions` |  |
| `COMPANY_CODE` | `int64` | Firmen ID | [x] |  |  |
| `CONTRACTDURATION` | `int32` | Vertragsdauer | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContractDuration` |  |
| `CONTRACTLEASECOMPANY` | `varchar2` | Leasinggesellschaft | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContractLeaseCompany` |  |
| `CONTRACTNUMBER` | `varchar2` | Vertragsnummer | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContractNumber` |  |
| `CONTRIBUTIONNOTDEDUCTIBLE` | `decimal` | Beitrag nicht abzugsfähig | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContributionNotDeductible` |  |
| `CONTRIBUTIONPRIVATEPERCENTAGE` | `int32` | Anteil der privaten Nutzung (%) | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContributionPrivatePercentage` |  |
| `CONTRIBUTIONPRIVATEUSE` | `decimal` | Beitrag – Privater Gebrauch | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContributionPrivateUse` |  |
| `EMPLOYEEID` | `int32` | Mitarbeiter ID | [ ] |  |  |
| `ENDDATE` | `datetime` | Enddatum | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:EndDate` |  |
| `FIRSTREGISTRATIONDATE` | `datetime` | Datum der Erstregistrierung | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:FirstResgistrationDate` |  |
| `ID` | `int32` | ID | [x] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:Id` |  |
| `LEASINGPRICEMONTH` | `decimal` | Monatliche Leasingrate | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:LeasingPriceMonth` |  |
| `LICENSEPLATE` | `varchar2` | Nummernschild | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:LicensePlate` |  |
| `MAXMILEAGE` | `int32` | Maximale Laufleistung | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:MaxMileage` |  |
| `MODEL` | `varchar2` | Model | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:Model` |  |
| `PRICELESSMILEAGE` | `decimal` | Unbezahlbare Meilen | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:PriceLessMileage` |  |
| `PRICEMOREMILEAGE` | `decimal` | Preis Mehr Kilometerleistung | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:PriceMoreMileage` |  |
| `REASONNOCONTRIBUTION` | `int32` | Grund: Kein Beitrag | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ReasonNoContribution` |  |
| `STARTDATE` | `datetime` | Anfangsdatum | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar2_GetAll_EmployeesByCompanyResponse/nes:LeaseCar2_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:StartDate` |  |


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

- [Nmbrs](/de/release-notes/drivers?driver=nmbrs)
