invantive documentation
Invantive SupportforenAnmelden / Eintragen

EmployeeAddresses: Nmbrs Mitarbeiteradressen

read only per partition XML

  • Katalog: Nmbrs
  • Schema: Employees
  • Bezeichnung: Mitarbeiteradressen

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: Address_GetAll_AllEmployeesByCompany
  • XML-Pfad: /nes:EmployeeAddresses/nes:EmployeeAddress_V2

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 48

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Tabellenspalten

Die Spalten der Tabelle EmployeeAddresses 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
CITY varchar2 City /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:City
COMPANY_CODE int64 Firmen ID
COUNTRYISOCODE varchar2 ISO-Ländercode /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:CountryISOCode
CREATIONDATE datetime Datum erstellen /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:CreationDate
EMPLOYEEID int32 Mitarbeiter ID /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeId
ENDPERIOD int32 Endperiode /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:EndPeriod
ENDYEAR int32 Letztes Jahr /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:EndYear
HOUSENUMBER varchar2 Hausnummer /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:HouseNumber
HOUSENUMBERADDITION varchar2 Hinzufügen einer Hausnummer /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:HouseNumberAddition
ID int32 ID /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:Id
POSTALCODE varchar2 Postleitzahl /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:PostalCode
STARTPERIOD int32 Startzeitraum /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:StartPeriod
STARTYEAR int32 Startjahr /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:StartYear
STATEPROVINCE varchar2 State/Province /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:StateProvince
STREET varchar2 Street /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:Street
TYPE varchar2 Type /soap:Envelope/soap:Body/nes:Address_GetAll_AllEmployeesByCompanyResponse/nes:Address_GetAll_AllEmployeesByCompanyResult/nes:EmployeeAddressItem/nes:EmployeeAddresses/nes:EmployeeAddress_V2/nes:Type One of 'HomeAddress', 'PostAddress', 'AbsenceAddress', 'HolidaysAddress', 'WeekendAddress'.

Anmerkungen zu dieser Version

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