AllAdministrationAssignedTypes: Exact Online All Administration Assigned Types
read only XML
- Catálogo:
ExactOnlineXML - Esquema:
XML - Label: All Administration Assigned Types
Todos los tipos asignados por la administración
Solo puede recuperar datos.
Resumen
Types assigned to administrations across all customers.
Additional where-clause columns supported:
- division
Fuente de la API
- Tema XML:
AllAdministrationAssignedTypes
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 AllAdministrationAssignedTypes. 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 |
|---|---|---|---|---|---|
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 |
Código de Administración | / |
The internal unique code of the administration. | |
ADMINISTRATIONTYPES_ |
varchar2 |
Administration Company Size Code | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Código del País | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Descripción del País | / |
||
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 |
Nombre de la Adminisración | / |
||
ADMINISTRATIONTYPES_ |
number |
Número de administración | / |
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 |
Código SBI | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Administration SEPA Direct Dunning Creditor Identifier | / |
||
ADMINISTRATIONTYPES_ |
date |
Administration Start Date | / |
Start date: YYYY-MM-DD | |
ADMINISTRATIONTYPES_ |
varchar2 |
Código del Estado | / |
||
ADMINISTRATIONTYPES_ |
varchar2 |
Descripción del Estado | / |
||
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 |
Identificación de la Administración | Número único Interno de la administración de Exact Online. | ||
DIVISION_ |
int64 |
Administration | Number of the Exact Online administration.Not guaranteed to be unique. | ||
DIVISION_ |
varchar2 |
Nombre de la Adminisración | Name of the Exact Online administration.Not guaranteed to be unique. | ||
INTERFACE_ |
varchar2 |
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: