invantive documentation
Forum di supporto InvantiveAccedi / Registrati

AllAdministrations: Exact Online Administrations

read only XML

  • Catalogo: ExactOnlineXML
  • Schema: XML
  • Chiavi primarie: code_attr
  • Label: Administrations

Tutte le amministrazioni

È possibile solo recuperare i dati.

All administrations across all customers.

Additional where-clause columns supported:

  • division

Codice sorgente dell'API

  • Argomento XML: AllAdministrations

Caratteristiche prestazionali

Characteristic Value
Numero stimato di righe 500
Dimensione stimata (byte) 0

Il risultato può essere memorizzato nella memoria cache sul client.

Colonne della tabella

Di seguito sono riportate le colonne della tabella AllAdministrations. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati 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 Indirizzo 1 /eExact/Administrations/Administration/AddressLine1/
ADDRESSLINE2 varchar2 Indirizzo 2 /eExact/Administrations/Administration/AddressLine2/
ADDRESSLINE3 varchar2 Indirizzo 3 /eExact/Administrations/Administration/AddressLine3/
ADMINISTRATIONTYPES varchar2 Tipi di amministrazione /eExact/Administrations/Administration/AdministrationTypes/
BLOCKINGSTATUS varchar2 Stato di blocco /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 Codice del tipo di attività /eExact/Administrations/Administration/BusinessType/code
CHAMBEROFCOMMERCE varchar2 Camera di Commercio /eExact/Administrations/Administration/ChamberOfCommerce/
CHAMBEROFCOMMERCEESTABLISHMENT varchar2 Istituzione della Camera di Commercio /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 Codice relativo alle dimensioni dell'azienda /eExact/Administrations/Administration/CompanySize/code
COUNTRY_CODE_ATTR varchar2 Codice della nazione /eExact/Administrations/Administration/Country/code
COUNTRY_DESCRIPTION varchar2(255) Descrizione del paese /eExact/Administrations/Administration/Country/Description/
COUNTRY_DESCRIPTION_TERMID_ATTR number Country Description Term ID /eExact/Administrations/Administration/Country/Description/termid
CURRENCY_CODE_ATTR varchar2 Codice della valuta /eExact/Administrations/Administration/Currency/code
CURRENCY_DESCRIPTION varchar2(255) Descrizione della valuta /eExact/Administrations/Administration/Currency/Description/
CURRENCY_DESCRIPTION_TERMID_ATTR number Currency Description Term ID /eExact/Administrations/Administration/Currency/Description/termid
DIGITALPOSTBOXES varchar2 Cassette postali digitali /eExact/Administrations/Administration/DigitalPostBoxes/
DIVISIONCLASSNAMES varchar2 Nomi delle classi di divisione /eExact/Administrations/Administration/DivisionClassNames/
DIVISION_CODE varchar2 ID amministrativo Numero univoco interno dell'amministrazione di Exact Online.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Nome dell'amministrazione Name of the Exact Online administration.Not guaranteed to be unique.
EMAIL varchar2 Email /eExact/Administrations/Administration/Email/
ENDDATE date Data di fine /eExact/Administrations/Administration/EndDate/ End date: YYYY-MM-DD
ETTSOURCE varchar2 Fonte ETT /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 Sito web /eExact/Administrations/Administration/HomePage/
INTERFACE_URL varchar2(4000) URL dell'interfaccia URL utilizzato per collegare questa riga a 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 Estensione del telefono /eExact/Administrations/Administration/PhoneExt/
POSTCODE varchar2 Codice postale /eExact/Administrations/Administration/Postcode/
ROWNUM int64 Numero di riga Numero della riga all'interno dei risultati, a partire da 1.
SBICODE_CODE_ATTR varchar2 SBI Code Code /eExact/Administrations/Administration/SBICode/code
SEPADDCREDITORIDENTIFIER varchar2 Identificatore del creditore per le sollecitazioni relative agli addebiti diretti SEPA /eExact/Administrations/Administration/SepaDDCreditorIdentifier/
STARTDATE date Data di inizio /eExact/Administrations/Administration/StartDate/ Start date: YYYY-MM-DD
STATE_CODE_ATTR varchar2 Codice dello stato /eExact/Administrations/Administration/State/code
STATE_DESCRIPTION varchar2(255) Descrizione dello stato /eExact/Administrations/Administration/State/Description/
STATE_DESCRIPTION_TERMID_ATTR number itgen_eol_state_description Term ID /eExact/Administrations/Administration/State/Description/termid
USERADMINISTRATIONS varchar2 Amministrazioni degli utenti /eExact/Administrations/Administration/UserAdministrations/
VATNUMBER varchar2 Numero di partita IVA /eExact/Administrations/Administration/VATNumber/

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: