invantive documentation
Invantive SupportforenAnmelden / Eintragen

SalesInvoicesIncremental: Exact Online Sales Invoices (Incremental)

read only

  • Katalog: ExactOnlineREST
  • Schema: Views
  • Label: Sales Invoices (Incremental)

Headers of sales invoices.

Es können nur Daten abgerufen werden.

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 432
Anzahl der Vollscan-Zeilen pro Minute 50,300
Anzahl der Query-Zeilen pro Minute 138

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Tabellenspalten

Die Spalten der Tabelle SalesInvoicesIncremental sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
AmountDC double Betrag Sparte Währung Amount in the default currency of the company.For almost all lines this can be calculated like: AmountDC = AmountFC * RateFC.
AmountDiscount double Betrag Rabatt Discount amount in the default currency of the company.
AmountDiscountExclVat double Amount Discount excluding VAT Discount amount excluding VAT in the default currency of the company.
AmountFC double Summe Fremdwährung Amount in the currency of the transaction.
AmountFCExclVat double Betrag in Währung ohne Mehrwertsteuer Amount exclude VAT in the currency of the transaction.
CostCenter varchar2 Kostenstelle Reference to Cost center.
CostUnit varchar2 Kostenträger Reference to Cost unit.
Created datetime Created
Creator guid Creator writable User ID of creator.
Currency varchar2 Currency Currency code.
CustomField varchar2 Benutzerdefiniertes Feld
CustomerItemCode varchar2 Kundenartikelcode Code the customer uses for this item.
DeliverTo guid Liefern an Reference to the delivery customer.For an existing sales order this value can not be changed.
DeliverToAddress guid An die Adresse liefern Delivery address.
DeliverToContactPerson guid An den Ansprechpartner liefern Reference to contact person of delivery customer.
DeliveryDate datetime Liefertermin 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 Rabatttyp 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 Filter auf der Plattform Division code.
Document guid Document Document that is manually linked to the sales order.
DueDate datetime Fälligkeitsdatum 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 Endzeit EndTime is used to store the last date of a period.EndTime is used in combination with StartTime.
EndTime2 datetime Endzeit EndTime is used to store the last date of a period.EndTime is used in combination with StartTime.
ExtraDutyAmountFC double Zuschlagsbetrag in Währung 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 Zuschlag (%) Extra duty percentage.
GAccountAmountFC double G-Konto-Betrag in Fremdwährung 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 Hauptbuchkonto Filter auf der Plattform 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 Hauptbuchkonto Filter auf der Plattform 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 Incoterm-Adresse Filter auf der Plattform
IncotermCode varchar2 Incoterm-Code Filter auf der Plattform
IncotermVersion int16 Incoterm-Version Filter auf der Plattform
InvoiceDate datetime Rechnungsdatum 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 Rechnungs-ID The InvoiceID identifies the sales invoice.All the lines of a sales invoice have the same InvoiceID.
InvoiceNumber int32 Rechnungsnummer 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 Rechnung an Reference to the customer who will receive the invoice.For an existing sales order this value can not be changed.
InvoiceToContactPerson guid Rechnung an Ansprechpartner Reference to the contact person of the customer who will receive the invoice.
IsExtraDuty char Ist Überstundenarbeit 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 Zeilen Nummer Indicates the sequence of the lines within one invoice.
LineNumber2 int32 Zeilen Nummer Indicates the sequence of the lines within one invoice.
Modified datetime Modified
Modifier guid Modifier writable User ID of modifier.
NetPrice double Nettopreis Net price of the sales invoice line.
Notes varchar2 Notes Extra notes.
OrderDate datetime Orderdatum writable Order date.
OrderNumber int32 Bestellnummer Number of sales order.
OrderedBy guid Bestellt von Customer who ordered the invoice.
OrderedByContactPerson guid Sortiert nach Ansprechpartner Contact person of customer who ordered the invoice.
PaymentCondition varchar2(2) Zahlungsbedingung filters on the platform, writable The payment condition used for due date and discount calculation.
PaymentReference varchar2(60) Zahlungsreferenz filters on the platform, writable Payment reference for sales invoice.
Pricelist guid Preisliste 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 Projekt-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 Verkaufskanal Reference to sales channel.
SalesOrder guid Kundenauftrag Identifies the sales order this invoice line is based on.
SalesOrderLine guid Auftragsposition Identifies the sales order line this sales invoice line is based on.
SalesOrderLine2 guid Auftragsposition Identifies the sales order line this sales invoice line is based on.
Salesperson guid Verkaufer Reference to sales person.
StartTime datetime Startzeit StartTime is used to store the first date of a period.StartTime is used in combination with EndTime.
StartTime2 datetime Startzeit 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 Filter auf der Plattform
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 Einheit Code Code of Unit.
UnitPrice double Einheit Preis Price per unit.
UnitPrice2 double Einheit Preis Price per unit.
VATAmountDC double Umsatzsteuerbetrag Währung VAT amount in the default currency of the company.
VATAmountFC double USt. Summe Fremdwährung VAT amount in the currency of the transaction.
VATCode varchar2 Umsatzsteuer-IDNr. The VAT code that is used when the invoice is registered.
VATPercentage double Umsatzsteuer Prozentsatz 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 Quellensteuerbetrag (Fremdwährung) Withholding tax amount applied to sales invoice.Not supported in The Netherlands.
WithholdingTaxBaseAmount double Bemessungsgrundlage für die Quellensteuer Withholding tax base amount to calculate withholding amount.Not supported in The Netherlands.
WithholdingTaxPercentage double Quellensteuer (%) Withholding tax percentage applied to sales invoice.Not supported in The Netherlands.
YourRef varchar2(60) Ihre Referenz filters on the platform, writable Invoice number of the customer.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

Änderungen an dieser Tabelle, 26.0 bis 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 weitere Änderungen

  • + UnitPrice2 (double)

Alle Treiberwechsel, 26.0 bis 27.0