InventTable Table
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