PurchaseOrderLines: Exact Online Purchase Order Lines
insert update delete per partition webhook REST
- Catalogus:
ExactOnlineREST - Schema:
PurchaseOrder - Primaire sleutels:
ID - Label: Purchase 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 PurchaseOrders op PurchaseOrderID.
API-bron
- Eindpunt:
/api/v1/{division}/purchaseorder/PurchaseOrderLines - Metagegevens:
/api/v1/{division}/purchaseorder/$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 PurchaseOrderLines 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 | filters on the platform, writable | Amount in the default currency of the company. | |
Amount |
double |
Bedrag Vreemde Valuta | filters on the platform, writable | Amount in the currency of the transaction. | |
Cost |
varchar2 |
Kostenplaats | filters on the platform, writable | Reference to Cost center. | |
Cost |
varchar2 |
Kostenplaats Omschrijving | filters on the platform, writable | Description of CostCenter. | |
Cost |
varchar2 |
Kostendrager | filters on the platform, writable | Reference to Cost unit. | |
Cost |
varchar2 |
Kostendrager Omschrijving | filters on the platform, writable | Description of CostUnit. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Aangemaakt (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Aanmaker Volledige Naam | filters on the platform, writable | Name of creator. | |
Custom |
varchar2 |
Aangepast Veld | writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | Description of the purchase order line. | |
Discount |
double |
Discount | filters on the platform, writable | Discount in percentage for 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. | |
Expense |
guid |
Expense | filters on the platform, writable | Expense related to the Work Breakdown Structure of the selected project.Only available with a professional service license. | |
Expense |
varchar2 |
Uitgave Omschrijving | filters on the platform, writable | Description of expense.Only available with a professional service license. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
In |
double |
Op Voorraad | writable | The current stock level of items shown in stock unit.The information is displayed only for items with the stock property selected. | |
Invoiced |
double |
Gefactureerde Hoeveelheid | writable | Quantity of item that has been invoiced. | |
Is |
int16 |
Is Batch-Nummer Item | filters op het platform | ||
Is |
int16 |
Is Serienummer Artikel | filters op het platform | ||
Item |
guid |
Item | filters on the platform, writable | Reference to the item for purchase order. | |
Item |
varchar2 |
Artikelbarcode | filters op het platform | ||
Item |
varchar2 |
itgen_eol_itembarcodeadditional | filters on the platform, writable | ||
Item |
varchar2 |
Artikelcode | filters on the platform, writable | Item code. | |
Item |
varchar2 |
Artikelomschrijving | filters on the platform, writable | Description of item. | |
Item |
char |
Splitsbaar Artikel | filters on the platform, writable | Indicates if fractional quantities of the item can be used, for example quantity = 0.4. | |
Line |
int32 |
Regelnummer | filters on the platform, writable | Line number. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Gewijzigd (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Gewijzigd Volledige Naam | filters on the platform, writable | Name of modifier. | |
Net |
double |
Netto Prijs | filters on the platform, writable | The net price is the unit price (VAT code taken into account) with any discount applied. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Notes. | |
Project |
guid |
Project | filters on the platform, writable | Reference to project.Only available with a professional service license. | |
Project |
varchar2 |
Projectcode | filters on the platform, writable | Project code.Only available with a professional service license. | |
Project |
varchar2 |
Projectomschrijving | filters on the platform, writable | Description of the project.Only available with a professional service license. | |
Projected |
double |
Geprojecteerde Voorraad | writable | The current stock level + the planned quantity to be received - the planned quantity to deliver shown in stock unit. | |
Purchase |
guid |
Inkoopopdracht ID | filters on the platform, writable | Identifies the purchase order.All the lines of a purchase order have the same PurchaseOrderID. | |
Quantity |
double |
Quantity | filters on the platform, writable | Quantity in item units. | |
Quantity |
double |
Hoeveelheid in Inkoopeenheden | writable | Quantity in purchase units.Use this field when creating a purchase order. | |
Rebill |
char |
Rebill | filters on the platform, writable | Indicates whether the purchase order line needs to be rebilled.Only available with a professional service license. | |
Receipt |
datetime |
Ontvangstdatum | filters on the platform, writable | Date the goods are expected to be received. | |
Received |
double |
Ontvangen Hoeveelheid | writable | Quantity of goods received. | |
Sales |
guid |
Verkooporder | filters on the platform, writable | Sales order that is linked to a back to back sales order in purchase order. | |
Sales |
guid |
Verkooporderregel | filters on the platform, writable | Sales order line of the sales order that is linked to a back to back sales order in purchase order. | |
Sales |
int32 |
Verkooporder Regelnummer | filters on the platform, writable | Number of the sales order line. | |
Sales |
int32 |
Verkoopordernummer | filters on the platform, writable | Number of the sales order. | |
Shop |
guid |
Productieorder | filters on the platform, writable | ||
Shop |
guid |
itgen_eol_shopordermaterialplan | filters on the platform, writable | ||
Shop |
int32 |
itgen_eol_shopordermaterialplanlinenumber | filters op het platform | ||
Shop |
int32 |
Productieordernummer | filters op het platform | ||
Shop |
guid |
itgen_eol_shoporderroutingstepplan | filters on the platform, writable | ||
Shop |
int32 |
itgen_eol_shoporderroutingstepplanlinenumber | filters op het platform | ||
Supplier |
varchar2 |
Leverancier Artikelcode | writable | Code the supplier uses for this item. | |
Supplier |
int16 |
itgen_eol_supplieritemcopyremarks | writable | Indicate if the notes content should be copied from SupplierItem's remarks.The default follows the CopyRemarks value from SupplierItem.Values: 0 = Do not copy remark, 1 = Copy remark. | |
Unit |
varchar2 |
Unit | filters on the platform, writable | Code of item unit. | |
Unit |
varchar2 |
Omschrijving Unit | filters on the platform, writable | Description of unit. | |
Unit |
double |
Prijs per Eenheid | writable | Item price per purchase unit. | |
VAT |
double |
BTW-bedrag | filters on the platform, writable | Amount of VAT charges calculated from total amount and vat percentage. | |
VAT |
varchar2 |
BTW-code | filters on the platform, writable | The VAT code used when the invoice was registered. | |
VAT |
varchar2 |
BTW Omschrijving | filters on the platform, writable | Description of the VAT code. | |
VAT |
double |
BTW-percentage | filters on the platform, writable | The VAT percentage of the VAT code.This is the percentage at the moment the invoice is created.It's also used by the default calculation of VAT amounts and VAT base amounts. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
Purchase |
Cost |
Costcenters.Code |
Key | |
Purchase |
Cost |
Costunits.Code |
Key | |
Purchase |
Creator |
Users. |
Key | |
Purchase |
Item |
Items.ID |
Key | |
Purchase |
Modifier |
Users. |
Key | |
Purchase |
Project |
Projects.ID |
Key | |
Purchase |
Purchase |
PurchaseOrders. |
Key | |
Purchase |
Sales |
SalesOrderLines.ID |
Key | |
Purchase |
Sales |
SalesOrders. |
Key | |
Purchase |
Unit |
Units.Code |
Key | |
Purchase |
VAT |
VATCodes.Code |
Key |
Geciteerd door
- PurchaseInvoiceLines
PurchaseOrderLine(Key) - GoodsReceiptLines
PurchaseOrderLineID(Key) - SalesOrderLines
PurchaseOrderLine(Key) - SalesOrderLinesBulk
PurchaseOrderLine(Key)
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: