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. | |
Account |
varchar2 |
Código de la Cuenta | writable | Code of the Account. | |
Account |
varchar2 |
Nombre de la Cuenta | writable | Name of account. | |
Amount |
double |
Importe División Moneda | writable | Amount in the default currency of the company. | |
Amount |
double |
Cantidad Moneda Extranjera | writable | Amount in the currency of the transaction. | |
Amount |
double |
Importe, base del IVA, moneda extranjera | writable | Vat base amount in the currency of the transaction. | |
Amount |
double |
Importe del IVA en moneda extranjera | writable | Vat amount in the currency of the transaction. | |
Asset |
guid |
Asset | writable | Reference to asset. | |
Asset |
varchar2 |
Código de Activo | writable | Code of Asset. | |
Asset |
varchar2 |
Descripción del Activo | writable | Description of Asset. | |
Cost |
varchar2 |
Centro de Costo | filters on the platform, writable | Reference to cost center. | |
Cost |
varchar2 |
Descripción del Centro de Costo | writable | Description of CostCenter. | |
Cost |
varchar2 |
Unidad de Costo | filters on the platform, writable | Reference to cost unit. | |
Cost |
varchar2 |
Descripción de la Unidad de Costo | writable | Description of CostUnit. | |
Created |
datetime |
Created | writable | Creation date. | |
Created |
datetime |
Creado | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Nombre Completo del Creador | writable | Name of creator. | |
Currency |
varchar2 |
Currency | writable | Currency. | |
Custom |
varchar2 |
Campo personalizado | writable | ||
Date |
datetime |
Date | filters on the platform, writable | Date. | |
Description |
varchar2 |
Description | writable | Description. | |
Display |
varchar2 |
Mostrar documentos (URL) | writable | URL to display documents attached to this transaction using Get My Report. | |
Division |
int32 |
Division | Division code. | ||
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 | filters on the platform, writable | Reference to document. | |
Document |
int32 |
Número de Documento | writable | Number of the document. | |
Document |
varchar2 |
Tema del Documento | writable | Subject of the document. | |
Due |
datetime |
Fecha de Vencimiento | writable | Date that payment should be done. | |
Entry |
guid |
Identificación de la Entrada | filters on the platform, writable | The transaction lines that make up a financial entry share the same EntryID. | |
Entry |
int32 |
Número de Entrada | filters on the platform, writable | Entry number of the header. | |
Exchange |
double |
Tasa de Cambio | writable | Exchange rate. | |
External |
varchar2 |
Descripción del Vínculo Externo | |||
External |
varchar2 |
Referencia del Vínculo Externo | |||
Extra |
double |
Importe del recargo por monedas extranjeras | writable | Extra duty amount. | |
Extra |
double |
Recargo (%) | writable | Extra duty percentage. | |
Financial |
int16 |
Período Financiero | filters on the platform, writable | Financial period. | |
Financial |
int16 |
Año Económico | filters on the platform, writable | Financial year. | |
GL |
guid |
Cuenta de Contabilidad General | filters on the platform, writable | General ledger account. | |
GL |
varchar2 |
Parte del saldo de la cuenta GL | writable | Balance side of transactions on this GL account. | |
GL |
varchar2 |
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. | |
GL |
varchar2 |
Código de Cuenta de Libro Mayor | writable | Code of the G/L account. | |
GL |
varchar2 |
Descripción de Cuenta del Libro Mayor | writable | Description of the G/L account. | |
GL |
char |
Cuenta GL: Revaluación de moneda | writable | Whether to revalue amounts posted on this GL account. | |
GL |
varchar2 |
Código de búsqueda de cuentas GL | writable | User-friendly search code for the GL account. | |
GL |
int32 |
Tipo de Cuenta de Libro Mayor | writable | Type of GL account.See view GLAccountTypes. | |
GL |
varchar2 |
Descripción del Tipo de Cuenta del Libro Mayor | writable | Description of the GL account type. | |
GL |
char |
Utilizar Centros de Costo | writable | Indicator whether to use cost centers for transaction lines on the GL account. | |
GL |
char |
Utilizar Unidad de Costo | writable | Indicator whether to use cost units for transaction lines on the GL account. | |
GL |
varchar2 |
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. | |
Invoice |
int32 |
Número de factura | filters on the platform, writable | Invoice number. | |
Item |
guid |
Item | writable | Reference to item. | |
Item |
varchar2 |
Código del Artículo | writable | Code of Item. | |
Item |
varchar2 |
Descripción del Elemento | writable | Description of Item. | |
Journal |
varchar2 |
Código del Diario | filters on the platform, writable | The journal code. | |
Journal |
varchar2 |
Descripción del Diario | writable | The journal description. | |
Line |
int32 |
Número de Línea | writable | Line number. | |
Line |
int16 |
Tipo de Línea | writable | Line type. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modificado (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Modifier |
varchar2 |
Nombre completo modificado | writable | Name of modifier. | |
Notes |
varchar2 |
Notes | writable | Extra remarks. | |
Offset |
guid |
ID de la cuenta contable de contrapartida | writable | OffsetID. | |
Order |
int32 |
Número de la Orden | filters on the platform, writable | Order number. | |
Payment |
double |
Importe del descuento por pago | writable | Discount amount when paid in time. | |
Payment |
varchar2 |
Referencia de Pago | writable | Payment reference. | |
Project |
guid |
Project | filters on the platform, writable | Reference to project. | |
Project |
varchar2 |
Código de Proyecto | writable | Code of Project. | |
Project |
varchar2 |
Descripción del Proyecto | writable | Description of Project. | |
Project |
guid |
Estructura de división del proyecto (WBS) | writable | Project WBS ID. | |
Project |
varchar2 |
Descripción de la estructura de división del proyecto (WBS) | writable | Project WBS description. | |
Quantity |
double |
Quantity | writable | Quantity. | |
Serial |
varchar2 |
Número de Serie | writable | Serial number of item. | |
Shop |
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. | |
Subscription |
varchar2 |
Descripción de Suscripción | writable | Description of subscription line. | |
Tracking |
varchar2 |
Número de Seguimiento | writable | Tracking number of item. | |
Tracking |
varchar2 |
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. | |
VAT |
varchar2 |
Código VAT | filters on the platform, writable | VAT code. | |
VAT |
varchar2 |
Descripción del Código VAT | writable | Description of VAT code. | |
VAT |
double |
Porcentaje VAT | writable | Vat percentage. | |
VAT |
varchar2 |
Tipo de VAT | filters on the platform, writable | VAT type. | |
Your |
varchar2 |
Su Referencia | filters on the platform, writable | Your reference (of customer). |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
Transaction |
Account |
Accounts.ID |
Key | |
Transaction |
Asset |
Assets.ID |
Key | |
Transaction |
Cost |
Costcenters.Code |
Key | |
Transaction |
Cost |
Costunits.Code |
Key | |
Transaction |
Creator |
Users. |
Key | |
Transaction |
Currency |
Currencies.Code |
Key | |
Transaction |
Document |
Documents.ID |
Key | |
Transaction |
GL |
GLAccounts.ID |
Key | |
Transaction |
Item |
Items.ID |
Key | |
Transaction |
Journal |
Journals.Code |
Key | |
Transaction |
Modifier |
Users. |
Key | |
Transaction |
Project |
ProjectWBS.ID |
Key | |
Transaction |
Project |
Projects.ID |
Key | |
Transaction |
Shop |
ShopOrders.ID |
Key | |
Transaction |
Subscription |
Subscriptions. |
Key | |
Transaction |
VAT |
VATCodes.Code |
Key |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: