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

AccountsFullTextSearch: Exact Online Accounts Full-Text Search

read only per partition REST

  • Catálogo: ExactOnlineREST
  • Esquema: CRM
  • Llaves Primarias: ID
  • Label: Accounts Full-Text Search

Search for legal counter parties using a text query.

Los datos de esta tabla están divididos por el valor de la columna Division.

Solo puede recuperar datos.

Fuente de la API

  • Punto final: /api/v1/{division}/read/crm/AccountsFullTextSearch
  • Metadatos: /api/v1/{division}/read/crm/$metadata

Características de rendimiento

Characteristic Value
Latencia media de acceso (ms) 5
Número de filas escaneadas por minuto 7,200
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.

Parámetros

Name Tipo de Datos Required Default Documentation
division int32 ID of the division to retrieve data for.
searchText varchar2

Columnas de la Tabla

A continuación se muestran las columnas de la tabla AccountsFullTextSearch. 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
AccountManager guid Administración de Cuenta filters on the platform, writable
AccountManagerFullName varchar2(240) Nombre y apellidos del gestor de cuentas filters on the platform, writable
AccountManagerHID int32 Administración de la Cuenta HID filters on the platform, writable
Accountant guid Accountant filters on the platform, writable
ActivitySector guid Sector de la Actividad filters on the platform, writable
ActivitySubSector guid Subsector de actividad filters on the platform, writable
AddressLine1 varchar2(80) Línea de la Dirección 1 filters on the platform, writable Visit address first line.
AddressLine2 varchar2(80) Línea de la Dirección 2 filters on the platform, writable Second address line.
AddressLine3 varchar2(80) Línea de la Dirección 3 filters on the platform, writable Third address line.
AddressSource int16 Fuente de la dirección filters on the platform, writable
AutomaticProcessProposedEntry int16 Entrada propuesta por proceso automático filtros de la plataforma
BRIN guid BRIN filters on the platform, writable
BSN varchar2 Número de Seguro Social filters on the platform, writable Citizen Service Number for the Netherlands.
Blocked char Blocked filters on the platform, writable
BusinessType guid Tipo de Negocio filters on the platform, writable
CanDropShip char Se Puede Efectuar la Expedición Directa filters on the platform, writable
ChamberOfCommerce varchar2(60) Cámara de Comeercio filters on the platform, writable Chamber of commerce number.
City varchar2(30) City filters on the platform, writable City.
Classification varchar2 Classification filters on the platform, writable
Classification1 guid Clasificación 1 filters on the platform, writable
Classification2 guid Clasificación 2 filters on the platform, writable
Classification3 guid Clasificación 3 filters on the platform, writable
Classification4 guid Clasificación 4 filters on the platform, writable
Classification5 guid Clasificación 5 filters on the platform, writable
Classification6 guid Clasificación 6 filters on the platform, writable
Classification7 guid Clasificación 7 filters on the platform, writable
Classification8 guid Clasificación 8 filters on the platform, writable
ClassificationDescription varchar2 Descripción de la Clasificación filters on the platform, writable
Code varchar2 Code filters on the platform, writable
CodeAtSupplier varchar2(20) Código en el Proveedor filters on the platform, writable Code under which your own company is known at the account.
CompanySize guid Tamaño de la Compañía filters on the platform, writable
ConsolidationScenario int16 Escenario de Consolidación filters on the platform, writable
ControlledDate datetime Fecha de comprobación filters on the platform, writable
CostPaid int16 Costo Pagado filters on the platform, writable
Costcenter varchar2(8) Centro de Costo filters on the platform, writable
CostcenterDescription varchar2(60) Descripción del Centro de Costo filters on the platform, writable
Country varchar2(30) Country filters on the platform, writable Country code.
CountryName varchar2 Nombre del País filters on the platform, writable Country name.
Created datetime Created filters on the platform, writable Creation date.
CreatedUtc datetime Creado writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Nombre Completo del Creador filters on the platform, writable Name of creator.
CreditLinePurchase double Línea de crédito para compras filters on the platform, writable
CreditLineSales double Línea de crédito para ventas filters on the platform, writable
Currency varchar2(30) Currency filters on the platform, writable Code of Currency.
CustomField varchar2 Campo personalizado filters on the platform, writable
CustomerSince datetime Cliente Desde filters on the platform, writable
DatevCreditorCode varchar2(30) Código de acreedor de DATEV filters on the platform, writable
DatevDebtorCode varchar2(30) Código de deudor de DATEV filters on the platform, writable
DeliveryAdvice int16 Información sobre envíos filtros de la plataforma
DiscountPurchase double Descuento por compra filters on the platform, writable
DiscountSales double Descuento en las ventas filters on the platform, writable
Division int32 Division writable
DivisionCompanyCoCNumber varchar2(60) Número de la Cámara de Comercio de la División writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Número IBAN de la división writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) División: Nombre de la empresa writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Número de la división RSIN writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Número de IVA de la división writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) 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.
DivisionLabel varchar2(128) Etiqueta de división writable Label of the Exact Online division.
DivisionName varchar2(50) Nombre de la Adminisración writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) 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.
DivisionOwnerCompanyNumber varchar2(18) 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.
DivisionShortName int64 Nombre abreviado de la división writable Short name of the Exact Online division.
Document guid Document filters on the platform, writable
DunsNumber varchar2(9) Número DUNS filters on the platform, writable
EORINumber varchar2 Número EORI writable EORI number (United Kingdom).
Email varchar2(128) Email filters on the platform, writable
EnableSalesPaymentLink char Activar el enlace de pago de ventas filtros de la plataforma
EndDate datetime Fecha Final filters on the platform, writable
EstablishedDate datetime Fecha de constitución filters on the platform, writable
Fax varchar2(25) Fax filters on the platform, writable Fax number.
GLAP guid Libro Mayor de Cuentas por Pagar filters on the platform, writable
GLAR guid Libro Mayor de Cuentas por Cobrar filters on the platform, writable
GLAccountPurchase guid Cuenta contable para compras filters on the platform, writable
GLAccountSales guid Cuenta contable de ventas filters on the platform, writable
GlnNumber varchar2(13) Número GLN filters on the platform, writable 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.
HasWithholdingTaxSales char Tiene ventas sujetas a retención fiscal filters on the platform, writable
ID guid ID filters on the platform, writable
IgnoreDatevWarningMessage char Ignorar el mensaje de advertencia de DATEV filters on the platform, writable
IncotermAddressPurchase varchar2 Dirección de compra según los Incoterm filters on the platform, writable
IncotermAddressSales varchar2 Dirección de ventas según los Incoterm filters on the platform, writable
IncotermCodePurchase varchar2 Código Incoterm: Compra filters on the platform, writable
IncotermCodeSales varchar2 Código Incoterm: Ventas filters on the platform, writable
IncotermVersionPurchase int16 Compra de la versión de Incoterm filters on the platform, writable
IncotermVersionSales int16 Versión de los Incoterms para ventas filters on the platform, writable
IntraStatArea varchar2 Área Intrasat filters on the platform, writable
IntraStatDeliveryTerm varchar2 Términos de Entrega Intrastat filters on the platform, writable
IntraStatSystem varchar2(5) Sistema Intrastat filters on the platform, writable
IntraStatTransactionA varchar2(1) Transacción Intrastat A filters on the platform, writable
IntraStatTransactionB varchar2(1) Transacción Intrastat B filters on the platform, writable
IntraStatTransportMethod varchar2(1) Método de transporte de Intrastat filters on the platform, writable
InvoiceAccount guid Cuenta de la Factura filters on the platform, writable
InvoiceAccountCode varchar2(18) Código de Cuenta de la Factura filters on the platform, writable
InvoiceAccountName varchar2(50) Nombre de Cuenta de la Factura filters on the platform, writable Name of account.
InvoiceAttachmentType int32 Tipo de Adjunto de la Factura filters on the platform, writable
InvoicingMethod int32 Método de Facturación filters on the platform, writable
IsAccountant int16 Es Contable. filters on the platform, writable
IsAgency int16 Es Agencia filters on the platform, writable
IsAnonymised int16 Es anónimo filters on the platform, writable Indicates whether the account is anonymised.
IsBank char Es Banco filters on the platform, writable
IsCompetitor int16 Es Comopetidor filters on the platform, writable
IsExtraDuty char ¿Son horas extras? filters on the platform, writable
IsMailing int16 ¿Es el envío por correo? filters on the platform, writable
IsMember char Es Miembro filters on the platform, writable
IsPilot char Es Piloto filters on the platform, writable
IsPurchase char ¿Es una compra? filters on the platform, writable
IsReseller char Es Revendedor filters on the platform, writable
IsSales char ¿Es el departamento de ventas? filters on the platform, writable
IsSupplier char Es Proveedor filters on the platform, writable
Language varchar2(30) Language filters on the platform, writable Código de idioma.
LanguageDescription varchar2(60) Descripción del Lenguaje filters on the platform, writable Language description.
Latitude double Latitude filters on the platform, writable
LeadPurpose guid Objetivo principal filters on the platform, writable Reference to Lead Purpose of an account.
LeadSource guid Fuente de Contacto filters on the platform, writable
Logo blob Logo filters on the platform, writable
LogoFileName varchar2 Nombrer de Archivo del Logo filters on the platform, writable
LogoThumbnailUrl varchar2 Miniatura del logotipo (URL) writable
LogoUrl varchar2 Logotipo (URL) filters on the platform, writable
Longitude double Longitude filters on the platform, writable
MainContact guid Contacto Principal filters on the platform, writable
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Modificado (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Nombre completo modificado filters on the platform, writable Name of modifier.
Name varchar2(50) Name filters on the platform, writable Name of account.
OINNumber varchar2(20) Número OIN filters on the platform, writable Dutch government identification number.
Parent guid Parent filters on the platform, writable
PayAsYouEarn varchar2 Pay-as-you-Earn filters on the platform, writable
PaymentConditionPurchase varchar2(2) Compra de la Condición de Pago filters on the platform, writable
PaymentConditionPurchaseDescription varchar2(60) Descripción de la Compra de la Condición de Pago filters on the platform, writable
PaymentConditionSales varchar2(2) Ventas de la Condición de Pago filters on the platform, writable
PaymentConditionSalesDescription varchar2(60) Descripción de la Venta de la Condición de Pago filters on the platform, writable
PeppolIdentifier varchar2 Identificador Peppol filtros de la plataforma
PeppolIdentifierType int32 Tipo de identificador Peppol filtros de la plataforma
Phone varchar2(25) Phone filters on the platform, writable Número de teléfono.
PhoneExtension varchar2(15) Extensión Telefónica filters on the platform, writable Phone number extension.
Postcode varchar2(20) Código Postal filters on the platform, writable Postcode.
PriceList guid Lista de Precios filters on the platform, writable
PurchaseCurrency varchar2(30) Moneda de la Compra filters on the platform, writable Currency of purchase.
PurchaseCurrencyDescription varchar2(60) Descripción de la Moneda de Compra filters on the platform, writable Description of purchase currency.
PurchaseLeadDays int32 Días de Pago de la Compra filters on the platform, writable
PurchaseVATCode varchar2(3) Código VAT de Compra filters on the platform, writable Purchase VAT code.
PurchaseVATCodeDescription varchar2(60) Descripción del Código VAT de la Compra filters on the platform, writable Description of Purchase VAT code.
RSIN varchar2 Número RSIN filters on the platform, writable Fiscal number for NL legislation.
RecepientOfCommissions char Destinatario de las Comisiones filters on the platform, writable
Remarks varchar2 Remarks filters on the platform, writable
Reseller guid Reseller filters on the platform, writable
ResellerCode varchar2(18) Código del Revendedor filters on the platform, writable Code of Reseller.
ResellerName varchar2(50) Nombre del Revendedor filters on the platform, writable Name of reseller.
SalesCurrency varchar2(30) Moneda de la Venta filters on the platform, writable Currency of sales price.
SalesCurrencyDescription varchar2(60) Descripción de la Moneda de Ventas filters on the platform, writable Description of sales currency.
SalesTaxSchedule guid Calendario de Impuesto de Ventas filters on the platform, writable
SalesTaxScheduleCode varchar2 Código de Programación de Impuestos filters on the platform, writable
SalesTaxScheduleDescription varchar2 Descripción de la Programación del Impuesto sobre las Ventas filters on the platform, writable
SalesVATCode varchar2(3) Código VAT de Ventas filters on the platform, writable Sales VAT code.
SalesVATCodeDescription varchar2(60) Descripción del Código VAT de Ventas filters on the platform, writable Description of Sales VAT code.
SearchCode varchar2(15) Código que se ha de buscar filters on the platform, writable Search code.
SecurityLevel int32 Nivel de Seguridad filters on the platform, writable
SeparateInvPerProject int16 Separar Factura por Proyecto filters on the platform, writable
SeparateInvPerSubscription int16 Separar Factura por Suscripción filters on the platform, writable
ShippingLeadDays int32 Días de Pago del Envío filters on the platform, writable
ShippingMethod guid Modo de Envío filters on the platform, writable
ShowRemarkForSales char Mostrar comentario de ventas filters on the platform, writable
Source int16 Source filtros de la plataforma
StartDate datetime Fecha Inicial filters on the platform, writable
State varchar2(30) State filters on the platform, writable State/Province code.
StateName varchar2(60) Estado filters on the platform, writable Name of state/province.
Status varchar2(1) Status filters on the platform, writable 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.
StatusSince datetime Estado Desde filters on the platform, writable
TradeName varchar2(50) Tradename filters on the platform, writable
Type varchar2(1) Type filters on the platform, writable Account type: Values: A = Relation, D = Division.
UniqueTaxpayerReference varchar2 Referencia Única del Contribuyente filters on the platform, writable
VATLiability varchar2 Pasivo de VAT filters on the platform, writable
VATNumber varchar2(35) Número VAT filters on the platform, writable VAT number.
Website varchar2(128) Website filters on the platform, writable Website of the account.

Notas de la Versión

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