invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

EmployeeLeaseCarsByCompanyYearPeriod: Nmbrs Leaseauto's per Bedrijf, Jaar en Periode

read only per partition XML

  • Catalogus: Nmbrs
  • Schema: Employees
  • Label: Leaseauto's per Bedrijf, Jaar en Periode

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom COMPANY_CODE.

Kan alleen gegevens ophalen.

API-bron

  • XML-service: EmployeeService.asmx
  • XML-onderwerp: LeaseCar_GetAll_EmployeesByCompany
  • XML-pad: /nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 48

Het resultaat kan op de client in de Cache worden opgeslagen.

Parameters

Name Datatype Required Default Documentation
Period number Loonperiode binnen het jaar.
Year number Loonjaar.

Tabelkolommen

De kolommen van de tabel EmployeeLeaseCarsByCompanyYearPeriod worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
ADDITIONPERCENTAGE varchar2 Toevoeging (%) /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 Cataloguswaarde /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:CatalogValue
CO2EMISSIONS varchar2 CO2 Uitstoot /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:CO2Emissions
COMPANY_CODE int64 Bedrijf ID
CONTRACTDURATION int32 Contractduur /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContractDuration
CONTRACTLEASECOMPANY varchar2 Contract lease Bedrijf /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContractLeaseCompany
CONTRACTNUMBER varchar2 Contractnummer /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContractNumber
CONTRIBUTIONNOTDEDUCTIBLE decimal Bijdrage niet Aftrekbaar /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContributionNotDeductible
CONTRIBUTIONPRIVATEPERCENTAGE int32 Bijdrage Privégebruik (%) /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContributionPrivatePercentage
CONTRIBUTIONPRIVATEUSE decimal Bijdrage Privégebruik /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ContributionPrivateUse
EMPLOYEEID int32 Werknemer ID /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:EmployeeId
ENDDATE datetime Einddatum /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:EndDate
FIRSTREGISTRATIONDATE datetime Eerste Registratiedatum /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:FirstResgistrationDate
ID int32 ID /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:Id
LEASINGPRICEMONTH decimal Leaseprijs per maand /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:LeasingPriceMonth
LICENSEPLATE varchar2 Kentekenplaat /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:LicensePlate
MAXMILEAGE int32 Maximale Kilometerstand /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 Onbetaalbare kilometers /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:PriceLessMileage
PRICEMOREMILEAGE decimal Prijs Meer Kilometer /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:PriceMoreMileage
REASONNOCONTRIBUTION int32 Reden Geen bijdrage /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:ReasonNoContribution
STARTDATE datetime Startdatum /soap:Envelope/soap:Body/nes:LeaseCar_GetAll_EmployeesByCompanyResponse/nes:LeaseCar_GetAll_EmployeesByCompanyResult/nes:EmployeeLeaseCars/nes:LeaseCars/nes:EmployeeLeaseCar/nes:StartDate

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: