DMFInventTableEntity Table
The DMFInventTableEntity table contains information about items.
Configuration Key: DMF
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.) |
|
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.) |
|
checkInvalidFieldAccess | Gets and sets invalid field access. (Inherited from xRecord.) |
|
checkRecord | Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.) |
|
checkRestrictedDeleteActions | Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.) |
|
clear | Removes all rows from the table buffer. (Inherited from xRecord.) |
|
company | Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.) |
|
con2buf | Unpacks a container into the table buffers. (Inherited from xRecord.) |
|
concurrencyModel | Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.) |
|
context | Gets and sets the context property. (Inherited from xRecord.) |
|
data | Retrieves a row from the table. (Inherited from xRecord.) |
|
dataSource | Retrieves the data source of the table. (Inherited from xRecord.) |
|
defaultField | Populates default values in a field in the table. (Inherited from xRecord.) |
|
defaultRow | Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.) |
|
delete | Deletes the current record from the table. (Inherited from xRecord.) |
|
disableCache | Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.) |
|
dispose | Releases resources that are used by the xRecord object. (Inherited from xRecord.) |
|
doClear | Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.) |
|
doDelete | Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.) |
|
doInsert | Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.) |
|
doUpdate | Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.) |
|
doValidateDelete | Performs the action to validate that a record can be deleted. (Inherited from xRecord.) |
|
equal | Determines whether the specified object is equal to the current one. (Inherited from xRecord.) |
|
fieldAccessRight | Returns the field access right. (Inherited from xRecord.) |
|
fieldBufferAccessRight | Returns the field access right for the current record. (Inherited from xRecord.) |
|
fieldState | Sets or returns the state of a field in the table buffer. (Inherited from xRecord.) |
|
getAllowRedefault | Returns the list of fields that are allowed to re-default. (Inherited from xRecord.) |
|
getDefaultingDependencies | Returns the container that holds defaulting dependencies. (Inherited from xRecord.) |
|
getExtension | Returns the table extension. (Inherited from xRecord.) |
|
getFieldValue | Gets the value of the specified field from a table buffer. (Inherited from xRecord.) |
|
getInstanceRelationType | Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.) |
|
getPhysicalTableName | Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.) |
|
getPresenceFieldData | Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.) |
|
getSQLStatement | Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.) |
|
getTableInInstanceHierarchy | (Inherited from xRecord.) |
|
getTableType | Indicates the type of the table. (Inherited from xRecord.) |
|
getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) |
|
handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
|
hasRelatedTable | Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.) |
|
helpField | Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.) |
|
initValue | Initializes a field to the default value. (Inherited from xRecord.) |
|
inputStatus | Sets or returns the current input status of the table buffer. (Inherited from xRecord.) |
|
insert | Inserts the record into the table. (Inherited from xRecord.) |
|
interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) |
|
isFieldDataRetrieved | Checks whether the data of the given field has been retrieved. (Inherited from xRecord.) |
|
isFieldSet | Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.) |
|
isFormDataSource | Indicates whether the data source is a form. (Inherited from xRecord.) |
|
isNewRecord | Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.) |
|
isPartOfUOWSaveChanges | (Inherited from xRecord.) |
|
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.) |
|
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.) |
|
merge | Merges the current table with the specified table. (Inherited from xRecord.) |
|
modifiedField | Modifies the specified field to the original. (Inherited from xRecord.) |
|
modifiedFieldValue | Modifies the specified field to the original value. (Inherited from xRecord.) |
|
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.) |
|
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.) |
|
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 | Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.) |
|
reread | Rereads the record from the table. (Inherited from xRecord.) |
|
RowCount | Retrieves the number of rows in the table. (Inherited from xRecord.) |
|
selectForUpdate | Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.) |
|
selectLocked | Indicates whether to select locked records. (Inherited from xRecord.) |
|
selectRefRecord | Selects the record by referenced field ID. (Inherited from xRecord.) |
|
selectWithRepeatableRead | Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.) |
|
setConnection | Sets the user connection for this table. (Inherited from xRecord.) |
|
setCrossPartition | Sets or resets cross-partitioning for the table. (Inherited from xRecord.) |
|
setFieldValue | Sets the field value in the record buffer. (Inherited from xRecord.) |
|
setSQLTracing | Enables or disables SQL tracing mode. (Inherited from xRecord.) |
|
setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) |
|
setTmp | Sets the table so that it is not persisted to the database. (Inherited from xRecord.) |
|
setTmpData | Sets the contents of the temporary table to the specified data. (Inherited from xRecord.) |
|
setXDSContext | Sets new XDS context. (Inherited from xRecord.) |
|
skipAosValidation | Gets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.) |
|
skipDatabaseLog | Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.) |
|
skipDataMethods | Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.) |
|
skipDeleteActions | Gets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.) |
|
skipDeleteMethod | Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.) |
|
skipEvents | Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.) |
|
skipPostLoad | Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.) |
|
skipTTSCheck | Gets and sets the property that indicates whether to skip the check to determine whether the record is selected for update. (Inherited from xRecord.) |
|
suppressWarnings | Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.) |
|
tableAccessRight | Returns the table access right. (Inherited from xRecord.) |
|
tableBufferAccessRight | Returns the table access right for the current record. (Inherited from xRecord.) |
|
takeOwnershipOfTempDBTable | (Inherited from xRecord.) |
|
toolTipField | Retrieves the HelpText value for the specified field. (Inherited from xRecord.) |
|
toolTipRecord | Retrieves the ToolTip value for the current record. (Inherited from xRecord.) |
|
toString | Returns a string that represents the current object. (Inherited from Object.) |
|
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. (Inherited from xRecord.) |
|
usageCount | Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.) |
|
useExistingTempDBTable | (Inherited from xRecord.) |
|
validateDelete | Determines whether the current record is valid and ready to be deleted from the database. (Inherited from xRecord.) |
|
validateField | By-pass validation to the changes of a field in the table DMFInventTableEntity record. |
|
validateFieldValue | (Inherited from xRecord.) |
|
validateWrite | Do not checks if the DMFInventTableEntityrecord can be saved. |
|
validTimeStateUpdateMode | Sets a valid time state update mode on the cursor. (Inherited from xRecord.) |
|
wait | Pauses a process. (Inherited from Object.) |
|
wasCached | Specifies the location from which the data was retrieved. (Inherited from xRecord.) |
|
write | Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.) |
|
xml | Retrieves an XML string that represents the current object. (Inherited from xRecord.) |
Top
Fields
| Field | Type | Configuration key | Description |
|---|---|---|---|
| ABCContributionMargin | Extended Data Type: DMFABC Type: String |
DMF | Item's ABC-code for contribution margin (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ABCRevenue | Extended Data Type: DMFABC Type: String |
DMF | Item's ABC-code for sales (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ABCTieUp | Extended Data Type: DMFABC Type: String |
DMF | Item's ABC-code for inventory carrying cost (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ABCValue | Extended Data Type: DMFABC Type: String |
DMF | Item's ABC-code for inventory value (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. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| AltInventColorId | Extended Data Type: EcoResItemColorName Type: String |
EcoResProductColor | Identification of alternative item color (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| AltInventSizeId | Extended Data Type: EcoResItemSizeName Type: String |
EcoResProductSize | Identification of alternative item size (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| 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) |
| AltItemId | Extended Data Type: ItemIdAlternative Type: String |
LogisticsBasic | Alternative inventory number is used for order entry. (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) |
| 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) |
| AutoReportFinished | Extended Data Type: DMFNoYesStr Type: String |
DMF | Activate automatic report as finished in connection with transactions for the item. (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 (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| BOMCalcGroupId | Extended Data Type: BOMCalcGroupId Type: String |
None | Identification of the calculation group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| BOMLevel | Extended Data Type: ItemBOMLevel Type: Integer |
BOM | Calculated BOM level on latest requirement calculation (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| BOMManualReceipt | Extended Data Type: DMFNoYesStr Type: String |
DMF | Manually enter material profit for this item for a production? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| BOMUnitId | Extended Data Type: BOMUnitId Type: String |
BOM | BOM consumption unit (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| CommissionGroupId | Extended Data Type: CommissItemGroup Type: String |
Commission | Commission group the item is attached to. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| CostGroupId | Extended Data Type: CostGroupId Type: String |
BOM | Cost group the item is included in on BOM calculations. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| CostModel | Extended Data Type: DMFNoYesStr Type: String |
DMF | Update the item automatically with latest cost price? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| CustomsTariffCodeTable_IN_Dir_Exp | Extended Data Type: DMFDirection_IN Type: String |
DMF | Type of direction for the tariff code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| CustomsTariffCodeTable_IN_Dir_Imp | Extended Data Type: DMFDirection_IN Type: String |
DMF | Type of direction for the tariff code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| CustomsTariffCodeTable_IN_TariffCode_Exp | Extended Data Type: CustomsTariffCode_IN Type: String |
None | Enter the tariff code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| CustomsTariffCodeTable_IN_TariffCode_Imp | Extended Data Type: CustomsTariffCode_IN Type: String |
None | Enter the tariff code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| DefaultDimension | Extended Data Type: DMFDefaultDimensionStr Type: String |
DMF | <Dimension1>:<Dimension2>:...<DimensionN> (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| DefaultInventSiteId | Extended Data Type: InventSiteId Type: String |
LogisticsBasic | Identify the site (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| DefaultOrderType | Extended Data Type: DMFReqPOType Type: String |
DMF | Current planned order type when coverage planning. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| DefinitionGroup | Extended Data Type: DMFDefinationGroupName Type: String |
DMF | Processing group name (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| Density | Extended Data Type: BOMMeasureDensity Type: Real |
None | Measurement conversion factor for the density dimension. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| Depth | Extended Data Type: BOMMeasureDepth Type: Real |
None | Measurement conversion factor for the depth dimension. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| DisplayProductNumber | Extended Data Type: EcoResProductDisplayProductNumber Type: String |
LogisticsBasic | Identification of the product (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| EPCManager | Extended Data Type: EPCManager Type: Real |
RFID | The EPC manager of the item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| 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) |
| ExciseTariffCodes_IN_TariffCode | Extended Data Type: TariffCode_IN Type: String |
None | Select the excise tariff code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ExecutionId | Extended Data Type: DMFExecutionId Type: String |
DMF | Identification of the job (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| EximProductGroupTable_IN_ProductGroup | Extended Data Type: EximProductGroup_IN Type: String |
None | Unique identification of the product group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| FiscalLIFOAvoidCalc | Extended Data Type: DMFNoYesStr Type: String |
DMF | Exclude items from fiscal LIFO calculation. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| FiscalLIFONormalValue | Extended Data Type: InventFiscalLIFONormalValue Type: Real |
None | Normal value for the group or item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| FiscalLIFONormalValueCalc | Extended Data Type: DMFInventFiscalLIFONormalValueCalc Type: String |
DMF | Should normal value be calculated (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| FITaxationOrigin_BR | Extended Data Type: DMFFITaxationOrigin_BR Type: String |
DMF | Specifies the item's origin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ForecastDMPInclude | Extended Data Type: DMFNoYesStr Type: String |
DMF | Include in demand planning. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| grossDepth | Extended Data Type: InventDepth Type: Real |
LogisticsBasic | Unit depth incl. packing (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| grossHeight | Extended Data Type: InventHeight Type: Real |
LogisticsBasic | Unit height incl. packing (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| grossWidth | Extended Data Type: InventWidth Type: Real |
LogisticsBasic | Unit width incl. packing (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| GroupId | Extended Data Type: InventFiscalLIFOGroupId Type: String |
None | Identification of fiscal LIFO reporting group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| Height | Extended Data Type: BOMMeasureHeight Type: Real |
None | Measurement conversion factor for the height dimension. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ICMSonService_BR | Extended Data Type: DMFNoYesStr Type: String |
DMF | ICMS tax applied on service item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| Intracode | Extended Data Type: IntrastatItemCodeId Type: String |
ForeignTrade | Item commodity code (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| IntrastatExclude | Extended Data Type: DMFNoYesStr Type: String |
DMF | 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) |
| 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) |
| IntraUnit | Extended Data Type: IntrastatConvert Type: Real |
ForeignTrade | Quantity of additional units per inventory unit, used for Intrastat. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventModuleInvent_MaximumRetailPrice_IN | Extended Data Type: MaximumRetailPrice_IN Type: Real |
None | Maximum retail price per the number of units specified in the Price unit field. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventModuleInvent_PDSPricingPrecision | Extended Data Type: PDSPricingPrecision Type: Integer |
PDSPotency | Pricing precision that is used to round the unit price during attribute-based pricing calculations (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventModulePurch_PDSPricingPrecision | Extended Data Type: PDSPricingPrecision Type: Integer |
PDSPotency | Pricing precision that is used to round the unit price during attribute-based pricing calculations (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventModuleSales_MaximumRetailPrice_IN | Extended Data Type: MaximumRetailPrice_IN Type: Real |
None | Maximum retail price per the number of units specified in the Price unit field. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| 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) |
| InventSetup_ATPApplyDemandTimeFence | Extended Data Type: SalesATPApplyDemandTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going forward from today, when delayed demand orders are considered as issues. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventSetup_ATPApplySupplyTimeFence | Extended Data Type: SalesATPApplySupplyTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going forward from today, when delayed supply orders are considered as receipts. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventSetup_ATPBackwardDemandTimeFence | Extended Data Type: SalesATPBackwardDemandTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going backward from today, for considering delayed demand orders in ATP calculation. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventSetup_ATPBackwardSupplyTimeFence | Extended Data Type: SalesATPBackwardSupplyTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going backward from today, for considering delayed supply orders in ATP calculation. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventSetup_ATPTimeFence | Extended Data Type: SalesATPTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going forward from today, for calculating ATP. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventSetup_HighestQty | Extended Data Type: QtyHighest Type: Real |
None | Maximum quantity applying to item transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventSetup_LeadTime | Extended Data Type: LeadTimeInventDefault Type: Integer |
LogisticsBasic | Default lead time or lead time in number of days (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventSetup_LowestQty | Extended Data Type: QtyLowest Type: Real |
None | Minimum quantity applying to item transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventSetup_MultipleQty | Extended Data Type: QtyMultiples Type: Real |
None | Multiples quantity during packing or production (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventSetup_Override | Extended Data Type: DMFNoYesStr Type: String |
DMF | Display Yes / No (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventSetup_StandardQty | Extended Data Type: QtyStandard Type: Real |
None | Standard order quantity applying to item transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventSetup_Stopped | Extended Data Type: DMFNoYesStr Type: String |
DMF | Display Yes / No (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventSiteId | Extended Data Type: InventSiteId Type: String |
LogisticsBasic | Identify the site (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTable_Description | Extended Data Type: String255 Type: String |
None | String of length 255 (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_EndDisc | Extended Data Type: DMFNoYesStr Type: String |
DMF | Is the item included in the calculation of a combined total discount? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_LineDisc | Extended Data Type: InventLineDiscCode Type: String |
PriceDisc | Unique identification of line discount (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_MarkupSecCur_RU | Extended Data Type: InventPriceMarkupSecCur_RU Type: Real |
LogisticsBasic | Fixed charges on price, applied once for each invoice (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_MaxiRetPrice_IN | Extended Data Type: MaximumRetailPrice_IN Type: Real |
None | Maximum retail price per the number of units specified in the Price unit field. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_MaxPriceInclVAT | Extended Data Type: RetailPriceInclVAT Type: Real |
Retail | Price including value added tax (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_MinPriceInclVAT | Extended Data Type: RetailPriceInclVAT Type: Real |
Retail | Price including value added tax (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_MultiLineDisc | Extended Data Type: InventMultiLineDiscCode Type: String |
PriceDisc | Determines multiline discount of the item for several invoice lines in the module. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_OverDeliveryPct | Extended Data Type: OverDeliveryPct Type: Real |
LogisticsOverUnderDelivery | The percentage by which the product receipt quantity is allowed to exceed the order quantity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_PDSPricPrecision | Extended Data Type: PDSPricingPrecision Type: Integer |
PDSPotency | Pricing precision that is used to round the unit price during attribute-based pricing calculations (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_Price | Extended Data Type: Price Type: Real |
None | Price per the number of units specified in the Price unit field. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_PriceDate | Extended Data Type: PriceDate Type: Date |
None | Date when price was last modified. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_PriceInclVAT | Extended Data Type: RetailPriceInclVAT Type: Real |
Retail | Price including value added tax (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_PriceQty | Extended Data Type: PriceQty Type: Real |
None | Quantity to be used when allocating the specified charges on price per unit. Requires selection of the Incl. in unit price field. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_PriceSecCur_RU | Extended Data Type: CostPriceSecCur_RU Type: Real |
LogisticsBasic | Run-dependent cost price per unit. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_PriceUnit | Extended Data Type: PriceUnit Type: Real |
LogisticsBasic | Number of units the price is specified in. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_TaxItemGroupId | Extended Data Type: TaxItemGroup Type: String |
LedgerBasicSalesTax | Module-specific item sales tax group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_UnderDeliveryPct | Extended Data Type: OverDeliveryPct Type: Real |
LogisticsOverUnderDelivery | The percentage by which the product receipt quantity is allowed to exceed the order quantity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInvent_UnitId | Extended Data Type: UnitOfMeasureSymbol Type: String |
None | Unit which the module is run in (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInventPurch_EndDisc | Extended Data Type: DMFNoYesStr Type: String |
DMF | Is the item included in the calculation of a combined total discount? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleInventSales_EndDisc | Extended Data Type: DMFNoYesStr Type: String |
DMF | Is the item included in the calculation of a combined total discount? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_LineDisc | Extended Data Type: InventLineDiscCode Type: String |
PriceDisc | Unique identification of line discount (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_MarkupSecCur_RU | Extended Data Type: InventPriceMarkupSecCur_RU Type: Real |
LogisticsBasic | Fixed charges on price, applied once for each invoice (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_MaxiRetPrice_IN | Extended Data Type: MaximumRetailPrice_IN Type: Real |
None | Maximum retail price per the number of units specified in the Price unit field. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_MaxPriceInclVAT | Extended Data Type: RetailPriceInclVAT Type: Real |
Retail | Price including value added tax (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_MinPriceInclVAT | Extended Data Type: RetailPriceInclVAT Type: Real |
Retail | Price including value added tax (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_MultiLineDisc | Extended Data Type: InventMultiLineDiscCode Type: String |
PriceDisc | Determines multiline discount of the item for several invoice lines in the module. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_OverDeliveryPct | Extended Data Type: OverDeliveryPct Type: Real |
LogisticsOverUnderDelivery | The percentage by which the product receipt quantity is allowed to exceed the order quantity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_PDSPricPrecision | Extended Data Type: PDSPricingPrecision Type: Integer |
PDSPotency | Pricing precision that is used to round the unit price during attribute-based pricing calculations (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_Price | Extended Data Type: Price Type: Real |
None | Price per the number of units specified in the Price unit field. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_PriceDate | Extended Data Type: PriceDate Type: Date |
None | Date when price was last modified. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_PriceInclVAT | Extended Data Type: RetailPriceInclVAT Type: Real |
Retail | Price including value added tax (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_PriceQty | Extended Data Type: PriceQty Type: Real |
None | Quantity to be used when allocating the specified charges on price per unit. Requires selection of the Incl. in unit price field. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_PriceSecCur_RU | Extended Data Type: CostPriceSecCur_RU Type: Real |
LogisticsBasic | Run-dependent cost price per unit. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_PriceUnit | Extended Data Type: PriceUnit Type: Real |
LogisticsBasic | Number of units the price is specified in. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_TaxItemGroupId | Extended Data Type: TaxItemGroup Type: String |
LedgerBasicSalesTax | Module-specific item sales tax group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_UnderDeliveryPct | Extended Data Type: OverDeliveryPct Type: Real |
LogisticsOverUnderDelivery | The percentage by which the product receipt quantity is allowed to exceed the order quantity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModulePurch_UnitId | Extended Data Type: UnitOfMeasureSymbol Type: String |
None | Unit which the module is run in (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_LineDisc | Extended Data Type: InventLineDiscCode Type: String |
PriceDisc | Unique identification of line discount (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_MarkupSecCur_RU | Extended Data Type: InventPriceMarkupSecCur_RU Type: Real |
LogisticsBasic | Fixed charges on price, applied once for each invoice (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_MaxiRetPrice_IN | Extended Data Type: MaximumRetailPrice_IN Type: Real |
None | Maximum retail price per the number of units specified in the Price unit field. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_MaxPriceInclVAT | Extended Data Type: RetailPriceInclVAT Type: Real |
Retail | Price including value added tax (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_MinPriceInclVAT | Extended Data Type: RetailPriceInclVAT Type: Real |
Retail | Price including value added tax (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_MultiLineDisc | Extended Data Type: InventMultiLineDiscCode Type: String |
PriceDisc | Determines multiline discount of the item for several invoice lines in the module. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_OverDeliveryPct | Extended Data Type: OverDeliveryPct Type: Real |
LogisticsOverUnderDelivery | The percentage by which the product receipt quantity is allowed to exceed the order quantity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_PDSPricPrecision | Extended Data Type: PDSPricingPrecision Type: Integer |
PDSPotency | Pricing precision that is used to round the unit price during attribute-based pricing calculations (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_Price | Extended Data Type: Price Type: Real |
None | Price per the number of units specified in the Price unit field. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_PriceDate | Extended Data Type: PriceDate Type: Date |
None | Date when price was last modified. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_PriceInclVAT | Extended Data Type: RetailPriceInclVAT Type: Real |
Retail | Price including value added tax (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_PriceQty | Extended Data Type: PriceQty Type: Real |
None | Quantity to be used when allocating the specified charges on price per unit. Requires selection of the Incl. in unit price field. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_PriceSecCur_RU | Extended Data Type: CostPriceSecCur_RU Type: Real |
LogisticsBasic | Run-dependent cost price per unit. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_PriceUnit | Extended Data Type: PriceUnit Type: Real |
LogisticsBasic | Number of units the price is specified in. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_TaxItemGroupId | Extended Data Type: TaxItemGroup Type: String |
LedgerBasicSalesTax | Module-specific item sales tax group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_UnderDeliveryPct | Extended Data Type: OverDeliveryPct Type: Real |
LogisticsOverUnderDelivery | The percentage by which the product receipt quantity is allowed to exceed the order quantity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| InventTableModuleSales_UnitId | Extended Data Type: UnitOfMeasureSymbol Type: String |
None | Unit which the module is run in (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| IsSelected | Extended Data Type: DMFIsSelected Type: Enum |
DMF | Select the record for migration from staging to target (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ItemBuyerGroupId | Extended Data Type: ItemBuyerGroupId Type: String |
LogisticsBasic | Identification of the buyer group. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ItemDimCostPrice | Extended Data Type: DMFNoYesStr Type: String |
DMF | Activate, use, and maintain cost prices for product variants. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ItemGroupId | Extended Data Type: ItemGroupId Type: String |
LogisticsBasic | Identification of item group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ItemId | Extended Data Type: ItemId Type: String |
LogisticsBasic | Identify item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ItemInventLocationId | Extended Data Type: InventLocationId Type: String |
LogisticsBasic | Identify the warehouse. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ItemPriceToleranceGroupId | Extended Data Type: ItemPriceToleranceGroupId Type: String |
PurchInvoiceMatching | Identification of item price tolerance group for accounts payable invoice matching (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ItemTaggingLevel | Extended Data Type: DMFRFIDItemTaggingLevel Type: String |
DMF | Is item tagging mandatory? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ItemType | Extended Data Type: DMFItemType Type: String |
DMF | Type determining how the item is administered. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| LowestQty | Extended Data Type: QtyLowest Type: Real |
None | Minimum quantity applying to item transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| 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) |
| MatchingPolicy | Extended Data Type: DMFMatchingPolicy Type: String |
DMF | Default policy for PO lines. Three-way: PO, product receipt, and invoice. Two-way: PO and invoice. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| MinimumPalletQuantity | Extended Data Type: WMSMinimumPalletQuantity Type: Real |
WMSPallet | Minimum quantity for pallets used for output transports (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ModelGroupId | Extended Data Type: InventModelGroupId Type: String |
LogisticsBasic | Identification of item model group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| NameAlias | Extended Data Type: ItemNameAlias Type: String |
LogisticsBasic | Find fast name applying to the item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| NetWeight | Extended Data Type: ItemNetWeight Type: Real |
LogisticsBasic | Net weight of inventory item for one inventory unit (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| 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) |
| OrigCountryRegionId | Extended Data Type: ItemOrigCountryRegionId Type: String |
ForeignTrade | Country/region of origin of the current inventory item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| OrigCountyId | Extended Data Type: ItemOrigCountyId Type: String |
ForeignTrade | County of origin of the current inventory item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| OrigStateId | Extended Data Type: ItemOrigStateId Type: String |
ForeignTrade | State of origin for the current item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PackagingGroupId | Extended Data Type: ItemPackagingGroupId Type: String |
InventPackaging | Identification of the packing group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| 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) |
| PalletTagging | Extended Data Type: DMFNoYesStr Type: String |
DMF | Is pallet tagging mandatory? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| Partition | Extended Data Type: Partition Type: Int64 |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PBAAutostart | Extended Data Type: DMFNoYesStr Type: String |
DMF | Autostart of configuration dialog when entering a modeling enabled item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PBAHideApproval | Extended Data Type: DMFNoYesStr Type: String |
DMF | Hide approval dialog after acknowledgement of configuration details (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PBAHideDialog | Extended Data Type: DMFNoYesStr Type: String |
DMF | Hide dialog for automatic configuration based on default values (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PBAInventItemGroupId | Extended Data Type: PBAInventItemGroupId Type: String |
PBA_ProductBuilder | Identification of the item product model group. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PBAItemAutoGenerated | Extended Data Type: DMFNoYesStr Type: String |
DMF | Generated item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PBAItemConfigurable | Extended Data Type: DMFNoYesStr Type: String |
DMF | Can this item be modeled in the Product Builder? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PBAMandatoryConfig | Extended Data Type: DMFNoYesStr Type: String |
DMF | Check item lines for complete configuration details (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) |
| PDSPotencyAttribRecording | Extended Data Type: DMFPDSPotencyAttribRecordingEnum Type: String |
DMF | 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) |
| 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) |
| 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) |
| 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) |
| PdsVendorCheckItem | Extended Data Type: DMFPdsVendorCheckItem Type: String |
DMF | 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) |
| Phantom | Extended Data Type: DMFNoYesStr Type: String |
DMF | Propose item as phantom item in bills of materials? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| 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) |
| 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) |
| PmfProductType | Extended Data Type: DMFPmfProductType Type: String |
DMF | Define production type of an item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| 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) |
| PrimaryVendorId | Extended Data Type: ItemPrimaryVendId Type: String |
None | Primary vendor for planned purchase order (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| projCategoryId | Extended Data Type: ProjCategoryId Type: String |
ProjBasic | Category that is used as a default. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PropertyId | Extended Data Type: PropertyIdItem Type: String |
ProdShop | Necessary property when producing the item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchInventLocationId | Extended Data Type: InventLocationId Type: String |
LogisticsBasic | Identify the warehouse. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchModel | Extended Data Type: DMFNoYesStr Type: String |
DMF | Update the item automatically with latest purchase price? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchSetup_ATPApplyDemandTimeFenc | Extended Data Type: SalesATPApplyDemandTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going forward from today, when delayed demand orders are considered as issues. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchSetup_ATPApplySupplyTimeFenc | Extended Data Type: SalesATPApplySupplyTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going forward from today, when delayed supply orders are considered as receipts. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchSetup_ATPBackwardDemandTimeF | Extended Data Type: SalesATPBackwardDemandTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going backward from today, for considering delayed demand orders in ATP calculation. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchSetup_ATPBackwardSupplyTimeF | Extended Data Type: SalesATPBackwardSupplyTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going backward from today, for considering delayed supply orders in ATP calculation. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchSetup_ATPTimeFence | Extended Data Type: SalesATPTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going forward from today, for calculating ATP. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchSetup_HighestQty | Extended Data Type: QtyHighest Type: Real |
None | Maximum quantity applying to item transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchSetup_LeadTime | Extended Data Type: LeadTimeInventDefault Type: Integer |
LogisticsBasic | Default lead time or lead time in number of days (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchSetup_LowestQty | Extended Data Type: QtyLowest Type: Real |
None | Minimum quantity applying to item transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchSetup_MultipleQty | Extended Data Type: QtyMultiples Type: Real |
None | Multiples quantity during packing or production (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchSetup_Override | Extended Data Type: DMFNoYesStr Type: String |
DMF | Display Yes / No (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchSetup_StandardQty | Extended Data Type: QtyStandard Type: Real |
None | Standard order quantity applying to item transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| PurchSetup_Stopped | Extended Data Type: DMFNoYesStr Type: String |
DMF | Display Yes / No (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| qtyPerLayer | Extended Data Type: WMSQtyPerLayer Type: Real |
WMSPallet | Quantity per layer on standard pallet (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| RecId | Extended Data Type: RecId Type: Int64 |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| recVersion | Extended Data Type: RecVersion Type: Integer |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ReleaseProductCompany | Extended Data Type: Name Type: String |
None | Name. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ReqGroupId | Extended Data Type: ReqGroupId Type: String |
Req | Group that determines how a requirement is calculated for the item. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| 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) |
| SalesContributionRatio | Extended Data Type: ItemSalesContributionRatio Type: Real |
LogisticsBasic | Contribution ratio to be used when calculating sales price (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesInventLocationId | Extended Data Type: InventLocationId Type: String |
LogisticsBasic | Identify the warehouse. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesModel | Extended Data Type: DMFSalesPriceModel Type: String |
DMF | Calculate sales price of the item by which model? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesPercentMarkup | Extended Data Type: ItemSalesPercentMarkup Type: Real |
LogisticsBasic | Charges percentage to be used when calculating sales price (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesPriceModelBasic | Extended Data Type: DMFSalesPriceModelBasic Type: String |
DMF | Base price to be used when calculating sales price (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesSetup_ATPApplyDemandTimeFenc | Extended Data Type: SalesATPApplyDemandTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going forward from today, when delayed demand orders are considered as issues. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesSetup_ATPApplySupplyTimeFenc | Extended Data Type: SalesATPApplySupplyTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going forward from today, when delayed supply orders are considered as receipts. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesSetup_ATPBackwardDemandTimeF | Extended Data Type: SalesATPBackwardDemandTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going backward from today, for considering delayed demand orders in ATP calculation. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesSetup_ATPBackwardSupplyTimeF | Extended Data Type: SalesATPBackwardSupplyTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going backward from today, for considering delayed supply orders in ATP calculation. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesSetup_ATPTimeFence | Extended Data Type: SalesATPTimeFence Type: Integer |
SalesDeliveryDateControl | Time period in days, going forward from today, for calculating ATP. This applies only if the delivery date control is set to ATP or ATP + Issue margin. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesSetup_HighestQty | Extended Data Type: QtyHighest Type: Real |
None | Maximum quantity applying to item transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesSetup_LeadTime | Extended Data Type: LeadTimeInventDefault Type: Integer |
LogisticsBasic | Default lead time or lead time in number of days (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesSetup_LowestQty | Extended Data Type: QtyLowest Type: Real |
None | Minimum quantity applying to item transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesSetup_MultipleQty | Extended Data Type: QtyMultiples Type: Real |
None | Multiples quantity during packing or production (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesSetup_Override | Extended Data Type: DMFNoYesStr Type: String |
DMF | Display Yes / No (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesSetup_StandardQty | Extended Data Type: QtyStandard Type: Real |
None | Standard order quantity applying to item transactions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SalesSetup_Stopped | Extended Data Type: DMFNoYesStr Type: String |
DMF | Display Yes / No (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ScrapConst | Extended Data Type: ScrapConst Type: Real |
BOM | Constant scrap in BOM unit (used as default when inserting the item in BOMs) (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ScrapVar | Extended Data Type: ScrapVar Type: Real |
BOM | Variable scrap in percent (used as default when inserting the item in BOMs) (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SerialNumGroupId | Extended Data Type: InventNumGroupId Type: String |
LogisticsBasic | Group for automatic serial number allocation (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| ServiceCodeTable_IN_ServiceCode | Extended Data Type: ServiceCode_IN Type: String |
None | Define the service code. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| SkipIntraCompanySync_RU | Extended Data Type: DMFNoYesStr Type: String |
DMF | Disable intracompany synchronization for agreement line. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| sortCode | Extended Data Type: WMSSortCode Type: Integer |
WMSBasic | Sort order of items (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| StandardConfigId | Extended Data Type: ConfigIdStandard Type: String |
Config | Product dimension proposal for variants on order and transaction entries (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| StandardInventColorId | Extended Data Type: EcoResItemColorName Type: String |
EcoResProductColor | Product dimension proposal for variants on order and transaction entries (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| StandardInventSizeId | Extended Data Type: EcoResItemSizeName Type: String |
EcoResProductSize | Product dimension proposal for variants on order and transaction entries (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| 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) |
| standardPalletQuantity | Extended Data Type: WMSStandardPalletQuantity Type: Real |
WMSPallet | Standard order quantity on a pallet (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| StatisticsFactor | Extended Data Type: IntrastatMarkupPct Type: Real |
ForeignTrade | Portion of the amount in hundredths (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| TaraWeight | Extended Data Type: ItemTaraWeight Type: Real |
LogisticsBasic | The tare weight of the item for an inventory unit (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| 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) |
| TaxPackagingQty | Extended Data Type: TaxPackagingQty Type: Real |
LedgerBasicSalesTax | Quantity of which packing duty is to be calculated. The quantity is stated per inventory unit. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| 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) |
| TransferStatus | Enumeration: DMFTransferStatus |
None | Transfer status for active record (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| UnitVolume | Extended Data Type: ItemVolume Type: Real |
LogisticsBasic | Volume in cubic meters of an inventory unit (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| UseAltItemId | Extended Data Type: DMFABC Type: String |
DMF | Never|When|Always (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| VariantConfigurationTechnology | Extended Data Type: DMFVariantConfigurationTechnology Type: String |
DMF | Specifies configuration technology used to configure product variants (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| Width | Extended Data Type: BOMMeasureWidth Type: Real |
None | Factor for the measurement dimension width. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| WMSArrivalHandlingTime | Extended Data Type: WMSArrivalHandlingTime Type: Integer |
WMSBasic | Time used to arrival update per inventory standard order quantity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| WMSPalletTypeId | Extended Data Type: WMSPalletTypeId Type: String |
WMSPallet | Standard pallet type for the item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| WMSPickingQtyTime | Extended Data Type: TimeHour24 Type: Integer |
None | Time for pick of 1 package (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Top
Field Groups
| Field Group | Fields |
|---|---|
| DMF | |
| AutoReport | |
| ExclusionList |
Top
Relations
| Relation | Table | Lines |
|---|---|---|
| DMFDefinitionGroup | DMFDefinitionGroup | |
| DMFExecution | DMFExecution | |
| InventFiscalLIFOGroup | InventFiscalLIFOGroup | |
| InventModelGroup | InventModelGroup | |
| InventNumGroup | InventNumGroup | |
| InventProductTypeTable_BR | InventProductTypeTable_BR | |
| InventTable | InventTable | |
| InventTable_PmfPlanningItemId | InventTable | |
| LvNRTaxItemGroupHeading | LvNRTaxItemGroupHeading | |
| Partition | Partitions | |
| RAssetMainGroup | RAssetMainGroup | |
| RAssetTable | RAssetTable |
Top
Indexes
| Index | AllowDuplicates | Enabled | Fields |
|---|---|---|---|
| ItemIdx | No | Yes | |
| RecId | No | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
DMFInventTableEntity Table