invantive documentation
Invantive Support ForumsLog In / Sign Up

ShopOrderRoutingStepPlansIncremental: Exact Online Shop Order Routing Step Plans (Incremental)

read only per partition

  • Catalog: ExactOnlineREST
  • Schema: Incremental
  • Primary Keys: ID
  • Label: Shop Order Routing Step Plans (Incremental)

The data in this table is partitioned per value of the Division column.

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 154
Full scan rows per minute 50,300
Point query rows per minute 138

The result can be cached on the client.

Table Columns

The columns of the table ShopOrderRoutingStepPlansIncremental are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
Account guid Account
AttendedPercentage double Attended Percentage
Backflush int16 Backflush
CostPerItem double itgen_eol_costperitem
Created datetime Created
Creator guid Creator
Description varchar2 Description
Division int32 Division
EfficiencyPercentage double itgen_eol_efficiencypercentage
FactorType int32 Factor Type
ID guid ID
LineNumber int32 Line Number
Modified datetime Modified
Modifier guid Modifier
Notes varchar2 Notes
Operation guid Operation
OperationResource guid Operation Resource
PlannedEndDate datetime Planned End Date
PlannedRunHours double Planned Run Hours
PlannedSetupHours double Planned Setup Hours
PlannedStartDate datetime Planned Start Date
PlannedTotalHours double Planned Total Hours
PurchaseUnit varchar2 Purchase Unit
PurchaseUnitFactor double Purchase Unit Factor
PurchaseUnitPriceFC double Purchase Unit Price Foreign Currency
PurchaseUnitQuantity double itgen_eol_purchaseunitquantity
RoutingStepType int32 Routing Step Type
Run double Production Run
RunMethod int32 Run Method
Setup double Setup
SetupUnit varchar2 Setup Unit
ShopOrder guid Shop Order
Status int32 Status
SubcontractedLeadDays int32 itgen_eol_subcontractedleaddays
Timestamp int64 Timestamp filters on the platform
TotalCostDC double Total Cost Division Currency
Workcenter guid Workcentre

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: