invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

SalesOrdersExploded: Exact Online Sales Orders (Exploded Structure)

read only per partition REST

  • Catalogus: ExactOnlineREST
  • Schema: SalesOrder
  • Primaire sleutels: SolID
  • Label: Sales Orders (Exploded Structure)

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.

Kan alleen gegevens ophalen.

API-bron

  • Eindpunt: /api/v1/{division}/salesorder/SalesOrders?$expand=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 SalesOrdersExploded 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, ::ancestor.::ancestor.AmountDC
AmountFC double Bedrag Vreemde Valuta filters on the platform, writable, ::ancestor.::ancestor.AmountFC
ApprovalStatus int16 Goedkeuringsstatus filters on the platform, writable, ::ancestor.::ancestor.ApprovalStatus
ApprovalStatusDescription varchar2 Goedkeuringsstatus Omschrijving filters on the platform, writable, ::ancestor.::ancestor.ApprovalStatusDescription
Approved datetime Approved filters on the platform, writable, ::ancestor.::ancestor.Approved
Approver guid Approver filters on the platform, writable, ::ancestor.::ancestor.Approver
ApproverFullName varchar2 Goedkeurder Volledige naam filters on the platform, writable, ::ancestor.::ancestor.ApproverFullName
Created datetime Created filters on the platform, writable, ::ancestor.::ancestor.Created
Creator guid Creator filters on the platform, writable, ::ancestor.::ancestor.Creator
CreatorFullName varchar2 Aanmaker Volledige Naam filters on the platform, writable, ::ancestor.::ancestor.CreatorFullName
Currency varchar2 Currency filters on the platform, writable, ::ancestor.::ancestor.Currency
DeliverTo guid Leveren aan filters on the platform, writable, ::ancestor.::ancestor.DeliverTo
DeliverToContactPerson guid Bezorg aan Contactpersoon filters on the platform, writable, ::ancestor.::ancestor.DeliverToContactPerson
DeliverToContactPersonFullName varchar2 Leveringscontactpersoon Volledige naam filters on the platform, writable, ::ancestor.::ancestor.DeliverToContactPersonFullName
DeliverToName varchar2 Leveren aan Naam filters on the platform, writable, ::ancestor.::ancestor.DeliverToName
DeliveryAddress guid Afleveradres filters on the platform, writable, ::ancestor.::ancestor.DeliveryAddress
DeliveryDate datetime Leveringsdatum filters on the platform, writable, ::ancestor.::ancestor.DeliveryDate
DeliveryStatus int16 Afleverstatus filters on the platform, writable, ::ancestor.::ancestor.DeliveryStatus
DeliveryStatusDescription varchar2 Afleverstatusomschrijving writable, ::ancestor.::ancestor.DeliveryStatusDescription
Description varchar2 Description filters on the platform, writable, ::ancestor.::ancestor.Description
Division int32 Division filters on the platform, writable, ::ancestor.::ancestor.Division
Document guid Document filters on the platform, writable, ::ancestor.::ancestor.Document
DocumentNumber int32 Documentnummer filters on the platform, writable, ::ancestor.::ancestor.DocumentNumber
DocumentSubject varchar2 Document Onderwerp filters on the platform, writable, ::ancestor.::ancestor.DocumentSubject
InvoiceStatus int16 Factuurstatus filters on the platform, writable, ::ancestor.::ancestor.InvoiceStatus
InvoiceStatusDescription varchar2 Factuurstatusomschrijving writable, ::ancestor.::ancestor.InvoiceStatusDescription
InvoiceTo guid Factuur aan filters on the platform, writable, ::ancestor.::ancestor.InvoiceTo
InvoiceToContactPerson guid Factuur aan Contactpersoon filters on the platform, writable, ::ancestor.::ancestor.InvoiceToContactPerson
InvoiceToContactPersonFullName varchar2 Factuur voor Contactpersoon Volledige naam filters on the platform, writable, ::ancestor.::ancestor.InvoiceToContactPersonFullName
InvoiceToName varchar2 Factuur aan Naam filters on the platform, writable, ::ancestor.::ancestor.InvoiceToName
Modified datetime Modified filters on the platform, writable, ::ancestor.::ancestor.Modified
Modifier guid Modifier filters on the platform, writable, ::ancestor.::ancestor.Modifier
ModifierFullName varchar2 Gewijzigd Volledige Naam filters on the platform, writable, ::ancestor.::ancestor.ModifierFullName
OrderDate datetime Besteldatum filters on the platform, writable, ::ancestor.::ancestor.OrderDate
OrderID guid Order ID filters on the platform, writable, ::ancestor.::ancestor.OrderID
OrderNumber int32 Ordernummer filters on the platform, writable, ::ancestor.::ancestor.OrderNumber
OrderedBy guid Besteld door filters on the platform, writable, ::ancestor.::ancestor.OrderedBy
OrderedByContactPerson guid Besteld door Contactpersoon filters on the platform, writable, ::ancestor.::ancestor.OrderedByContactPerson
OrderedByContactPersonFullName varchar2 Besteld door Contactpersoon Volledige naam filters on the platform, writable, ::ancestor.::ancestor.OrderedByContactPersonFullName
OrderedByName varchar2 Besteld door Naam filters on the platform, writable, ::ancestor.::ancestor.OrderedByName
PaymentCondition varchar2 Betalingsvoorwaarde filters on the platform, writable, ::ancestor.::ancestor.PaymentCondition
PaymentConditionDescription varchar2 Betalingsconditie Omschrijving filters on the platform, writable, ::ancestor.::ancestor.PaymentConditionDescription
PaymentReference varchar2 Betalingskenmerk filters on the platform, writable, ::ancestor.::ancestor.PaymentReference
Remarks varchar2 Remarks filters on the platform, writable, ::ancestor.::ancestor.Remarks
Salesperson guid Verkoper filters on the platform, writable, ::ancestor.::ancestor.Salesperson
SalespersonFullName varchar2 Verkoper Volledige Naam filters on the platform, writable, ::ancestor.::ancestor.SalespersonFullName
ShippingMethod guid Verzendwijze filters on the platform, writable, ::ancestor.::ancestor.ShippingMethod
ShippingMethodDescription varchar2 Verzendmethode Omschrijving filters on the platform, writable, ::ancestor.::ancestor.ShippingMethodDescription
SolAmountDC double Verkooporderregel Bedrag Administratievaluta writable, AmountDC
SolAmountFC double Verkooporderregel Bedrag Vreemde Valuta writable, AmountFC
SolCostCenter varchar2 Verkooporderregel Kostenplaats writable, CostCenter
SolCostCenterDescription varchar2 itgen_eol_solcostcenterdescription writable, CostCenterDescription
SolCostPriceFC double Verkooporderregel Kostprijs Vreemde Valuta writable, CostPriceFC
SolCostUnit varchar2 Verkooporderregel Kostendrager writable, CostUnit
SolCostUnitDescription varchar2 itgen_eol_solcostunitdescription writable, CostUnitDescription
SolDeliveryDate datetime Verkooporderregel Leveringsdatum writable, DeliveryDate
SolDescription varchar2 Verkooporderregelomschrijving writable, Description
SolDiscount double Verkooporderregel Korting writable, Discount
SolDivision int32 Verkooporderregel Administratie writable, Division
SolID guid Verkooporderregel ID writable, ID
SolItem guid Verkooporderregel Artikel writable, Item
SolItemCode varchar2 Verkooporderregel Artikelcode writable, ItemCode
SolItemDescription varchar2 Verkooporderregel Artikelomschrijving writable, ItemDescription
SolItemVersion guid Verkooporderregel Artikelversie writable, ItemVersion
SolItemVersionDescription varchar2 itgen_eol_solitemversiondescription writable, ItemVersionDescription
SolLineNumber int32 Verkooporder Regelnummer writable, LineNumber
SolMargin double Verkooporderregel Marge writable, Margin
SolNetAmountFC double Verkooporderregel Nettobedrag Vreemde Valuta writable
SolNetPrice double Verkooporderregel Nettoprijs writable, NetPrice
SolNotes varchar2 Verkooporderregel Notities writable, Notes
SolOrderNumber int32 Verkoopordernummer writable, OrderNumber
SolPricelist guid Verkooporderregel Prijslijst writable, Pricelist
SolPricelistDescription varchar2 itgen_eol_solpricelistdescription writable, PricelistDescription
SolProject guid Verkooporderregel Project writable, Project
SolProjectDescription varchar2 itgen_eol_solprojectdescription writable, ProjectDescription
SolQuantity double Verkooporderregel Hoeveelheid writable, Quantity
SolQuantityDelivered double itgen_eol_solquantitydelivered writable, QuantityDelivered
SolQuantityInvoiced double Verkooporderregel Gefactureerde Hoeveelheid writable, QuantityInvoiced
SolShopOrder guid Verkooporderregel Productie-order writable, ShopOrder
SolTaxSchedule guid Verkooporderregel Belastingschema writable, TaxSchedule
SolTaxScheduleCode varchar2 Verkooporderregel Belastingschemacode writable, TaxScheduleCode
SolTaxScheduleDescription varchar2 itgen_eol_soltaxscheduledescription writable, TaxScheduleDescription
SolUnitCode varchar2 Verkooporderregel Eenheidscode writable, UnitCode
SolUnitDescription varchar2 Verkooporderregel Eenheidsomschrijving writable, UnitDescription
SolUnitPrice double Verkooporderregel Eenheidsprijs writable, UnitPrice
SolUseDropShipment int16 Verkooporderregel Gebruik Drop-shipment writable, UseDropShipment
SolVATAmountFC double Verkooporderregel BTW-bedrag Vreemde Valuta writable, VATAmount
SolVATCode varchar2 Verkooporderregel BTW-code writable, VATCode
SolVATCodeDescription varchar2 itgen_eol_solvatcodedescription writable, VATCodeDescription
SolVATPercentage double Verkooporderregel BTW-percentage writable, VATPercentage
Status int16 Status filters on the platform, writable, ::ancestor.::ancestor.Status
StatusDescription varchar2 Statusomschrijving writable, ::ancestor.::ancestor.StatusDescription
TaxSchedule guid Belastingplan filters on the platform, writable, ::ancestor.::ancestor.TaxSchedule
TaxScheduleCode varchar2 Belasting Planningscode filters on the platform, writable, ::ancestor.::ancestor.TaxScheduleCode
TaxScheduleDescription varchar2 Belasting Planningsomschrijving filters on the platform, writable, ::ancestor.::ancestor.TaxScheduleDescription
WarehouseCode varchar2 Magazijncode filters on the platform, writable, ::ancestor.::ancestor.WarehouseCode
WarehouseDescription varchar2 Magazijnomschrijving filters on the platform, writable, ::ancestor.::ancestor.WarehouseDescription
WarehouseID guid Magazijn ID filters on the platform, writable, ::ancestor.::ancestor.WarehouseID
YourRef varchar2(60) Uw Referentie filters on the platform, writable, ::ancestor.::ancestor.YourRef

Release Notes

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