invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

PurchaseOrders: Exact Online Purchase Orders

insert update delete per partition webhook REST

  • Catalogus: ExactOnlineREST
  • Schema: PurchaseOrder
  • Primaire sleutels: PurchaseOrderID
  • Label: Purchase Orders

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 doorgegeven via het webhook-onderwerp PurchaseOrders.

API-bron

  • Eindpunt: /api/v1/{division}/purchaseorder/PurchaseOrders
  • 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 PurchaseOrders 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
AmountDC double Bedrag Administratie Munteenheid filters on the platform, writable Total amount in the default currency of the company.
AmountDiscount double Kortingsbedrag filters on the platform, writable
AmountDiscountExclVat double Kortingsbedrag exclusief BTW filters op het platform
AmountFC double Bedrag Vreemde Valuta filters on the platform, writable Total amount in the currency of the transaction.
AmountFCExclVat double Bedrag Vreemde Valuta exclusief BTW filters op het platform
ApprovalStatus int16 Goedkeuringsstatus filters op het platform
ApprovalStatusDescription varchar2 Goedkeuringsstatus Omschrijving filters op het platform
Approved datetime Approved filters op het platform
Approver guid Approver filters op het platform
ApproverFullName varchar2 Goedkeurder Volledige naam filters op het platform
Created datetime Created filters on the platform, writable Creation date.
CreatedUtc datetime Aangemaakt (UTC) writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Aanmaker Volledige Naam filters on the platform, writable Name of creator.
Currency varchar2(30) Currency filters on the platform, writable Currency code.
DeliveryAccount guid Levering Account filters on the platform, writable Reference to account for delivery.
DeliveryAccountCode varchar2(18) Afleverrelatie Code filters on the platform, writable Delivery account code.
DeliveryAccountName varchar2(50) Afleverrelatie Naam filters on the platform, writable Name of account.
DeliveryAddress guid Afleveradres filters on the platform, writable Reference to shipping address.
DeliveryContact guid Aflevercontactpersoon filters on the platform, writable Reference to contact for delivery.
DeliveryContactPersonFullName varchar2(240) Aflevercontactpersoon Volledige naam filters on the platform, writable Name of the contact person of the customer who will receive delivered goods.
Description varchar2 Description filters on the platform, writable Description of the purchase order.
Discount double Discount filters on the platform, writable
Division int32 Division Division code.
DivisionCompanyCoCNumber varchar2(60) Divisie Kamer van Koophandel Nummer writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Divisie IBAN Nummer writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Divisie Bedrijfsnaam writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Divisie RSIN Nummer writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Divisie BTW Nummer writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Divisie Loonbelastingnummer writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Divisie Label writable Label of the Exact Online division.
DivisionName varchar2(50) Administratie Naam writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Naam Abonnementhouder writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Abonnementhoudernummer writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Divisie Korte Naam writable Short name of the Exact Online division.
Document guid Document filters on the platform, writable Document that is manually linked to the purchase order.
DocumentSubject varchar2(256) Document Onderwerp filters on the platform, writable Subject of the document.
DropShipment char Drop Shipment filters on the platform, writable Shows if it is a drop shipment purchase order.
ExchangeRate double Wisselkoers filters on the platform, writable Allows you to set the currency for the invoice.You can only do this if you have checked the Variable: Currency and Variable: Exchange rate fields in the sales journal settings.Once a line has been created in the invoice, the currency can no longer be changed.
IncotermAddress varchar2 Incoterm-adres filters on the platform, writable
IncotermCode varchar2 Incoterm-code filters on the platform, writable
IncotermVersion int16 Incoterm-versie filters on the platform, writable
InvoiceStatus int32 Factuurstatus filters on the platform, writable Invoice status of purchase order: 10-Open, 20-Partial, 30-Complete, 40-Canceled.
Modified datetime Modified filters on the platform, writable Last modified date.
ModifiedUtc datetime Gewijzigd (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) Gewijzigd Volledige Naam filters on the platform, writable Name of modifier.
OrderDate datetime Besteldatum filters on the platform, writable Order date.
OrderNumber int32 Ordernummer filters on the platform, writable Human readable id of the purchase order.
OrderStatus int32 Orderstatus filters on the platform, writable Purchase order status: 10-Open, 20-Partial, 30-Complete, 40-Canceled.
PaymentCondition varchar2(2) Betalingsvoorwaarde filters on the platform, writable The payment condition code used for due date and discount calculation.
PaymentConditionDescription varchar2(60) Betalingsconditie Omschrijving filters on the platform, writable Description of payment condition.
PurchaseAgent guid Inkoopagent filters on the platform, writable Purchase agent.
PurchaseAgentFullName varchar2(240) Inkoopagent Volledige Naam filters on the platform, writable Name of purchase agent.
PurchaseOrderID guid Inkoopopdracht ID filters on the platform, writable Primary key.
PurchaseOrderLineCount int32 itgen_eol_purchaseorderlinecount filters op het platform
ReceiptDate datetime Ontvangstdatum filters on the platform, writable This field shows the date the goods are expected to be received.
ReceiptStatus int32 Ontvangststatus filters on the platform, writable Receipt status of purchase order: 10-Open, 20-Partial, 30-Complete, 40-Canceled.
Remarks varchar2 Remarks filters on the platform, writable Include any relevant remarks regarding the purchase order.
SalesOrder guid Verkooporder filters on the platform, writable Reference to sales order when purchase order generated via back to back sales order.
SalesOrderNumber int32 Verkoopordernummer filters on the platform, writable Number of the sales order.
SelectionCode guid Selectiecode filters op het platform ID of selection code.
SelectionCodeCode varchar2 Selectiecode filters op het platform Code of selection code.
SelectionCodeDescription varchar2 itgen_eol_selectioncodedescription filters op het platform Description of selection code.
ShippingMethod guid Verzendwijze filters on the platform, writable ShippingMethod.
ShippingMethodCode varchar2 Verzendmethodecode filters op het platform
ShippingMethodDescription varchar2 Verzendmethode Omschrijving filters on the platform, writable Description of ShippingMethod.
Source int16 Source filters on the platform, writable This shows how the purchase order was created: 1-Manual entry, 2-Import, 3-Other, 4-Purchase order, 5-Sales order, 6-Supplier's items, 7-Subcontract, 8-Purchase order advice, 9-Shop order, 10-MRP calculation.
Supplier guid Supplier filters on the platform, writable Reference to supplier account.
SupplierCode varchar2(18) Leverancierscode filters on the platform, writable Code of supplier.
SupplierContact guid Contactpersoon Leverancier filters on the platform, writable Contact of supplier.
SupplierContactPersonFullName varchar2(240) Contactpersoon Leverancier Volledige naam filters on the platform, writable Contact person full name of supplier.
SupplierName varchar2(50) Leveranciersnaam filters on the platform, writable Name of supplier.
VATAmount double BTW-bedrag filters on the platform, writable Total VAT amount in the currency of the transaction.
Warehouse guid Warehouse filters on the platform, writable Warehouse.
WarehouseCode varchar2 Magazijncode filters on the platform, writable Code of Warehouse.
WarehouseDescription varchar2 Magazijnomschrijving filters on the platform, writable Description of Warehouse.
YourRef varchar2(60) Uw Referentie filters on the platform, writable Shows the reference number associated with the purchase order.Enter a description and reference to make the purchase order easier to identify.

Toetsen

Key Column Verwijst naar Kind Description
PurchaseOrders_Creator_Users_fk Creator Users.UserID Key
PurchaseOrders_Currency_Currencies_fk Currency Currencies.Code Key
PurchaseOrders_DeliveryAccount_Accounts_fk DeliveryAccount Accounts.ID Key
PurchaseOrders_DeliveryAddress_Addresses_fk DeliveryAddress Addresses.ID Key
PurchaseOrders_DeliveryContact_Contacts_fk DeliveryContact Contacts.ID Key
PurchaseOrders_Document_Documents_fk Document Documents.ID Key
PurchaseOrders_Modifier_Users_fk Modifier Users.UserID Key
PurchaseOrders_PurchaseAgent_Users_fk PurchaseAgent Users.UserID Key
PurchaseOrders_SalesOrder_SalesOrders_fk SalesOrder SalesOrders.OrderID Key
PurchaseOrders_SelectionCode_SelectionCodes_fk SelectionCode SelectionCodes.ID Key
PurchaseOrders_ShippingMethod_ShippingMethods_fk ShippingMethod ShippingMethods.ID Key
PurchaseOrders_SupplierContact_Contacts_fk SupplierContact Contacts.ID Key
PurchaseOrders_Supplier_Accounts_fk Supplier Accounts.ID Key
PurchaseOrders_Warehouse_Warehouses_fk Warehouse Warehouses.ID Key

Geciteerd door

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: