SalesInvoices: Exact Online Sales Invoices
insert update delete per partition webhook REST
- Katalog:
ExactOnlineREST - Schema:
SalesInvoice - Primärschlüssel:
InvoiceID - Label: Sales Invoices
Die Daten in dieser Tabelle sind nach dem Wert der Spalte Division aufgeteilt.
Mit insert, update und delete können Daten abgerufen und geändert werden.
Änderungen werden über das Webhook-Thema SalesInvoices übermittelt.
API-Quelle
- Endpunkt:
/api/v1/{division}/salesinvoice/SalesInvoices - Metadaten:
/api/v1/{division}/salesinvoice/$metadata
Leistungsmerkmale
| Characteristic | Value |
|---|---|
| Durchschnittliche Zugriffsverzögerung (ms) | 5 |
| Anzahl der Vollscan-Zeilen pro Minute | 7,200 |
| Anzahl der Query-Zeilen pro Minute | 300 |
| Zeilen pro Minute schreiben | 300 |
Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.
Tabellenspalten
Die Spalten der Tabelle SalesInvoices 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 |
|---|---|---|---|---|---|
Amount |
double |
Betrag Sparte Währung | writable | For the header lines (LineNumber = 0) of an entry this is the SUM(AmountDC) of all lines. | |
Amount |
double |
Betrag Rabatt | writable | Discount amount in the default currency of the company. | |
Amount |
double |
Amount Discount excluding VAT | writable | Discount amount exclude VAT in the default currency of the company. | |
Amount |
double |
Summe Fremdwährung | writable | For the header this is the sum of all lines, including VAT. | |
Amount |
double |
Betrag in Währung ohne Mehrwertsteuer | writable | For the header this is the sum of all lines, excluding VAT. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Angelegt | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Ersteller vollständiger Name | writable | Name of creator. | |
Currency |
varchar2 |
Currency | writable | Currency for the invoice.Default this is the currency of the administration. | |
Deliver |
guid |
Liefern an | filters on the platform, writable | Delivery account for invoice. | |
Deliver |
guid |
An die Adresse liefern | filters on the platform, writable | Address of delivery as per invoice delivery account. | |
Deliver |
guid |
An den Ansprechpartner liefern | filters on the platform, writable | Delivery account person for invoice. | |
Deliver |
varchar2 |
Lieferung an Ansprechpartner – Vollständiger Name | writable | Name of delivery account's contact person as per invoice. | |
Deliver |
varchar2 |
An Namen liefern | writable | Name of the delivery account's customer as per invoice. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description.Can be different for header and lines. | |
Discount |
double |
Discount | writable | Discount percentage. | |
Discount |
int16 |
Rabatttyp | writable | ||
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Nummer der Handelskammer des Bezirks | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Abteilung IBAN-Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Geschäftsbereich Firmenname | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Abteilung RSIN-Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Umsatzsteuer-Identifikationsnummer der Abteilung | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Nummer der Lohnsteuerabteilung | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Abteilungsbezeichnung | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Verwaltung Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Name des Abonnenten | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnentennummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Kurzbezeichnung der Abteilung | writable | Short name of the Exact Online division. | |
Document |
guid |
Document | filters on the platform, writable | Document that is manually linked to the invoice. | |
Document |
int32 |
Dokumentnummer | writable | Number of the document. | |
Document |
varchar2 |
Dokument Betreff | writable | Subject of the document. | |
Due |
datetime |
Fälligkeitsdatum | writable | The due date for payments.This date is calculated based on the EntryDate and the Paymentcondition. | |
Extra |
double |
Zuschlagsbetrag in Währung | writable | 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. | |
G |
double |
G-Konto-Betrag in Fremdwährung | writable | 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. | |
Incoterm |
varchar2 |
Incoterm-Adresse | filters on the platform, writable | ||
Incoterm |
varchar2 |
Incoterm-Code | filters on the platform, writable | ||
Incoterm |
int16 |
Incoterm-Version | filters on the platform, writable | ||
Invoice |
datetime |
Rechnungsdatum | filters on the platform, 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. | |
Invoice |
guid |
Rechnungs-ID | filters on the platform, writable | Primary key. | |
Invoice |
int32 |
Rechnungsnummer | filters on the platform, writable | 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. | |
Invoice |
guid |
Rechnung an | filters on the platform, writable | Reference to the Customer who will receive the invoice. | |
Invoice |
guid |
Rechnung an Ansprechpartner | filters on the platform, writable | Reference to the Contact person of the customer who will receive the invoice. | |
Invoice |
varchar2 |
Rechnungsempfänger: Vollständiger Name des Ansprechpartners | writable | Name of the contact person of the customer who will receive the invoice. | |
Invoice |
varchar2 |
Rechnungsempfänger | writable | Name of the customer who will receive the invoice. | |
Is |
char |
Ist Überstundenarbeit | writable | Indicates whether the invoice has extra duty. | |
Journal |
varchar2 |
Journal | filters on the platform, writable | The journal code.Every invoice should be linked to a sales journal. | |
Journal |
varchar2 |
Journal Beschreibung | writable | Description of Journal. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Geändert (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Modifier |
varchar2 |
Geänderter vollständiger Name | writable | Name of modifier. | |
Net |
double |
Nettobetrag, Abteilung, Währung | writable | Net amount in division currency of sales invoice. | |
Net |
double |
Nettobetrag in Währung | writable | Net amount in foreign currency of sales invoice. | |
Order |
datetime |
Orderdatum | writable | Order date. | |
Order |
int32 |
Bestellnummer | filters on the platform, writable | Number to identify the order.By default the number is based on a setting for the first free number, but you can post your own number. | |
Ordered |
guid |
Bestellt von | filters on the platform, writable | Customer who ordered the invoice. | |
Ordered |
guid |
Sortiert nach Ansprechpartner | filters on the platform, writable | Contact person of customer who ordered the invoice. | |
Ordered |
varchar2 |
Sortiert nach vollständigem Namen des Ansprechpartners | writable | Name of contact person of customer who ordered the invoice. | |
Ordered |
varchar2 |
Nach Namen sortiert | writable | Name of customer who ordered the invoice. | |
Payment |
varchar2 |
Zahlungsbedingung | writable | The payment condition used for due date and discount calculation. | |
Payment |
varchar2 |
Zahlungsbedingung Beschreibung | writable | Description of PaymentCondition. | |
Payment |
varchar2 |
Zahlungsreferenz | filters on the platform, writable | Payment reference for sales invoice. | |
Remarks |
varchar2 |
Remarks | writable | Extra remarks. | |
Sales |
guid |
Verkaufskanal | Filter auf der Plattform | ||
Sales |
varchar2 |
Vertriebskanal-Code | |||
Sales |
varchar2 |
Beschreibung des Vertriebskanals | |||
Salesperson |
guid |
Verkaufer | filters on the platform, writable | Sales representative. | |
Salesperson |
varchar2 |
Vertriebsmitarbeiter vollständiger Name | writable | Name of sales representative. | |
Selection |
guid |
Auswahlcode | filters on the platform, writable | ID of selection code.Only supported by the Advanced and Premium editions for Wholesale & Distribution and Manufacturing. | |
Selection |
varchar2 |
Auswahlcode | writable | Code of selection code. | |
Selection |
varchar2 |
itgen_eol_selectioncodedescription | writable | Description of selection code. | |
Shipping |
guid |
Versandart | filters on the platform, writable | ||
Shipping |
varchar2 |
Versandart-Code | Filter auf der Plattform | ||
Shipping |
varchar2 |
Beschreibung der Versandart | Filter auf der Plattform | ||
Starter |
int16 |
Status der Verkaufsrechnung (Starter) | writable | Starter Sales invoice status (for starter functionality). | |
Starter |
varchar2 |
itgen_eol_startersalesinvoicestatusdescription | writable | Description of StarterSalesInvoiceStatus. | |
Status |
int16 |
Status | filters on the platform, writable | 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. | |
Status |
varchar2 |
Status-Beschreibung | writable | Description of Status. | |
Tax |
guid |
Steuerübersicht | filters on the platform, writable | Obsolete. | |
Tax |
varchar2 |
Steuer-Tarifcode | writable | Obsolete. | |
Tax |
varchar2 |
Beschreibung der Steuertabelle | writable | Obsolete. | |
Type |
int32 |
Type | filters on the platform, writable | Indicates the type of invoice Values: 8020 - Sales invoices, 8021 - Sales credit note. | |
Type |
varchar2 |
Typ Beschreibung | writable | Description of the type. | |
VAT |
double |
Umsatzsteuerbetrag Währung | writable | Total VAT amount in the default currency of the company. | |
VAT |
double |
USt. Summe Fremdwährung | writable | Total VAT amount in the currency of the transaction. | |
Warehouse |
guid |
Warehouse | filters on the platform, writable | Mandatory for direct sales invoice/credit note, cannot be set for normal sales invoice/credit note. | |
Withholding |
double |
Quellensteuerbetrag (Fremdwährung) | writable | Withholding tax amount applied to sales invoice. | |
Withholding |
double |
Bemessungsgrundlage für die Quellensteuer | writable | Withholding tax base amount to calculate withholding amount. | |
Withholding |
double |
Quellensteuer (%) | writable | Withholding tax percentage applied to sales invoice. | |
Your |
varchar2 |
Ihre Referenz | filters on the platform, writable | The invoice number of the customer. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Sales |
Creator |
Users. |
Key | |
Sales |
Currency |
Currencies.Code |
Key | |
Sales |
Deliver |
Addresses.ID |
Key | |
Sales |
Deliver |
Contacts.ID |
Key | |
Sales |
Deliver |
Accounts.ID |
Key | |
Sales |
Document |
Documents.ID |
Key | |
Sales |
Invoice |
Contacts.ID |
Key | |
Sales |
Invoice |
Accounts.ID |
Key | |
Sales |
Journal |
Journals.Code |
Key | |
Sales |
Modifier |
Users. |
Key | |
Sales |
Ordered |
Contacts.ID |
Key | |
Sales |
Ordered |
Accounts.ID |
Key | |
Sales |
Salesperson |
Users. |
Key | |
Sales |
Selection |
SelectionCodes.ID |
Key | |
Sales |
Warehouse |
Warehouses.ID |
Key |
Verwiesen von
- SalesInvoiceLines
InvoiceID(Key) - SalesInvoiceLinesBulk
InvoiceID(Key)
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: