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

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 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 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 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 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:

Modificaciones de esta tabla, De 26.0 a 27.0

  • + 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)

1 cambios más

  • + UnitPrice2 (double)

Todos los cambios del conductor, De 26.0 a 27.0