invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

ShopOrderRoutingStepPlansAvailableToWork: Exact Online Shop Order Routing Step Plans Available to Work

read only per partition REST

  • Catalogus: ExactOnlineREST
  • Schema: Manufacturing
  • Primaire sleutels: RoutingStep
  • Label: Shop Order Routing Step Plans Available to Work

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

Kan alleen gegevens ophalen.

API-bron

  • Eindpunt: /api/v1/{division}/read/manufacturing/ShopOrderRoutingStepPlansAvailableToWork
  • Metagegevens: /api/v1/{division}/read/manufacturing/$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.

Parameters

Name Datatype Required Default Documentation
division int32 ID of the division to retrieve data for.
employee guid
employeeWorkCenters int32
endDate datetime
isReleased char
operations varchar2
startDate datetime
workcenters varchar2

Tabelkolommen

De kolommen van de tabel ShopOrderRoutingStepPlansAvailableToWork 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
CustomerCode varchar2(18) Klantcode filters on the platform, writable
CustomerCount int32 Aantal Klanten filters on the platform, writable
CustomerName varchar2 Naam Klant filters on the platform, writable
DataType int16 itgen_eol_datatype filters on the platform, writable
DateAscendingOrder int32 itgen_eol_dateascendingorder filters on the platform, writable
DateDescendingOrder int32 itgen_eol_datedescendingorder filters on the platform, writable
Division int32 Divisie ID Unique number of the Exact Online division.
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.
ExtraDescription varchar2 Extra Omschrijving filters on the platform, writable
IsFractionAllowedItem char Is Fraction Toegestaan op Artikel filters on the platform, writable
IsReleased char Is Vrijgegeven filters on the platform, writable
IsRunOperationFinished char itgen_eol_isrunoperationfinished filters on the platform, writable
IsSetupOperationFinished char itgen_eol_issetupoperationfinished filters on the platform, writable
Item guid Item filters on the platform, writable
ItemCode varchar2 Artikelcode filters on the platform, writable
ItemCodeAscendingOrder int32 itgen_eol_itemcodeascendingorder filters on the platform, writable
ItemCodeDescendingOrder int32 itgen_eol_itemcodedescendingorder filters on the platform, writable
ItemDescription varchar2 Artikelomschrijving filters on the platform, writable
ItemVersion guid Artikelversie filters on the platform, writable
ItemVersionNotes varchar2 Artikelversie Opmerkingen filters on the platform, writable
LineNumber int32 Regelnummer filters on the platform, writable
Mode int32 Mode filters on the platform, writable
Notes varchar2 Notes filters on the platform, writable
Operation guid Operation filters on the platform, writable
OperationCode varchar2 Bewerkingscode filters on the platform, writable
PictureThumbnailPath varchar2 itgen_eol_picturethumbnailpath filters on the platform, writable
PlannedDate datetime Geplande Datum filters on the platform, writable
PlannedQuantity double Geplande Hoeveelheid filters on the platform, writable
PlannedSetupHours double Geplande Insteluren filters on the platform, writable
Priority int32 Priority filters on the platform, writable
PriorityDescendingOrder int32 itgen_eol_prioritydescendingorder filters on the platform, writable
Project guid Project filters on the platform, writable
ProjectCode varchar2 Projectcode filters on the platform, writable
ProjectDescription varchar2 Projectomschrijving filters on the platform, writable
QuantityCompleted double Hoeveelheid Voltooid filters on the platform, writable
RoutingStep guid Routeringsstap filters on the platform, writable
RoutingStepDescription varchar2 itgen_eol_routingstepdescription filters on the platform, writable
RoutingStepRealizationNotes varchar2 itgen_eol_routingsteprealizationnotes filters on the platform, writable
RoutingStepStatus int32 Routeringsstapstatus filters on the platform, writable
RoutingStepStatusDescription varchar2 itgen_eol_routingstepstatusdescription filters on the platform, writable
RoutingStepType int32 Routing Stapsoort filters on the platform, writable
RunStartTime datetime Run Starttijd filters on the platform, writable
RunStatus int32 Runstatus filters on the platform, writable
RunTimedTimeTransaction guid itgen_eol_runtimedtimetransaction filters on the platform, writable
SalesOrderCount int32 Aantal Verkooporders filters on the platform, writable
SalesOrderLineNumber int32 Verkooporder Regelnummer filters on the platform, writable
SalesOrderNumber int32 Verkoopordernummer filters on the platform, writable
SetupPercentComplete double itgen_eol_setuppercentcomplete filters on the platform, writable
SetupStartTime datetime Starttijd Instellen filters on the platform, writable
SetupStatus int32 Instelstatus filters on the platform, writable
SetupTimedTimeTransaction guid itgen_eol_setuptimedtimetransaction filters on the platform, writable
ShopOrder guid Productieorder filters on the platform, writable
ShopOrderDescription varchar2 itgen_eol_shoporderdescription filters on the platform, writable
ShopOrderNumber int32 Productieordernummer filters on the platform, writable
ShopOrderNumberAscendingOrder int32 itgen_eol_shopordernumberascendingorder filters on the platform, writable
ShopOrderNumberDescendingOrder int32 itgen_eol_shopordernumberdescendingorder filters on the platform, writable
ShopOrderStatus int32 Productieorderstatus filters on the platform, writable
Unit varchar2 Unit filters on the platform, writable
Warehouse guid Warehouse filters on the platform, writable
Workcenter guid Workcentre filters on the platform, writable
WorkcenterCode varchar2 Workcentercode filters on the platform, writable

Release Notes

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