TransactionsIncremental: Exact Online Transactions (Incremental)
read only
- Catálogo:
ExactOnlineREST - Esquema:
Views - Label: Transactions (Incremental)
Headers of general ledger transactions.
Solo puede recuperar datos.
Características de rendimiento
| Characteristic | Value |
|---|---|
| Latencia media de acceso (ms) | 432 |
| Número de filas escaneadas por minuto | 50,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 TransactionsIncremental. 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. | ||
GL |
guid |
Cuenta de Contabilidad General | General ledger account. | ||
Invoice |
int32 |
Número de factura | Invoice number. | ||
Item |
guid |
Item | Reference to item. | ||
Item2 |
guid |
Item | Reference to item. | ||
Journal |
varchar2 |
Código del Diario | Journal code. | ||
Line |
int32 |
Número de Línea | Line number. | ||
Line |
int32 |
Número de Línea | Line number. | ||
Line |
int16 |
Tipo de Línea | Line type. | ||
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. | ||
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. | ||
Project2 |
guid |
Project | Reference to project. | ||
Quantity |
double |
Quantity | Quantity. | ||
Quantity2 |
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). |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:
Modificaciones de esta tabla, De 26.0 a 27.0
+GLAccount(guid)+GLAccount2(guid)+Item(guid)+Item2(guid)+LineNumber(int32)+LineNumber2(int32)+LineType(int16)+LineType2(int16)+OffsetID(guid)+OffsetID2(guid)+Project(guid)+Project2(guid)+Quantity(double)+Quantity2(double)