OwnerAdministrationAssignedTypes: Exact Online Current Customer Administration Assigned Types
insert update per partition XML
- Katalog:
ExactOnlineXML - Schema:
XML - Label: Current Customer Administration Assigned Types
Die Daten in dieser Tabelle sind nach dem Wert der Spalte Division aufgeteilt.
Mit insert und update können Daten abgerufen und geändert werden.
Zusammenfassung
Additional where-clause columns supported:
- division
- code
- number_from
- number_to
- startdate_from
- startdate_to
API-Quelle
- XML-Dienst:
Administrations - XML-Thema:
Administrations - XML-Pfad:
/AdministrationTypes/AdministrationType
Tabellenspalten
Die Spalten der Tabelle OwnerAdministrationAssignedTypes 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 |
|---|---|---|---|---|---|
ADMINISTRATIONTYPES_ |
varchar2 |
Activity Sector Code | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Activity Sub Sector Code | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Address Line 1 | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Address Line 2 | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Address Line 3 | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Blocking Status | / |
0=Not blocked, 1=Backup, 2=Conversion busy, 3=Conversion shadow, 4=Conversion waiting, 5=Copy data waiting, 6=Copy data busy | |
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Business Type Code | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Chamber of Commerce | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Chamber of Commerce Establishment | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration City | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Verwaltungsgesetzbuch | / |
The internal unique code of the administration. | |
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Company Size Code | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Landescode | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Länderbeschreibung | / |
||
ADMINISTRATIONTYPES_ |
number |
itgen_eol_administrations_administration_country_description Term ID | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Currency Code | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Currency Description | / |
||
ADMINISTRATIONTYPES_ |
number |
itgen_eol_administrations_administration_currency_description Term ID | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Digital Post Boxes | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Division Class Names | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Email | / |
||
ADMINISTRATIONTYPES_ |
date |
Administration End Date | / |
End date: YYYY-MM-DD | |
ADMINISTRATIONTYPES_ |
varchar2 |
Administration ETT Source | / |
0=Not applicable, 1=ProAcc PersProf, 2=ProAcc Corporate, 3=ProAcc Studio, 4=Cubic, 5=Globe, 6=ExactOnLine, 7=Winbooks, 8=Auditfile - Twinfield, 9=Auditfile - Microsoft Navision Attain, 10=Auditfile - iMUIS, 11=Auditfile - Reeleezee Audit, 12=Auditfile - SAP SBO NL, 13=Auditfile - Yuki, 14=Auditfile - Snelstart Reserve [15 to 18] for dataswitcher conversion sources, not displaying it in documentation 15=DataSwitcher - Vero 16=DataSwitcher - SageBob 17=DataSwitcher - ExpertM 18=DataSwitcher - Adsolut | |
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Fax | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Home Page | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Verwaltung Name | / |
||
ADMINISTRATIONTYPES_ |
number |
Verwaltungsnummer | / |
The external code of the administration as shown in the administration card. | |
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Phone | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Phone Extension | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Postal Code | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
SBI-Code | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration SEPA Direct Dunning Creditor Identifier | / |
||
ADMINISTRATIONTYPES_ |
date |
Administration Start Date | / |
Start date: YYYY-MM-DD | |
ADMINISTRATIONTYPES_ |
varchar2 |
Statuscode | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Status-Beschreibung | / |
||
ADMINISTRATIONTYPES_ |
number |
itgen_eol_administrations_administration_state_description Term ID | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration User Administrations | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration VAT Number | / |
||
CODE_ |
varchar2 |
Code | / |
||
DESCRIPTION |
varchar2 |
Description | / |
||
DIVISION_ |
varchar2 |
Verwaltung ID | Interne einzigartige Nummer der Exact Online-Verwaltung. | ||
DIVISION_ |
int64 |
Administration | Number of the Exact Online administration.Not guaranteed to be unique. | ||
DIVISION_ |
varchar2 |
Verwaltung Name | Name of the Exact Online administration.Not guaranteed to be unique. | ||
INTERFACE_ |
varchar2 |
Schnittstelle URL | URL, die zum Verbinden dieser Reihe mit Exact Online verwendet wird. | ||
ROWNUM |
int64 |
Zeilennummer | Nummer der Reihe innerhalb der Ergebnisse, startend bei 1. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: