Share via

Tables Affected, Listed by Table, A

  • Article

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

This topic provides a list of the tables that would be affected by a given upgrade script. The list is grouped by each table that has links to the applicable data upgrade script topics.

This topic lists the tables whose names begin with the letter A.

(Other)

Checked Conditions

Mitigation/How-to-fix

Validation Issues Description

a ledger journal name with a continuous number sequence that is associated to it exists.

a record in the LedgerTrans table is contained within a virtual company.

a valid user in the SysCompanyUserInfo table.

LedgerTrans table contains a record with an invalid value for the AccountNum or Dimension fields. The account and dimension must exist in the LedgerTable table in order for the upgrade to proceed.

LedgerTrans table is contained within a virtual company. The upgrade will be unable to proceed if this is a case.

that for an inventory dimension group where warehouse is not a financial dimension, all items are on the same site.

the LedgerTrans table does not contain any records that are contained within a virtual company.

a

able

ACCOUNTINGDISTRIBUTION

AccountingEvent

AccountNum and LedgerTrans fields in the LedgerTrans table. The Dimension field contains values found in the LedgerTable table.

AccountNum, OperationAccount, TaxOffsetAccountUseTax and Dimension fields contain values found in LedgerTable table.

Accounts payable

Accounts receivable

ACOJournalName_BR

ACOJournalTable_BR

ACOJournalTransOverhead_BR

ACOProdOverHeadCostTrans_BR

Address

AddressCountryRegion

AddressCountryRegionBLWI

AddressCountryRegionGroupBLWI

AddressCounty

AddressFlatNumber_RU

AddressFormatHeading

AddressFormatLines

AddressHouseNumber_RU

AddressSettlement_RU

AddressState

AddressTown_RU

AddressTrans_RU

AddressZipCode

AdjustmentAmounts_IN

AdminUpgDummy

AdvanceAdjustmentParameters_W

AgreementClassification

AgreementClassificationExt_RU

AgreementClassificationTranslation

AgreementHeader

AgreementHeaderDefault

AgreementHeaderExt

AgreementHeaderExt_RU

AgreementLine

AgreementLineDefault

AgreementLineQuantityCommitment

AgreementLineReference

AgreementLineReleasedLine

AgreementReference

AgreementReleaseHeaderMatch

AifAction

AifAdapter

AifChannel

AifDataPolicy

AifDataPolicyXPath

AifDocumentField

AifDocumentLog

AifDocumentSchemaTable

AifEndpoint

AifEndpointActionPolicy

AifEndpointActionValueMap

AifEndpointConstraint

AifGatewayQueue

AifGlobalSettings

AifInboundPort

AifMessageLog

AifOutboundPort

AifOutboundProcessingQueue

AifPipeline

AifPipelineComponent

AifPort

AifPortActionPolicy

AifPortDocument

AifResponse

AifRuntimeCache

AifSchemaStore

AifService

AifTransform

AifTransformElement

AifValueSubstitutionComponentConfig

AifValueSubstitutionConfig

AmountDiffParameters_RU

AssetAddition

AssetBook

AssetBookManualCust_BR

AssetBookManualVend_BR

AssetBookMerge

AssetBookTable

AssetBudget

AssetDepBookTable

AssetDepBookTrans

AssetDepreciationZakat_SA

AssetDisposalParameters

AssetGroup

AssetGroupInformation_IN

AssetGroupZakat_SA

AssetInternalTransferHistory

AssetInventTrans

AssetLedgerAccounts

AssetLending

AssetLocation

AssetParameters

ASSETPARAMETERS

AssetParametersDeprRates_DE

AssetSourceType_CN

AssetTable

AssetTaxDepr_LV

AssetTaxDeprCategory_LV

AssetTrans

assingn a unit

ationName

ATTRIBUTEVALUE

AxdDocumentParameters

ayrollTaxRegion

ayrollTaxRegionForSymmetry

See also

Tables Affected, Listed by Table