invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

AllAdministrationClassifications: Exact Online All Administrations

read only XML

  • Catalogue : ExactOnlineXML
  • Schéma : XML
  • Label: All Administrations

Toutes les classifications administratives

Permet uniquement de récupérer des données.

Résumé

Classifications assigned to administrations across all customers.

Additional where-clause columns supported:

  • division

Source de l'API

  • Rubrique XML : AllAdministrationClassifications

Caractéristiques de performance

Characteristic Value
Nombre estimé de lignes 500
Taille estimée (octets) 0

Le résultat peut être mis en cache côté client.

Colonnes de table

Les colonnes de la table AllAdministrationClassifications sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
CODE_ATTR varchar2 Code /eExact/Administrations/Administration/DivisionClassNames/DivisionClassName/DivisionClasses/DivisionClass/code
DESCRIPTION varchar2 Description /eExact/Administrations/Administration/DivisionClassNames/DivisionClassName/DivisionClasses/DivisionClass/Description/
DIVISIONCLASSES_DIVISIONCLASSNAME_DESCRIPTION varchar2(255) Description de la classification /eExact/Administrations/Administration/DivisionClassNames/DivisionClassName/Description/
DIVISIONCLASSES_DIVISIONCLASSNAME_DESCRIPTION_TERMID_ATTR number itgen_eol_administrations_administration_division_class_names_division_class_name_description Term ID /eExact/Administrations/Administration/DivisionClassNames/DivisionClassName/Description/termid
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_ACTIVITYSECTOR_CODE_ATTR varchar2 Activity Sector Code /eExact/Administrations/Administration/ActivitySector/code
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_ACTIVITYSUBSECTOR_CODE_ATTR varchar2 Activity Sub Sector Code /eExact/Administrations/Administration/ActivitySubSector/code
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_ADDRESSLINE1 varchar2 Administration Address Line 1 /eExact/Administrations/Administration/AddressLine1/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_ADDRESSLINE2 varchar2 Administration Address Line 2 /eExact/Administrations/Administration/AddressLine2/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_ADDRESSLINE3 varchar2 Administration Address Line 3 /eExact/Administrations/Administration/AddressLine3/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_ADMINISTRATIONTYPES varchar2 Administration Administration Types /eExact/Administrations/Administration/AdministrationTypes/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_BLOCKINGSTATUS varchar2 Administration Blocking 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
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_BUSINESSTYPE_CODE_ATTR varchar2 Administration Business Type Code /eExact/Administrations/Administration/BusinessType/code
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_CHAMBEROFCOMMERCE varchar2 Administration Chamber of Commerce /eExact/Administrations/Administration/ChamberOfCommerce/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_CHAMBEROFCOMMERCEESTABLISHMENT varchar2 Administration Chamber of Commerce Establishment /eExact/Administrations/Administration/ChamberOfCommerceEstablishment/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_CITY varchar2 Administration City /eExact/Administrations/Administration/City/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_CODE_ATTR varchar2 Code administratif /eExact/Administrations/Administration/code The internal unique code of the administration.
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_COMPANYSIZE_CODE_ATTR varchar2 Administration Company Size Code /eExact/Administrations/Administration/CompanySize/code
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_COUNTRY_CODE_ATTR varchar2 code du pays /eExact/Administrations/Administration/Country/code
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_COUNTRY_DESCRIPTION varchar2(255) Description du pays /eExact/Administrations/Administration/Country/Description/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_COUNTRY_DESCRIPTION_TERMID_ATTR number itgen_eol_administrations_administration_country_description Term ID /eExact/Administrations/Administration/Country/Description/termid
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_CURRENCY_CODE_ATTR varchar2 Administration Currency Code /eExact/Administrations/Administration/Currency/code
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_CURRENCY_DESCRIPTION varchar2(255) Administration Currency Description /eExact/Administrations/Administration/Currency/Description/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_CURRENCY_DESCRIPTION_TERMID_ATTR number itgen_eol_administrations_administration_currency_description Term ID /eExact/Administrations/Administration/Currency/Description/termid
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_DIGITALPOSTBOXES varchar2 Administration Digital Post Boxes /eExact/Administrations/Administration/DigitalPostBoxes/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_EMAIL varchar2 Administration Email /eExact/Administrations/Administration/Email/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_ENDDATE date Administration End Date /eExact/Administrations/Administration/EndDate/ End date: YYYY-MM-DD
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_ETTSOURCE varchar2 Administration ETT Source /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
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_FAX varchar2 Administration Fax /eExact/Administrations/Administration/Fax/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_HOMEPAGE varchar2 Administration Home Page /eExact/Administrations/Administration/HomePage/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_NAME varchar2 Nom de l'administration /eExact/Administrations/Administration/Name/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_NUMBER_ATTR number Numéro administratif /eExact/Administrations/Administration/number The external code of the administration as shown in the administration card.
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_PHONE varchar2 Administration Phone /eExact/Administrations/Administration/Phone/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_PHONEEXT varchar2 Administration Phone Extension /eExact/Administrations/Administration/PhoneExt/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_POSTCODE varchar2 Administration Postal Code /eExact/Administrations/Administration/Postcode/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_SBICODE_CODE_ATTR varchar2 Code SBI /eExact/Administrations/Administration/SBICode/code
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_SEPADDCREDITORIDENTIFIER varchar2 Administration SEPA Direct Dunning Creditor Identifier /eExact/Administrations/Administration/SepaDDCreditorIdentifier/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_STARTDATE date Administration Start Date /eExact/Administrations/Administration/StartDate/ Start date: YYYY-MM-DD
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_STATE_CODE_ATTR varchar2 Code d'état /eExact/Administrations/Administration/State/code
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_STATE_DESCRIPTION varchar2(255) Description de l'état /eExact/Administrations/Administration/State/Description/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_STATE_DESCRIPTION_TERMID_ATTR number itgen_eol_administrations_administration_state_description Term ID /eExact/Administrations/Administration/State/Description/termid
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_USERADMINISTRATIONS varchar2 Administration User Administrations /eExact/Administrations/Administration/UserAdministrations/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_VATNUMBER varchar2 Administration VAT Number /eExact/Administrations/Administration/VATNumber/
DIVISIONCLASSES_DIVISIONCLASSNAME_NUMBER_ATTR number Classification Number /eExact/Administrations/Administration/DivisionClassNames/DivisionClassName/number
DIVISION_CODE varchar2 Identifiant d'administration Numéro unique interne de l'administration d'Exact Online.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Nom de l'administration Name of the Exact Online administration.Not guaranteed to be unique.
INTERFACE_URL varchar2(4000) URL de l'interface URL utilisée pour relier cette ligne à Exact Online.
ROWNUM int64 Numéro de ligne Numéro de la ligne dans les résultats, en commençant par 1.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :