TransactionLinesIncremental: Exact Online Transaction Lines (Incremental)
popular read only per partition
- Catálogo:
ExactOnlineREST - Esquema:
Incremental - Llaves Primarias:
ID - Label: Transaction Lines (Incremental)
Los datos de esta tabla están divididos por el valor de la columna Division.
Solo puede recuperar datos.
Características de rendimiento
| Characteristic | Value |
|---|---|
| Latencia media de acceso (ms) | 181 |
| Número de filas escaneadas por minuto | 40,300 |
| Número de filas de queries puntuales por minuto | 138 |
El resultado se puede almacenar en la Caché del cliente.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla TransactionLinesIncremental. 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 | Reference to account. | ||
Amount |
double |
Importe División Moneda | Amount in the default currency of the company. | ||
Amount |
double |
Cantidad Moneda Extranjera | Amount in the currency of the transaction. | ||
Amount |
double |
Importe, base del IVA, moneda extranjera | VAT base amount in the currency of the transaction. | ||
Amount |
double |
Importe del IVA en moneda extranjera | VAT amount in the currency of the transaction. | ||
Asset |
guid |
Asset | Reference to asset. | ||
Cost |
varchar2 |
Centro de Costo | Reference to cost center. | ||
Cost |
varchar2 |
Unidad de Costo | Reference to cost unit. | ||
Created |
datetime |
Created | Creation date. | ||
Creator |
guid |
Creator | User ID of creator. | ||
Currency |
varchar2 |
Currency | Currency. | ||
Custom |
varchar2 |
Campo personalizado | |||
Date |
datetime |
Date | Entry date. | ||
Description |
varchar2 |
Description | Description. | ||
Division |
int32 |
Division | Division code. | ||
Document |
guid |
Document | Reference to document. | ||
Due |
datetime |
Fecha de Vencimiento | Date that payment should be done. | ||
Entry |
guid |
Identificación de la Entrada | The transaction lines that make up a financial entry share the same EntryID. | ||
Entry |
int32 |
Número de Entrada | Entry number of the header. | ||
Exchange |
double |
Tasa de Cambio | Exchange rate. | ||
Extra |
double |
Importe del recargo por monedas extranjeras | Extra duty amount. | ||
Extra |
double |
Recargo (%) | Extra duty percentage. | ||
Financial |
int16 |
Período Financiero | Financial period. | ||
Financial |
int16 |
Año Económico | Financial year. | ||
GL |
guid |
Cuenta de Contabilidad General | General ledger account. | ||
ID |
guid |
ID | Primary key. | ||
Invoice |
int32 |
Número de factura | Invoice number. | ||
Item |
guid |
Item | Reference to item. | ||
Journal |
varchar2 |
Código del Diario | Journal code. | ||
Line |
int32 |
Número de Línea | Line number. | ||
Line |
int16 |
Tipo de Línea | Line type. | ||
Modified |
datetime |
Modified | Last modified date. | ||
Modifier |
guid |
Modifier | User ID of modifier. | ||
Notes |
varchar2 |
Notes | Extra remarks. | ||
Offset |
guid |
ID de la cuenta contable de contrapartida | Offset ID. | ||
Order |
int32 |
Número de la Orden | Order number. | ||
Payment |
double |
Importe del descuento por pago | Discount amount when paid in time. | ||
Payment |
varchar2 |
Referencia de Pago | Payment reference. | ||
Project |
guid |
Project | Reference to project. | ||
Quantity |
double |
Quantity | Quantity. | ||
Serial |
varchar2 |
Número de Serie | |||
Status |
int16 |
Status | Status, 20 = Open, 50 = Processed. | ||
Subscription |
guid |
Subscription | Reference to subscription line. | ||
Timestamp |
int64 |
Timestamp | Timestamp. | ||
Tracking |
varchar2 |
Número de Seguimiento | Tracking number. | ||
Type |
int32 |
Type | Transaction type. | ||
VAT |
varchar2 |
Código VAT | VAT code. | ||
VAT |
double |
Porcentaje VAT | VAT percentage. | ||
VAT |
varchar2 |
Tipo de VAT | VAT type. | ||
Your |
varchar2 |
Su Referencia | Your reference (of customer). |
Ejemplos de queries
--
-- Financial transaction lines from all journals and selected companies. Note that LineNumber 0 reflects the header and 9999 the VAT.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/exact-online-data-model/webhelp/exact-online-connector-exactonlinerest-incremental-transactionlinesincremental.html
--
-- Related forum post: https://forums.invantive.eu/t/recommended-and-popular-exact-online-tables-for-2022/2340
--
select *
from ExactOnlineREST.Incremental.TransactionLinesIncremental@eol
limit 100
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: