ProdTable Table

Article
04/11/2014

The ProdTable table contains the header information about all of the production orders, which can be connected to a planned production order, a sales order or a project.

Configuration Key: Prod

Methods

	Method	Description
	allowUpdateWithQualityOrder	Determines whether the update of the production order is enabled by related quality order.
	amountUnderconsumed
	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.)
	autoUpdate
	bomVersion	Gets a production/batch order in the original BOM/Formula version.
	buf2con	Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
	calcDelay	Calculates the scheduling delay.
	calculatingWIP_RU
	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.)
	checkBOMId	Checks the bill of materials ID.
	checkEqualityReleaseQty_RU
	checkInvalidFieldAccess	Gets and sets invalid field access. (Inherited from xRecord.)
	checkMaxPhysicalDataForEndJob_RU
	checkNotMissingProdItemPrice_RU
	checkProdType	Indicates whether the production order type is valid.
	checkRecord	Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
	checkRefProdBOM
	checkRefProdJournalProd
	checkRefSalesLine
	checkReleaseProportionallyFixedPrice_RU
	checkReqActivity
	checkRestrictedDeleteActions	Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
	checkRouteId	Checks the route ID.
	checkValid
	checkWIPCalcMethod_RU
	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.
	cwReportedFinishedError	Gets the error quantity that was reported as finished.
	cwRouteReportedError	Gets the catch-weight error quantity that is reported.
	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
	deleteProdTableProj
	disableCache	Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
	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.)
	firstWIPCalculationDate_RU
	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.)
	hasProdBOMReservation
	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.)
	historicalCostQtyError
	historicalCostQtyGood
	initBOMVersion
	initFromBOMVersion	Initializes the record based on a BOM version.
	initFromCaller
	initFromInventTable	Initializes the current ProdTable buffer with default values from an item.
	initFromItemId	Initializes the current ProdTable buffer from ItemId.
	initFromPmfProdCoBy
	initFromProdBOM
	initFromProjActivity
	initFromProjTable
	initFromReqPo
	initFromReworkProdTable
	initFromSalesLine
	initFromSplitProdTable
	initProjPostingType
	initReworkOrderFields	Initializes the fields for a reword order.
	initRouteVersion
	initValue	Initializes field values in a new ProdTable record.
	inputStatus	Sets or returns the current input status of the table buffer. (Inherited from xRecord.)
	insert
	insertFromForm
	insertSplitProduction
	interactiveContext	Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
	inventDim
	inventItemPrice	Gets the active InventItemPrice record that is associated with the record.
	inventMovementProj
	inventTable
	inventUnitId	Gets the default inventory unit of the related product.
	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.)
	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.)
	isProjMethodConsumed
	isProjMethodFinished
	isProjMethodLinkedToOrder
	isReceiptQtyEqual_RU
	isReqExploded
	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.)
	itemName
	itemReqInventRefTransId
	joinChild	Finds the join child of the current record. (Inherited from xRecord.)
	joinParent	Finds the join parent of the current record. (Inherited from xRecord.)
	lastWIPCalculationDate_RU
	linkInventDim2Dimension	Applies default ProdTable.dimension values that are based on the InventDim record buffer values.
	linkPhysicalTableInstance	Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
	mandatoryRegister
	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
	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.)
	orig	Retrieves the original values of the current record. (Inherited from xRecord.)
	overDelivery
	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.)
	PdsCatchWeightEnabled	Gets whether the catch-weight feature is enabled.
	pdsCWHistoricalCostQtyError
	pdsCWHistoricalCostQtyGood
	pdsCWRegisteredQty
	pdsCWRemainInventFinancial
	pdsCWReportedFinishedErr
	pdsCWReportedFinishedGood
	pdsCWUnitId	Gets the catch weight unit for the item.
	pmfRemainCostAlloc
	pmfTotalCostAlloc
	pmfUpdateTCA
	pmfValidateTCA	Validates the PmfProdCoBy records for TCA requirements.
	pmfYieldPercentage	Gets the yield percentage.
	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.)
	prodCalcTrans
	prodParametersDim	Finds a ProdParametersDim record based on the inventDimId of this record.
	prodStatusParameters	Finds ProdStatusParameters records.
	prodTableProj
	prodTableRef
	projCopyActivityToLines	Sets the project activity on the production BOM, production route, route card journal and picking list journal.
	projCostControlUpdate	Updates the committed cost records of item requirements that references the current production order when using the project posting Consumed/Linked to order.
	projIsUnposted	Indicates whether the project posting can be reverted.
	projQueryValueInventTransId
	projTable
	psAeditActivityPurpose
	qtyError
	qtyMarked
	qtyUnderconsumed
	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.)
	reestimate	Invokes re-estimation for the production order.
	referenceInfoWhatCanBeMarked
	referenceName
	referenceProdSearch
	registeredQty
	relatedTable	Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.)
	releasedError_RU
	remainInventFinancial
	renamePrimaryKey	Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.)
	reportedFinishedError
	reportedFinishedGood
	reqTrans	Finds the corresponding record in the ReqTrans table for the current record in the ProdTable table.
	reread	Rereads the record from the table. (Inherited from xRecord.)
	reschedule	Reschedules the production order with the previous used parameters.
	routeReportedError
	routeReportedGood
	RowCount	Retrieves the number of rows in the table. (Inherited from xRecord.)
	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.)
	setGanttColor
	setInventDimId	Applies the InventDimId parameter to the ProdTable.inventDimId field and applies default values that are based on the new inventory dimensions.
	setInventDimIdFromInventDim	Finds or creates an InventDimId value for the InventDim parameter and applies the found InventDimId to the ProdTable.inventDimId field.
	setInventStorageDim
	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.)
	status
	statusClient
	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.)
	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.)
	transDate
	transSchedTime
	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
	typeClient
	underconsumed
	update
	updateCollectRefProdId
	updateLinesPrice_RU	Initializes price and calculates line amount of the production BOM.
	updateRawMaterialDates	Saves the dates on the raw material related to the current production order.
	updateRoute
	usageCount	Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.)
	useExistingTempDBTable	(Inherited from xRecord.)
	useReleaseFromProduction_RU
	validateDelete
	validateField	Determines whether the specified field is valid. (Inherited from xRecord.)
	validateFieldValue
	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.)
	wrkCtrParametersDim	Finds a WrkCtrParametersDim record.
	xml	Retrieves an XML string that represents the current object. (Inherited from xRecord.)
	::argsProdId
	::checkExist	Indicates whether the specified record exists in the ProdTable table and displays a message if the record does not exist.
	::checkMultiSiteBOMRouteConsistency	Checks whether the specified site is used consistently for a production.
	::exist
	::find
	::findTransId
	::isAccessibleToSetProjPostingType
	::lookupBatchOrders	Creates a look up for selecting batch orders.
	::lookupProdId
	::lookUpProdNumJournal
	::lookupStdOnlyProd
	::name
	::numberSeqProdId
	::pmfLookupNonConsBatchOrders	Creates a look up for selecting non-consolidated batch orders.
	::pmfNumberSeqBatchId
	::pmfNumberSeqConsOrdId	Gets a NumberSeq object for the Consolidate Orders.
	::pmfUpdateConsOrder	Updates a production batch order by using the specified consolidated order number.
	::txtNotExist	Gets the message to use when a specific record in the ProdTable table does not exist.
	::validateBOMId	Validates a bill of materials ID.
	::validateRouteId	Validates a route ID.
	::wmsRegisterProdLookup

Top

Fields

Field	Type	Configuration key	Description
ActivityNumber	Extended Data Type: smmActivityNumber Type: String	None	The activity number
BackorderStatus	Enumeration: ProdBackStatus	Prod	Backorder sales status for the production.
BOMDate	Extended Data Type: TransDate Type: Date	None	BOM date used
BOMId	Extended Data Type: BOMId Type: String	BOM	Bill of materials used when creating production
CalcDate	Extended Data Type: TransDate Type: Date	None	Date of last estimate
CheckRoute	Enumeration: NoYes	ProdRouting	Test route?
CollectRefLevel	Extended Data Type: BOMLevel Type: Integer	BOM	Level where production refers to the reference
CollectRefProdId	Extended Data Type: ProdId Type: String	Prod	Reference to a higher production level which includes this production.
createdBy	Extended Data Type: CreatedBy Type: String	None
createdDateTime	Extended Data Type: CreatedDateTime Type: UtcDateTime	None
CurrencyCode_RU	Extended Data Type: CurrencyCode Type: String	None	Currency used to define prices (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dataAreaId	Extended Data Type: DataAreaId Type: String	None
DefaultDimension	Extended Data Type: DimensionDefault Type: Int64	LedgerBasic	Default dimensions
dEL_CreatedTime	Extended Data Type: DEL_CreatedTime Type: Integer	None	(This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
Density	Extended Data Type: BOMMeasureDensity Type: Real	None	Measurement conversion factor for the density dimension.
Depth	Extended Data Type: BOMMeasureDepth Type: Real	None	Measurement conversion factor for the depth dimension.
DlvDate	Extended Data Type: SalesShippingDate Type: Date	LogisticsBasic	Requested date of delivery or finish report
DlvTime	Extended Data Type: SchedTime Type: Integer	ProdShop	Delivery time
FinishedDate	Extended Data Type: TransDate Type: Date	None	Last report as finished date
GanttColorId	Extended Data Type: GanttColorId Type: Integer	ProdShop	This color is used in the Gantt chart if it is defined in the setup of colors in the Gantt chart.
Height	Extended Data Type: BOMMeasureHeight Type: Real	None	Measurement conversion factor for the height dimension.
InventDimId	Extended Data Type: InventDimId Type: String	None	Identification of dimensions for the item.
InventRefId	Extended Data Type: InventRefId Type: String	None	Number of the order, project, production, or purchase referred to
InventRefTransId	Extended Data Type: InventRefTransId Type: String	LogisticsBasic	Lot ID referred to.
InventRefType	Enumeration: InventRefType	None	Module and number referred to
InventTransId	Extended Data Type: InventTransId Type: String	LogisticsBasic	Summary number for finished-item transactions
ItemId	Extended Data Type: ItemIdProduction Type: String	LogisticsBasic	Finished item number for the production
LatestSchedDate	Extended Data Type: SchedDate Type: Date	ProdRouting	Scheduling date last used
LatestSchedDirection	Enumeration: SchedDirection	ProdRouting	Scheduling direction last used
LatestSchedTime	Extended Data Type: SchedTime Type: Integer	ProdShop	Scheduling time last used
Name	Extended Data Type: ProdName Type: String	Prod	Describe the production
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))
PBAId	Extended Data Type: PBAId Type: String	PBA_ProductBuilder	Product model ID
PdsCWBatchEst	Extended Data Type: PdsCWBatchEst Type: Real	PdsCatchWeight	Catch weight quantity estimated. (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))
PdsCWBatchSched	Extended Data Type: PdsCWBatchSched Type: Real	PdsCatchWeight	Catch weight quantity scheduled. (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))
PdsCWBatchSize	Extended Data Type: PdsCWBatchSize Type: Real	PdsCatchWeight	Catch weight quantity size. (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))
PdsCWBatchStup	Extended Data Type: PdsCWBatchStup Type: Real	PdsCatchWeight	Catch weight quantity started. (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))
PdsCWRemainInventPhysical	Extended Data Type: PdsCWInventQty Type: Real	PdsCatchWeight	Catch weight report remainder as finished. (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))
PmfBulkOrd	Extended Data Type: PmfBulkOrd Type: Enum	PMF	Indicates the particular batch order is for a bulk item. (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))
PmfCoByVarAllow	Extended Data Type: PmfCoByVarAllow Type: Enum	PMF	When checked, co-product and by-product variations are allowed. (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))
PmfConsOrdId	Extended Data Type: PmfConsOrdId Type: String	PMF	Consolidated batch order number (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))
PmfReworkBatch	Extended Data Type: PmfReworkBatch Type: Enum	PmfReworkBatch	The batch will be treated as a rework batch. (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))
PmfTotalCostAllocation	Extended Data Type: PmfTotalCostAllocation Type: Enum	PMF	Marks a formula version for total cost allocation costing method. (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))
PmfYieldPct	Extended Data Type: PmfYieldPct Type: Real	PMF	Yield percentage of formula lines. (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))
PriceGroup_RU	Extended Data Type: CustPriceGroup Type: String	PriceDisc	Customer price group used for components delivered to subcontractor. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
ProdGroupId	Extended Data Type: ProdGroupId Type: String	Prod	Production group that production is attached to.
ProdId	Extended Data Type: ProdId Type: String	Prod	Identify the production order.
ProdLocked	Extended Data Type: Locked Type: Enum	ProdRouting	Is the production locked for rescheduling?
ProdOrigId	Extended Data Type: ProdOrigId Type: String	Prod	Production on which the creation of the current production is based.
ProdPoolId	Extended Data Type: ProdPoolId Type: String	Prod	Specifies the pool that the production is attached to.
ProdPostingType	Enumeration: ProdPostingType	Prod	Determines how production should be posted to ledger.
ProdPrio	Extended Data Type: Priority Type: Integer	ProdRouting	Production priority. Higher numbers have higher priority.
ProdStatus	Enumeration: ProdStatus	Prod	Production status
ProdType	Enumeration: ProdType	Prod	Production type
ProdWHSReleasePolicy	Enumeration: ProdWHSReleasePolicy	WHSandTMS	Specify whether all materials must be reserved before an order can be released to the warehouse (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
ProfitSet	Enumeration: CostProfitSet	BOM	Profit-setting used in determining sales price
ProjCategoryId	Extended Data Type: ProjCategoryId Type: String	ProjBasic	Category that is used as a default.
ProjCostAmount	Extended Data Type: CostAmount Type: Real	None	The total of quantity multiplied by cost price
ProjCostPrice	Extended Data Type: ItemCostPrice Type: Real	LogisticsBasic	Item cost price used for posting
ProjId	Extended Data Type: ProjId Type: String	ProjBasic	Project identification
ProjLinePropertyId	Extended Data Type: ProjLinePropertyId Type: String	ProjBasic	Attribute that defines cost and sales percentages and options for revenue accrual and capitalization cost
ProjLinkedToOrder	Enumeration: NoYes	None	Indicates whether record is linked to a sales line or item requirement.
ProjPostingType	Enumeration: ProjProdPostingType	ProjBasic	Determines how production should be posted to project
ProjSalesCurrencyId	Extended Data Type: ProjSalesCurrencyCode Type: String	None	Currency in which the project is invoiced.
ProjSalesPrice	Extended Data Type: ProjSalesPriceCost Type: Real	ProjBasic	Sales price per unit calculated in the current sales currency.
ProjSalesUnitId	Extended Data Type: UnitOfMeasureSymbol Type: String	None	Unit symbol
ProjTaxGroupId	Extended Data Type: ProjTaxGroup Type: String	ProjBasic	Sales tax group project invoicing.
ProjTaxItemGroupId	Extended Data Type: ProjTaxItemGroup Type: String	ProjBasic	Item sales tax group project invoicing.
ProjTransId	Extended Data Type: ProjItemTransId Type: String	ProjBasic	Identification of transaction.
PropertyId	Extended Data Type: PropertyId Type: String	ProdRouting	Necessary property for production
QtyCalc	Extended Data Type: ProdQtyCalc Type: Real	Prod	Quantity cost estimated
QtySched	Extended Data Type: ProdQtySched Type: Real	Prod	Scheduled production quantity
QtyStUp	Extended Data Type: ProdQtyStUp Type: Real	Prod	Started production quantity
RealDate	Extended Data Type: TransDate Type: Date	None	Date that the production status was updated to Ended.
RecId	Extended Data Type: RecId Type: Int64	None
recVersion	Extended Data Type: RecVersion Type: Integer	None
RefLookUp	Enumeration: ProdRefLookUp	None	Code used for auto-search.
ReleasedDate	Extended Data Type: TransDate Type: Date	None	Release date (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
RemainInventPhysical	Extended Data Type: InventQty Type: Real	None	Quantity not yet reported as finished
ReqPlanIdSched	Extended Data Type: ReqPlanIdSched Type: String	Req	Identification of plan
ReqPOId	Extended Data Type: ReqPOId Type: String	Req	Number identifying the planned order
Reservation	Enumeration: ProdReservation	Prod	When should autoreservation be performed?
RouteId	Extended Data Type: RouteId Type: String	ProdRouting	Route used when creating production
RouteJobs	Enumeration: NoYes	ProdShop	Have route jobs been generated for the production?
SchedDate	Extended Data Type: TransDate Type: Date	ProdRouting	Last scheduled
SchedEnd	Extended Data Type: SchedToDate Type: Date	None	The date that the project is scheduled to finish
SchedFromTime	Extended Data Type: SchedFromTime Type: Integer	ProdShop	Scheduled start time.
SchedStart	Extended Data Type: SchedFromDate Type: Date	None	The date that the project is scheduled to begin
SchedStatus	Enumeration: ProdSchedStatus	ProdRouting	Scheduling status of the production
SchedToTime	Extended Data Type: SchedToTime Type: Integer	ProdShop	Scheduled end time
StUpDate	Extended Data Type: TransDate Type: Date	None	Last start date
Width	Extended Data Type: BOMMeasureWidth Type: Real	None	Factor for the measurement dimension width.

Top

Field Groups

Field Group	Fields
AutoReport
BOM
DateUpdated
Dimensions
BOMRoute
DateScheduled
Grouping
Identification
Inventory
ItemReference
Origin
LatestScheduling
Measurement
Other
ProjectCostPrice
Project
ProjectFinishedItem
ProjectIdentification
ProjectSalesPrice
ProjectSalesTax
ProjectTransaction
QualityManagement
QuantityUpdated
Route
Scheduling
Setup
Status
SummaryReference
System
PlannedOrderReference
Price_RU
PmfReworkBatch
PmfBatch
Production
ProductModelNumber
ProductionBatch

Top

Relations

Relation	Table	Lines
BOMTable	BOMTable
Currency	Currency
dataAreaId	DataArea
DefaultDimension	DimensionAttributeValueSet
GanttColorTable	GanttColorTable
InventDim	InventDim
InventJournal	InventJournalTable
InventTable	InventTable
InventTransferTable	InventTransferTable
InventTransOrigin	InventTransOrigin
OriginalProdTable	ProdTable
Partition	Partitions
PBATable	PBATable
PlannedOrder	ReqPO
PmfConsOrd	PmfConsOrd
PriceGroup_RU	PriceDiscGroup
ProdGroup	ProdGroup
ProdLine	ProdBOM
ProdPool	ProdPool
ProdTable	ProdTable
ProdTableProj	ProdTableProj
Production	ProdTable
ProjCategory	ProjCategory
ProjectSalesCurrency	Currency
ProjectTaxGroupHeading	TaxGroupHeading
ProjectTaxItemGroupHeading	TaxItemGroupHeading
ProjItemTrans	ProjItemTrans
ProjLineProperty	ProjLineProperty
ProjSalesUnitId	UnitOfMeasure
ProjTable	ProjTable
ReferenceProdTable	ProdTable
ReqPlanSched	ReqPlanSched
RouteTable	RouteTable
SalesOrder	SalesTable
SalesOrderLine	SalesLine
smmActivities	smmActivities
WrkCtrProperty	WrkCtrProperty

Top

Indexes

Index	AllowDuplicates	Enabled
BackStatusItemIdx	Yes	Yes
ProdIdx	No	Yes
ProdStatusIdx	No	Yes
ProjIdx	Yes	Yes
RecId	No	Yes
RefCollectIdx	No	Yes
TransIdIdx	No	Yes
TypeRemainIdx	No	Yes

Top

Inheritance Hierarchy

xRecord Class
Common Table
ProdTable Table