invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

AllAdministrationClassifications: Exact Online All Administrations

read only XML

  • Catálogo: ExactOnlineXML
  • Esquema: XML
  • Label: All Administrations

Todas las categorías administrativas

Solo puede recuperar datos.

Resumen

Classifications assigned to administrations across all customers.

Additional where-clause columns supported:

  • division

Fuente de la API

  • Tema XML: AllAdministrationClassifications

Características de rendimiento

Characteristic Value
Número estimado de filas 500
Tamaño estimado (bytes) 0

El resultado se puede almacenar en la Caché del cliente.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla AllAdministrationClassifications. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos 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) Descripción de la Clasificación /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 Código de Administración /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 Código del País /eExact/Administrations/Administration/Country/code
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_COUNTRY_DESCRIPTION varchar2(255) Descripción del País /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 Nombre de la Adminisración /eExact/Administrations/Administration/Name/
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_NUMBER_ATTR number Número de administración /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 Código 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 Código del Estado /eExact/Administrations/Administration/State/code
DIVISIONCLASSES_DIVISIONCLASSNAME_DIVISIONCLASSNAMES_ADMINISTRATION_STATE_DESCRIPTION varchar2(255) Descripción del Estado /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 Identificación de la Administración Número único Interno de la administración de Exact Online.
DIVISION_HID int64 Administration Number of the Exact Online administration.Not guaranteed to be unique.
DIVISION_NAME varchar2(240) Nombre de la Adminisración Name of the Exact Online administration.Not guaranteed to be unique.
INTERFACE_URL varchar2(4000) URL de Interfaz URL utilizada para que interactúe esta fila con Exact Online.
ROWNUM int64 Número de la Fila Número de fila dentro de los resultados, empezando por el 1.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: