The ProdRoute table contains production route information. The production route is a list of operations that have to be performed to produce an item in production. When you create a production order for a selected item, a copy of the route for that item is automatically placed in the ProdRoute table. If the item does not have a route, and no route number is assigned when the production order is created, the production route will still be created but it will be blank.
Configuration Key: ProdRouting
Methods
| Method | Description | |
|---|---|---|
.gif "Public method") |
activity | Retrieves the record ID of the activity that represents this record. |
|
activityRequirementSet | Gets the first activity requirement set that represents this record. |
|
aosValidateDelete | Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.) |
|
aosValidateInsert | Validates on the server that the specified record can be inserted. (Inherited from xRecord.) |
|
aosValidateRead | Validates on the server that the specified record can be read. (Inherited from xRecord.) |
|
aosValidateUpdate | Validates on the server that the specified record can be updated. (Inherited from xRecord.) |
|
buf2con | Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.) |
|
cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) |
|
canSubmitToWorkflow | Indicates whether submission to workflow is possible. (Inherited from xRecord.) |
|
caption | Gets and sets the caption property of a table. (Inherited from xRecord.) |
|
checkInvalidFieldAccess | Gets and sets invalid field access. (Inherited from xRecord.) |
|
checkOperationStatus | Checks whether the operation status can be modified. |
|
checkRecord | Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.) |
|
checkRestrictedDeleteActions | Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.) |
|
checkValid | |
|
clear | Removes all rows from the table buffer. (Inherited from xRecord.) |
|
company | Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.) |
|
companyInfo | Retrieves the CompanyInfo record associated with the current record. |
|
con2buf | Unpacks a container into the table buffers. (Inherited from xRecord.) |
|
concurrencyModel | Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.) |
|
context | Gets and sets the context property. (Inherited from xRecord.) |
|
copyDimension | Retrieves a dimension set that can be applied to the defaultDimension field on this table. |
|
data | Retrieves a row from the table. (Inherited from xRecord.) |
|
dataSource | Retrieves the data source of the table. (Inherited from xRecord.) |
|
defaultField | Populates default values in a field in the table. (Inherited from xRecord.) |
|
defaultRow | Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.) |
|
delete | Deletes the current record from the database. |
|
disableCache | Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.) |
|
displayWrkCtrId | Gets the ID of the resource that is used on the production route. |
|
displayWrkCtrLoadPct | Retrieves the resource load percentage. |
|
displayWrkCtrName | Gets the name of the resource that is used on the production route. |
|
displayWrkCtrNumOf | Retrieves the quantity of resources that is required for the operation. |
|
displayWrkCtrType | Retrieves the type of the resource to use on the production route. |
|
dispose | Releases resources that are used by the xRecord object. (Inherited from xRecord.) |
|
doClear | Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.) |
|
doDelete | Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.) |
|
doInsert | Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.) |
|
doUpdate | Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.) |
|
doValidateDelete | Performs the action to validate that a record can be deleted. (Inherited from xRecord.) |
|
equal | Determines whether the specified object is equal to the current one. (Inherited from xRecord.) |
|
fieldAccessRight | Returns the field access right. (Inherited from xRecord.) |
|
fieldBufferAccessRight | Returns the field access right for the current record. (Inherited from xRecord.) |
|
fieldState | Sets or returns the state of a field in the table buffer. (Inherited from xRecord.) |
|
getAllowRedefault | Returns the list of fields that are allowed to re-default. (Inherited from xRecord.) |
|
getDefaultingDependencies | Returns the container that holds defaulting dependencies. (Inherited from xRecord.) |
|
getExtension | Returns the table extension. (Inherited from xRecord.) |
|
getFieldValue | Gets the value of the specified field from a table buffer. (Inherited from xRecord.) |
|
getInstanceRelationType | Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.) |
|
getPhysicalTableName | Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.) |
|
getPresenceFieldData | Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.) |
|
getResource | Gets the resource that has been scheduled or assigned as the requirement for the current record. |
|
getSQLStatement | Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.) |
|
getTableInInstanceHierarchy | (Inherited from xRecord.) |
|
getTableType | Indicates the type of the table. (Inherited from xRecord.) |
|
getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) |
|
handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
|
hasRelatedTable | Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.) |
|
helpField | Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.) |
.gif "Private method") |
initDimension | |
|
initDimensionWrkCtrTable | |
|
initFromBaseOperation | Initializes the record buffer from a base operation relation. |
|
initFromPhantom | |
|
initFromProdTable | |
|
initFromReqRouteRouteOpr | |
|
initFromRoute | |
|
initFromRouteRouteOpr | |
|
initFromWrkCtrId | Initializes this record from the values in a WrkCtrTable buffer. |
|
initValue | Initializes field values in a new ProdRoute record. |
|
inputStatus | Sets or returns the current input status of the table buffer. (Inherited from xRecord.) |
|
insert | Inserts the current record into the database. |
|
interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) |
|
isFieldDataRetrieved | Checks whether the data of the given field has been retrieved. (Inherited from xRecord.) |
|
isFieldSet | Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.) |
|
isFirstOpr | Computes whether the current operation is a starting route operation. |
|
isFormDataSource | Indicates whether the data source is a form. (Inherited from xRecord.) |
|
isNewRecord | Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.) |
|
isOprStatusModified | Checks whether the operation status has been modified. |
|
isPartOfUOWSaveChanges | (Inherited from xRecord.) |
|
isProcessCategoryMandatory | Validates if the ProcessCategoryId field is mandatory for this record |
|
isProjMethodConsumed | |
|
isQtyCategoryMandatory | Validates if the QtyCategoryId field is mandatory for this record |
|
isSetupCategoryMandatory | Validates if the SetupCategoryId field is mandatory for this record |
|
isTempDb | Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.) |
|
isTmp | Indicates whether this is a temporary table. (Inherited from xRecord.) |
|
joinChild | Finds the join child of the current record. (Inherited from xRecord.) |
|
joinParent | Finds the join parent of the current record. (Inherited from xRecord.) |
|
linkPhysicalTableInstance | Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.) |
|
materialConsumption | Computes whether material is consumed in a specified job. |
|
merge | Merges the current table with the specified table. (Inherited from xRecord.) |
|
mergeDimension | Retrieves a dimension set that holds the merged combination of the current defaultDimensionfield on this table and the provided dimension set. |
|
modifiedField | Modifies the specified field to the original. (Inherited from xRecord.) |
|
modifiedFieldValue | Modifies a field on the current record. |
|
mustRouteJobsBeUpdated | |
|
new | Initializes a new instance of the Object class. (Inherited from Object.) |
|
nextOperation | |
|
notify | Releases the hold on an object that has called the wait method on this object. (Inherited from Object.) |
|
notifyAll | Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.) |
|
objectOnServer | Determines whether the object is on a server. (Inherited from Object.) |
|
operationName | |
|
orig | Retrieves the original values of the current record. (Inherited from xRecord.) |
|
overwriteSystemfields | Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.) |
|
owner | Returns the instance that owns the object. (Inherited from Object.) |
|
pdsCWCalcQty | Gets the catch weight estimated quantity. |
|
pdsCWQtyError | Determines the total reported error quantity from the operation. |
|
pdsCWQtyGood | Determines the total reported good quantity from the operation. |
|
pdsCWReportedQtyError | Gets the catch weight reported error quantity for the operation. |
|
pdsCWReportedQtyGood | Gets the catch weight reported good quantity for the operation. |
|
postCacheLoad | Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.) |
|
postLoad | Is executed after a record is read. (Inherited from xRecord.) |
|
preRemoting | Is executed before a cross-tier call is about to be executed for the table that would pack its state to the other tier. (Inherited from xRecord.) |
|
primary | |
|
prodRouteProj | |
|
prodTable | |
|
prodUnitId | |
|
prodUnitInputWarehouse | Retrieves the input warehouse for the current route operation. |
|
projCostControlUpdate | |
|
projTable | |
|
qtyError | |
|
qtyGood | |
|
qtyHours | |
|
qualityOrderStatusDisplay | Retrieves and returns the status of the associated quality orders. |
|
queryTimedOut | Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.) |
|
queryTimeout | Gets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.) |
|
readCommittedLock | (Inherited from xRecord.) |
|
readPast | Gets and sets the property that indicates whether to skip rows that are locked by other processes when a record is read. (Inherited from xRecord.) |
|
recordLevelSecurity | Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.) |
|
relatedTable | Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.) |
|
renamePrimaryKey | Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.) |
|
reportedHours | |
|
reportedQtyError | |
|
reportedQtyGood | |
|
reread | Rereads the record from the table. (Inherited from xRecord.) |
|
routeGroup | |
|
routeOpr | |
|
RowCount | Retrieves the number of rows in the table. (Inherited from xRecord.) |
|
scheduledResources | Gets the IDs of the resources that are used on the production route. |
|
selectForUpdate | Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.) |
|
selectLocked | Indicates whether to select locked records. (Inherited from xRecord.) |
|
selectRefRecord | Selects the record by referenced field ID. (Inherited from xRecord.) |
|
selectWithRepeatableRead | Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.) |
|
setConnection | Sets the user connection for this table. (Inherited from xRecord.) |
|
setCrossPartition | Sets or resets cross-partitioning for the table. (Inherited from xRecord.) |
|
setFieldValue | Sets the field value in the record buffer. (Inherited from xRecord.) |
|
setSQLTracing | Enables or disables SQL tracing mode. (Inherited from xRecord.) |
|
setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) |
|
setTmp | Sets the table so that it is not persisted to the database. (Inherited from xRecord.) |
|
setTmpData | Sets the contents of the temporary table to the specified data. (Inherited from xRecord.) |
|
setXDSContext | Sets new XDS context. (Inherited from xRecord.) |
|
skipAosValidation | Gets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.) |
|
skipDatabaseLog | Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.) |
|
skipDataMethods | Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.) |
|
skipDeleteActions | Gets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.) |
|
skipDeleteMethod | Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.) |
|
skipEvents | Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.) |
|
skipPostLoad | Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.) |
|
skipTTSCheck | Gets and sets the property that indicates whether to skip the check to determine whether the record is selected for update. (Inherited from xRecord.) |
|
statusImage | |
|
statusTxt | |
|
suppressWarnings | Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.) |
|
tableAccessRight | Returns the table access right. (Inherited from xRecord.) |
|
tableBufferAccessRight | Returns the table access right for the current record. (Inherited from xRecord.) |
|
takeOwnershipOfTempDBTable | (Inherited from xRecord.) |
|
toHours | |
|
toolTipField | Retrieves the HelpText value for the specified field. (Inherited from xRecord.) |
|
toolTipRecord | Retrieves the ToolTip value for the current record. (Inherited from xRecord.) |
|
toString | Returns a string that represents the current object. (Inherited from Object.) |
|
toTimeEstimated | Calculate the to time of the production route based on the capacity reservations. |
|
ttsabort | Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.) |
|
ttsbegin | Starts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.) |
|
ttscommit | Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.) |
|
type | |
|
update | Updates the current record in the database. |
|
updateCheckFlag | |
|
usageCount | Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.) |
|
useExistingTempDBTable | (Inherited from xRecord.) |
|
validateDelete | |
|
validateField | Determines whether the specified field is valid. (Inherited from xRecord.) |
|
validateFieldValue | |
|
validateProject | |
|
validateWrite | |
|
validTimeStateUpdateMode | Sets a valid time state update mode on the cursor. (Inherited from xRecord.) |
|
wait | Pauses a process. (Inherited from Object.) |
|
wasCached | Specifies the location from which the data was retrieved. (Inherited from xRecord.) |
|
write | Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.) |
|
xml | Retrieves an XML string that represents the current object. (Inherited from xRecord.) |
.gif "Static member") |
::accError | |
|
::checkIsRouteReportedFinished | |
|
::checkProjCategoryId | |
|
::exist | |
|
::existRecId | Indicates whether a record with the specified record ID exists in the database. |
|
::existSecondary | Checks whether a secondary operation exists. |
|
::find | |
|
::findByOprId | Reads the ProdRoute table to find the specified ProdRoute record. |
|
::findFirst | |
|
::findJobId | |
|
::findLast | |
|
::findPhantomBOMFirst | |
|
::findRecId | |
|
::highestOprNum | |
|
::lastOprNum | |
|
::lookupOprId | Performs lookup for the OprId values that match the given parameters for a given form control. |
|
::lookupOprNum | |
|
::lowestRemainStatus | |
|
::reportOprAsFinished | Reports a specific production operation as finished. |
|
::startUpOpr | Begins specific production operations. |
|
::updateOprStatusFromForm | Updates the operation status on all related records when a manual change of the operation status is performed on the ProdRoute form. |
|
::updateReNumberLevelNum | |
|
::updateReNumberOprNum | |
|
::viewCacheProdId |
Top
Fields
| Field | Type | Configuration key | Description |
|---|---|---|---|
| AccError | Extended Data Type: RouteAccErrorPct Type: Real |
ProdRouting | Accumulated scrap percentage for this operation |
| BackorderStatus | Enumeration: ProdBackStatus |
Prod | Remaining status of the line. |
| CalcProc | Extended Data Type: RouteOprTimeProcess Type: Real |
ProdRouting | Estimated process consumption in hours |
| CalcQty | Extended Data Type: RouteOprQtyToOpr Type: Real |
ProdRouting | Calculated quantity in for this operation |
| CalcSetUp | Extended Data Type: RouteOprTimeSetup Type: Real |
ProdRouting | Estimated setup time in number of hours |
| ConstantReleased | Extended Data Type: ProdConstantReleased Type: Enum |
Prod | Has constant consumption been released? |
| dataAreaId | Extended Data Type: DataAreaId Type: String |
None | |
| DefaultDimension | Extended Data Type: DimensionDefault Type: Int64 |
LedgerBasic | Default dimensions |
| ErrorPct | Extended Data Type: RouteErrorPct Type: Real |
ProdRouting | Scrap from this operation |
| ExecutedProcess | Extended Data Type: ProdExecutedPctProcess Type: Real |
ProdRouting | Portion of the amount in hundredths |
| ExecutedSetup | Extended Data Type: ProdExecutedPctSetup Type: Real |
ProdRouting | Portion of the amount in hundredths |
| Formula | Enumeration: RouteFormula |
None | Method used to calculate the consumption for the line |
| FormulaFactor1 | Extended Data Type: RouteFormulaFactor Type: Real |
None | Factor that may be used in formula. |
| FromDate | Extended Data Type: SchedFromDate Type: Date |
None | The date that the project is scheduled to begin |
| FromTime | Extended Data Type: SchedFromTime Type: Integer |
ProdShop | Scheduled start time. |
| JobIdProcess | Extended Data Type: JmgJobId Type: String |
JmgJob | Job that is attached to this registration |
| JobIdSetup | Extended Data Type: JmgJobId Type: String |
JmgJob | Job that is attached to this registration |
| JobPayType | Extended Data Type: JmgJobPayType Type: Enum |
JmgJob | Is payment based on an hourly rate or on a piecework rate? |
| Level | Extended Data Type: RouteLevel Type: Integer |
ProdRouting | Level where the current operation is situated. |
| LinkType | Enumeration: SchedJobLinkType |
ProdRouting | Attachment type to next job. |
| OprFinished | Extended Data Type: ProdFinishedOpr Type: Enum |
ProdRouting | Is operation finished? |
| OprId | Extended Data Type: RouteOprId Type: String |
ProdRouting | Identification of the operation |
| OprNum | Extended Data Type: OprNum Type: Integer |
ProdRouting | Number for determining sequence in routes |
| OprNumNext | Extended Data Type: OprNumNext Type: Integer |
ProdRouting | Next operation number in the route |
| OprPriority | Enumeration: RouteOprPriority |
ProdRouting | Is operation primary or secondary? |
| OprStartedUp | Enumeration: NoYes |
None | Is the operation started? |
| OverlapQty | Extended Data Type: RouteOprQtyOverlap Type: Real |
ProdRouting | Quantity to be produced before next operation may begin |
| Partition | Extended Data Type: Partition Type: Int64 |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| PhantomBOMFactor | Extended Data Type: Factor Type: Real |
None | Factor used for multiplying |
| ProcessCategoryId | Extended Data Type: RouteCostCategoryIdProcess Type: String |
ProdRouting | Cost category for run time |
| ProcessPerQty | Extended Data Type: RouteOprQtyProcessNumOf Type: Real |
ProdRouting | Quantity that can be produced in the run time. |
| ProcessTime | Extended Data Type: RouteOprTimeProcess Type: Real |
ProdRouting | Time for production of process quantity |
| ProdId | Extended Data Type: ProdId Type: String |
Prod | Identify the production order. |
| PropertyId | Extended Data Type: PropertyId Type: String |
ProdRouting | Necessary resource property when processing the operation. |
| QtyCategoryId | Extended Data Type: RouteCostCategoryIdQty Type: String |
ProdRouting | Cost category for quantity |
| QueueTimeAfter | Extended Data Type: RouteOprTimeQueueAfter Type: Real |
ProdRouting | Queue time after operation |
| QueueTimeBefore | Extended Data Type: RouteOprTimeQueueBefore Type: Real |
ProdRouting | Queue time before operation |
| RecId | Extended Data Type: RecId Type: Int64 |
None | |
| recVersion | Extended Data Type: RecVersion Type: Integer |
None | |
| RouteGroupId | Extended Data Type: RouteGroupId Type: String |
ProdRouting | Route group definition applicable to the operation |
| RouteOprRefRecId | Extended Data Type: RouteOprRefRecId Type: Int64 |
None | Record ID of referred operation |
| RouteType | Enumeration: RouteOprType |
ProdRouting | Is the operation assigned to an external resource? |
| SetUpCategoryId | Extended Data Type: RouteCostCategoryIdSetup Type: String |
ProdRouting | Cost category for setup time |
| SetupTime | Extended Data Type: RouteOprTimeSetup Type: Real |
ProdRouting | Setup time for the operation |
| ToDate | Extended Data Type: SchedToDate Type: Date |
None | The date that the project is scheduled to finish |
| ToHours | Extended Data Type: RouteHourFactor Type: Real |
LogisticsBasic | Conversion factor to hours. (Factor * Time) = Time in hours. |
| ToTime | Extended Data Type: SchedToTime Type: Integer |
ProdShop | Scheduled end time |
| TransferBatch | Extended Data Type: RouteOprQtyTransferBatch Type: Real |
ProdRouting | Quantity that can be moved between sequential resources. |
| TranspTime | Extended Data Type: RouteOprTimeTransport Type: Real |
ProdRouting | Transit time to next operation |
| WrkCtrIdCost | Extended Data Type: WrkCtrIdCost Type: String |
WrkCtr | The resource used for costing purposes. |
Top
Field Groups
| Field Group | Fields |
|---|---|
| AutoSummary | |
| AutoReport | |
| ConsumptionCalculation | |
| Balance | |
| CostCategories | |
| Estimation | |
| Finish | |
| DateScheduled | |
| Deleted | |
| Dimensions | |
| Other | |
| Identification | |
| Operation | |
| Piecework | |
| QualityManagement | |
| Route | |
| Overlap | |
| System | |
| Times | |
| WorkCenter |
Top
Relations
| Relation | Table | Lines |
|---|---|---|
| CostResource | WrkCtrTable | |
| dataAreaId | DataArea | |
| DefaultDimension | DimensionAttributeValueSet | |
| InventReq | ReqTrans | |
| Partition | Partitions | |
| ProdRoute | ProdRoute | |
| ProdRouteProj | ProdRouteProj | |
| ProdTable | ProdTable | |
| QuantityCostCategory | RouteCostCategory | |
| RouteGroup | RouteGroup | |
| RouteOpr | RouteOpr | |
| RouteOprTable | RouteOprTable | |
| RuntimeCostCategory | RouteCostCategory | |
| SetupCostCategory | RouteCostCategory | |
| WrkCtrProperty | WrkCtrProperty |
Top
Indexes
| Index | AllowDuplicates | Enabled | Fields |
|---|---|---|---|
| NumNextIdx | Yes | Yes | |
| NumOprNumIdx | No | Yes | |
| NumRemainIdx | Yes | Yes | |
| OperationIdx | No | Yes | |
| Processjobidx | Yes | Yes | |
| RecId | No | Yes | |
| SetupJobidx | Yes | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
ProdRoute Table