SalesOrderLines: Exact Online Sales Order Lines
insert update delete per partition webhook REST
- Catalogus:
ExactOnlineREST - Schema:
SalesOrder - Primaire sleutels:
ID - Label: Sales Order Lines
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Je kunt gegevens ophalen en wijzigen met insert, update en delete.
Wijzigingen worden binnengekomen via het webhook-onderwerp SalesOrders op OrderID.
API-bron
- Eindpunt:
/api/v1/{division}/salesorder/SalesOrderLines - Metagegevens:
/api/v1/{division}/salesorder/$metadata
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 5 |
| Aantal rijen per minuut bij volledige scan | 7,200 |
| 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 SalesOrderLines 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 | writable | Amount in the default currency of the company. | |
Amount |
double |
Bedrag Vreemde Valuta | writable | Amount in the currency of the transaction. | |
Cost |
varchar2 |
Kostenplaats | filters on the platform, writable | Reference to Cost Center. | |
Cost |
varchar2 |
Kostenplaats Omschrijving | writable | Description of cost center. | |
Cost |
double |
Kostprijs Vreemde Valuta | writable | Item cost price. | |
Cost |
varchar2 |
Kostendrager | filters on the platform, writable | Reference to Cost Unit. | |
Cost |
varchar2 |
Kostendrager Omschrijving | writable | Description of cost unit. | |
Custom |
varchar2 |
Aangepast Veld | filters op het platform | ||
Customer |
varchar2 |
Klant Artikelcode | Code the customer uses for this item. | ||
Delivery |
datetime |
Leveringsdatum | filters on the platform, writable | Delivery date of this line. | |
Delivery |
int16 |
Afleverstatus | filters on the platform, writable | Shipping status of the sales order line.12=Open, 20=Partial, 21=Complete, 45=Cancelled. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description. | |
Discount |
double |
Discount | writable | Discount given on the default price.Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of Item. | |
Division |
int32 |
Division | Division code. | ||
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. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Invoice |
int16 |
Factuurstatus | filters on the platform, writable | Invoice status of the sales order line.12=Open, 20=Partial, 21=Complete, 45=Cancelled. | |
Item |
guid |
Item | filters on the platform, writable | Reference to the Item that is sold in this sales order line. | |
Item |
varchar2 |
Artikelcode | writable | Code of the item. | |
Item |
varchar2 |
Artikelomschrijving | writable | Description of Item. | |
Item |
guid |
Artikelversie | filters on the platform, writable | Version of item. | |
Item |
varchar2 |
Artikelversie Omschrijving | writable | Description of Item Version. | |
Line |
int32 |
Regelnummer | filters on the platform, writable | Line number. | |
Margin |
double |
Margin | writable | Sales margin of the sales order line. | |
Net |
double |
Netto Prijs | writable | Net price of the sales order line. | |
Notes |
varchar2 |
Notes | writable | Extra notes. | |
Order |
guid |
Order ID | filters on the platform, writable | Reference to Sales Order.All the lines of a sales order have the same OrderID. | |
Order |
int32 |
Ordernummer | filters on the platform, writable | Number of sales order. | |
Order |
int16 |
Orderstatus | filters on the platform, writable | The status of the sales order line.12=Open, 20=Partial, 21=Complete, 45=Cancelled. | |
Pricelist |
guid |
Prijslijst | filters on the platform, writable | Reference to Price List. | |
Pricelist |
varchar2 |
Prijslijstomschrijving | writable | Description of Price List. | |
Project |
guid |
Project | filters on the platform, writable | Reference to Project.The project can be different per line.Sometimes also the project in the header is filled although this is not really used. | |
Project |
varchar2 |
Projectomschrijving | writable | Description of Project. | |
Purchase |
guid |
Inkooporder | writable | Reference to Purchase Order. | |
Purchase |
guid |
Inkooporderregel | writable | Reference to Purchase Order Line. | |
Purchase |
int32 |
Inkoop Orderregel Nummer | writable | Line number of referenced Purchase Order Line. | |
Purchase |
int32 |
Inkoopordernummer | writable | Number of referenced Purchase Order. | |
Quantity |
double |
Quantity | writable | Number of items sold in default units.The quantity shown in the entry screen is Quantity * UnitFactor. | |
Quantity |
double |
Aantal Geleverd | writable | The number of items delivered. | |
Quantity |
double |
Gefactureerd Aantal | writable | The number of items invoiced. | |
Shop |
guid |
Productieorder | filters on the platform, writable | Reference to Shop Order. | |
Tax |
guid |
Belastingplan | writable | Obsolete. | |
Tax |
varchar2 |
Belasting Planningscode | writable | Obsolete. | |
Tax |
varchar2 |
Belasting Planningsomschrijving | writable | Obsolete. | |
Unit |
varchar2 |
Unit Code | writable | Code of item unit. | |
Unit |
varchar2 |
Omschrijving Unit | writable | Description of Item Unit. | |
Unit |
double |
Prijs per Eenheid | writable | Price per unit in the currency of the transaction. | |
Use |
int16 |
Gebruik Drop Shipment | filters on the platform, writable | Indicates if drop shipment is used (delivery directly to customer, invoice to wholesaler). | |
VAT |
double |
BTW-bedrag | writable | VAT amount in the currency of the transaction. | |
VAT |
varchar2 |
BTW-code | filters on the platform, writable | VAT code. | |
VAT |
varchar2 |
BTW Code Omschrijving | writable | Description of VAT code. | |
VAT |
double |
BTW-percentage | writable | The VAT percentage of the VAT code.This is the percentage at the moment the sales order is created.It's also used for the default calculation of VAT amounts and VAT base amounts. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
Sales |
Cost |
Costcenters.Code |
Key | |
Sales |
Cost |
Costunits.Code |
Key | |
Sales |
Item |
ItemVersions.ID |
Key | |
Sales |
Item |
Items.ID |
Key | |
Sales |
Order |
SalesOrders. |
Key | |
Sales |
Pricelist |
SalesPriceLists.ID |
Key | |
Sales |
Project |
Projects.ID |
Key | |
Sales |
Purchase |
PurchaseOrderLines.ID |
Key | |
Sales |
Purchase |
PurchaseOrders. |
Key | |
Sales |
Shop |
ShopOrders.ID |
Key | |
Sales |
VAT |
VATCodes.Code |
Key |
Geciteerd door
- PurchaseOrderLines
SalesOrderLine(Key) - SalesInvoiceLines
SalesOrderLine(Key) - SalesInvoiceLinesBulk
SalesOrderLine(Key) - DigitalOrderPickingLines
SalesOrderLineID(Key) - GoodsDeliveryLines
SalesOrderLineID(Key) - GoodsDeliveryLinesBulk
SalesOrderLineID(Key) - PlannedSalesReturnLines
SalesOrderLineID(Key)
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: