ReqTrans Table [AX 2012]
The ReqTrans table contains all net requirements used in master scheduling. The requirements can be issues or receipts and are specific to a single master or forecast plan.
Configuration Key: Req| Method | Description | |
|---|---|---|
![]() | actionAdvancePostpone | Retrieves the advance, postpone or cancel icon based on the action type. |
![]() | actionIncreaseDecrease | Retrieves the increase, decrease or cancel icon based on the action type. |
![]() | actionSum | Calculates the final requirement quantity of the current ReqTrans record if the action message is accepted. |
![]() | addCov | |
![]() | 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.) |
![]() | bomType | Constructs a BOMTypeBase derived object based on the bom type of the current record. |
![]() | buf2con | Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.) |
![]() | cacheKey | |
![]() | calcFuturesDaysFromDerived | Calculates the highest number of the futures days for the derived requirement transactions. |
![]() | calcFuturesDaysReceipt | Calculates the number of the futures days for the current requirement transaction. |
![]() | calcMaxFuturesDateFromDerived | Calculates the latest futures date of the derived requirement transactions. |
![]() | canBeFirmed | Determines if the requirement can be firmed. |
![]() | 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.) |
![]() | 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.) |
![]() | 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.) |
![]() | compareIntercompanyValues | Determine if the values of the fields essential for the intercompany demand are the same. |
![]() | 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.) |
![]() | createRoute | |
![]() | createTransferDemand | Creates a derived requirement transaction for the planned transfer order. |
![]() | cwActionSum | Calculates the final catch weight requirement quantity of the current ReqTrans record if the action message is accepted. |
![]() | 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 | |
![]() | deleteBOM | |
![]() | deleteCov | |
![]() | deleteDerivedReqTrans | Deletes derived ReqTrans records. |
![]() | deleteExplosionCoverage | |
![]() | deleteExplosionCoverageTrans | |
![]() | deleteReceiptReqTrans | |
![]() | deleteRoute | Deletes the route, jobs and reservations for the order associated with the requirement transaction. |
![]() | deleteUnusedPlannedOrder | Deletes the current ReqTrans record if this represents an unused planned order. |
![]() | derivedTransWithMaxFuturesDateTime | Calculates the latest futures date of the derived requirement transactions. |
![]() | disableCache | Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.) |
![]() | displayActionDate | |
![]() | displayActionSum | |
![]() | displayCWActionSum | |
![]() | displayFuturesDate | |
![]() | displayFuturesDays | |
![]() | displayFuturesMessage | |
![]() | displayReqDateDlv | |
![]() | displayReqPlanId | Gets the ID of the master plan. |
![]() | displayWrkCtrConsumption | Gets the value of the wrkCtrConsumption field from either the standard bill of materials or from the production bill of materials. |
![]() | 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.) |
![]() | doIntercompanyDemandUpdate | Does the database update of a planned intercompany demand transaction, after it was updated by ReqIntercompanyDemand.initReqTransFromIntercompanyReqPO(), making sure that fields like open status and direction are correctly set. |
![]() | 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.) |
![]() | findSimilarIntercompanyDemand | Finds a ReqTrans record which is relating to the same intercompany planned order. |
![]() | fromDate | |
![]() | fromTime | |
![]() | futuresDaysBaseDate | |
![]() | futuresPostpone | Retrieves the image icon for futures. |
![]() | ganttCalenderId | |
![]() | 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.) |
![]() | 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.) |
![]() | initDateTimeFromInvent | |
![]() | initFromBOM | Initializes the bill of materials line information from the master data bill of materials line record. |
![]() | initFromInventSumLogTTS | Initializes the current ReqTrans record from a InventSumLogTTS record. |
![]() | initFromInventTransOrigin | Initializes the current ReqTrans record from an InventTransOrigin record. |
![]() | initFromParentReqTrans | Initializes the current ReqTrans record from a parent ReqTrans record. |
![]() | initFromReqPo | |
![]() | initFromSetup | |
![]() | initializeReceiptTime | |
![]() | initSupplyDemandSubClassification | Initializes the sub classification setting based on the planned order. |
![]() | initValue | Initializes a field to the default value. (Inherited from xRecord.) |
![]() | inputStatus | Sets or returns the current input status of the table buffer. (Inherited from xRecord.) |
![]() | insert | Persists a record in the data base when super is called. |
![]() | insertFromReqPo | Initializes and inserts a ReqTrans record. |
![]() | insertUsingInsertList | |
![]() | interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) |
![]() | intercompanyParentReqPO | Gets the parent planned order record from another legal entity for an intercompany demand. |
![]() | inventDim | |
![]() | inventTable | Return related inventTable record. |
![]() | inventTransOrigin | Returns the related InventTransOrigin record if a relation exists. |
![]() | inventUnitId | |
![]() | isDelayed | Checks whether the current order is delayed. |
![]() | isDerivedDemand | |
![]() | isEventKanban | Determines if the transactions is representing an Event Kanban. |
![]() | 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.) |
![]() | isForecast | Determines if the current ReqTrans record is a forecast transaction. |
![]() | 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.) |
![]() | isPartOfUOWSaveChanges | (Inherited from xRecord.) |
![]() | isPlannedOrder | |
![]() | isPmfTransaction | Determines whether the current record is related to the process industries functionality. |
![]() | isReceipt | Determines if the current ReqTrans record is a receipt. |
![]() | isSelfSettled | Indicates whether the settled requirement transaction represents the same transaction as the current requirement transaction. |
![]() | isStaticReceipt | |
![]() | 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.) |
![]() | itemGroupId | |
![]() | itemName | |
![]() | joinChild | Finds the join child of the current record. (Inherited from xRecord.) |
![]() | joinParent | Finds the join parent of the current record. (Inherited from xRecord.) |
![]() | jumpRefRefId | Opens the related form for the current ReqTrans record. |
![]() | kanban | Gets the kanban that the transactions is representing. |
![]() | kanbanJob | Retrieves the related KanbanJob record of the current ReqTrans record. |
![]() | linkPhysicalTableInstance | Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.) |
![]() | mcrGetPriceAlertTyp | Method used to determine whether there is a Price break in comparison to the current price on the Planned orders and return an appropriate enum type to the display methos on form DS |
![]() | mcrValidateQtyBreak | Method used to determine whether there is a Price break in comparison to the current price on the Planned orders and return an appropriate enum type to the display methos on form DS |
![]() | merge | Merges the current table with the specified table. (Inherited from xRecord.) |
![]() | modifiedField | Modifies the specified field to the original. (Inherited from xRecord.) |
![]() | modifiedFieldValue | Modifies the specified field to the original value. (Inherited from xRecord.) |
![]() | mustTransIdBeUpdated | Determines whether the current ReqTrans record must be updated. |
![]() | new | Initializes a new instance of the Object class. (Inherited from Object.) |
![]() | 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.) |
![]() | openQty | |
![]() | 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.) |
![]() | pdsCWActionQtyAdd | |
![]() | pdsCWCovQty | |
![]() | pdsCWOriginalQty | |
![]() | pdsCWReqQty | Converts the current quantity to a catch weight quantity. |
![]() | pdsCWUnitId | The catch weight units, if applicable, of the current record. |
![]() | pdsNeedByDate | Determines the final date the product must be available to the customer. |
![]() | pdsSetShelfLifeFields | Assigns the appropriate expiration date and sellable days to this requirements transaction line. |
![]() | pmfCreateCoProducts | Creates co-product receipt records related to a planned order. |
![]() | pmfDeleteCoProducts | Deletes co-product requirement transactions for the current batch planned order record. |
![]() | pmfSetPlanningData | |
![]() | pmfUpdateCoProductDates | Updates the requirement and future date on related co-product outputs. |
![]() | pmfUpdateCoProductsQty | Updates the quantities on all co-product transactions for the curernt planned batch order transaction. |
![]() | 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.) |
![]() | qtyCovOnhand | Calculates the coverage quantity for the current ReqTrans record that is covered by on-hand. |
![]() | 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.) |
![]() | refBOM | |
![]() | 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.) |
![]() | reqDateOrder | |
![]() | reqDateSchedBackward | |
![]() | reqExplodeTypeDefault | |
![]() | reqPo | |
![]() | reqRefTypeImage | Returns icon based on the referenced orter type. |
![]() | reqSetup | |
![]() | reqSetupDim | |
![]() | reqTimeOrder | |
![]() | reqTransDirectlyDerived | |
![]() | reqTransSettled | |
![]() | reqTransTransferDemand | |
![]() | reread | Rereads the record from the table. (Inherited from xRecord.) |
![]() | resetFutures | Resets the futures data of this record. |
![]() | RowCount | Retrieves the number of rows in the table. (Inherited from xRecord.) |
![]() | selectCov | |
![]() | selectCovJoinTrans | |
![]() | selectCovJoinTransDerived | |
![]() | selectDerived | Selects derived ReqTrans records from the current ReqTrans record. |
![]() | 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.) |
![]() | selectParent | Selects parent ReqTrans records from the current ReqTrans record. |
![]() | 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.) |
![]() | setAction | |
![]() | setConnection | Sets the user connection for this table. (Inherited from xRecord.) |
![]() | setCrossPartition | Sets or resets cross-partitioning for the table. (Inherited from xRecord.) |
![]() | setDirection | |
![]() | setFields | |
![]() | setFieldValue | Sets the field value in the record buffer. (Inherited from xRecord.) |
![]() | setFuturesDateTimeIssue | Determines the futures date and time for the current issue requirement transaction. |
![]() | setFuturesDateTimeReceipt | Determines the futures date and time for the current requirement transaction. |
![]() | setOpenStatus | Sets this record's OpenStatus field, according to requirement quantity and covered quantity. |
![]() | setSQLTracing | Enables or disables SQL tracing mode. (Inherited from xRecord.) |
![]() | setSupplyDemandSubClassification | |
![]() | 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.) |
![]() | sortingDate | |
![]() | subCov | |
![]() | 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.) |
![]() | toDate | |
![]() | 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.) |
![]() | toTime | |
![]() | 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.) |
![]() | unitOfMeasure | Gets the unit of measure for the item of the transaction. |
![]() | update | |
![]() | updateBOMQty | Recalculates the requirement quantity for derived requirement transactions. |
![]() | updateReduceCopyCovQty | |
![]() | updateReduceCovQty | |
![]() | updateTransferDemandQty | |
![]() | updateTransferReqDate | Updates the requirement date of the transfer demand based on the dates of a planned order. |
![]() | 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 | Determines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.) |
![]() | validateField | Determines whether the specified field is valid. (Inherited from xRecord.) |
![]() | validateFieldValue | |
![]() | validateWrite | Determines whether the current record is valid and ready to be written. (Inherited from xRecord.) |
![]() | 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.) |
![]() ![]() | ::bulkInitFromInventTransOrigin | Initializes many ReqTrans records for a specific item ID with the settings from the related originator records. |
![]() ![]() | ::common2ReqTrans | |
![]() ![]() | ::derivedRefType | Returns the derived requirement type based on the specified ReqRefType enum. |
![]() ![]() | ::findCommon | Finds the corresponding ReqTrans record if possible from a record of any type. |
![]() ![]() | ::findFromPurchReqLineRecId | Find a ReqTrans record based on the RecId of a requisition line; |
![]() ![]() | ::findOprNum | Finds the operation number for a specific production bills of materials line. |
![]() ![]() | ::findPriceDiscTable | Finds a purchase trade agreement for a specific item. |
![]() ![]() | ::findRecId | |
![]() ![]() | ::findRecIdCrossCompany | Find a ReqTrans record across all company accounts. |
![]() ![]() | ::getInventDim | Calculates the final inventory dimensions for a bills of materials line. |
![]() ![]() | ::getUnitOfMeasure | Gets the unit of measure for the supplied item. |
![]() ![]() | ::hasSalesForecast | Determines whether an item has a sales forecast defined for the specified inventory dimensions. |
![]() ![]() | ::isTransfer | |
![]() ![]() | ::mcrHasSalesContinuity | Checks to see if there are ReqTras records of type continuity |
![]() ![]() | ::parentRefType | |
![]() ![]() | ::pmfSetActionCancel | Set action type to cancel for all reqTrans related to the planned production batch. |
![]() ![]() | ::refType2Short | |
![]() ![]() | ::refType2TransType | Finds corresponding InventTransType for given ReqRefType value. |
![]() ![]() | ::refTypeCanHaveBOM | Determines if the specified requirement type can have a bills of materials attached. |
![]() ![]() | ::refTypeCanHaveKanbanRule | Determines whether the specified requirement type can have a kanban rule attached. |
![]() ![]() | ::refTypeCanHaveRoute | Determines if the specified requirement type can have a route attached. |
![]() ![]() | ::refTypeCanReserveWorkCenter | Determines if a requirement type can reserve workcenter capacity. |
![]() ![]() | ::refTypeIsDerivedFromPlannedOrder | Determines whether the specified requirement type represents a derived requirement type from a planned order. |
![]() ![]() | ::refTypeIsPlannedOrder | Determines if the specified requirement type is a planned order. |
![]() ![]() | ::refTypeIsReceipt | Determines if a type as default represents a receipt. |
![]() ![]() | ::statusIssue2Priority | |
![]() ![]() | ::transType2RefType |
| Field | Type | Configuration key | Description |
|---|---|---|---|
| ActionDate |
Extended Data Type:
ActionDate Type: Date | ReqSchedAction | Date the transaction should be postponed or advanced to. |
| ActionDays |
Extended Data Type:
ActionDays Type: Integer | ReqSchedAction | Days by which the transaction should be advanced or postponed, according to the action message. |
| ActionMarked |
Enumeration:
NoYes | ReqSchedAction | Has action message been given for the transaction? |
| ActionQtyAdd |
Extended Data Type:
ActionQtyAdd Type: Real | ReqSchedAction | Quantity by which the transaction should be increased or reduced, according to the action message. |
| ActionType |
Enumeration:
ActionType | ReqSchedAction | Action that is proposed to be executed for the transaction. |
| BOMRefRecId |
Extended Data Type:
BOMRefRecId Type: Int64 | None | Record ID of referred BOM line |
| BOMType |
Enumeration:
BOMType | None | Type determining how the line is administered. |
| CovInventDimId |
Extended Data Type:
ReqCovInventDimId Type: String | LogisticsBasic | Identify the inventory dimensions that the item is coverage planned to. |
| CovQty |
Extended Data Type:
ReqQtyCoverage Type: Real | Req | Quantity coverage planned for the transaction |
| CustAccountId |
Extended Data Type:
CustAccount Type: String | None | Customer account number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| CustGroupId |
Extended Data Type:
CustGroupId Type: String | LedgerBasic | Group of customers. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| dataAreaId |
Extended Data Type:
DataAreaId Type: String | None | |
| Direction |
Enumeration:
InventDirection | None | Quantity direction, receipt or issue |
| FuturesDate |
Extended Data Type:
FuturesDate Type: Date | None | Date the requirement can be met, according to the futures message. |
| FuturesDays |
Extended Data Type:
FuturesDays Type: Integer | None | Number of days the transaction is delayed. |
| FuturesMarked |
Enumeration:
NoYes | None | Has futures message been activated for the transaction? |
| FuturesTime |
Extended Data Type:
SchedTime Type: Integer | None | Time when items have futures message |
| IntercompanyPlannedOrder |
Extended Data Type:
RefRecId Type: Int64 | Req | Issue due to planned purchase order from another company |
| InventTransOrigin |
Extended Data Type:
InventTransOriginId Type: Int64 | LogisticsBasic | A reference to a record from the inventory transactions originator table |
| IsDelayed |
Extended Data Type:
ReqTransIsDelayed Type: Enum | Req | Indicates whether the requirement transaction and associated order is delayed. |
| IsDerivedDirectly |
Extended Data Type:
ReqIsDerivedDirectly Type: Enum | Req | Is the planned order directly derived from the BOM line type? |
| IsForecastPurch |
Extended Data Type:
ReqIsForecastPurch Type: Enum | Forecast | Has the planned order been generated on the basis of the supply forecast |
| ItemBomId |
Extended Data Type:
BOMId Type: String | BOM | Bill of materials used when creating production |
| ItemId |
Extended Data Type:
ItemId Type: String | LogisticsBasic | Identify item. |
| ItemRouteId |
Extended Data Type:
RouteId Type: String | ProdRouting | Route used when creating production |
| Keep |
Enumeration:
NoYes | None | |
| LastPlanRecId |
Extended Data Type:
RefRecId Type: Int64 | None | Reference field in a different table |
| Level |
Extended Data Type:
BOMLevel Type: Integer | BOM | Level at which the line is included in the calculation. |
| MarkingRefInventTransOrigin |
Extended Data Type:
InventTransOriginId Type: Int64 | LogisticsBasic | A reference to a record from the inventory transactions originator table |
| MCRPriceTimeFence |
Extended Data Type:
Counter Type: Integer | None | Item has been cancelled and will no longer be sold once inventory runs out (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| OpenStatus |
Enumeration:
ReqOpenStatus | Req | Coverage status of quantity |
| OprNum |
Extended Data Type:
OprNum Type: Integer | ProdRouting | Reference to operation where item is consumed. |
| OriginalQuantity |
Extended Data Type:
ReqOriginalQuantity Type: Real | Req | Original requirement quantity |
| 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)) |
| PdsExpiryDate |
Extended Data Type:
PdsVendExpiryDate Type: Date | PdsShelf | Vendor's batch expiration date. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| PdsSellableDays |
Extended Data Type:
PdsSellableDays Type: Integer | PdsShelf | Number of days between customer receipt and batch expiration for shelf life products. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| PlanVersion |
Extended Data Type:
RefRecId Type: Int64 | None | Reference field in a different table |
| PmfActionQtyAdd |
Extended Data Type:
ActionQtyAdd Type: Real | PMF | Quantity by which the transaction should be increased or reduced, according to the action message. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| PmfCoByRefRecId |
Extended Data Type:
PmfCoByRefRecId Type: Int64 | PMF | Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| PmfPlanGroupId |
Extended Data Type:
PmfPlanGroupId Type: String | PMF | Planning group ID. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| PmfPlanGroupPrimaryIssue |
Extended Data Type:
PmfPlanGroupPrimaryIssue Type: Enum | PMF | Indicates that the record is a primary issue for a planning group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| PmfPlanGroupPriority |
Extended Data Type:
PmfPlanGroupPriority Type: Integer | PMF | Planning priority (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| PmfPlanningItemId |
Extended Data Type:
PmfPlanningItemId Type: String | PMF | Default planning formula. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| PmfPlanPriorityCurrent |
Extended Data Type:
PmfPlanPriorityCurrent Type: Integer | PMF | Current master planning priority. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS), Microsoft Dynamics AX 2012 (FPK)) |
| Priority |
Extended Data Type:
Integer Type: Integer | None | Priority of the transaction: the lowest number has the highest priority |
| Qty |
Extended Data Type:
ReqQty Type: Real | Req | Requirement quantity attached to the transaction |
| RecId |
Extended Data Type:
RecId Type: Int64 | None | |
| recVersion |
Extended Data Type:
RecVersion Type: Integer | None | |
| RefId |
Extended Data Type:
InventTransRefId Type: String | None | The ID of the record that is the origin for the requirement transaction |
| RefType |
Enumeration:
ReqRefType | Req | The name of the record type that is the origin for the requirement transaction |
| ReqDate |
Extended Data Type:
ReqDate Type: Date | Req | Requirement date attached to the transaction |
| ReqDateDlvOrig |
Extended Data Type:
ReqDateDlvOrig Type: Date | Req | Delivery date originally desired (requirement date) |
| ReqProcessId |
Extended Data Type:
ReqProcessId Type: String | Req | Identification of the scheduling process. |
| ReqTime |
Extended Data Type:
ReqTime Type: Integer | Req | Time when the item is required |
| RequisitionLine |
Extended Data Type:
RefRecId Type: Int64 | None | Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| SupplyDemandSubClassification |
Enumeration:
SupplyDemandSubClassification | None |
| Field Group | Fields |
|---|---|
| BOM | |
| Route | |
| NetRequirements | |
| Customer | |
| FuturesMessage | |
| MCRPriceAlerts | |
| Other | |
| PdsShelfLife | |
| AutoReport | |
| Identification | |
| PdsCatchWeight | |
| PMFPlan | |
| ActionMessage | |
| OrderGroup |
| Relation | Table | Lines |
|---|---|---|
| BOM | BOM | |
| BOMLine | ReqPO | |
| BOMTable | BOMTable | |
| CustGroup | CustGroup | |
| CustTable | CustTable | |
| dataAreaId | DataArea | |
| InventDim | InventDim | |
| InventOnhand | InventSum | |
| InventTransOrigin | InventTransOrigin | |
| Itemtable | InventTable | |
| MarkingRefInventTransOrigin | InventTransOrigin | |
| Partition | Partitions | |
| PmfFormulaCoBy | PmfFormulaCoBy | |
| PmfFormulaLine | ReqPO | |
| PmfPlanGroup | PmfPlanGroup | |
| PmfPlanningItem | InventTable | |
| PmfProdCoBy | PmfProdCoBy | |
| Production | ProdTable | |
| ProductionLine | ProdTable | |
| Purch | PurchTable | |
| ReqPlanVersion | ReqPlanVersion | |
| ReqPlanVersionLastPlan | ReqPlanVersion | |
| ReqPo | ReqPO | |
| ReqPOPlannedIntercompanyDemand | ReqPO | |
| ReqTransferDemand | ReqTrans | |
| RequisitionLine | PurchReqLine | |
| RouteTable | RouteTable | |
| SalesOrder | SalesTable |
Community Additions
ADD
Show:
