Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The InventTable table contains information about items.
Configuration Key: LogisticsBasic
Methods
| Method | Description | |
|---|---|---|
.gif "Public method") |
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.) |
|
approximateTaxValue_BR | Retrieves the approximate tax value for the current item |
|
bomCalcGroup | |
|
bomId | |
|
bomIdConstruction | |
|
bomUnitId | |
|
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.) |
|
categoryName | Display the category name of the selected category record. |
.gif "Private method") |
checkAltInventDimCombination | |
|
checkColorId | |
|
checkConfigId | |
|
checkCostGroupId | Indicates whether the cost group type of the current cost group is correct with regard to the product type. |
|
checkDimGroupForBatch | Specifies whether the assigned dimension group is valid for the item. |
|
checkFiscalLIFOValuePrevYear | |
|
checkICMSOnService_BR | This method checks if the field ICMS on Service is checke even when the Item Type is not Service |
|
checkInvalidFieldAccess | Gets and sets invalid field access. (Inherited from xRecord.) |
|
checkInventDimCombination | |
|
checkMarkupCode_RU | |
|
checkPhantom | Specifies whether the item is a phantom item. |
|
checkPlanningItemCost | Specifies whether the cost allocation for a planning item is valid. |
|
checkProductType | Specifies whether the assigned production type is valid for service or purchased items. |
|
checkProjCategoryId | |
|
checkRecord | Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.) |
|
checkRefInventTrans | |
|
checkRestrictedDeleteActions | Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.) |
|
checkSizeId | |
|
checkStandardInventDimCombination | |
|
checkStyleId | Checks if the specified style name is valid for this item. |
|
checkValid | |
|
clear | Removes all rows from the table buffer. (Inherited from xRecord.) |
|
colorActive | |
|
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.) |
|
configActive | |
|
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. |
|
costGroup | Retrieves the cost group. |
|
costPcsPrice | |
|
costPcsPriceSecCur_RU | |
|
custVendExternalItemDescription | |
|
data | Retrieves a row from the table. (Inherited from xRecord.) |
|
dataSource | Retrieves the data source of the table. (Inherited from xRecord.) |
|
defaultCustVendExternalItemDescription | |
|
defaultExternalItemDescription | Retrieves an external description of an item. |
|
defaultExternalItemId | Retrieves an external ID of an item. |
|
defaultField | Populates default values in a field in the table. (Inherited from xRecord.) |
|
defaultLoadHeight | |
|
defaultProductDescription | Retrieves the description of a product that this item represents. |
|
defaultProductName | Retrieves the name of a product that this item represents. |
|
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.) |
|
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.) |
|
editTMSInventEnabled | Gets and sets whether the item is TMS enabled |
|
equal | Determines whether the specified object is equal to the current one. (Inherited from xRecord.) |
|
existsVendInvoiceTrans_RU | |
|
externalItemDescription | Retrieves the external description of an item. |
|
externalItemId | Retrieves the external ID of an item. |
|
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.) |
|
findBomAndRouteForCoProd | Finds a BOM and Route data for a co-product based on the search criteria. |
|
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.) |
|
getSalesPriceAgreement | |
|
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.) |
|
grossVolume | |
|
grossWeight | |
|
handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
|
hasActiveAltItemId | Specifies whether an active alternative item setup exists for this item. |
|
hasConfigs | |
|
hasForecastPurch | |
|
hasForecastSales | |
|
hasInventTrans | Specifies whether any inventory transactions exist for this item. |
|
hasProductDimensions | |
|
hasRelatedTable | Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.) |
|
hasTrackingDimensions | Gets a value indicating whether any of the tracking dimensions are active or sales process active |
|
helpField | Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.) |
|
initFromEcoResProduct | Initializes an InventTable record with the values from an EcoResProduct record. |
|
initNonSpecifiedStandardProductDims | Initializes the standard item dimensions that are not already specified. |
|
initPdsVendorCheckFromInventModelGroup | Initializes the vendor check from the item model group. |
|
initStandardProductDimensions | |
|
initValue | Initializes field values in a new InventTable record. |
|
inputStatus | Sets or returns the current input status of the table buffer. (Inherited from xRecord.) |
|
insert | |
|
insertBOMTable | |
|
insertInventItemOrderSetup | |
|
interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) |
|
interCompanyBlockedPurch | |
|
interCompanyBlockedSales | |
|
inventCostPriceMap | |
|
inventCostPriceMapSecCur_RU | |
|
inventDimLinkedDefaultDimension | |
|
inventDimParmActiveDimensions | Determines all active dimensions that belong to the current item. |
|
inventDimParmCovDimensions | |
|
inventDimParmPrimaryDimensions | Determines all active primary dimensions that belong to the current item. |
|
inventDimParmProductDimensions | |
|
inventDimParmSalesProcessActiveDim | Determines all sales process active dimensions that belong to the current item. |
|
inventDimPrimaryDimensions | Removes all non primary dimensions on the InventDim parameter. |
|
inventDimProductDimensions | |
|
inventInventSiteId | |
|
inventItemGroupItem | Retrieves the InventItemGroupItem record associated with the current record. |
|
inventItemInventSetup | |
|
inventItemOrderSetupMap | |
|
inventItemPurchSetup | |
|
inventItemSalesSetup | |
|
inventItemSetupSupplyType | Finds the specified record in the InventItemSetupSupplyType record that is related to the current item. |
|
inventItemType | |
|
inventLocationId | Gets an inventory warehouse ID. |
|
inventLocationIdBOM | |
|
inventLowestQty | Returns a minimum allowed inventory order quantity. |
|
inventModelGroupItem | Retrieves the InventModelGroupItem record associated with the current record. |
|
inventoriedPolicy | Initializes a new instance of the InventTableInventoriedPolicy class. |
|
inventStandardQty | Gets a standard inventory order quantity. |
|
inventTableModuleInvent | |
|
inventTableModulePurch | |
|
inventTableModuleSales | |
|
inventUnitId | |
|
isActiveInSalesProcess | Determines if the given Item belongs to a Tracking Dimension that has the "Active in Sales Process" flag enabled and item is stocked. |
|
isBOMAllowed | Specifies whether the item can have a BOM. |
|
isBOMProducedByDefault | Specifies whether the item should be produced by default with a production order. |
|
isByProduct | Determines whether the item is a by-product. |
|
isCoByProduct | Determines whether the item is a co-product or by-product. |
|
isConfigurable | |
|
isConstraintBasedConfigurable | Validates that this item is configurable by constraint-based product configuration. |
|
isCoProduct | Determines whether the item is a co-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.) |
|
isFormulaAllowed | Specifies whether the item can have formula. |
|
isFormulaOrBOMAllowed | Specifies whether the item can have a BOM or formula. |
|
isFormulaProducedByDefault | Specifies whether the item should be produced by default with a batch order. |
|
isItemBatchActivated | Specifies whether the batch number inventory dimension is active for the item. |
|
isItemGroupSetup | |
|
isMarkupCodeEnabled_RU | Determines whether the field MarkupCode_RU is enabled. |
|
isModelGroupSetup | |
|
isNewRecord | Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.) |
|
isPartOfUOWSaveChanges | (Inherited from xRecord.) |
|
isProducedByDefault | Determines if the item should be produced by default (default order is set to production). |
|
isShelfLifeItem | Specifies whether the item is a shelf life item. |
|
isStocked | Determines whether the policy is stocked. |
|
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.) |
|
itemDescriptionOrName | Retrieves the description or name of a product that this item represents. |
|
itemGroup | Retrieves the item group of the current item. |
|
itemGroupId | Retrieves the item group ID of the current item. |
|
itemIdAndDescription | Retrieves the value of the ItemId field concatenated with the description or name of a product that this item represents. |
|
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.) |
|
linkPhysicalTableInstance | Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.) |
|
mcrGetProductMaster | Retrieves the product master for the current item. |
|
mcrInventTable | Retrieves the packed table MCRInventTable. |
|
mcrInventUnitOfMeasureClass | Retrieves the unit of measure class for the current item's unit ID. |
|
mcrPackMCRInventTable | Packs the extended MCRInventTable after setting the record ID on the current record. |
|
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 of this table and the specified dimension set. |
|
modelGroup | Retrieves an item model group for the current item. |
|
modelGroupId | Retrieves the ID of an item model group for an item. |
|
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.) |
|
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.) |
|
pdsBaseValueDisplay | Gets the base value from PdsBatchAttributeByItem table. |
|
pdsBatchLookup | Displays a lookup selection for batch attributes that can be used as the potency attribute. |
|
pdsCheck | Specifies whether the shelf life tests should be executed for the item. |
|
pdsCheckApprovedVendorList | Specifies whether the item has an approved vendor list. |
|
pdsCheckCWItemSetup | Checks whether the catch weigh has been completely defined. |
|
pdsCheckSameLot | Specifies whether the item can be used for the same lot batch reservation. |
|
pdsCWCheckBatchNumGroupId | Specifies whether the assigned batch number group is valid for a catch weight item. |
|
pdsCWCheckItemType | Specifies whether the item and production type are valid for a catch weight item. |
|
pdsCWCheckSerialNumGroupId | Specifies whether the assigned serial number group is valid for a catch weight item. |
|
pdsCWItem | Specifies whether the item is a catch weight item. |
|
pdsDefaultOrderType | Gets the default order type of the product, for the current legal entity. |
|
pdsEffectExpiryDate | Gets the effective expiry date for this item. |
|
pdsExpiryDays | Gets the number of days until an inventory batch for this item expires. |
|
pdsIsBestBeforeMandatory | Checks if this product must have a best before date defined. |
|
pdsIsShelfLifeCapable | Checks if this product allows editing of shelf Life information. |
|
pdsIsShelfLifeMandatory | Checks if this product must have a shelf Life date defined. |
|
pdsMRCRegulatedMaterial | Specifies whether the item is a regulated material. |
|
pdsMRCRestrictedMaterial | Specifies whether the item is a restricted material. |
|
pdsQualOrdWarning | Shows a warning for additional requirements. |
|
pdsValidateBestBeforeDays | Specifies whether the best before days field is valid for the item. |
|
pmfHasFormulaWithCoProdOutput | Determines if the item is a formula or planning item that has additional co-product outputs. |
|
pmfImageResNo | Gets the image resource matching the item type and production type of the item. |
|
pmfInventProductType | Gets the PmfInventProductType class that corresponds to the current InventTable record. |
|
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.) |
|
primaryVendorId | |
|
Product | Looks up the related EcoResProduct table. |
|
productDescription | Retrieves the description of the product that this item represents. |
|
productDimensionGroup | Retrieves a product dimension group ID related to the current item. |
|
productDimensionGroupName | Retrieves a product dimension group name that is related to the current item. |
|
productHasCWSetup | Specifies whether the product definition for this item has catch-weight setup. |
|
productName | Retrieves the name of a product that this item represents. |
|
productSubtype | Retrieves a product subtype related to the current item. |
|
purchInventLocationId | Gets a purchase warehouse ID. |
|
purchInventSiteId | |
|
purchLineDisc | |
|
purchLowestQty | Gets the minimum allowed inventory order quantity. |
|
purchMarkupGroup | |
|
purchMultiLineDisc | |
|
purchOverDeliveryPct | |
|
purchPcsPrice | |
|
purchPriceAgreement | |
|
purchPriceUnit | |
|
purchStandardQty | Gets the standard purchase order quantity. |
|
purchSuppItemGroupId | |
|
purchTaxItemGroupId | |
|
purchUnderDeliveryPct | |
|
purchUnitId | |
|
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 | |
|
reread | Rereads the record from the table. (Inherited from xRecord.) |
|
routeId | |
|
routeIdConstruction | |
|
RowCount | Retrieves the number of rows in the table. (Inherited from xRecord.) |
|
salesInventLocationId | Gets a sales warehouse ID. |
|
salesInventSiteId | |
|
salesLineDisc | |
|
salesMarkupGroup | |
|
salesMultiLineDisc | |
|
salesOverDeliveryPct | |
|
salesPcsPrice | |
|
salesPriceAgreement | |
|
salesPriceUnit | |
|
salesStandardQty | Gets a standard sales order quantity. |
|
salesSuppItemGroupId | |
|
salesTaxItemGroupId | |
|
salesUnderDeliveryPct | |
|
salesUnitId | |
|
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.) |
|
serviceCode_BR | Returns the service code for a service. |
|
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.) |
|
showCSSItemDescription | Indicates whether the SPCSS item description Web page must show when an item is added to the basket. |
|
sizeActive | |
|
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.) |
|
storageDimensionGroup | Retrieves the ID of a storage dimension group that is related to the current item. |
|
styleActive | Checks if the style dimension is active for this item. |
|
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.) |
|
title | Retrieves the ID and a product name of the current product per company and combines it into a title. |
|
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.) |
|
totalAvailPhysical | Calculates the total physical quantity available for the specified item. |
|
trackingDimensionGroup | Retrieves the ID of a tracking dimension group that is related to the current item. |
|
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.) |
|
update | Updates the current record in the database. |
|
updateAutoSalesPercent | |
|
updateCheckFix | |
|
updateLastCostPrice | |
|
updateLastCostPriceSecCur_RU | |
|
updateLastPurchPrice | |
|
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. |
|
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 to the database. |
|
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.) |
|
whsAllowPhysNeg | Returns a boolean value indicating whether the physical inventory be negative or not. |
|
whsBatchActive | Returns a boolean value indicating whether the Batch inventory dimension is active for current item or not. |
|
whsDisplayHasTransactions | Returns an integer flag indicating whether there are open inventory transactions for current item or not. |
|
whsItemIsWHSControlled | Determines if the current IventTable record is WHS controlled. |
|
whsReservationHierarchy | Retrieves the ID of the reservation hierarchy that is related to the current item. |
|
whsReservationHierarchyName | Retrieves the name of the reservation hierarchy that is related to the current item. |
|
whsSerialActive | Returns a boolean value indicating whether the Serial Number inventory dimension is active for current item or not. |
|
write | Writes the current record to the database. |
|
xml | Retrieves an XML string that represents the current object. (Inherited from xRecord.) |
.gif "Static member") |
::buildMaxQtyDialogStr | |
|
::buildMinQtyDialogStr | |
|
::buildMultipleDialogStr | Builds the text for the dialog to adjust for the transaction quantity based on the multiple unit defined. |
|
::checkAssetId_RU | |
|
::checkColor | |
|
::checkConfig | |
|
::checkExist | Indicates whether the specified record exists in the InventTable table and displays a message if the record does not exist. |
|
::checkProductDimensions | Indicates whether the product dimensions are valid for the specified item. |
|
::checkSize | |
|
::checkStyle | Checks if a style name is valid for an item. |
|
::exist | |
|
::existsWithExceptionCode_BR | It verifies if exist at least one record on InventTable with the Exception Code |
|
::existsWithInventProductType_BR | It verifies if exist at least one record on InventTable with the Invent Product Type ID |
|
::existsWithTaxFiscalClassification_BR | It verifies if exist at least one record on InventTable with the Tax Fiscal CLassification ID |
|
::find | |
|
::findAlternativeItem | |
|
::findByProduct | |
|
::findByProductInCompany | Finds the specified record in the InventTable table. |
|
::findCostPcsPrice | |
|
::findCostPcsPriceSecCur_RU | |
|
::findExternalItemId | |
|
::findHavingPotencyAttribute | Finds the specified record in the InventTable table that is tied to a product-specific potency attribute. |
|
::findInLegalEntity | Finds the specified InventTable record. |
|
::findRecId | |
|
::findTagId | |
|
::getDistinctProductRecId | Retrieves the record ID of a EcoResDistinctProduct or EcoResDistinctProductVariantrecord. |
|
::getInventDimId | |
|
::infoActionBOMCalcGroup | |
|
::infoActionItemId | |
|
::inventDecimals | |
|
::isBatchReceiptRequired | |
|
::isCoByItem | Specifies whether an item is a co-product or by-product. |
|
::isFormulaItem | Specifies whether an item is a formula item. |
|
::isPlanningItem | Specifies whether an item is a planning item. |
|
::isPotencyItem | Specifies whether the item is a potency item. |
|
::itemGroupByItemId | Retrieves an item group for an item. |
|
::itemGroupIdByItemId | Retrieves an item group ID for an item. |
|
::itemProduct | Finds the reference record ID for the specified ItemId record |
|
::itemProductDimensionGroup | |
|
::itemTypeByProductType | Converts a product type to an item type. |
|
::jumpRefItemId | Provides the open main table functionality for an item. |
|
::lookupBOMId | Performs a lookup on the BOMVersio table. |
|
::lookupBOMItemId | Provides a lookup for the InventTable table containing only BOM items. |
|
::lookupBulkPackItemForSetup | Provides a lookup for the InventTable table containing only items compatible with the containerized packaging. |
|
::lookupFormulaId | Provides a lookup for the BOMVersion table containing only formulas. |
|
::lookupFormulaItemId | Provides a lookup for the InventTable table containing only BOM items. |
|
::lookupItem | |
|
::lookupItemByTrackingDimension | Creates and displays a lookup from which the user can select for items tracked by a specific dimension only. |
|
::lookupItemIdAsset_RU | Find asset items. |
|
::lookupItemIdCanBeProduced | |
|
::lookupItemIdCanBeTracked | Creates and displays a lookup from which the user can select for trackable items only |
|
::lookupItemIdCanBeTransferred | Finds items that can be transferred. |
|
::lookupItemIdCanHaveBOMFormula | Find BOM and formula items. |
|
::lookupItemIdCanHaveCoProdBOMFormula | Find BOM items, formula items and co-products. |
|
::lookupItemIdDefaultOrderType | Creates a lookup for selecting items with the specified default order type. |
|
::lookupItemIdGroup | |
|
::lookupItemIdType | |
|
::lookupItemIdTypePricingTemplate | Find items that can be used for a commodity pricing template. |
|
::lookupItemsForQuotes | Provides a lookup for the items which belongs to a catalog for a specified MCRSourceID source code. |
|
::lookupItemType | Find co-products and by-products. |
|
::lookupPmfBulkItem | Finds bulk items for the specified BOMId. |
|
::lookupPmfPlanningItem | Runs a lookup form for formula or planning items that can be used for planning a given co-product item. |
|
::lookupRouteId | Performs a lookup on the RouteVersion table. |
|
::mcrFindByContinuitySchedId | Finds the InventTable record via the passed continuity schedule ID. |
|
::mcrFindUpcomingProdOrder | Finds the first upcoming scheduled production order for a given item and item dimensions, whose scheduled end date is after today. |
|
::mcrFindUpcomingPurchLine | Finds the first upcoming open purchase line for a given item and item dimensions, whose delivery date is after today. |
|
::mcrGetUpcomingInventAvailDate | Gets the first upcoming date after today that the item with given item dimensions will become available. |
|
::mcrIsItemContinuity | Gets whether or not the item is a continuity item. |
|
::mcrLookupContinuityItems | Looks up continuity schedules and continuity customer information lines on items that are continuity. |
|
::mcrLookupItemIds | Looks up basic item information. |
|
::mcrLookupNonContinuityItems | Looks up the continuity schedules and continuity customer information lines on items that are continuity and cannot be added at the line level. |
|
::mcrValidStartEndDate | Determines whether the start and end dates are valid. |
|
::modelGroupByItemId | Retrieves an item model group for an item. |
|
::modelGroupIdByItemId | Retrieves an item model group ID for an item. |
|
::mustConvertQty | |
|
::mustConvertQtyClient | |
|
::name | |
|
::pbaLookupItemIdGroup | Displays a manually created lookup form for picking the item to be associated with the current product model. |
|
::pdsFillDefaultBatchAttribforItem | Creates a list of batch attributes for an item. |
|
::pdsFindBaseAttribute | Return the Base Batch Attribute for a given item. |
|
::pmfCheckAllowQuality | Specifies whether quality orders can be created for an item. |
|
::pmfCheckFormulaItemForCoBy | Specifies whether a formula item has assigned co-products or by-products. |
|
::pmflookupItemIdCoBy | Find co-products and by-products. |
|
::priceInventDimId | Find or create an inventDimId for storing the price of an item price. |
|
::queryIsBomOrFormulaAllowed | Filters the user query to ensure only BOM items or formula items are selected. |
|
::setMinMaxQty | Determines a quantity that conforms with the minimum, maximum and multiple settings of an ItemAccount. |
|
::showItemSiteAndProductDim | |
|
::txtNotExist | Gets the message to use when a specific record in the InventTable table does not exist. |
|
::unitConvert | |
|
::unitConvertValue | |
|
::updateAssetId_RU | |
|
::updateAutoSalesPrice | |
|
::webLookupItemIdQuery | Creates a query object that is used in the Enterprise Portal and adds ranges based on the customer or vendor. |
|
::wmsPalletTypeId |
Top
Fields
| Field | Type | Configuration key | Description |
|---|---|---|---|
| ABCContributionMargin | Enumeration: ABC |
None | Item's ABC-code for contribution margin |
| ABCRevenue | Enumeration: ABC |
None | Item's ABC-code for sales |
| ABCTieUp | Enumeration: ABC |
None | Item's ABC-code for inventory carrying cost |
| ABCValue | Enumeration: ABC |
None | Item's ABC-code for inventory value |
| AlcoholManufacturerId_RU | Extended Data Type: AlcoholManufacturerId_RU Type: String |
None | Alcohol manufacturer (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| AlcoholProductionTypeId_RU | Extended Data Type: AlcoholProductionTypeId_RU Type: String |
None | The alcohol production type (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| AlcoholStrength_RU | Extended Data Type: AlcoholStrength_RU Type: Real |
None | The alcohol concentration as a percentage (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| AltConfigId | Extended Data Type: ConfigIdAlternative Type: String |
Config | Alternative configuration is used in order entry. |
| AltInventColorId | Extended Data Type: EcoResItemColorName Type: String |
EcoResProductColor | Identification of alternative item color |
| AltInventSizeId | Extended Data Type: EcoResItemSizeName Type: String |
EcoResProductSize | Identification of alternative item size |
| AltInventStyleId | Extended Data Type: EcoResItemStyleName Type: String |
EcoResProductStyle | Identification of alternative item style (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)) |
| AltItemId | Extended Data Type: ItemIdAlternative Type: String |
LogisticsBasic | Alternative inventory number is used for order entry. |
| ApproxTaxValue_BR | Extended Data Type: ApproximateTaxValue_BR Type: Real |
LedgerBasicSalesTax | The tax rate that is used to calculate the approximate tax amount for the product (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| AssetGroupId_RU | Extended Data Type: RAssetMainGroupId Type: String |
RAsset | identifier of FA group. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| AssetId_RU | Extended Data Type: RAssetId Type: String |
RAsset | Unique key for identification of fixed asset. The key is used when creating new assets. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| AutoReportFinished | Extended Data Type: ItemAutoReportFinished Type: Enum |
BOM | Activate automatic report as finished in connection with transactions for the item. |
| BatchMergeDateCalculationMethod | Enumeration: InventBatchMergeDateCalculationMethod |
LogisticsBasic | Date calculation method to use when merging batches. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| BatchNumGroupId | Extended Data Type: InventNumGroupId Type: String |
LogisticsBasic | Group for automatic batch number allocation |
| BOMCalcGroupId | Extended Data Type: BOMCalcGroupId Type: String |
None | Identification of the calculation group |
| BOMLevel | Extended Data Type: ItemBOMLevel Type: Integer |
BOM | Calculated BOM level on latest requirement calculation |
| BOMManualReceipt | Extended Data Type: ItemBOMManualReceipt Type: Enum |
Prod | Manually enter material profit for this item for a production? |
| BOMUnitId | Extended Data Type: BOMUnitId Type: String |
BOM | BOM consumption unit |
| CommissionGroupId | Extended Data Type: CommissItemGroup Type: String |
Commission | Commission group the item is attached to. |
| CostGroupId | Extended Data Type: CostGroupId Type: String |
BOM | Cost group the item is included in on BOM calculations. |
| CostModel | Extended Data Type: ItemCostModel Type: Enum |
LogisticsBasic | Update the item automatically with latest cost price? |
| createdBy | Extended Data Type: CreatedBy Type: String |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| createdDateTime | Extended Data Type: CreatedDateTime Type: UtcDateTime |
None | |
| CustomsExportTariffCodeTable_IN | Extended Data Type: RefRecId Type: Int64 |
None | Select the export tariff code for the item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| CustomsImportTariffCodeTable_IN | Extended Data Type: RefRecId Type: Int64 |
None | Select the import tariff code for the item. (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)) |
| dEL_ModifiedTime | Extended Data Type: DEL_ModifiedTime 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. |
| EPCManager | Extended Data Type: EPCManager Type: Real |
RFID | The EPC manager of the item. |
| ExceptionCode_BR | Extended Data Type: ExceptionCode_BR Type: String |
None | Fiscal classification exception code (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| ExciseTariffCodes_IN | Extended Data Type: RefRecId Type: Int64 |
None | Excise tariff code for the item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| EximProductGroupTable_IN | Extended Data Type: RefRecId Type: Int64 |
None | Select the product group for the item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| FiscalLIFOAvoidCalc | Extended Data Type: InventFiscalLIFOAvoidCalc Type: Enum |
None | Exclude items from fiscal LIFO calculation. |
| FiscalLIFONormalValue | Extended Data Type: InventFiscalLIFONormalValue Type: Real |
None | Normal value for the group or item |
| FiscalLIFONormalValueCalc | Enumeration: InventFiscalLIFONormalValueCalc |
None | Should normal value be calculated |
| ForecastDMPInclude | Extended Data Type: ForecastDMPInclude Type: Enum |
None | Include in demand planning. |
| grossDepth | Extended Data Type: InventDepth Type: Real |
LogisticsBasic | Unit depth incl. packing |
| grossHeight | Extended Data Type: InventHeight Type: Real |
LogisticsBasic | Unit height incl. packing |
| grossWidth | Extended Data Type: InventWidth Type: Real |
LogisticsBasic | Unit width incl. packing |
| Height | Extended Data Type: BOMMeasureHeight Type: Real |
None | Measurement conversion factor for the height dimension. |
| ICMSOnService_BR | Extended Data Type: ICMSonService_BR Type: Enum |
None | ICMS tax applied on service item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| Intracode | Extended Data Type: IntrastatItemCodeId Type: String |
ForeignTrade | Item commodity code |
| IntrastatExclude | Enumeration: NoYes |
ForeignTrade | If this check box is selected, the item is excluded from the Intrastat report (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| IntrastatProcId_CZ | Extended Data Type: IntrastatProcId Type: String |
ForeignTrade | Code for the current statistical procedure. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| IntraUnit | Extended Data Type: IntrastatConvert Type: Real |
ForeignTrade | Quantity of additional units per inventory unit, used for Intrastat. |
| InventFiscalLIFOGroup | Extended Data Type: InventFiscalLIFOGroupRecId Type: Int64 |
None | Assign a group if this item must be included in a group average calculation. |
| InventProductType_BR | Extended Data Type: InventProductTypeId_BR Type: String |
None | Product type classification. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| ItemBuyerGroupId | Extended Data Type: ItemBuyerGroupId Type: String |
LogisticsBasic | Identification of the buyer group. |
| ItemDimCostPrice | Extended Data Type: ItemDimCostPrice Type: Enum |
LogisticsBasic | Activate, use, and maintain cost prices for product variants. |
| ItemId | Extended Data Type: ItemId Type: String |
LogisticsBasic | Identify item. |
| ItemPriceToleranceGroupId | Extended Data Type: ItemPriceToleranceGroupId Type: String |
PurchInvoiceMatching | Identification of item price tolerance group for accounts payable invoice matching |
| ItemTaggingLevel | Enumeration: RFIDItemTaggingLevel |
RFIDTagging | Is item tagging mandatory? |
| ItemType | Enumeration: ItemType |
LogisticsBasic | Type determining how the item is administered. |
| MarkupCode_RU | Extended Data Type: MarkupCodeVend_RU Type: String |
Markup | Identification of the charges (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| MatchingPolicy | Enumeration: PurchMatchingPolicyWithNotSetOption |
PurchInvoiceMatching | Default policy for PO lines. Three-way: PO, product receipt, and invoice. Two-way: PO and invoice. |
| MinimumPalletQuantity | Extended Data Type: WMSMinimumPalletQuantity Type: Real |
WMSPallet | Minimum quantity for pallets used for output transports |
| modifiedBy | Extended Data Type: ModifiedBy Type: String |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| modifiedDateTime | Extended Data Type: ModifiedDateTime Type: UtcDateTime |
None | |
| NameAlias | Extended Data Type: ItemNameAlias Type: String |
LogisticsBasic | Find fast name applying to the item |
| NetWeight | Extended Data Type: ItemNetWeight Type: Real |
LogisticsBasic | Net weight of inventory item for one inventory unit |
| NGPCodesTable_FR | Extended Data Type: NGPCodesTableFRId Type: Int64 |
None | French national item code |
| NRTaxGroup_LV | Extended Data Type: LvNRTaxGroup Type: String |
None | Group identifier. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| OrigCountryRegionId | Extended Data Type: ItemOrigCountryRegionId Type: String |
ForeignTrade | Country/region of origin of the current inventory item |
| OrigCountyId | Extended Data Type: ItemOrigCountyId Type: String |
ForeignTrade | County of origin of the current inventory item |
| OrigStateId | Extended Data Type: ItemOrigStateId Type: String |
ForeignTrade | State of origin for the current item |
| PackagingGroupId | Extended Data Type: ItemPackagingGroupId Type: String |
InventPackaging | Identification of the packing group |
| Packing_RU | Extended Data Type: ItemPackingType_RU Type: String |
LogisticsBasic | Type of packing in a packing slip. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| PalletTagging | Extended Data Type: RFIDPalletTagging Type: Enum |
RFIDTagging | Is pallet tagging mandatory? |
| 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)) |
| PBAAutoStart | Extended Data Type: PBAAutostart Type: Enum |
PBA_ProductBuilder | Autostart of configuration dialog when entering a modeling enabled item |
| PBAHideApproval | Extended Data Type: PBAHideApproval Type: Enum |
PBA_ProductBuilder | Hide approval dialog after acknowledgement of configuration details |
| PBAHideDialog | Extended Data Type: PBAHideDialog Type: Enum |
PBA_ProductBuilder | Hide dialog for automatic configuration based on default values |
| PBAInventItemGroupId | Extended Data Type: PBAInventItemGroupId Type: String |
PBA_ProductBuilder | Identification of the item product model group. |
| PBAItemAutoGenerated | Extended Data Type: PBAItemAutoGenerated Type: Enum |
None | Generated item |
| PBAItemConfigurable | Enumeration: NoYes |
PBA_ProductBuilder | Can this item be modeled in the Product Builder? |
| PBAMandatoryConfig | Extended Data Type: PBAMandatoryConfig Type: Enum |
PBA_ProductBuilder | Check item lines for complete configuration details |
| PDSBaseAttributeId | Extended Data Type: PDSBaseAttributeId Type: String |
PDSPotency | Define the base attributes for the item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| PdsBestBefore | Extended Data Type: PdsLeadTimeBest Type: Integer |
PdsShelf | Number of days before 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)) |
| PdsCWWMSMinimumPalletQty | Extended Data Type: PdsCWMinimumPalletQty Type: Real |
PdsCatchWeight | Minimum CW quantity for pallets used for output transports. (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)) |
| PdsCWWMSQtyPerLayer | Extended Data Type: PdsCWQtyPerLayer Type: Real |
PdsCatchWeight | CW quantity per layer on a standard pallet. (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)) |
| PdsCWWMSStandardPalletQty | Extended Data Type: PdsCwStandardPalletQty Type: Real |
PdsCatchWeight | Standard CW order quantity on a pallet. (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)) |
| PdsFreightAllocationGroupId | Extended Data Type: PdsFreightAllocationGroupId Type: String |
PdsRebate | Freight allocation unique 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)) |
| PdsItemRebateGroupId | Extended Data Type: PdsItemRebateGroupId Type: String |
PdsRebate | Group of item for which a rebate is applicable. (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)) |
| PDSPotencyAttribRecording | Enumeration: PDSPotencyAttribRecordingEnum |
PDSPotency | Indicates whether the attribute value can be recorded from an RAF journal or entered using a quality order (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| PdsShelfAdvice | Extended Data Type: PdsLeadTimeAdvice Type: Integer |
PdsShelf | Shelf advice for number of days. (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)) |
| PdsShelfLife | Extended Data Type: PdsLeadTimeLife Type: Integer |
PdsShelf | Lead time life. (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)) |
| PDSTargetFactor | Extended Data Type: PDSTargetFactor Type: Real |
PDSPotency | Target value for the batch attribute selected as the potency base attribute (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| PdsVendorCheckItem | Enumeration: PdsVendorCheckItem |
PdsAVL | The type of validation that is done against the approved vendor list at the item level. (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)) |
| Phantom | Extended Data Type: ItemPhantom Type: Enum |
BOM | Propose item as phantom item in bills of materials? |
| PKWiUCode_PL | Extended Data Type: PlPKWiUCode Type: String |
None | PKWiU code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| 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)) |
| PmfProductType | Enumeration: PmfProductType |
PMF | Define production type of an 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)) |
| 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)) |
| PrimaryVendorId | Extended Data Type: ItemPrimaryVendId Type: String |
None | Primary vendor for planned purchase order |
| ProdFlushingPrincip | Enumeration: ProdFlushingPrincipItem |
Prod | Indicates when automatic BOM consumption is reported. |
| ProdGroupId | Extended Data Type: ItemProdGroupId Type: String |
Prod | Production group proposed when creating productions for the item |
| ProdPoolId | Extended Data Type: ItemProdPoolId Type: String |
Prod | Pool proposed when creating productions for the item |
| Product | Extended Data Type: EcoResProductRecId Type: Int64 |
None | Identification of the product |
| projCategoryId | Extended Data Type: ProjCategoryId Type: String |
ProjBasic | Category that is used as a default. |
| PropertyId | Extended Data Type: PropertyIdItem Type: String |
ProdShop | Necessary property when producing the item |
| PurchModel | Extended Data Type: ItemPurchModel Type: Enum |
LogisticsBasic | Update the item automatically with latest purchase price? |
| qtyPerLayer | Extended Data Type: WMSQtyPerLayer Type: Real |
WMSPallet | Quantity per layer on standard pallet |
| RecId | Extended Data Type: RecId Type: Int64 |
None | |
| recVersion | Extended Data Type: RecVersion Type: Integer |
None | |
| ReqGroupId | Extended Data Type: ReqGroupId Type: String |
Req | Group that determines how a requirement is calculated for the item. |
| SADRateCode_PL | Extended Data Type: PlSADRateCode Type: String |
None | Code of item group. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| SalesContributionRatio | Extended Data Type: ItemSalesContributionRatio Type: Real |
LogisticsBasic | Contribution ratio to be used when calculating sales price |
| SalesModel | Extended Data Type: ItemSalesModel Type: Enum |
LogisticsBasic | Calculate sales price of the item by which model? |
| SalesPercentMarkup | Extended Data Type: ItemSalesPercentMarkup Type: Real |
LogisticsBasic | Charges percentage to be used when calculating sales price |
| SalesPriceModelBasic | Enumeration: SalesPriceModelBasic |
LogisticsBasic | Base price to be used when calculating sales price |
| ScrapConst | Extended Data Type: ScrapConst Type: Real |
BOM | Constant scrap in BOM unit (used as default when inserting the item in BOMs) |
| ScrapVar | Extended Data Type: ScrapVar Type: Real |
BOM | Variable scrap in percent (used as default when inserting the item in BOMs) |
| SerialNumGroupId | Extended Data Type: InventNumGroupId Type: String |
LogisticsBasic | Group for automatic serial number allocation |
| ServiceCodeTable_IN | Extended Data Type: RefRecId Type: Int64 |
None | Service code for the service item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| SkipIntraCompanySync_RU | Extended Data Type: SkipIntraCompanySync_RU Type: Enum |
TradeBlanketOrder | Disable intracompany synchronization for agreement line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| sortCode | Extended Data Type: WMSSortCode Type: Integer |
WMSBasic | Sort order of items |
| StandardConfigId | Extended Data Type: ConfigIdStandard Type: String |
Config | Product dimension proposal for variants on order and transaction entries |
| StandardInventColorId | Extended Data Type: EcoResItemColorName Type: String |
EcoResProductColor | Product dimension proposal for variants on order and transaction entries |
| StandardInventSizeId | Extended Data Type: EcoResItemSizeName Type: String |
EcoResProductSize | Product dimension proposal for variants on order and transaction entries |
| StandardInventStyleId | Extended Data Type: EcoResItemStyleName Type: String |
EcoResProductStyle | Product dimension proposal for variants on order and transaction entries (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)) |
| standardPalletQuantity | Extended Data Type: WMSStandardPalletQuantity Type: Real |
WMSPallet | Standard order quantity on a pallet |
| StatisticsFactor | Extended Data Type: IntrastatMarkupPct Type: Real |
ForeignTrade | Portion of the amount in hundredths |
| TaraWeight | Extended Data Type: ItemTaraWeight Type: Real |
LogisticsBasic | The tare weight of the item for an inventory unit |
| TaxationOrigin_BR | Enumeration: FITaxationOrigin_BR |
None | Specifies the item's origin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| TaxFiscalClassification_BR | Extended Data Type: TaxFiscalClassificationId_BR Type: String |
None | Fiscal classification code of the item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| TaxPackagingQty | Extended Data Type: TaxPackagingQty Type: Real |
LedgerBasicSalesTax | Quantity of which packing duty is to be calculated. The quantity is stated per inventory unit. |
| TaxServiceCode_BR | Extended Data Type: TaxServiceCodeId_BR Type: String |
None | Fiscal classification applied for services (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| UnitVolume | Extended Data Type: ItemVolume Type: Real |
LogisticsBasic | Volume in cubic meters of an inventory unit |
| UseAltItemId | Extended Data Type: ItemUseAlternative Type: Enum |
LogisticsBasic | When should alternative item number be used? |
| Width | Extended Data Type: BOMMeasureWidth Type: Real |
None | Factor for the measurement dimension width. |
| WMSArrivalHandlingTime | Extended Data Type: WMSArrivalHandlingTime Type: Integer |
WMSBasic | Time used to arrival update per inventory standard order quantity |
| WMSPalletTypeId | Extended Data Type: WMSPalletTypeId Type: String |
WMSPallet | Standard pallet type for the item |
| WMSPickingQtyTime | Extended Data Type: TimeHour24 Type: Integer |
WMSAdvanced | Time for pick of 1 package |
Top
Field Groups
| Field Group | Fields |
|---|---|
| AllFields | |
| ABC | |
| AlternativeProduct | |
| AlcoholDeclaration_RU | |
| EPItem | |
| Deleted | |
| CaseMoreInformation | |
| Coverage | |
| FixedAssets_RU | |
| Handling | |
| Identification | |
| Integration | |
| IntraCompany_RU | |
| DefaultProductDimensions | |
| EximIncentiveSchemes_IN | |
| FiscalInformation_BR | |
| FiscalLIFO | |
| Intrastat | |
| BOM | |
| AutoReport | |
| Costing | |
| EPC | |
| AutoSummary | |
| Dimension | |
| ExciseTariffcode_IN | |
| BOMCalculation | |
| CustomsTariff_IN | |
| Forecast | |
| EPExternalItem | |
| ForeignTrade | |
| Groups | |
| Item | |
| ItemAlternative | |
| ItemCoverage | |
| ItemData | |
| MarkupCode_RU | |
| Measurement | |
| Name | |
| NaturalTax_LV | |
| InvoiceMatching | |
| InventPriceUpdate | |
| PBAItemAutoGenerated | |
| PdsApprovedVendor | |
| Origin | |
| Packaging | |
| ShippingAndReceiving | |
| PDSPotency | |
| SAD | |
| ProductBuilder | |
| Tracking | |
| WarehouseManagement | |
| PmfYield | |
| ProjAdministration | |
| WeightMeasurements | |
| PdsItemData | |
| WebCategoryBrowsing | |
| PdsItemCustomData | |
| PdsItemRebateGroup | |
| PhysicalDimensions | |
| PriceUpdate | |
| PmfFormulaPlanning | |
| Production | |
| Project | |
| PurchasePriceUpdate | |
| RFIDTagging | |
| SalesAdministration | |
| PurchaseAdministration | |
| SalesPriceUpdate | |
| ServiceCode_IN | |
| ProductConfigurator |
Top
Relations
| Relation | Table | Lines |
|---|---|---|
| AlcoholManufacturer_RU | VendTable | |
| AlcoholProductionType_RU | AlcoholProductionType_RU | |
| AltEcoResColor | EcoResColor | |
| AltEcoResConfiguration | EcoResConfiguration | |
| AltEcoResSize | EcoResSize | |
| AltEcoResStyle | EcoResStyle | |
| AlternativeInventTable | InventTable | |
| BatchNumGroup | InventNumGroup | |
| BOMCalcGroup | BOMCalcGroup | |
| BOMCostGroup | BOMCostGroup | |
| CommissionItemGroup | CommissionItemGroup | |
| CustomsExportTariffCodeTable_IN | CustomsTariffCodeTable_IN | |
| CustomsImportTariffCodeTable_IN | CustomsTariffCodeTable_IN | |
| dataAreaId | DataArea | |
| DefaultDimension | DimensionAttributeValueSet | |
| EcoResProduct | EcoResProduct | |
| ExceptionCode_BR | ExceptionCodeTable_BR | |
| ExciseTariffCodes_IN | ExciseTariffCodes_IN | |
| EximProductGroupTable_IN | EximProductGroupTable_IN | |
| IntrastatItemCode | IntrastatItemCode | |
| IntrastatStatProc | IntrastatStatProc | |
| InventBuyerGroup | InventBuyerGroup | |
| InventFiscalLIFOGroup | InventFiscalLIFOGroup | |
| InventItemPriceToleranceGroup | InventItemPriceToleranceGroup | |
| InventPackagingGroup | InventPackagingGroup | |
| InventProductType_BR | InventProductTypeTable_BR | |
| ItemId | InventTable | |
| LvNRTaxItemGroupHeading | LvNRTaxItemGroupHeading | |
| MarkupCodeVend | MarkupTable | |
| NGPCodesTable_FR | NGPCodesTable_FR | |
| OriginCountryRegion | LogisticsAddressCountryRegion | |
| OriginCounty | LogisticsAddressCounty | |
| OriginState | LogisticsAddressState | |
| Partition | Partitions | |
| PBAInventItemGroup | PBAInventItemGroup | |
| PdsBatchAttrib | PdsBatchAttrib | |
| PdsBatchAttribByItem | PdsBatchAttribByItem | |
| PdsFreightGroup | PdsFreightGroup | |
| PdsItemRebateGroup | PdsItemRebateGroup | |
| PlSADRateGroup | PlSADRateGroup | |
| PmfPlanningItem | InventTable | |
| PrimaryVendTable | VendTable | |
| ProdGroup | ProdGroup | |
| ProdPool | ProdPool | |
| ProjCategory | ProjCategory | |
| RAssetMainGroup | RAssetMainGroup | |
| RAssetTable | RAssetTable | |
| ReqGroup | ReqGroup | |
| SerialNumGroup | InventNumGroup | |
| ServiceCodeTable_IN | ServiceCodeTable_IN | |
| StandardEcoResColor | EcoResColor | |
| StandardEcoResConfiguration | EcoResConfiguration | |
| StandardEcoResSize | EcoResSize | |
| StandardEcoResStyle | EcoResStyle | |
| TaxFiscalClassification_BR | TaxFiscalClassification_BR | |
| TaxServiceCode_BR | TaxServiceCode_BR | |
| UnitOfMeasure | UnitOfMeasure | |
| WMSPalletType | WMSPalletType | |
| WrkCtrProperty | WrkCtrProperty |
Top
Indexes
| Index | AllowDuplicates | Enabled | Fields |
|---|---|---|---|
| CustomsExportTariffCodeTable_INIdx | Yes | Yes | |
| CustomsImportTariffCodeTable_INIdx | Yes | Yes | |
| ExciseTariffCodes_INIdx | Yes | Yes | |
| EximProductGroupTable_INIdx | Yes | Yes | |
| InventFiscalLIFOGroupIdx | Yes | Yes | |
| ItemIdx | No | Yes | |
| NameAliasIdx | Yes | Yes | |
| PmfProductTypePlanningItemIdx | Yes | Yes | |
| ProductIdx | No | Yes | |
| RecId | No | Yes | |
| ServiceCodeTable_INIdx | Yes | Yes | |
| TypeIdx | Yes | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
InventTable Table