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

# EmployeeLeaseCarsByCompanyYearPeriod : Nmbrs Voitures de société en location par entreprise, année et période

`read only` `per partition` `XML`

- Catalogue : `Nmbrs`
- Schéma : `Employees`
- Libellé : Voitures de société en location par entreprise, année et période

Les données de cette table sont partitionnées en fonction de la valeur de la colonne `COMPANY_CODE`.

Permet uniquement de récupérer des données.

## Source de l'API

- Service XML : `EmployeeService.asmx`
- Rubrique XML : `LeaseCar_GetAll_EmployeesByCompany`
- Chemin XML : `/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar`

## Caractéristiques de performance

| Characteristic | Value |
|---|---:|
| Latence moyenne d'accès (ms) | 48 |

Le résultat peut être mis en cache côté client.

## Paramètres

| Name | Type de données | Required | Default | Documentation |
|---|---|:---:|---|---|
| `Period` | `number` | [x] |  | Période de paie au sein de l'année. |
| `Year` | `number` | [x] |  | Année de paie. |

## Colonnes de table

Les colonnes de la table `EmployeeLeaseCarsByCompanyYearPeriod` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ADDITIONPERCENTAGE` | `varchar2` | Addition (%) | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:AdditionPercentage` |  |
| `BRAND` | `varchar2` | Brand | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:Brand` |  |
| `CATALOGVALUE` | `decimal` | Valeur catalogue | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:CatalogValue` |  |
| `CO2EMISSIONS` | `varchar2` | Émissions de CO2 | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:CO2Emissions` |  |
| `COMPANY_CODE` | `int64` | ID de l'entreprise | [x] |  |  |
| `CONTRACTDURATION` | `int32` | Durée du contrat | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContractDuration` |  |
| `CONTRACTLEASECOMPANY` | `varchar2` | Société de location longue durée | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContractLeaseCompany` |  |
| `CONTRACTNUMBER` | `varchar2` | Numéro de contrat | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContractNumber` |  |
| `CONTRIBUTIONNOTDEDUCTIBLE` | `decimal` | Cotisation non déductible | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContributionNotDeductible` |  |
| `CONTRIBUTIONPRIVATEPERCENTAGE` | `int32` | Part de l'usage privé (%) | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContributionPrivatePercentage` |  |
| `CONTRIBUTIONPRIVATEUSE` | `decimal` | Contribution à usage privé | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContributionPrivateUse` |  |
| `EMPLOYEEID` | `int32` | ID d'employé | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:EmployeeId` |  |
| `ENDDATE` | `datetime` | Date de fin | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:EndDate` |  |
| `FIRSTREGISTRATIONDATE` | `datetime` | Date de première immatriculation | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:FirstResgistrationDate` |  |
| `ID` | `int32` | ID | [x] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:Id` |  |
| `LEASINGPRICEMONTH` | `decimal` | Loyer mensuel | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:LeasingPriceMonth` |  |
| `LICENSEPLATE` | `varchar2` | La plaque d'immatriculation | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:LicensePlate` |  |
| `MAXMILEAGE` | `int32` | Kilométrage maximal | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:MaxMileage` |  |
| `MODEL` | `varchar2` | Model | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:Model` |  |
| `PRICELESSMILEAGE` | `decimal` | Des kilomètres inestimables | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:PriceLessMileage` |  |
| `PRICEMOREMILEAGE` | `decimal` | Prix et kilométrage | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:PriceMoreMileage` |  |
| `REASONNOCONTRIBUTION` | `int32` | Motif : aucune contribution | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ReasonNoContribution` |  |
| `STARTDATE` | `datetime` | Date de début | [ ] | `/soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:StartDate` |  |


## Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

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