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

TransactionLinesBulk: Exact Online Transaction Lines (Bulk)

read only per partition webhook REST

  • Catálogo: ExactOnlineREST
  • Esquema: FinancialTransaction
  • Llaves Primarias: ID
  • Label: Transaction Lines (Bulk)

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

Solo puede recuperar datos.

Los cambios llegan a través del tema de webhook FinancialTransactions en EntryID.

Fuente de la API

  • Punto final: /api/v1/{division}/bulk/financial/TransactionLines
  • Metadatos: /api/v1/{division}/bulk/financial/$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 TransactionLinesBulk. 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 Account filters on the platform, writable Reference to account.
AccountCode varchar2(18) Código de la Cuenta writable Code of the Account.
AccountName varchar2(50) Nombre de la Cuenta writable Name of account.
AmountDC double Importe División Moneda writable Amount in the default currency of the company.
AmountFC double Cantidad Moneda Extranjera writable Amount in the currency of the transaction.
AmountVATBaseFC double Importe, base del IVA, moneda extranjera writable Vat base amount in the currency of the transaction.
AmountVATFC double Importe del IVA en moneda extranjera writable Vat amount in the currency of the transaction.
Asset guid Asset writable Reference to asset.
AssetCode varchar2(30) Código de Activo writable Code of Asset.
AssetDescription varchar2(60) Descripción del Activo writable Description of Asset.
CostCenter varchar2(8) Centro de Costo filters on the platform, writable Reference to cost center.
CostCenterDescription varchar2(60) Descripción del Centro de Costo writable Description of CostCenter.
CostUnit varchar2(8) Unidad de Costo filters on the platform, writable Reference to cost unit.
CostUnitDescription varchar2(60) Descripción de la Unidad de Costo writable Description of CostUnit.
Created datetime Created writable Creation date.
CreatedUtc datetime Creado writable Creation date in UTC.
Creator guid Creator writable User ID of creator.
CreatorFullName varchar2(240) Nombre Completo del Creador writable Name of creator.
Currency varchar2(30) Currency writable Currency.
CustomField varchar2 Campo personalizado writable
Date datetime Date filters on the platform, writable Date.
Description varchar2(60) Description writable Description.
DisplayDocumentsUrl varchar2 Mostrar documentos (URL) writable URL to display documents attached to this transaction using Get My Report.
Division int32 Division Division code.
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 Reference to document.
DocumentNumber int32 Número de Documento writable Number of the document.
DocumentSubject varchar2(256) Tema del Documento writable Subject of the document.
DueDate datetime Fecha de Vencimiento writable Date that payment should be done.
EntryID guid Identificación de la Entrada filters on the platform, writable The transaction lines that make up a financial entry share the same EntryID.
EntryNumber int32 Número de Entrada filters on the platform, writable Entry number of the header.
ExchangeRate double Tasa de Cambio writable Exchange rate.
ExternalLinkDescription varchar2 Descripción del Vínculo Externo
ExternalLinkReference varchar2 Referencia del Vínculo Externo
ExtraDutyAmountFC double Importe del recargo por monedas extranjeras writable Extra duty amount.
ExtraDutyPercentage double Recargo (%) writable Extra duty percentage.
FinancialPeriod int16 Período Financiero filters on the platform, writable Financial period.
FinancialYear int16 Año Económico filters on the platform, writable Financial year.
GLAccount guid Cuenta de Contabilidad General filters on the platform, writable General ledger account.
GLAccountBalanceSide varchar2(1) Parte del saldo de la cuenta GL writable Balance side of transactions on this GL account.
GLAccountBalanceType varchar2(1) Tipo de saldo de la cuenta GL writable Balance type of transactions on this GL account, being either 'B' for Balance or 'W' for Profit and Loss.
GLAccountCode varchar2(30) Código de Cuenta de Libro Mayor writable Code of the G/L account.
GLAccountDescription varchar2(60) Descripción de Cuenta del Libro Mayor writable Description of the G/L account.
GLAccountRevalueCurrency char Cuenta GL: Revaluación de moneda writable Whether to revalue amounts posted on this GL account.
GLAccountSearchCode varchar2(9) Código de búsqueda de cuentas GL writable User-friendly search code for the GL account.
GLAccountType int32 Tipo de Cuenta de Libro Mayor writable Type of GL account.See view GLAccountTypes.
GLAccountTypeDescription varchar2 Descripción del Tipo de Cuenta del Libro Mayor writable Description of the GL account type.
GLAccountUseCostCenter char Utilizar Centros de Costo writable Indicator whether to use cost centers for transaction lines on the GL account.
GLAccountUseCostUnit char Utilizar Unidad de Costo writable Indicator whether to use cost units for transaction lines on the GL account.
GLAccountVatCode varchar2(3) Código de IVA de la cuenta del libro mayor writable Associated VAT code of the GL account.
ID guid ID filters on the platform, writable Primary key.
InvoiceNumber int32 Número de factura filters on the platform, writable Invoice number.
Item guid Item writable Reference to item.
ItemCode varchar2(30) Código del Artículo writable Code of Item.
ItemDescription varchar2(255) Descripción del Elemento writable Description of Item.
JournalCode varchar2(20) Código del Diario filters on the platform, writable The journal code.
JournalDescription varchar2(60) Descripción del Diario writable The journal description.
LineNumber int32 Número de Línea writable Line number.
LineType int16 Tipo de Línea writable Line type.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Modificado (UTC) writable Last modified date in UTC.
Modifier guid Modifier writable User ID of modifier.
ModifierFullName varchar2(240) Nombre completo modificado writable Name of modifier.
Notes varchar2 Notes writable Extra remarks.
OffsetID guid ID de la cuenta contable de contrapartida writable OffsetID.
OrderNumber int32 Número de la Orden filters on the platform, writable Order number.
PaymentDiscountAmount double Importe del descuento por pago writable Discount amount when paid in time.
PaymentReference varchar2(60) Referencia de Pago writable Payment reference.
Project guid Project filters on the platform, writable Reference to project.
ProjectCode varchar2(20) Código de Proyecto writable Code of Project.
ProjectDescription varchar2(60) Descripción del Proyecto writable Description of Project.
ProjectWBS guid Estructura de división del proyecto (WBS) writable Project WBS ID.
ProjectWBSDescription varchar2 Descripción de la estructura de división del proyecto (WBS) writable Project WBS description.
Quantity double Quantity writable Quantity.
SerialNumber varchar2(30) Número de Serie writable Serial number of item.
ShopOrder guid Orden de Producción Reference to shop order.
Status int16 Status filters on the platform, writable 20 = Open, 50 = Processed.
Subscription guid Subscription writable Reference to subscription line.
SubscriptionDescription varchar2(60) Descripción de Suscripción writable Description of subscription line.
TrackingNumber varchar2(100) Número de Seguimiento writable Tracking number of item.
TrackingNumberDescription varchar2(240) Descripción del Número de Seguimiento writable Tracking number description.
Type int32 Type filters on the platform, writable The transaction type.Possible values: see TransactionLineTypes.
VATCode varchar2(3) Código VAT filters on the platform, writable VAT code.
VATCodeDescription varchar2(60) Descripción del Código VAT writable Description of VAT code.
VATPercentage double Porcentaje VAT writable Vat percentage.
VATType varchar2(1) Tipo de VAT filters on the platform, writable VAT type.
YourRef varchar2(60) Su Referencia filters on the platform, writable Your reference (of customer).

Teclas

Key Column Se refiere a Kind Description
TransactionLinesBulk_Account_Accounts_fk Account Accounts.ID Key
TransactionLinesBulk_Asset_Assets_fk Asset Assets.ID Key
TransactionLinesBulk_CostCenter_Costcenters_fk CostCenter Costcenters.Code Key
TransactionLinesBulk_CostUnit_Costunits_fk CostUnit Costunits.Code Key
TransactionLinesBulk_Creator_Users_fk Creator Users.UserID Key
TransactionLinesBulk_Currency_Currencies_fk Currency Currencies.Code Key
TransactionLinesBulk_Document_Documents_fk Document Documents.ID Key
TransactionLinesBulk_GLAccount_GLAccounts_fk GLAccount GLAccounts.ID Key
TransactionLinesBulk_Item_Items_fk Item Items.ID Key
TransactionLinesBulk_JournalCode_Journals_fk JournalCode Journals.Code Key
TransactionLinesBulk_Modifier_Users_fk Modifier Users.UserID Key
TransactionLinesBulk_ProjectWBS_ProjectWBS_fk ProjectWBS ProjectWBS.ID Key
TransactionLinesBulk_Project_Projects_fk Project Projects.ID Key
TransactionLinesBulk_ShopOrder_ShopOrders_fk ShopOrder ShopOrders.ID Key
TransactionLinesBulk_Subscription_Subscriptions_fk Subscription Subscriptions.EntryID Key
TransactionLinesBulk_VATCode_VATCodes_fk VATCode VATCodes.Code Key

Notas de la Versión

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