SalesInvoicesBulk: Exact Online Sales Invoices
read only per partition webhook REST
- Catalogus:
ExactOnlineREST - Schema:
SalesInvoice - Primaire sleutels:
InvoiceID - Label: Sales Invoices
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Kan alleen gegevens ophalen.
Wijzigingen worden doorgegeven via het webhook-onderwerp SalesInvoices.
API-bron
- Eindpunt:
/api/v1/{division}/bulk/SalesInvoice/SalesInvoices - Metagegevens:
/api/v1/{division}/bulk/SalesInvoice/$metadata
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 5 |
| Aantal rijen per minuut bij volledige scan | 20,000 |
| Aantal rijen per minuut in een Query | 300 |
| Aantal rijen per minuut schrijven | 300 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel SalesInvoicesBulk worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Amount |
double |
Bedrag Administratie Munteenheid | For the header lines (LineNumber = 0) of an entry this is the SUM(AmountDC) of all lines. | ||
Amount |
double |
Kortingsbedrag | Discount amount in the default currency of the company. | ||
Amount |
double |
Kortingsbedrag exclusief BTW | Discount amount exclude VAT in the default currency of the company. | ||
Amount |
double |
Bedrag Vreemde Valuta | For the header this is the sum of all lines, including VAT. | ||
Amount |
double |
Bedrag Vreemde Valuta exclusief BTW | For the header this is the sum of all lines, excluding VAT. | ||
Created |
datetime |
Created | filters op het platform | Creation date. | |
Created |
datetime |
Aangemaakt (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | User ID of creator. | ||
Creator |
varchar2 |
Aanmaker Volledige Naam | Name of creator. | ||
Currency |
varchar2 |
Currency | Currency for the invoice.Default this is the currency of the administration. | ||
Deliver |
guid |
Leveren aan | filters op het platform | Delivery account for invoice. | |
Deliver |
guid |
Afleveradres | filters op het platform | Address of delivery as per invoice delivery account. | |
Deliver |
guid |
Bezorg aan Contactpersoon | filters op het platform | Delivery account person for invoice. | |
Deliver |
varchar2 |
Leveringscontactpersoon Volledige naam | Name of delivery account's contact person as per invoice. | ||
Deliver |
varchar2 |
Leveren aan Naam | Name of the delivery account's customer as per invoice. | ||
Description |
varchar2 |
Description | Description.Can be different for header and lines. | ||
Discount |
double |
Discount | Discount percentage. | ||
Discount |
int16 |
Kortingssoort | Discount Type. | ||
Division |
int32 |
Divisie ID | Unique number of the Exact Online division. | ||
Division |
varchar2 |
Divisie Kamer van Koophandel Nummer | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Divisie IBAN Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisie Bedrijfsnaam | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Divisie RSIN Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Divisie BTW Nummer | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Divisie Loonbelastingnummer | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Divisie Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administratie Naam | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Naam Abonnementhouder | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnementhoudernummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Divisie Korte Naam | writable | Short name of the Exact Online division. | |
Document |
guid |
Document | filters op het platform | Document that is manually linked to the invoice. | |
Document |
int32 |
Documentnummer | Number of the document. | ||
Document |
varchar2 |
Document Onderwerp | Subject of the document. | ||
Due |
datetime |
Vervaldag | The due date for payments.This date is calculated based on the EntryDate and the Paymentcondition. | ||
Extra |
double |
Extra Belasting Bedrag Vreemde Valuta | 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-rekening Bedrag Vreemde Valuta | 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-adres | |||
Incoterm |
varchar2 |
Incoterm-code | |||
Incoterm |
int16 |
Incoterm-versie | |||
Invoice |
datetime |
Factuurdatum | filters op het platform | 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 |
Factuur ID | filters op het platform | Primary key. | |
Invoice |
int32 |
Factuurnummer | filters op het platform | 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 |
Factuur aan | filters op het platform | Reference to the Customer who will receive the invoice. | |
Invoice |
guid |
Factuur aan Contactpersoon | filters op het platform | Reference to the Contact person of the customer who will receive the invoice. | |
Invoice |
varchar2 |
Factuur voor Contactpersoon Volledige naam | Name of the contact person of the customer who will receive the invoice. | ||
Invoice |
varchar2 |
Factuur aan Naam | Name of the customer who will receive the invoice. | ||
Is |
char |
Is Extra Belasting | Indicates whether the invoice has extra duty. | ||
Journal |
varchar2 |
Journal | filters op het platform | The journal code.Every invoice should be linked to a sales journal. | |
Journal |
varchar2 |
Dagboekomschrijving | Description of Journal. | ||
Modified |
datetime |
Modified | Last modified date. | ||
Modified |
datetime |
Gewijzigd (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | User ID of modifier. | ||
Modifier |
varchar2 |
Gewijzigd Volledige Naam | Name of modifier. | ||
Net |
double |
Nettobedrag Administratie Valuta | writable | Net amount in division currency of sales invoice. | |
Net |
double |
Netto Bedrag Vreemde Valuta | writable | Net amount in foreign currency of sales invoice. | |
Order |
datetime |
Besteldatum | Order date. | ||
Order |
int32 |
Ordernummer | filters op het platform | 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 |
Besteld door | filters op het platform | Customer who ordered the invoice. | |
Ordered |
guid |
Besteld door Contactpersoon | filters op het platform | Contact person of customer who ordered the invoice. | |
Ordered |
varchar2 |
Besteld door Contactpersoon Volledige naam | Name of contact person of customer who ordered the invoice. | ||
Ordered |
varchar2 |
Besteld door Naam | Name of customer who ordered the invoice. | ||
Payment |
varchar2 |
Betalingsvoorwaarde | The payment condition used for due date and discount calculation. | ||
Payment |
varchar2 |
Betalingsconditie Omschrijving | Description of PaymentCondition. | ||
Payment |
varchar2 |
Betalingskenmerk | Payment reference for sales invoice. | ||
Remarks |
varchar2 |
Remarks | Extra remarks. | ||
Sales |
guid |
Verkoopkanaal | |||
Sales |
varchar2 |
Verkoopkanaalcode | |||
Sales |
varchar2 |
Verkoopkanaalomschrijving | |||
Salesperson |
guid |
Verkoper | filters op het platform | Sales representative. | |
Salesperson |
varchar2 |
Verkoper Volledige Naam | Name of sales representative. | ||
Selection |
guid |
Selectiecode | filters on the platform, writable | ID of selection code.Only supported by the Advanced and Premium editions for Wholesale & Distribution and Manufacturing. | |
Selection |
varchar2 |
Selectiecode | writable | Code of selection code. | |
Selection |
varchar2 |
itgen_eol_selectioncodedescription | writable | Description of selection code. | |
Shipping |
guid |
Verzendwijze | |||
Shipping |
varchar2 |
Verzendmethodecode | |||
Shipping |
varchar2 |
Verzendmethode Omschrijving | |||
Starter |
int16 |
Verkoopfactuurstatus | Starter Sales invoice status (for starter functionality). | ||
Starter |
varchar2 |
itgen_eol_startersalesinvoicestatusdescription | Description of StarterSalesInvoiceStatus. | ||
Status |
int16 |
Status | filters op het platform | 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 |
Statusomschrijving | Description of Status. | ||
Tax |
guid |
Belastingplan | filters op het platform | Obsolete. | |
Tax |
varchar2 |
Belasting Planningscode | Obsolete. | ||
Tax |
varchar2 |
Belasting Planningsomschrijving | Obsolete. | ||
Type |
int32 |
Type | filters op het platform | Indicates the type of invoice Values: 8020 - Sales invoices, 8021 - Sales credit note, 8023 - Direct sales invoice, 8024 - Direct credit note. | |
Type |
varchar2 |
Soort Omschrijving | Description of the type. | ||
VAT |
double |
BTW Bedrag Administratie Valuta | Total VAT amount in the default currency of the company. | ||
VAT |
double |
BTW-bedrag Vreemde Valuta | Total VAT amount in the currency of the transaction. | ||
Warehouse |
guid |
Warehouse | filters op het platform | Mandatory for direct sales invoice/credit note, cannot be set for normal sales invoice/credit note. | |
Withholding |
double |
Bronbelasting (Vreemde Valuta) | Withholding tax amount applied to sales invoice. | ||
Withholding |
double |
Roerende Voorheffing | Withholding tax base amount to calculate withholding amount. | ||
Withholding |
double |
Roerende Voorheffing (%) | Withholding tax percentage applied to sales invoice. | ||
Your |
varchar2 |
Uw Referentie | The invoice number of the customer. |
Toetsen
| Key | Column | Verwijst naar | 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 |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: