AccountsBulk: Exact Online Accounts
read only per partition webhook REST
- Catálogo:
ExactOnlineREST - Esquema:
CRM - Llaves Primarias:
ID - Label: Accounts
Las partes contratantes, como clientes, proveedores y clientes potenciales.
Los datos de esta tabla están divididos por el valor de la columna Division.
Solo puede recuperar datos.
Resumen
Cada contraparte está registrada como máximo una vez como cuenta. Su tipo se puede determinar mediante varios métodos:
- Customer: the column 'Status' has the value 'C' when the account is a customer. The meaning of the status codes is described in the table 'AccountCustomerStatuses'.
- Prospect: the column 'Status' has the value 'P' when the account is a prospect.
- Suspect: the column 'Status' has the value 'S' when the account is a suspect.
- Reseller: the column 'IsReseller' has the boolean value 'true'.
- Supplier: the column 'IsSupplier' has the boolean value 'true'.
- Accountant: the column 'IsAccountant' has the boolean value 'true'.
- Competitor: the column 'IsCompetitor' has the boolean value 'true'.
Los cambios llegan a través del tema de webhook Accounts.
Fuente de la API
- Punto final:
/api/v1/{division}/bulk/CRM/Accounts - Metadatos:
/api/v1/{division}/bulk/CRM/$metadata
Características de rendimiento
| Characteristic | Value |
|---|---|
| Latencia media de acceso (ms) | 5 |
| Número de filas escaneadas por minuto | 20,000 |
| Número de filas de queries puntuales por minuto | 300 |
| Escribir filas por minuto | 300 |
El resultado se puede almacenar en la Caché del cliente.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla AccountsBulk. 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 |
|---|---|---|---|---|---|
Account |
guid |
Administración de Cuenta | ID of the account manager. | ||
Account |
varchar2 |
Nombre y apellidos del gestor de cuentas | Name of the account manager. | ||
Account |
int32 |
Administración de la Cuenta HID | Number of the account manager. | ||
Accountant |
guid |
Accountant | filtros de la plataforma | Reference to the accountant of the customer.Conditions: The referred accountant must have value > 0 in the field IsAccountant. | |
Activity |
guid |
Sector de la Actividad | Reference to Activity sector of the account. | ||
Activity |
guid |
Subsector de actividad | Reference to Activity sub-sector of the account. | ||
Address |
varchar2 |
Línea de la Dirección 1 | Visit address first line. | ||
Address |
varchar2 |
Línea de la Dirección 2 | Visit address second line. | ||
Address |
varchar2 |
Línea de la Dirección 3 | Visit address third line. | ||
Address |
int16 |
Fuente de la dirección | filters on the platform, writable | ||
Automatic |
int16 |
Entrada propuesta por proceso automático | filtros de la plataforma | ||
BRIN |
guid |
BRIN | filtros de la plataforma | Obsolete. | |
BSN |
varchar2 |
Número de Seguro Social | writable | Citizen Service Number for the Netherlands. | |
Blocked |
char |
Blocked | Indicates if the account is blocked. | ||
Business |
guid |
Tipo de Negocio | Reference to the business type of the account. | ||
Can |
char |
Se Puede Efectuar la Expedición Directa | Indicates the default for the possibility to drop ship when an item is linked to a supplier. | ||
Chamber |
varchar2 |
Cámara de Comeercio | Chamber of commerce number. | ||
City |
varchar2 |
City | Visit address City. | ||
Classification |
varchar2 |
Classification | filtros de la plataforma | Obsolete. | |
Classification1 |
guid |
Clasificación 1 | filtros de la plataforma | Account classification 1. | |
Classification1 |
varchar2 |
Código de clasificación 1 | writable | Code of classification 1.See view Classifications. | |
Classification1 |
varchar2 |
Clasificación 1: Descripción | writable | Description of classification 1.See view Classifications. | |
Classification2 |
guid |
Clasificación 2 | filtros de la plataforma | Account classification 2. | |
Classification2 |
varchar2 |
Código de clasificación 2 | writable | Code of classification 2.See view Classifications. | |
Classification2 |
varchar2 |
Clasificación 2: Descripción | writable | Description of classification 2.See view Classifications. | |
Classification3 |
guid |
Clasificación 3 | filtros de la plataforma | Account classification 3. | |
Classification3 |
varchar2 |
Código de clasificación 3 | writable | Code of classification 3.See view Classifications. | |
Classification3 |
varchar2 |
Clasificación 3: Descripción | writable | Description of classification 3.See view Classifications. | |
Classification4 |
guid |
Clasificación 4 | filtros de la plataforma | Account classification 4. | |
Classification4 |
varchar2 |
Código de clasificación 4 | writable | Code of classification 4.See view Classifications. | |
Classification4 |
varchar2 |
Clasificación 4: Descripción | writable | Description of classification 4.See view Classifications. | |
Classification5 |
guid |
Clasificación 5 | filtros de la plataforma | Account classification 5. | |
Classification5 |
varchar2 |
Código de clasificación 5 | writable | Code of classification 5.See view Classifications. | |
Classification5 |
varchar2 |
Clasificación 5: Descripción | writable | Description of classification 5.See view Classifications. | |
Classification6 |
guid |
Clasificación 6 | filtros de la plataforma | Account classification 6. | |
Classification6 |
varchar2 |
Código de clasificación 6 | writable | Code of classification 6.See view Classifications. | |
Classification6 |
varchar2 |
Clasificación 6: Descripción | writable | Description of classification 6.See view Classifications. | |
Classification7 |
guid |
Clasificación 7 | filtros de la plataforma | Account classification 7. | |
Classification7 |
varchar2 |
Código de clasificación 7 | writable | Code of classification 7.See view Classifications. | |
Classification7 |
varchar2 |
Clasificación 7: Descripción | writable | Description of classification 7.See view Classifications. | |
Classification8 |
guid |
Clasificación 8 | filtros de la plataforma | Account classification 8. | |
Classification8 |
varchar2 |
Código de clasificación 8 | writable | Code of classification 8.See view Classifications. | |
Classification8 |
varchar2 |
Clasificación 8: Descripción | writable | Description of classification 8.See view Classifications. | |
Classification |
varchar2 |
Descripción de la Clasificación | Obsolete. | ||
Code |
varchar2 |
Code | filtros de la plataforma | Unique key, fixed length numeric string with leading spaces, length 18.IMPORTANT: When you use OData $filter on this field you have to make sure the filter parameter contains the leading spaces. | |
Code |
varchar2 |
Código en el Proveedor | Code under which your own company is known at the account. | ||
Company |
guid |
Tamaño de la Compañía | Reference to Company size of the account. | ||
Consolidation |
int16 |
Escenario de Consolidación | Consolidation scenario (Time & Billing).Values: 0 = No consolidation, 1 = Item, 2 = Item + Project, 3 = Item + Employee, 4 = Item + Employee + Project, 5 = Project + WBS + Item, 6 = Project + WBS + Item + Employee.Item means in this case including Unit and Price, these also have to be the same to consolidate. | ||
Controlled |
datetime |
Fecha de comprobación | Date of the latest control of account data with external web service. | ||
Cost |
int16 |
Costo Pagado | Obsolete. | ||
Costcenter |
varchar2 |
Centro de Costo | Obsolete. | ||
Costcenter |
varchar2 |
Descripción del Centro de Costo | Obsolete. | ||
Country |
varchar2 |
Country | filtros de la plataforma | Country code. | |
Country |
varchar2 |
Nombre del País | Country name. | ||
Created |
datetime |
Created | Creation date. | ||
Created |
datetime |
Creado | writable | Creation date in UTC. | |
Creator |
guid |
Creator | User ID of creator. | ||
Creator |
varchar2 |
Nombre Completo del Creador | Name of creator. | ||
Credit |
double |
Línea de crédito para compras | Maximum amount of credit for Purchase.If no value has been defined, there is no credit limit. | ||
Credit |
double |
Línea de crédito para ventas | Maximum amount of credit for sales.If no value has been defined, there is no credit limit. | ||
Currency |
varchar2 |
Currency | Obsolete. | ||
Custom |
varchar2 |
Campo personalizado | |||
Customer |
datetime |
Cliente Desde | Obsolete. | ||
Datev |
varchar2 |
Código de acreedor de DATEV | DATEV creditor code for Germany legislation. | ||
Datev |
varchar2 |
Código de deudor de DATEV | DATEV debtor code for Germany legislation. | ||
Delivery |
int16 |
Información sobre envíos | |||
Discount |
double |
Descuento por compra | Default discount percentage for purchase.This is stored as a fraction. ie 5.5% is stored as .055. | ||
Discount |
double |
Descuento en las ventas | Default discount percentage for sales.This is stored as a fraction. ie 5.5% is stored as .055. | ||
Division |
int32 |
ID de la Empresa | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Número de la Cámara de Comercio de la División | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Número IBAN de la división | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
División: Nombre de la empresa | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Número de la división RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Número de IVA de la división | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Número de identificación fiscal de la división en materia de impuestos sobre los salarios | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Etiqueta de división | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nombre de la Adminisración | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nombre del titular de la suscripción | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Número de titular de la suscripción | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nombre abreviado de la división | writable | Short name of the Exact Online division. | |
Document |
guid |
Document | Obsolete. | ||
Duns |
varchar2 |
Número DUNS | Obsolete. | ||
EORI |
varchar2 |
Número EORI | writable | EORI number (United Kingdom). | |
Email |
varchar2 |
E-Mail address of the account. | |||
Enable |
char |
Activar el enlace de pago de ventas | filtros de la plataforma | ||
End |
datetime |
Fecha Final | filtros de la plataforma | Determines in combination with the start date if the account is active.If the current date is > end date the account is inactive. | |
Established |
datetime |
Fecha de constitución | RegistrationDate. | ||
Fax |
varchar2 |
Fax | Fax number. | ||
GLAP |
guid |
Libro Mayor de Cuentas por Pagar | Default GL account for Accounts Payable. | ||
GLAR |
guid |
Libro Mayor de Cuentas por Cobrar | Default GL account for Accounts Receivable. | ||
GL |
guid |
Cuenta contable para compras | Default (corporate) GL offset account for purchase (cost). | ||
GL |
guid |
Cuenta contable de ventas | Default (corporate) GL offset account for sales (revenue). | ||
Gln |
varchar2 |
Número GLN | Global Location Number can be used by companies to identify their locations, giving them complete flexibility to identify any type or level of location required. | ||
Has |
char |
Tiene ventas sujetas a retención fiscal | Indicates whether a customer has withholding tax on sales. | ||
ID |
guid |
ID | filtros de la plataforma | Primary key. | |
Ignore |
char |
Ignorar el mensaje de advertencia de DATEV | Suppressed warning message when there is duplication on the DATEV code. | ||
Incoterm |
varchar2 |
Dirección de compra según los Incoterm | |||
Incoterm |
varchar2 |
Dirección de ventas según los Incoterm | |||
Incoterm |
varchar2 |
Código Incoterm: Compra | |||
Incoterm |
varchar2 |
Código Incoterm: Ventas | |||
Incoterm |
int16 |
Compra de la versión de Incoterm | |||
Incoterm |
int16 |
Versión de los Incoterms para ventas | |||
Intra |
varchar2 |
Área Intrasat | Intrastat Area. | ||
Intra |
varchar2 |
Términos de Entrega Intrastat | Intrastat delivery method. | ||
Intra |
varchar2 |
Sistema Intrastat | System for Intrastat. | ||
Intra |
varchar2 |
Transacción Intrastat A | Transaction type A for Intrastat. | ||
Intra |
varchar2 |
Transacción Intrastat B | Transaction type B for Intrastat. | ||
Intra |
varchar2 |
Método de transporte de Intrastat | Transport method for Intrastat. | ||
Invoice |
guid |
Cuenta de la Factura | filtros de la plataforma | ID of account to be invoiced instead of this account. | |
Invoice |
varchar2 |
Código de Cuenta de la Factura | Code of InvoiceAccount. | ||
Invoice |
varchar2 |
Nombre de Cuenta de la Factura | Name of InvoiceAccount. | ||
Invoice |
int32 |
Tipo de Adjunto de la Factura | Indicates which attachment types should be sent when a sales invoice is printed.Only values in related table with Invoice=1 are allowed. | ||
Invoicing |
int32 |
Método de Facturación | Method of sending for sales invoices.Values: 1: Paper, 2: EMail, 4: Mailbox (electronic exchange). | ||
Is |
int16 |
Es Contable. | filtros de la plataforma | Indicates whether the account is an accountant.Values: 0 = No accountant, 1 = True, but accountant doesn't want his name to be published in the list of accountants, 2 = True, and accountant is published in the list of accountants. | |
Is |
int16 |
Es Agencia | Indicates whether the accounti is an agency. | ||
Is |
int16 |
Es anónimo | Indicates whtether the account is anonymised. | ||
IsBank |
char |
Es Banco | Obsolete. | ||
Is |
int16 |
Es Comopetidor | Indicates whether the account is a competitor. | ||
Is |
char |
¿Son horas extras? | Indicates whether a customer is eligible for extra duty. | ||
Is |
int16 |
¿Es el envío por correo? | Indicates if the account is excluded from mailing marketing information. | ||
Is |
char |
Es Miembro | Obsolete. | ||
Is |
char |
Es Piloto | Indicates whether the account is a pilot account. | ||
Is |
char |
¿Es una compra? | Obsolete. | ||
Is |
char |
Es Revendedor | filtros de la plataforma | Indicates whether the account is a reseller. | |
Is |
char |
¿Es el departamento de ventas? | filtros de la plataforma | Indicates whether the account is allowed for sales. | |
Is |
char |
Es Proveedor | filtros de la plataforma | Indicates whether the account is a supplier. | |
Language |
varchar2 |
Language | Código de idioma. | ||
Language |
varchar2 |
Descripción del Lenguaje | Language description. | ||
Latitude |
double |
Latitude | Latitude (used by Google maps). | ||
Lead |
guid |
Objetivo principal | Reference to Lead purpose of an account. | ||
Lead |
guid |
Fuente de Contacto | Reference to Lead source of an account. | ||
Logo |
blob |
Logo | Bytes of the logo image. | ||
Logo |
varchar2 |
Nombrer de Archivo del Logo | The file name (without path, but with extension) of the image. | ||
Logo |
varchar2 |
Miniatura del logotipo (URL) | Thumbnail url of the logo. | ||
Logo |
varchar2 |
Logotipo (URL) | Url to retrieve the logo. | ||
Longitude |
double |
Longitude | Longitude (used by Google maps). | ||
Main |
guid |
Contacto Principal | filtros de la plataforma | Reference to main contact person. | |
Modified |
datetime |
Modified | filtros de la plataforma | Last modified date. | |
Modified |
datetime |
Modificado (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | User ID of modifier. | ||
Modifier |
varchar2 |
Nombre completo modificado | Name of modifier. | ||
Name |
varchar2 |
Name | filtros de la plataforma | Account name. | |
OIN |
varchar2 |
Número OIN | Dutch government identification number. | ||
Parent |
guid |
Parent | filtros de la plataforma | ID of the parent account. | |
Pay |
varchar2 |
Pay-as-you-Earn | Indicates the loan repayment plan for UK legislation. | ||
Payment |
varchar2 |
Compra de la Condición de Pago | Code of default payment condition for purchase. | ||
Payment |
varchar2 |
Descripción de la Compra de la Condición de Pago | Description of PaymentConditionPurchase. | ||
Payment |
varchar2 |
Ventas de la Condición de Pago | Code of default payment condition for sales. | ||
Payment |
varchar2 |
Descripción de la Venta de la Condición de Pago | Description of PaymentConditionSales. | ||
Peppol |
varchar2 |
Identificador Peppol | filtros de la plataforma | ||
Peppol |
int32 |
Tipo de identificador Peppol | filtros de la plataforma | ||
Phone |
varchar2 |
Phone | Número de teléfono. | ||
Phone |
varchar2 |
Extensión Telefónica | Phone number extention. | ||
Postcode |
varchar2 |
Código Postal | Visit address postcode. | ||
Price |
guid |
Lista de Precios | filtros de la plataforma | Default sales price list for account. | |
Purchase |
varchar2 |
Moneda de la Compra | Currency of purchase. | ||
Purchase |
varchar2 |
Descripción de la Moneda de Compra | Description of PurchaseCurrency. | ||
Purchase |
int32 |
Días de Pago de la Compra | Indicates number of days required to receive a purchase.Acts as a default. | ||
Purchase |
varchar2 |
Código VAT de Compra | Default VAT code used for purchase entries. | ||
Purchase |
varchar2 |
Descripción del Código VAT de la Compra | Description of PurchaseVATCode. | ||
RSIN |
varchar2 |
Número RSIN | Fiscal number for NL legislation. | ||
Recepient |
char |
Destinatario de las Comisiones | Define the relation that should be taken in the official document of the rewarding fiscal fiches Belcotax. | ||
Remarks |
varchar2 |
Remarks | Remarks. | ||
Reseller |
guid |
Reseller | ID of the reseller account.Conditions: the target account must have the property IsReseller turned on. | ||
Reseller |
varchar2 |
Código del Revendedor | Code of Reseller. | ||
Reseller |
varchar2 |
Nombre del Revendedor | Name of Reseller. | ||
Sales |
varchar2 |
Moneda de la Venta | Currency of Sales used for Time & Billing. | ||
Sales |
varchar2 |
Descripción de la Moneda de Ventas | Description of SalesCurrency. | ||
Sales |
guid |
Calendario de Impuesto de Ventas | Obsolete. | ||
Sales |
varchar2 |
Código de Programación de Impuestos | Obsolete. | ||
Sales |
varchar2 |
Descripción de la Programación del Impuesto sobre las Ventas | Obsolete. | ||
Sales |
varchar2 |
Código VAT de Ventas | Default VAT code for a sales entry. | ||
Sales |
varchar2 |
Descripción del Código VAT de Ventas | Description of SalesVATCode. | ||
Search |
varchar2 |
Código que se ha de buscar | filtros de la plataforma | Search code. | |
Security |
int32 |
Nivel de Seguridad | Security level (0 - 100). | ||
Separate |
int16 |
Separar Factura por Proyecto | Separate invoice per project (Time & Billing). | ||
Separate |
int16 |
Separar Factura por Suscripción | Indicates how invoices are generated from subscriptions.0 = subscriptions belonging to the same customer are combined in a single invoice.1 = each subscription results in one invoice.In both cases, each individual subscription line results in one invoice line. | ||
Shipping |
int32 |
Días de Pago del Envío | Indicates the number of days it takes to send goods to the customer.Acts as a default. | ||
Shipping |
guid |
Modo de Envío | Default shipping method. | ||
Show |
char |
Mostrar comentario de ventas | writable | Indicates whether to display Ordered by account's remarks when creating a new sales order. | |
Source |
int16 |
Source | filtros de la plataforma | ||
Start |
datetime |
Fecha Inicial | filtros de la plataforma | Indicates in combination with the end date if the account is active. | |
State |
varchar2 |
State | State/Province/County code When changing the Country and the State is filled, the State must be assigned with a valid value from the selected country or set to empty. | ||
State |
varchar2 |
Estado | Name of State. | ||
Status |
varchar2 |
Status | filtros de la plataforma | If the status field is filled this means the account is a customer.The value indicates the customer status.Possible values: A=None, S=Suspect, P=Prospect, C=Customer. | |
Status |
datetime |
Estado Desde | Obsolete. | ||
Trade |
varchar2 |
Tradename | Trade name can be registered and shown with the client (for all legislations). | ||
Type |
varchar2 |
Type | filtros de la plataforma | Account type: Values: A = Relation, D = Division. | |
Unique |
varchar2 |
Referencia Única del Contribuyente | Unique taxpayer reference for UK legislation. | ||
VAT |
varchar2 |
Pasivo de VAT | Indicates the VAT status of an account to be able to identify the relation that should be selected in the VAT debtor listing in Belgium. | ||
VAT |
varchar2 |
Número VAT | The number under which the account is known at the Value Added Tax collection agency. | ||
Website |
varchar2 |
Website | Website of the account. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Accounts |
Accountant |
Accounts.ID |
Key | |
Accounts |
Business |
BusinessTypes.ID |
Key | |
Accounts |
Creator |
Users. |
Key | |
Accounts |
GLAP |
GLAccounts.ID |
Key | |
Accounts |
GLAR |
GLAccounts.ID |
Key | |
Accounts |
GL |
GLAccounts.ID |
Key | |
Accounts |
GL |
GLAccounts.ID |
Key | |
Accounts |
Invoice |
Accounts.ID |
Key | |
Accounts |
Lead |
LeadPurposes.ID |
Key | |
Accounts |
Lead |
LeadSources.ID |
Key | |
Accounts |
Main |
Contacts.ID |
Key | |
Accounts |
Modifier |
Users. |
Key | |
Accounts |
Parent |
Accounts.ID |
Key | |
Accounts |
Price |
SalesPriceLists.ID |
Key | |
Accounts |
Reseller |
Accounts.ID |
Key | |
Accounts |
Shipping |
ShippingMethods.ID |
Key |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: