---
title: "SalesInvoicesIncremental (Exact Online)"
description: "Sales Invoices (Incremental)"
language: es
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/datamodels/exactonline/ExactOnlineREST.Views.SalesInvoicesIncremental
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.Views.SalesInvoicesIncremental
updated: 2026-11-16T20:58:27Z
license: https://documentation.invantive.eu/es/
---

# SalesInvoicesIncremental: Exact Online Sales Invoices (Incremental)

`read only`

- Catálogo: `ExactOnlineREST`
- Esquema: `Views`
- Label: Sales Invoices (Incremental)

Headers of sales invoices.

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 `SalesInvoicesIncremental`. 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 |
|---|---|---|:---:|---|---|
| `AmountDC` | `double` | Importe División Moneda | [ ] |  | Amount in the default currency of the company.For almost all lines this can be calculated like: AmountDC = AmountFC * RateFC. |
| `AmountDiscount` | `double` | Importe del descuento | [ ] |  | Discount amount in the default currency of the company. |
| `AmountDiscountExclVat` | `double` | Importe del descuento sin IVA | [ ] |  | Discount amount excluding VAT in the default currency of the company. |
| `AmountFC` | `double` | Cantidad Moneda Extranjera | [x] |  | Amount in the currency of the transaction. |
| `AmountFCExclVat` | `double` | Importe en moneda extranjera, sin IVA | [ ] |  | Amount exclude VAT in the currency of the transaction. |
| `CostCenter` | `varchar2` | Centro de Costo | [ ] |  | Reference to Cost center. |
| `CostUnit` | `varchar2` | Unidad de Costo | [ ] |  | Reference to Cost unit. |
| `Created` | `datetime` | Created | [ ] |  |  |
| `Creator` | `guid` | Creator | [ ] | writable | User ID of creator. |
| `Currency` | `varchar2` | Currency | [ ] |  | Currency code. |
| `CustomField` | `varchar2` | Campo personalizado | [ ] |  |  |
| `CustomerItemCode` | `varchar2` | Código de artículo del cliente | [ ] |  | Code the customer uses for this item. |
| `DeliverTo` | `guid` | Entregar a | [ ] |  | Reference to the delivery customer.For an existing sales order this value can not be changed. |
| `DeliverToAddress` | `guid` | Entregar en la dirección | [ ] |  | Delivery address. |
| `DeliverToContactPerson` | `guid` | Entregar a la persona de contacto | [ ] |  | Reference to contact person of delivery customer. |
| `DeliveryDate` | `datetime` | Fecha de Entrega | [ ] |  | Delivery date of an item in a sales invoice.This is used for VAT on prepayments, only if sales order is not used in the license. |
| `Description` | `varchar2` | Description | [ ] |  | Description.Can be different for header and lines. |
| `Discount` | `double` | Discount | [ ] |  | Discount given on the default price.Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of Item. |
| `DiscountType` | `int16` | Tipo de descuento | [ ] |  | Leading field of total discount.1=Discount percentage, 2=Discount amount excl. VAT, 3=Discount amount incl. VAT, 4=Total amount excl. VAT, 5=Total amount incl. VAT. |
| `Division` | `int32` | Division | [x] | filtros de la plataforma | Division code. |
| `Document` | `guid` | Document | [ ] |  | Document that is manually linked to the sales order. |
| `DueDate` | `datetime` | Fecha de Vencimiento | [ ] | writable | The due date for payments.This date is calculated based on the EntryDate and the Paymentcondition. |
| `Employee` | `guid` | Employee | [ ] |  | Link to Employee originating from time and cost transactions. |
| `EndTime` | `datetime` | Hora de finalización | [ ] |  | EndTime is used to store the last date of a period.EndTime is used in combination with StartTime. |
| `EndTime2` | `datetime` | Hora de finalización | [ ] |  | EndTime is used to store the last date of a period.EndTime is used in combination with StartTime. |
| `ExtraDutyAmountFC` | `double` | Importe del recargo por monedas extranjeras | [ ] |  | Extra duty amount in the currency of the transaction.Both extra duty amount and VAT amount need to be specified in order to differ this property from automatically calculated. |
| `ExtraDutyPercentage` | `double` | Recargo (%) | [ ] |  | Extra duty percentage. |
| `GAccountAmountFC` | `double` | Cuenta G Importe de moneda extranjera | [ ] |  | A positive value of the amount indicates that the amount is to be paid by the customer to your G bank account.In case of a credit invoice the amount should have negative value when retrieved or posted to Exact. |
| `GLAccount` | `guid` | Cuenta de Contabilidad General | [ ] | filtros de la plataforma | The GL Account of the sales invoice line.This field is mandatory.This field is generated based on the revenue account of the item (or the related item group).G/L Account is also used to determine whether the costcenter / costunit is mandatory. |
| `GLAccount2` | `guid` | Cuenta de Contabilidad General | [ ] | filtros de la plataforma | The GL Account of the sales invoice line.This field is mandatory.This field is generated based on the revenue account of the item (or the related item group).G/L Account is also used to determine whether the costcenter / costunit is mandatory. |
| `IncotermAddress` | `varchar2` | Dirección según los Incoterms | [ ] | filtros de la plataforma |  |
| `IncotermCode` | `varchar2` | Código Incoterm | [ ] | filtros de la plataforma |  |
| `IncotermVersion` | `int16` | Versión de Incoterm | [ ] | filtros de la plataforma |  |
| `InvoiceDate` | `datetime` | Fecha de la Factura | [ ] | writable | Official date for the invoice.When the invoice is entered it's equal to the field 'EntryDate'.During the printing process the invoice date can be entered. |
| `InvoiceID` | `guid` | ID de la Factura | [x] |  | The InvoiceID identifies the sales invoice.All the lines of a sales invoice have the same InvoiceID. |
| `InvoiceNumber` | `int32` | Número de factura | [ ] |  | Assigned at entry or at printing depending on setting.The number assigned is based on the freenumbers as defined for the Journal.When printing the field InvoiceNumber is copied to the fields EntryNumber and InvoiceNumber of the sales entry. |
| `InvoiceTo` | `guid` | Factura para | [ ] |  | Reference to the customer who will receive the invoice.For an existing sales order this value can not be changed. |
| `InvoiceToContactPerson` | `guid` | Factura a nombre de la persona de contacto | [ ] |  | Reference to the contact person of the customer who will receive the invoice. |
| `IsExtraDuty` | `char` | ¿Son horas extras? | [ ] |  | Indicates whether the invoice has extra duty. |
| `Item` | `guid` | Item | [ ] |  | Reference to the item that is sold in this sales invoice line. |
| `Item2` | `guid` | Item | [ ] |  | Reference to the item that is sold in this sales invoice line. |
| `Journal` | `varchar2` | Journal | [ ] |  | The journal code.Every invoice should be linked to a sales journal. |
| `LineNumber` | `int32` | Número de Línea | [ ] |  | Indicates the sequence of the lines within one invoice. |
| `LineNumber2` | `int32` | Número de Línea | [ ] |  | Indicates the sequence of the lines within one invoice. |
| `Modified` | `datetime` | Modified | [ ] |  |  |
| `Modifier` | `guid` | Modifier | [ ] | writable | User ID of modifier. |
| `NetPrice` | `double` | Precio Neto | [ ] |  | Net price of the sales invoice line. |
| `Notes` | `varchar2` | Notes | [ ] |  | Extra notes. |
| `OrderDate` | `datetime` | Fecha de la Orden | [ ] | writable | Order date. |
| `OrderNumber` | `int32` | Número de la Orden | [ ] |  | Number of sales order. |
| `OrderedBy` | `guid` | Pedido por | [ ] |  | Customer who ordered the invoice. |
| `OrderedByContactPerson` | `guid` | Ordenado por persona de contacto | [ ] |  | Contact person of customer who ordered the invoice. |
| `PaymentCondition` | `varchar2(2)` | Condición de Pago | [ ] | filters on the platform, writable | The payment condition used for due date and discount calculation. |
| `PaymentReference` | `varchar2(60)` | Referencia de Pago | [ ] | filters on the platform, writable | Payment reference for sales invoice. |
| `Pricelist` | `guid` | Lista de Precios | [ ] |  | Price list. |
| `Project` | `guid` | Project | [ ] |  | The project to which the sales transaction line is linked.The project can be different per line.Sometimes also the project in the header is filled although this is not really used. |
| `Project2` | `guid` | Project | [ ] |  | The project to which the sales transaction line is linked.The project can be different per line.Sometimes also the project in the header is filled although this is not really used. |
| `ProjectWBS` | `guid` | Estructura de división del proyecto (WBS) | [ ] |  | WBS linked to the sales invoice. |
| `Quantity` | `double` | Quantity | [ ] |  | The number of items sold in default units.The quantity shown in the entry screen is Quantity * UnitFactor. |
| `Remarks` | `varchar2` | Remarks | [ ] |  |  |
| `SalesChannel` | `guid` | Canal de Ventas | [ ] |  | Reference to sales channel. |
| `SalesOrder` | `guid` | Orden de Venta | [ ] |  | Identifies the sales order this invoice line is based on. |
| `SalesOrderLine` | `guid` | Línea de Orden de Ventas | [ ] |  | Identifies the sales order line this sales invoice line is based on. |
| `SalesOrderLine2` | `guid` | Línea de Orden de Ventas | [ ] |  | Identifies the sales order line this sales invoice line is based on. |
| `Salesperson` | `guid` | Vendedor | [ ] |  | Reference to sales person. |
| `StartTime` | `datetime` | Hora de Inicio | [ ] |  | StartTime is used to store the first date of a period.StartTime is used in combination with EndTime. |
| `StartTime2` | `datetime` | Hora de Inicio | [ ] |  | StartTime is used to store the first date of a period.StartTime is used in combination with EndTime. |
| `Status` | `int16` | Status | [ ] |  | The status of the entry.10 = draft.During the creation of an invoice draft records occur in the draft modus if during an invoice a new page with lines is triggered.If the user leaves the invoice in an abnormal way the draft invoices can be recovered.Draft invoices are not included in financial reports, balances etc. 20 = open.Open invoices can be changed.New invoices get the status open by default.50 = processed.Processed invoices can't be changed anymore.Processing is done via printing.Processed invoices can't be reopened. |
| `Subscription` | `guid` | Subscription | [ ] |  | When generating invoices from subscriptions, this field records the link between invoice lines and subscription lines. |
| `Timestamp` | `int64` | Timestamp | [x] | filtros de la plataforma |  |
| `Type` | `int16` | Type | [ ] |  | Indicates the type of invoice Values: 8020 - Sales invoices, 8021 - Sales credit note, 8023 - Direct sales invoice, 8024 - Direct credit note.Type 8023 and 8024 are only supported by the Advanced and Premium editions for Wholesale & Distribution and Manufacturing. |
| `UnitCode` | `varchar2` | Código de la Unidad | [ ] |  | Code of Unit. |
| `UnitPrice` | `double` | Precio de la Unidad | [ ] |  | Price per unit. |
| `UnitPrice2` | `double` | Precio de la Unidad | [ ] |  | Price per unit. |
| `VATAmountDC` | `double` | Importe del IVA, división, Moneda | [ ] |  | VAT amount in the default currency of the company. |
| `VATAmountFC` | `double` | Moneda Extranjera de la Cantidad VAT | [ ] |  | VAT amount in the currency of the transaction. |
| `VATCode` | `varchar2` | Código VAT | [ ] |  | The VAT code that is used when the invoice is registered. |
| `VATPercentage` | `double` | Porcentaje VAT | [ ] |  | The VAT percentage of the VAT code.This is the percentage at the moment the invoice is created.It's also used for the default calculation of VAT amounts and VAT base amounts. |
| `Warehouse` | `guid` | Warehouse | [ ] |  | Reference to warehouse.Mandatory for direct sales invoice/credit note, cannot be set for normal sales invoice/credit note. |
| `WithholdingTaxAmountFC` | `double` | Importe de la retención fiscal (moneda extranjera) | [ ] |  | Withholding tax amount applied to sales invoice.Not supported in The Netherlands. |
| `WithholdingTaxBaseAmount` | `double` | Importe base de la retención en origen | [ ] |  | Withholding tax base amount to calculate withholding amount.Not supported in The Netherlands. |
| `WithholdingTaxPercentage` | `double` | Retención fiscal (%) | [ ] |  | Withholding tax percentage applied to sales invoice.Not supported in The Netherlands. |
| `YourRef` | `varchar2(60)` | Su Referencia | [ ] | filters on the platform, writable | Invoice number of the customer. |


## Notas de la Versión

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

- [Exact Online](/es/release-notes/drivers?driver=exact-online)

### Modificaciones de esta tabla, De 26.0 a 27.0

<a id="EOL-27.0-D017"></a><a id="EOL-27.0-D018"></a><a id="EOL-27.0-D019"></a><a id="EOL-27.0-D020"></a><a id="EOL-27.0-D021"></a><a id="EOL-27.0-D022"></a><a id="EOL-27.0-D023"></a><a id="EOL-27.0-D024"></a><a id="EOL-27.0-D025"></a><a id="EOL-27.0-D026"></a><a id="EOL-27.0-D027"></a><a id="EOL-27.0-D028"></a><a id="EOL-27.0-D029"></a><a id="EOL-27.0-D030"></a><a id="EOL-27.0-D031"></a>

- `+` `EndTime` (`datetime`)
- `+` `EndTime2` (`datetime`)
- `+` `GLAccount` (`guid`)
- `+` `GLAccount2` (`guid`)
- `+` `Item` (`guid`)
- `+` `Item2` (`guid`)
- `+` `LineNumber` (`int32`)
- `+` `LineNumber2` (`int32`)
- `+` `Project` (`guid`)
- `+` `Project2` (`guid`)
- `+` `SalesOrderLine` (`guid`)
- `+` `SalesOrderLine2` (`guid`)
- `+` `StartTime` (`datetime`)
- `+` `StartTime2` (`datetime`)
- `+` `UnitPrice` (`double`)

<details>
<summary>

1 cambios más

</summary>

<a id="EOL-27.0-D032"></a>

- `+` `UnitPrice2` (`double`)

</details>

[Todos los cambios del conductor, De 26.0 a 27.0](/es/release-notes/drivers?driver=exact-online&step=26.0-to-27.0#exact-online-26.0-to-27.0)
