RetailMassUpdateWorksheetLine Table
The RetailMassUpdateWorksheetLine contains all the product property column.
Configuration Key: Retail
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.) |
|
insertFromAddProducts | Inserts a record into the RetailMassUpdateWorksheetLine table which are selected on the add products form. |
|
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.) |
|
productName | This method returns the product name in the current user's language. |
|
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 | This method is called whenever a record is updated in RetailMassUpdateWorksheetLine table. |
|
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. |
|
validateField | Determines whether the specified field is valid. (Inherited from xRecord.) |
|
validateFieldValue | (Inherited from xRecord.) |
|
validateWrite | Determines whether the current record is valid and ready to be written. (Inherited from xRecord.) |
|
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.) |
|
workSheetTable | Finds the corresponding record in RetailMassUpdateWorksheetTablefor current record in RetailMassUpdateWorksheetLine table |
|
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.) |
.gif "Static member") |
::findFieldName | Checks for the presence of a field with the given name in RetailMassUpdateWorksheetLine table. |
|
::findItemId | Finds a record of RetailMassUpdateWorksheetLine table. |
Top
Fields
| Field | Type | Configuration key | Description |
|---|---|---|---|
| dataAreaId | Extended Data Type: DataAreaId Type: String |
None | (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)) |
| EcoResProductRecId | Extended Data Type: EcoResProductRecId Type: Int64 |
None | Identification of the product (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)) |
| EcoResProductTranslation | Extended Data Type: RefRecId Type: Int64 |
None | Reference field in a different table (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)) |
| EcoResProductTranslation_Description | Extended Data Type: EcoResDescription Type: String |
LogisticsBasic | Additional description of the product (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)) |
| Invent_AllocateMarkup | Extended Data Type: PriceAllocateMarkup Type: Enum |
None | Include the price charges in the unit price of the various units specified in the Price quantity field? (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)) |
| Invent_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| Invent_Price | Extended Data Type: Price Type: Real |
None | Run-dependent price per unit. (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)) |
| Invent_PriceDate | Extended Data Type: PriceDate Type: Date |
None | Date attached to the price (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)) |
| Invent_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| Invent_UnderDeliveryPct | Extended Data Type: UnderDeliveryPct Type: Real |
LogisticsOverUnderDelivery | The percentage by which the product receipt quantity is allowed to be less than the order quantity (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)) |
| Invent_UnitId | Extended Data Type: UnitOfMeasureSymbol Type: String |
None | Unit symbol (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)) |
| InventItemGroupItem_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventItemLocation_CountGroupId | Extended Data Type: CountGroupId Type: String |
LogisticsBasic | Identification of counting group (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)) |
| InventModelGroupItem_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_ABCContributionMargin | Enumeration: ABC |
None | Item's ABC-code for contribution margin (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)) |
| InventTable_ABCRevenue | Enumeration: ABC |
None | Item's ABC-code for sales (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)) |
| InventTable_ABCTieUp | Enumeration: ABC |
None | Item's ABC-code for inventory carrying cost (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)) |
| InventTable_ABCValue | Enumeration: ABC |
None | Item's ABC-code for inventory value (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)) |
| InventTable_CommissionGroupId | Extended Data Type: CommissItemGroup Type: String |
Commission | Identification of commission item group (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)) |
| InventTable_CostGroupId | Extended Data Type: CostGroupId Type: String |
BOM | Identification of the cost group (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)) |
| InventTable_CostModel | Extended Data Type: ItemCostModel Type: Enum |
LogisticsBasic | Update the item automatically with latest cost price? (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)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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)) |
| InventTable_grossDepth | Extended Data Type: InventDepth Type: Real |
LogisticsBasic | Standard depth (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)) |
| InventTable_grossHeight | Extended Data Type: InventHeight Type: Real |
LogisticsBasic | Standard height (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)) |
| InventTable_grossWidth | Extended Data Type: InventWidth Type: Real |
LogisticsBasic | Standard width (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)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_NameAlias | Extended Data Type: NameAlias Type: String |
None | Specify text for fast search (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)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_PurchModel | Extended Data Type: ItemPurchModel Type: Enum |
LogisticsBasic | Update the item automatically with latest purchase price? (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)) |
| InventTable_qtyPerLayer | 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)) |
| InventTable_ReqGroupId | Extended Data Type: ReqGroupId Type: String |
Req | Identification of the coverage group. (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)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_SalesPriceModelBasic | Enumeration: SalesPriceModelBasic |
LogisticsBasic | Base price to be used when calculating sales price (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)) |
| InventTable_sortCode | Extended Data Type: WMSSortCode Type: Integer |
WMSBasic | Sort order of locations. (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)) |
| InventTable_standardPalletQuantity | 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)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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)) |
| InventTable_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)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_UseAltItemId | Extended Data Type: ItemUseAlternative Type: Enum |
LogisticsBasic | When should alternative item number be used? (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)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| InventTable_WMSPalletTypeId | Extended Data Type: WMSPalletTypeId Type: String |
WMSPallet | Description of the bearer (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)) |
| InventTable_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| IssueDate | Extended Data Type: TransDate Type: Date |
None | Transaction 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)) |
| ItemId | Extended Data Type: ItemId Type: String |
LogisticsBasic | Identify 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)) |
| 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)) |
| Purch_AllocateMarkup | Extended Data Type: PriceAllocateMarkup Type: Enum |
None | Include the price charges in the unit price of the various units specified in the Price quantity field? (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)) |
| Purch_EndDisc | Enumeration: NoYes |
None | 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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| Purch_InterCompanyBlocked | Extended Data Type: InterCompanyBlocked Type: Enum |
TradeInterCompany | Intercompany is stopped. (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)) |
| Purch_LineDisc | Extended Data Type: InventLineDiscCode Type: String |
PriceDisc | Specify item's line discount group in module (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)) |
| Purch_Markup | Extended Data Type: InventPriceMarkup 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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| Purch_MarkupGroupId | Extended Data Type: InventMarkupGroupId Type: String |
Markup | Specify charges group for the item in the module (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)) |
| Purch_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| Purch_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| Purch_Price | Extended Data Type: Price Type: Real |
None | Run-dependent price per unit. (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)) |
| Purch_PriceDate | Extended Data Type: PriceDate Type: Date |
None | Date attached to the price (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)) |
| Purch_PriceQty | Extended Data Type: PriceQty Type: Real |
None | Quantity that price and charges are applicable to (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)) |
| Purch_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| Purch_SuppItemGroupId | Extended Data Type: InventSuppItemGroupId Type: String |
SuppItem | Specify the supplementary item group of the item in the module (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)) |
| Purch_TaxItemGroupId | Extended Data Type: TaxItemGroup Type: String |
LedgerBasicSalesTax | Group of sales tax codes that can be calculated for 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)) |
| Purch_UnderDeliveryPct | Extended Data Type: UnderDeliveryPct Type: Real |
LogisticsOverUnderDelivery | The percentage by which the product receipt quantity is allowed to be less than the order quantity (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)) |
| Purch_UnitId | Extended Data Type: UnitOfMeasureSymbol Type: String |
None | Unit symbol (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)) |
| RecId | Extended Data Type: RecId Type: Int64 |
None | (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)) |
| recVersion | Extended Data Type: RecVersion Type: Integer |
None | (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)) |
| RetailInvent_BarcodeSetupId | Extended Data Type: BarcodeSetupId Type: String |
None | Select or view the bar code setup 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)) |
| RetailInvent_baseComparisonUnitCode | Extended Data Type: UnitOfMeasureSymbol Type: String |
None | Unit symbol (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)) |
| RetailInvent_blockedOnPOS | Extended Data Type: RetailBlocked Type: Enum |
None | Blocked at register (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)) |
| RetailInvent_ConcessionContractItem | Extended Data Type: NoYesId Type: Enum |
None | Product used cost on concession contract (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)) |
| RetailInvent_concessionVendAccount | Extended Data Type: RetailConcessionVendAccountNum Type: String |
RetailConcession | Vendor account number. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| RetailInvent_dateToActivateItem | Extended Data Type: RetailDateToActivateItem Type: Date |
None | Transaction 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)) |
| RetailInvent_dateToBeBlocked | Extended Data Type: RetailDateToBeBlocked Type: Date |
None | Transaction 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)) |
| RetailInvent_KeyingInPrice | Extended Data Type: RetailKeyingInPrice Type: Enum |
Retail | Requirements for keying in the price (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| RetailInvent_KeyingInQty | Extended Data Type: RetailKeyingInQty Type: Enum |
Retail | Requirements for keying in the quantity (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| RetailInvent_mustKeyInComment | Extended Data Type: RetailMustKeyInComment Type: Enum |
None | Must comment be keyed it? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| RetailInvent_noDiscountAllowed | Extended Data Type: RetailNoDiscountAllowed Type: Enum |
Retail | Is no discount allowed? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| RetailInvent_PrintVariantsShelfLabels | Extended Data Type: RetailPrintVariantsShelfLabels Type: Enum |
Retail | Print variants shelf labels (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)) |
| RetailInvent_ProhibitReturn_RU | Extended Data Type: RetailProhibitReturn_RU Type: Enum |
Retail | Disallow the return of item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
| RetailInvent_qtyBecomesNegative | Extended Data Type: RetailQtyBecomesNegative Type: Enum |
Retail | Does quantity become negative? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| RetailInvent_ScaleItem | Extended Data Type: RetailScaleItem Type: Enum |
Retail | Is it a scale product (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| RetailInvent_zeroPriceValid | Extended Data Type: RetailZeroPriceValid Type: Enum |
Retail | Is zero price valid? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS)) |
| RetailMassUpdateWorksheetTable | Extended Data Type: RefRecId Type: Int64 |
None | Reference field in a different table (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)) |
| Sales_AllocateMarkup | Extended Data Type: PriceAllocateMarkup Type: Enum |
None | Include the price charges in the unit price of the various units specified in the Price quantity field? (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)) |
| Sales_EndDisc | Enumeration: NoYes |
None | (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)) |
| Sales_InterCompanyBlocked | Extended Data Type: InterCompanyBlocked Type: Enum |
TradeInterCompany | Intercompany is stopped. (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)) |
| Sales_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| Sales_Markup | Extended Data Type: InventPriceMarkup 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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| Sales_MarkupGroupId | Extended Data Type: InventMarkupGroupId Type: String |
Markup | Identification of charges group (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)) |
| Sales_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| Sales_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| Sales_Price | Extended Data Type: Price Type: Real |
None | Run-dependent price per unit. (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)) |
| Sales_PriceDate | Extended Data Type: PriceDate Type: Date |
None | Date attached to the price (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)) |
| Sales_PriceQty | Extended Data Type: PriceQty Type: Real |
None | Quantity that price and charges are applicable to (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)) |
| Sales_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, Microsoft Dynamics AX 2012 R2 (SYS), Microsoft Dynamics AX 2012 Feature Pack (SYS)) |
| Sales_SuppItemGroupId | Extended Data Type: InventSuppItemGroupId Type: String |
SuppItem | Specify the supplementary item group of the item in the module (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)) |
| Sales_TaxItemGroupId | Extended Data Type: TaxItemGroup Type: String |
LedgerBasicSalesTax | Group of sales tax codes that can be calculated for 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)) |
| Sales_UnderDeliveryPct | Extended Data Type: UnderDeliveryPct Type: Real |
LogisticsOverUnderDelivery | The percentage by which the product receipt quantity is allowed to be less than the order quantity (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)) |
| Sales_UnitId | Extended Data Type: UnitOfMeasureSymbol Type: String |
None | Unit symbol (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)) |
Top
Field Groups
| Field Group | Fields |
|---|---|
| AutoReport | |
| Identification | |
| Others |
Top
Relations
| Relation | Table | Lines |
|---|---|---|
| BarcodeSetup | BarcodeSetup | |
| BOMCostGroup | BOMCostGroup | |
| CommissionItemGroup | CommissionItemGroup | |
| dataAreaId | DataArea | |
| EcoResProduct | EcoResProduct | |
| EcoResProductTranslation | EcoResProductTranslation | |
| ExceptionCode_BR | ExceptionCodeTable_BR | |
| IntrastatItemCode | IntrastatItemCode | |
| InventBuyerGroup | InventBuyerGroup | |
| InventCountGroup | InventCountGroup | |
| InventItemGroup | InventItemGroup | |
| InventItemGroupItem | InventItemGroupItem | |
| InventLineDiscountGroupPurch | PriceDiscGroup | |
| InventLineDiscountGroupSales | PriceDiscGroup | |
| InventModelGroup | InventModelGroup | |
| InventModelGroupItem | InventModelGroupItem | |
| InventPackagingGroup | InventPackagingGroup | |
| InventProductType_BR | InventProductTypeTable_BR | |
| InventTable | InventTable | |
| MarkGroupPurch | MarkupGroup | |
| MarkGroupSales | MarkupGroup | |
| MultiLineDiscGroupPurch | PriceDiscGroup | |
| MultiLineDiscGroupSales | PriceDiscGroup | |
| OriginCountryRegion | LogisticsAddressCountryRegion | |
| OriginState | LogisticsAddressState | |
| Partition | Partitions | |
| ReqGroup | ReqGroup | |
| RetailInventTable | RetailInventTable | |
| RetailMassUpdateWorksheet | RetailMassUpdateWorksheetTable | |
| RetailVendTable | RetailVendTable | |
| SuppItemGroupPurch | SuppItemGroup | |
| SuppItemGroupSales | SuppItemGroup | |
| TaxFiscalClassification_BR | TaxFiscalClassification_BR | |
| TaxItemGroupHeadingPurch | TaxItemGroupHeading | |
| TaxItemGroupHeadingSales | TaxItemGroupHeading | |
| TaxServiceCode_BR | TaxServiceCode_BR | |
| UnitOfMeasure | UnitOfMeasure | |
| VendTable | VendTable | |
| WMSPalletType | WMSPalletType |
Top
Indexes
| Index | AllowDuplicates | Enabled | Fields |
|---|---|---|---|
| RecId | No | Yes | |
| RetailMassUpdateWorksheetLineIdx | No | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
RetailMassUpdateWorksheetLine Table