InventTable Table [AX 2012]
The InventTable table contains information about items.
Configuration Key: LogisticsBasic| Method | Description | |
|---|---|---|
![]() | 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. |
![]() | 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.) |
![]() ![]() | ::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 |
| 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 |
| 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 |
| 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 |
| 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 |
Community Additions
ADD
Show:
