AssetTable Table [AX 2012]

The AssetTable contains the details related to the fixed assets.

Configuration Key: Asset

  MethodDescription
Gg871935.pubmethod(en-us,AX.60).gifallowEditOfAssetNum
Gg871935.pubmethod(en-us,AX.60).gifaosValidateDeleteValidates on the server that the specified record can be deleted from a table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifaosValidateInsertValidates on the server that the specified record can be inserted. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifaosValidateReadValidates on the server that the specified record can be read. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifaosValidateUpdateValidates on the server that the specified record can be updated. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifassetAddressByDate_JPRetrieves the address where the fixed asset is located on a specified date.
Gg871935.pubmethod(en-us,AX.60).gifassetBookCurrentRetrieves the first asset book that is in the current posting layer.
Gg871935.pubmethod(en-us,AX.60).gifassetGroup
Gg871935.pubmethod(en-us,AX.60).gifassetLedgerDimensionRetrieves the ledger dimension to which to post a transaction that has a fixed assets main account.
Gg871935.pubmethod(en-us,AX.60).gifassetOffsetLedgerDimensionRetrieves the ledger dimension to which to post a transaction that has a fixed assets offset account.
Gg871935.pubmethod(en-us,AX.60).gifbook
Gg871935.pubmethod(en-us,AX.60).gifbuf2conPacks the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifcancelTimeOutCancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg871935.pubmethod(en-us,AX.60).gifcanSubmitToWorkflowIndicates whether submission to workflow is possible. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifcaptionGets and sets the caption property of a table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifcheckInvalidFieldAccessGets and sets invalid field access. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifcheckMainAssetId
Gg871935.pubmethod(en-us,AX.60).gifcheckRecordGets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifcheckRestrictedDeleteActionsGets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifclearRemoves all rows from the table buffer. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifcompanyGets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifcon2bufUnpacks a container into the table buffers. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifconcurrencyModelGets and sets the default concurrency model to use to update records. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifcontextGets and sets the context property. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifcreateAssetBooksFromAssetGroup
Gg871935.pubmethod(en-us,AX.60).gifcreateAssetDepBookBonusFromAssetGroup
Gg871935.pubmethod(en-us,AX.60).gifcreateAssetDepBooksFromAssetGroup
Gg871935.pubmethod(en-us,AX.60).gifdataRetrieves a row from the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifdataSourceRetrieves the data source of the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifdefaultBookId
Gg871935.pubmethod(en-us,AX.60).gifdefaultDimensionRetrieves the default dimension for a specified asset book ID.
Gg871935.pubmethod(en-us,AX.60).gifdefaultFieldPopulates default values in a field in the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifdefaultRowPopulates default values in fields in the table in the non-interactive case. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifdeleteDeletes a row from the table, and puts the AssetId and Barcode values in the available pool of number sequences for those fields if they were automatically generated.
Gg871935.pubmethod(en-us,AX.60).gifdisableCacheGets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifdisposeReleases resources that are used by the xRecord object. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifdoClearRemoves all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifdoDeleteDeletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifdoInsertInserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifdoUpdateUpdates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifdoValidateDeletePerforms the action to validate that a record can be deleted. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifeditAssetActivityCodeSets the activity code.
Gg871935.pubmethod(en-us,AX.60).gifeditAssetPropertyGroupSets the property group.
Gg871935.pubmethod(en-us,AX.60).gifequalDetermines whether the specified object is equal to the current one. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).giffieldAccessRightReturns the field access right. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).giffieldBufferAccessRightReturns the field access right for the current record. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).giffieldStateSets or returns the state of a field in the table buffer. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifgetAllowRedefaultReturns the list of fields that are allowed to re-default. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifgetDefaultingDependenciesReturns the container that holds defaulting dependencies. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifgetExtensionReturns the table extension. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifgetFieldValueGets the value of the specified field from a table buffer. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifgetInstanceRelationTypeReturns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifgetPhysicalTableNameReturn the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifgetPresenceFieldDataRetrieves the PresenceInfo value from the specified field. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifgetSQLStatementGets the SQL statement that is used to return records from the database. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifgetTableInInstanceHierarchy (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifgetTableTypeIndicates the type of the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifgetTimeOutTimerHandleReturns the timer handle for the object. (Inherited from Object.)
Gg871935.pubmethod(en-us,AX.60).gifhandleRetrieves the handle of the class of the object. (Inherited from Object.)
Gg871935.pubmethod(en-us,AX.60).gifhasOpenAssetBookCalls the AssetBook::hasOpenBookForAsset method to check whether any asset book that has a status of Open is assigned to a fixed asset.
Gg871935.pubmethod(en-us,AX.60).gifhasRelatedTableIndicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifhelpFieldRetrieves a string that contains the Help text for the specified field. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifinitAssetNumberSeq
Gg871935.pubmethod(en-us,AX.60).gifinitBarcodeNumberSeq
Gg871935.pubmethod(en-us,AX.60).gifinitFromAssetGroupId
Gg871935.pubmethod(en-us,AX.60).gifinitValueInitializes field values in a new AssetTable record.
Gg871935.pubmethod(en-us,AX.60).gifinputStatusSets or returns the current input status of the table buffer. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifinsert
Gg871935.pubmethod(en-us,AX.60).gifinteractiveContextSets or returns the current interactive context of the table buffer. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifisFieldDataRetrievedChecks whether the data of the given field has been retrieved. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifisFieldSetChecks whether a field has a Set or Defaulted state. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifisFormDataSourceIndicates whether the data source is a form. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifisNewRecordReturns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifisPartOfUOWSaveChanges (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifisTempDbIndicates whether the type of the table is SQL TempDB. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifisTmpIndicates whether this is a temporary table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifjoinChildFinds the join child of the current record. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifjoinParentFinds the join parent of the current record. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).giflinkPhysicalTableInstanceChecks whether there is a link for the physical table instance for the record. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifmergeMerges the current table with the specified table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifmodifiedField
Gg871935.pubmethod(en-us,AX.60).gifmodifiedFieldValueModifies the specified field to the original value. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifnewInitializes a new instance of the Object class. (Inherited from Object.)
Gg871935.pubmethod(en-us,AX.60).gifnotifyReleases the hold on an object that has called the wait method on this object. (Inherited from Object.)
Gg871935.pubmethod(en-us,AX.60).gifnotifyAllReleases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
Gg871935.pubmethod(en-us,AX.60).gifobjectOnServerDetermines whether the object is on a server. (Inherited from Object.)
Gg871935.pubmethod(en-us,AX.60).giforigRetrieves the original values of the current record. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifoverwriteSystemfieldsGets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifownerReturns the instance that owns the object. (Inherited from Object.)
Gg871935.pubmethod(en-us,AX.60).gifpostCacheLoadIs executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifpostingProfile
Gg871935.pubmethod(en-us,AX.60).gifpostLoadIs executed after a record is read. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifpreRemotingIs 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.)
Gg871935.pubmethod(en-us,AX.60).gifprimaryValueModelForAssetProjectCalls the AssetBook::getPrimaryBookForAssetProject method.
Gg871935.pubmethod(en-us,AX.60).gifprimaryValueModelStatusForAssetProjectReturns the status of the value model (AssetBook) of a fixed asset record.
Gg871935.pubmethod(en-us,AX.60).gifqueryTimedOutIndicates whether the query exceeded the time limit for execution. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifqueryTimeoutGets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifreadCommittedLock (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifreadPastGets and sets the property that indicates whether to skip rows that are locked by other processes when a record is read. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifrecordLevelSecurityGets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifreductionEntryDocumentDate_JPDisplays and modifies the document date of the asset document reduction entry.
Gg871935.pubmethod(en-us,AX.60).gifreductionEntryTemplateId_JPDisplays and modifies the ID of the asset document template.
Gg871935.pubmethod(en-us,AX.60).gifrelatedTableSets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifrenamePrimaryKey
Gg871935.pubmethod(en-us,AX.60).gifrereadRereads the record from the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifRowCountRetrieves the number of rows in the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifselectForUpdateGets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifselectLockedIndicates whether to select locked records. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifselectRefRecordSelects the record by referenced field ID. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifselectWithRepeatableReadGets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifsetConnectionSets the user connection for this table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifsetCrossPartitionSets or resets cross-partitioning for the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifsetFieldValueSets the field value in the record buffer. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifsetNameAlias
Gg871935.pubmethod(en-us,AX.60).gifsetSQLTracingEnables or disables SQL tracing mode. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifsetTimeOutSets up the scheduled execution of a specified method. (Inherited from Object.)
Gg871935.pubmethod(en-us,AX.60).gifsetTmpSets the table so that it is not persisted to the database. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifsetTmpDataSets the contents of the temporary table to the specified data. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifsetXDSContextSets new XDS context. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifskipAosValidationGets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifskipDatabaseLogGets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifskipDataMethodsGets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifskipDeleteActionsGets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifskipDeleteMethodGets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifskipEventsProvides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifskipPostLoadGets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifskipTTSCheckGets and sets the property that indicates whether to skip the check to determine whether the record is selected for update. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifsuppressWarningsGets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).giftableAccessRightReturns the table access right. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).giftableBufferAccessRightReturns the table access right for the current record. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).giftakeOwnershipOfTempDBTable (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).giftoolTipFieldRetrieves the HelpText value for the specified field. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).giftoolTipRecordRetrieves the ToolTip value for the current record. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).giftopMainAsset
Gg871935.pubmethod(en-us,AX.60).giftoStringReturns a string that represents the current object. (Inherited from Object.)
Gg871935.pubmethod(en-us,AX.60).gifttsabortAborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifttsbeginStarts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifttscommitCommits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifupdateUpdates the current record in the database.
Gg871935.pubmethod(en-us,AX.60).gifusageCountRetrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifuseExistingTempDBTable (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifvalidateDeleteDetermines whether the current record is valid and ready to be deleted from the database.
Gg871935.pubmethod(en-us,AX.60).gifvalidateFieldDetermines whether the _fieldId field is valid.
Gg871935.pubmethod(en-us,AX.60).gifvalidateFieldValueValidates the field value of the instance of the AssetTable table.
Gg871935.pubmethod(en-us,AX.60).gifvalidateWriteDetermines whether the current record is valid and ready to be written to the database.
Gg871935.pubmethod(en-us,AX.60).gifvalidTimeStateUpdateModeSets a valid time state update mode on the cursor. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifvalueModelsCurrent
Gg871935.pubmethod(en-us,AX.60).gifvalueModelsOperations
Gg871935.pubmethod(en-us,AX.60).gifvalueModelsTax
Gg871935.pubmethod(en-us,AX.60).gifwaitPauses a process. (Inherited from Object.)
Gg871935.pubmethod(en-us,AX.60).gifwasCachedSpecifies the location from which the data was retrieved. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifwriteUpdates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifxmlRetrieves an XML string that represents the current object. (Inherited from xRecord.)
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::checkExistIndicates whether the specified record exists in the AssetTable table and displays a message if the record does not exist.
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::childList
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::depreciatingAncestor
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::depreciatingDepBookAncestor
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::exist
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::find
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::findByLedgerDimension
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::findByRecIdFinds the specified record in the AssetTable table.
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::fixedAssetGroupLookup_INIs a lookup for asset groups.
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::groupId
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::isAssetForSaleIndicates whether an asset can be sold.
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::isLowValuePoolAssetDetermines whether the asset contains any value models or depreciation books that use the low-value pool depreciation method.
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::lookupAccountNum
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::lookupAccountNumConsumption
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::lookupAccountNumLVPOpens the Asset lookup window, which limits assets to those that contain a value model or depreciation book that uses a low-value pool depreciation method.
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::lookupInvoiceAssetProvides lookup functionality for asset IDs.
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::treeImage
Gg871935.pubmethod(en-us,AX.60).gifGg871935.static(en-us,AX.60).gif::txtNotExistGets the message to use when a specific record in the AssetTable table does not exist.
Top

FieldTypeConfiguration keyDescription
AcquisitionDate_W Extended Data Type: AssetAcquisitionDate
Type: Date
AssetDate on which the fixed asset was acquired. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
AcquisitionPrice_W Extended Data Type: AssetAcquisitionPrice
Type: Real
AssetThe value paid for the fixed asset. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
AcquisitionValueNO Extended Data Type: AssetAcquisitionValueNO
Type: Real
AssetAcquisition value of the fixed asset for tax purposes.
AllowSale_PL Extended Data Type: PlAssetAllowSale
Type: Enum
NoneAllow asset to be sold. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
AssessmentNO Extended Data Type: AssetAssessmentNO
Type: Real
AssetTax assessment value of the fixed asset.
AssessmentTaxNO Extended Data Type: AssetAssessmentTaxNO
Type: Real
AssetValue for tax purposes of the fixed asset.
AssetActivityCode Extended Data Type: AssetActivityCodeRecId
Type: Int64
AssetA code that indicates the activity category for which the asset is acquired
AssetClassification_JP Enumeration: AssetClassification_JP
AssetThe classification of fixed assets to use to print fixed asset statements. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
AssetDeferredType_JP Enumeration: AssetDeferredType_JP
AssetDepreciation technique to apply for deferred assets. The depreciation can be immediate or equally divided. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
AssetGroup Extended Data Type: AssetGroupId
Type: String
AssetSelect a fixed asset group
AssetId Extended Data Type: AssetId
Type: String
AssetUnique key for identification of fixed asset. The key is used when creating new assets.
AssetProductionYear_PL Extended Data Type: PlYearString
Type: String
NoneYear of date. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
AssetPropertyGroup Extended Data Type: AssetPropertyGroupRecId
Type: Int64
AssetA detailed category, such as Trucks split into property groups of Medical Trucks and Ladder Trucks
AssetReplaceCost Extended Data Type: AssetReplaceCost
Type: Real
AssetCost to replace this fixed asset.
AssetSourceType_CN Extended Data Type: AssetSourceTypeRefRecId_CN
Type: Int64
AssetIdentify an asset classification for reporting purposes only, for examples, purchased, investment, etc. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
AssetType Enumeration: AssetType
AssetType of fixed asset.
Barcode Extended Data Type: AssetBarcode
Type: String
AssetBar code of the asset.
CategoryId_LV Extended Data Type: LvAssetCategoryId
Type: String
AssetAsset category for tax depreciation. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
Condition Extended Data Type: AssetConditionId
Type: String
NoneIdentify the current condition of the asset, for example, poor, good, or excellent.
createdBy Extended Data Type: CreatedBy
Type: String
None
createdDateTime Extended Data Type: CreatedDateTime
Type: UtcDateTime
None
dataAreaId Extended Data Type: DataAreaId
Type: String
None
DefaultDimension Extended Data Type: DimensionDefault
Type: Int64
LedgerBasicDefault dimensions (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_CreatedTime Extended Data Type: DEL_CreatedTime
Type: Integer
None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
dEL_ModifiedTime Extended Data Type: DEL_ModifiedTime
Type: Integer
None (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
Department Extended Data Type: OMDepartmentRecId
Type: Int64
NoneThe department or division that is responsible for the asset
DisposalRestriction Extended Data Type: AssetLongDescription
Type: String
NoneEnter any restrictions for properly disposing of the asset.
Documents Extended Data Type: Filename
Type: String
NoneLocation of documents regarding the fixed asset.
ExceptionTaxationCode_JP Extended Data Type: AssetExceptionTaxationCode_JP
Type: String
AssetA code that indicates whether the asset is subject to taxation. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
ExceptionTaxationRate_JP Extended Data Type: AssetExceptionTaxationRate_JP
Type: Real
AssetThe rate of the exception from taxes (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
FiscalEstablishment_BR Extended Data Type: FiscalEstablishmentRecId_BR
Type: Int64
NoneFiscal establishment identification (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
GISReferenceNumber Extended Data Type: AssetGISReferenceNumber
Type: String
NoneEnter the Geographic Information System reference number, which indicates the exact location within the GIS layer for the asset.
GoodsType_BR Enumeration: GoodsType_BR
NoneSpecify the type of the items to SPED. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
GuaranteeDate Extended Data Type: AssetTransDate
Type: Date
AssetDate of the start of the guarantee for this fixed asset.
ICMSCreditInstallments_BR Extended Data Type: ICMSCreditInstallments_BR
Type: Integer
NoneSpecify the number of installments to ICMS credit. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
InsuranceAgent Extended Data Type: AssetInsuranceAgent
Type: String
NoneIdentify the insurance agent for the asset.
InsuranceDate1 Extended Data Type: AssetInsuranceDate1
Type: Date
AssetInsurance date field used to keep check on insurance end dates, etc.
InsuranceDate2 Extended Data Type: AssetInsuranceDate2
Type: Date
AssetInsurance date field used to keep check on insurance end dates, etc.
InsurancePolicyNum Extended Data Type: AssetInsurancePolicyNum
Type: String
AssetInsurance policy number of the fixed asset.
InsuranceVendor Extended Data Type: VendAccount
Type: String
NoneIdentify the insurance company that insures the asset.
InsuredAtMarketValue Extended Data Type: NoYesId
Type: Enum
NoneIs the asset insured at its fair market value?
InsuredValue Extended Data Type: AssetInsuredValue
Type: Real
AssetValue that the fixed asset is insured for.
IsMissing Extended Data Type: NoYesId
Type: Enum
NoneSelect this check box if the asset cannot be located
IsRented_JP Extended Data Type: AssetIsRented_JP
Type: Enum
AssetIf this check box is selected, it indicates that the asset is rented. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
IsSecondHand_JP Extended Data Type: AssetIsSecondHand_JP
Type: Enum
AssetIf this check box is selected, it indicates that the asset is a second-hand acquisition. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
LastFactorUpdateDate Extended Data Type: AssetLastFactorUpdateDate
Type: Date
NoneDisplays the date the replacement cost or insured value was last updated using the fixed asset periodic process.
LastMaintenance Extended Data Type: AssetLastMaintenance
Type: Date
AssetDate of last maintenance.
Lease Extended Data Type: AssetLongDescription
Type: String
NoneIf the asset is leased, enter notes about the lease.
LenderName_JP Extended Data Type: AssetLenderName_JP
Type: String
AssetThe name of the person or company that lends the asset (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3)
Location Extended Data Type: AssetLocationId
Type: String
AssetLocation of the fixed asset.
LocationMemo Extended Data Type: AssetLongDescription
Type: String
NoneNotes about the location of the asset.
MainAssetId Extended Data Type: AssetIdMain
Type: String
AssetThe main fixed asset that this fixed asset uses as its parent.
MaintenanceInfo1 Extended Data Type: AssetMaintenanceInfo
Type: String
AssetField with update information.
MaintenanceInfo2 Extended Data Type: AssetMaintenanceInfo
Type: String
AssetField with update information.
MaintenanceInfo3 Extended Data Type: AssetMaintenanceInfoMemo
Type: VarString
AssetField with update information.
MajorType Extended Data Type: AssetMajorTypeId
Type: String
NoneIdentify a top-level asset classification for reporting purposes only, for example, street, land, or sewer.
Make Extended Data Type: Name
Type: String
NoneName of the manufacturer of the item.
Model Extended Data Type: Name
Type: String
NoneModel number of the item.
ModelYear Extended Data Type: AssetModelYear
Type: String
NoneEnter the year that the item was built.
modifiedBy Extended Data Type: ModifiedBy
Type: String
None
modifiedDateTime Extended Data Type: ModifiedDateTime
Type: UtcDateTime
None
Name Extended Data Type: AssetName
Type: String
AssetDescribe the fixed asset.
NameAlias Extended Data Type: AssetNameAlias
Type: String
AssetFind fast name applying to the fixed asset.
NextMaintenance Extended Data Type: AssetNextMaintenance
Type: Date
AssetDate of next maintenance.
Notes Extended Data Type: AssetNotes
Type: VarString
AssetGeneral comments for the fixed asset
ParcelId Extended Data Type: AssetParcelId
Type: String
NoneIf the asset is land, enter the identifier for the parcel, which is a plot of land. For example, enter 01-6211421.
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))
PhysicalAssetNumber_BR Extended Data Type: PhysicalAssetNumber_BR
Type: String
NoneSpecify the physical asset number - fixed on the asset (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PhysicalInventory Extended Data Type: AssetPhysicalInventory
Type: Date
AssetDate of last physical inventory of this fixed asset.
PISCOFINSReceivableLongTerm_BR Extended Data Type: TaxReceivableLongTerm_BR
Type: Enum
NoneIs the fixed asset to receive PIS/COFINS tax credit in installments? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
PolicyAmount Extended Data Type: AssetPolicyAmount
Type: Real
NoneEnter the amount that the asset is insured for.
PolicyExpiration Extended Data Type: AssetPolicyExpiration
Type: Date
NoneEnter the expiration date on the insurance policy for the asset.
PropertyType Extended Data Type: AssetPropertyTypeId
Type: Enum
NoneIdentify the type of property that the asset is.
PurchLineRecId Extended Data Type: PurchLineRefRecId
Type: Int64
LogisticsBasicReference field in a different table
Quantity Extended Data Type: AssetQuantity
Type: Real
AssetThe number of units
RecId Extended Data Type: RecId
Type: Int64
None
recVersion Extended Data Type: RecVersion
Type: Integer
None
Reference Extended Data Type: AssetReference
Type: String
AssetGeneral reference information for the fixed asset
ReturnOnInvestmentsNO Extended Data Type: AssetReturnOnInvestmentsNO
Type: Real
AssetOrigin of calculation of the return on capital.
RoomNumber Extended Data Type: AssetRoomNumber
Type: String
NoneEnter the room number where the asset is located.
SerialNum Extended Data Type: Num
Type: String
NoneSerial number for this fixed asset.
SortingId Extended Data Type: AssetSortingId
Type: String
AssetAlternative sort field for the fixed asset.
SortingId2 Extended Data Type: AssetSortingId2
Type: String
AssetAlternative sort field for the fixed asset.
SortingId3 Extended Data Type: AssetSortingId3
Type: String
AssetAlternative sort field for the fixed asset.
SubventionNO Extended Data Type: AssetSubventionNO
Type: Real
AssetTaxable contribution to the fixed asset.
SubventionTaxFreeNO Extended Data Type: AssetSubventionTaxFreeNO
Type: Real
AssetTax-free contribution to the fixed asset.
TaxCountyNO Extended Data Type: AssetTaxCountyNO
Type: String
AssetMunicipality that the fixed asset will be reported to for tax purposes.
TaxICMSOutgoing_BR Extended Data Type: TaxICMSOutgoing_BR
Type: Enum
NoneIs the fixed asset to receive ICMS tax credit in installments? (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
TechInfo1 Extended Data Type: AssetTechInfo
Type: String
AssetField for technical information.
TechInfo2 Extended Data Type: AssetTechInfo
Type: String
AssetField for technical information.
TechInfo3 Extended Data Type: AssetTechInfo
Type: String
AssetField for technical information.
TitleHolder Extended Data Type: AssetTitleHolder
Type: String
NoneIdentify the agency that holds the title for the asset.
TransferredFromInventory_BR Extended Data Type: TransferredFromInventory_BR
Type: Enum
NoneSpecify if this fixed asset was transferred from inventory. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2 (SYS))
UnitCost Extended Data Type: AssetUnitCost
Type: Real
AssetThe cost per unit
UnitOfMeasure Extended Data Type: AssetUnitOfMeasure
Type: String
AssetThe common unit of measure for the item, for example, dozen, case, or each
ValueAt19840101NO Extended Data Type: AssetValueAt19840101NO
Type: Real
AssetValue of the fixed asset as on January 1, 1984.
WorkerContactName Extended Data Type: HcmContactNameRecId
Type: Int64
NoneEnter the name of an individual who might know more information about the asset.
WorkerResponsible Extended Data Type: HcmResponsibleRecId
Type: Int64
HRMAdministrationEmployee who is responsible for the fixed asset.
Top

Field GroupFields
Acquisition_W
AutoLookup
AutoReport
AutoSummary
CategoryId_LV
Description
Dimensions_LV
Disposal
ExceptionTaxation_JP
FiscalEstablishment_BR
FiscalInformation_BR
Documents
Identification
Insurance
PurchaseOrders
Quantity
Reference
Sales_PL
Subventions
Sorting
Tracking
Type
Update
ValueModelGroup
Values
Warehouse
Inventory
IsMissing
Lease
MainAsset
Mapping
Municipality
Other
Model
Physical
Policy
Top

RelationTableLines
AssetActivityCodeAssetActivityCode
AssetConditionAssetCondition
AssetGroup_AssetGroupAssetGroup
AssetIdAssetTable
AssetLocationAssetLocation
AssetMajorTypeAssetMajorType
AssetPropertyGroupAssetPropertyGroup
AssetSortingAssetSorting
AssetSorting_SortingId2AssetSorting
AssetSorting_SortingId3AssetSorting
AssetSourceType_CNAssetSourceType_CN
AssetTableAssetTable
CategoryId_LVAssetBookTable
dataAreaIdDataArea
DefaultDimensionDimensionAttributeValueSet
FiscalEstablishment_BRFiscalEstablishment_BR
OMOperatingUnitOMOperatingUnit
PartitionPartitions
PurchLinePurchLine
UnitOfMeasureUnitOfMeasure
VendTableVendTable
WorkerContactName_FKHcmWorker
WorkerResponsible_FKHcmWorker
Top

IndexAllowDuplicatesEnabledFields
AssetNumIdxNoYes
AssetSourceType_CNIdxYesYes
GroupAssetIdxNoYes
MainAssetIdxYesYes
NameAliasIdxYesYes
RecIdNoYes
WorkerContactNameIdxYesYes
WorkerResponsibleIdxYesYes
Top

Community Additions

ADD
Show: