invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

AllAdministrations: Exact Online Administrations

read only XML

  • Catalogus: ExactOnlineXML
  • Schema: XML
  • Primaire sleutels: code_attr
  • Label: Overheden

Alle Administraties

Kan alleen gegevens ophalen.

Samenvatting

All administrations across all customers.

Additional where-clause columns supported:

  • division

API-bron

  • XML-onderwerp: AllAdministrations

Prestatiekenmerken

Characteristic Value
Geschat aantal rijen 500
Geschatte grootte (bytes) 0

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

Tabelkolommen

De kolommen van de tabel AllAdministrations 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
ACTIVITYSECTOR_CODE_ATTR varchar2 Activity Sector Code /eExact/Administrations/Administration/ActivitySector/code
ACTIVITYSUBSECTOR_CODE_ATTR varchar2 Activity Sub Sector Code /eExact/Administrations/Administration/ActivitySubSector/code
ADDRESSLINE1 varchar2 Adresregel 1 /eExact/Administrations/Administration/AddressLine1/
ADDRESSLINE2 varchar2 Adresregel 2 /eExact/Administrations/Administration/AddressLine2/
ADDRESSLINE3 varchar2 Adresregel 3 /eExact/Administrations/Administration/AddressLine3/
ADMINISTRATIONTYPES varchar2 Administratietypes /eExact/Administrations/Administration/AdministrationTypes/
BLOCKINGSTATUS varchar2 Blokkerende Status /eExact/Administrations/Administration/BlockingStatus/ 0=Not blocked, 1=Backup, 2=Conversion busy, 3=Conversion shadow, 4=Conversion waiting, 5=Copy data waiting, 6=Copy data busy
BUSINESSTYPE_CODE_ATTR varchar2 Bedrijfssoortcode /eExact/Administrations/Administration/BusinessType/code
CHAMBEROFCOMMERCE varchar2 Kamer van Koophandel /eExact/Administrations/Administration/ChamberOfCommerce/
CHAMBEROFCOMMERCEESTABLISHMENT varchar2 Vestiging Kamer van Koophandel /eExact/Administrations/Administration/ChamberOfCommerceEstablishment/
CITY varchar2 City /eExact/Administrations/Administration/City/
CODE_ATTR varchar2 Code /eExact/Administrations/Administration/code The internal unique code of the administration.
COMPANYSIZE_CODE_ATTR varchar2 Bedrijfsgroottecode /eExact/Administrations/Administration/CompanySize/code
COUNTRY_CODE_ATTR varchar2 Landcode /eExact/Administrations/Administration/Country/code
COUNTRY_DESCRIPTION varchar2(255) Land Omschrijving /eExact/Administrations/Administration/Country/Description/
COUNTRY_DESCRIPTION_TERMID_ATTR number Country Description Term ID /eExact/Administrations/Administration/Country/Description/termid
CURRENCY_CODE_ATTR varchar2 Valuta Code /eExact/Administrations/Administration/Currency/code
CURRENCY_DESCRIPTION varchar2(255) Valuta Omschrijving /eExact/Administrations/Administration/Currency/Description/
CURRENCY_DESCRIPTION_TERMID_ATTR number Currency Description Term ID /eExact/Administrations/Administration/Currency/Description/termid
DIGITALPOSTBOXES varchar2 Digitale Brievenbussen /eExact/Administrations/Administration/DigitalPostBoxes/
DIVISIONCLASSNAMES varchar2 Divisie Classificatienamen /eExact/Administrations/Administration/DivisionClassNames/
DIVISION_CODE varchar2 Administratie ID Intern uniek nummer van de Exact Online administratie.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Administratie Naam Name of the Exact Online administration.Not guaranteed to be unique.
EMAIL varchar2 Email /eExact/Administrations/Administration/Email/
ENDDATE date Einddatum /eExact/Administrations/Administration/EndDate/ End date: YYYY-MM-DD
ETTSOURCE varchar2 ETT Bron /eExact/Administrations/Administration/EttSource/ 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
FAX varchar2 Fax /eExact/Administrations/Administration/Fax/
HOMEPAGE varchar2 Website /eExact/Administrations/Administration/HomePage/
INTERFACE_URL varchar2(4000) Interface URL URL gebruikt om deze rij uit te wisselen met Exact Online.
NAME varchar2 Name /eExact/Administrations/Administration/Name/
NUMBER_ATTR number Number /eExact/Administrations/Administration/number The external code of the administration as shown in the administration card.
PHONE varchar2 Phone /eExact/Administrations/Administration/Phone/
PHONEEXT varchar2 Telefoontoestel /eExact/Administrations/Administration/PhoneExt/
POSTCODE varchar2 Postcode /eExact/Administrations/Administration/Postcode/
ROWNUM int64 Rijnummer Nummer van de regel binnen de resultaten, te beginnen bij 1.
SBICODE_CODE_ATTR varchar2 SBI Code Code /eExact/Administrations/Administration/SBICode/code
SEPADDCREDITORIDENTIFIER varchar2 SEPA Incasso Crediteuridentificatie /eExact/Administrations/Administration/SepaDDCreditorIdentifier/
STARTDATE date Startdatum /eExact/Administrations/Administration/StartDate/ Start date: YYYY-MM-DD
STATE_CODE_ATTR varchar2 Staat Code /eExact/Administrations/Administration/State/code
STATE_DESCRIPTION varchar2(255) Staat Omschrijving /eExact/Administrations/Administration/State/Description/
STATE_DESCRIPTION_TERMID_ATTR number itgen_eol_state_description Term ID /eExact/Administrations/Administration/State/Description/termid
USERADMINISTRATIONS varchar2 Gebruikeradministraties /eExact/Administrations/Administration/UserAdministrations/
VATNUMBER varchar2 BTW-nummer /eExact/Administrations/Administration/VATNumber/

Release Notes

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