Microsoft Dynamics AX 2012 Data Import Export Framework in Master Data Management Scenario
Purpose: The purpose of this document is to explain what Master Data Management capabilities are provided by Microsoft Dynamics AX 2012 Data Import Export Framework. Please note that in the previous articles I described how to implement Master Data Management scenario for Microsoft Dynamics using Microsoft SQL Server 2012 Master Data Services.
Challenge: There is number of tools and services available for Microsoft Dynamics AX 2012 which have Master Data Management capabilities. The challenge is to understand usage scenarios and how to apply them properly. Microsoft Dynamics AX 2012 Data Import Export Framework allows you to import master data into Microsoft Dynamics AX 2012 and can be used to synchronize master data between multiple instances of Microsoft Dynamics AX 2012.
Solution: Microsoft Dynamics AX 2012 Data Import Export Framework is an extension that helps you export data and import it into Microsoft Dynamics AX. Examples of the data that you can import include master data, open stock, balances, etc.
Scenario
Data Import Export Framework is a framework inside Microsoft Dynamics AX 2012 which is primarily designed to facilitate data migration efforts by providing numerous templates. Microsoft Dynamics AX 2012 Data Import Export Framework can also be used is some Master Data Management scenarios. For the sake of simplicity in this document I’ll consider usual Master Data Management entities such as Customers and Products.
Walkthrough
For the purposes of this walkthrough I installed Data Import Export Framework in Microsoft Dynamics AX 2012 environment. Data Import Export Framework is available for download on Information Source here: https://informationsource.dynamics.com//RFPServicesOnline/Rfpservicesonline.aspx?ToolDocName=Microsoft+Dynamics+AX+2012+Data+Import%2fExport+Framework%7cQJ4JEM76642V-8-1005
Data Import Export Framework imports the data into Microsoft Dynamics AX 2012 in 2 steps. First you move the data from Source (may be CSV File) into Staging area (set of flat staging tables in AX), and then you move the data from Staging into Target (business data tables in AX). This approach allows you to do pre-validation, required data transformation and other useful things before the data will be actually published into AX business data tables
First off let’s review setup of Data Import Export Framework very briefly
Data Import Export Framework parameters
Please note that Service connection URL is specific to support integration with Microsoft Dynamics RapidStart Services
Source data formats
Please note that Data Import Export Framework supports multiple source data formats such as File, AX and ODBC
Currently Data Import Export Framework provides 70 business entity templates for master data and transactional data
Target entities
Please note that there’re templates for Customers and Products included
For example, let’s review the structure of Customer business entity
Target entities – Entity structure
In this particular case we have just single data source for Customer data, however you may include multiple data sources into single entity using Composite entity structure which may be handy, for example, when importing Customer addresses along with Customer data
Then you can drill down to the field level. For example, this is the list of fields included in Customer data source
Target entities – Target fields
As soon as we have Staging area and Target business data tables in AX we’ll have to define a mapping between Staging and Target. For all standard Data Import Export Framework templates this is already done for you
Target entities – Map staging to target
Target entities – Map staging to target (Visualization)
Please note that you can also use Functions for data transformation which are essentially X++ methods exposed to Data Import Export Framework
Now let’s define what data we want to import by creating Processing group
Processing group
In this instance we want to import Customer data (we would also be interested in importing Product data and Data Import Export Framework also provides a standard template for it)
Entities
Please note that you can preview the data even before you move it to Staging area
Entity attributes
You can also review attributes associated with an entity
Now we have to define the mapping between Source and Staging similar to the way the mapping between Staging and Target is defined
Map source to staging
Map source to staging (Visualization)
At this point we are ready to move the data from Source to Staging
Create a job ID for the staging data job
Staging data execution
You can schedule this to be run as a batch job, however in this scenario we’ll execute it right away
Staging
As the result 6 Customer records will be inserted into Staging area
Infolog
Then you can review the results of the operation on Execution history form
Execution history
At this point the data was copied to Staging area and you can pre-validate it and do any kind of data changes and fixing if required
DMFCustomerEntity
Let’s see the result of validation below
Infolog
Please note that validation is done before the data is published to Microsoft Dynamics AX 2012 business data tables which allows to save time and rationalize data migration efforts
The next step would be to move the data from Staging to Target
Select a job ID to run
Target data execution
Again in this case I’ll execute this job interactively
Target
As the result 6 Customer records were written into Microsoft Dynamics AX 2012 business data tables
Infolog
Please note that if you want to execute incremental import or update, Data Import Export Framework supports that as well
Now on Execution history form we can see that Staging status and Target status = Ended which means that we completed our data import exercise
Execution history
The result in Microsoft Dynamics AX 2012 will look like the following
Result
Technically speaking each entity template in Data Import Export Framework is supported by table, class and query. Table represents a staging flat table for business entity. Class implements data import business logic. And query represents a target entity in Microsoft Dynamics AX 2012 data model which usually consists of multiple tables.
Project
Data Import Export Framework entity templates expose variety of data elements you may want to use. You can keep it as simple as you want meaning that you can only import (use) certain data elements from the full list
Here’s what’s included into Customer template in Data Import Export Framework
Table Name
|
Field Name
|
Data Type
|
Maximum Length/Value
|
CustTable
|
AccountNum
| ||
CustTable
|
AccountStatement
| ||
CustTable
|
BankAccount
| ||
CustTable
|
BankCentralBankPurposeCode
| ||
CustTable
|
BankCentralBankPurposeText
| ||
CustTable
|
BankCustPaymIdTable
| ||
CustTable
|
BirthCountyCode_IT
| ||
CustTable
|
BirthDate_IT
| ||
CustTable
|
BirthPlace_IT
| ||
CustTable
|
Blocked
| ||
CustTable
|
CashDisc
| ||
CustTable
|
ClearingPeriod
| ||
CustTable
|
CommissionGroup
| ||
CustTable
|
CompanyChainId
| ||
CustTable
|
CompanyIdSiret
| ||
CustTable
|
CompanyNAFCode
| ||
CustTable
|
CompanyType_MX
| ||
CustTable
|
ContactPersonId
| ||
CustTable
|
CreditCardAddressVerification
| ||
CustTable
|
CreditCardAddressVerificationLevel
| ||
CustTable
|
CreditCardAddressVerificationVoid
| ||
CustTable
|
CreditCardCVC
| ||
CustTable
|
CreditMax
| ||
CustTable
|
CreditRating
| ||
CustTable
|
Curp_MX
| ||
CustTable
|
Currency
| ||
CustTable
|
CustClassificationId
| ||
CustTable
|
CustExcludeCollectionFee
| ||
CustTable
|
CustExcludeInterestCharges
| ||
CustTable
|
CustGroup
| ||
CustTable
|
CustItemGroupId
| ||
CustTable
|
DefaultDimension
| ||
CustTable
|
DestinationCodeId
| ||
CustTable
|
DlvMode
| ||
CustTable
|
DlvReason
| ||
CustTable
|
DlvTerm
| ||
CustTable
|
EInvoice
| ||
CustTable
|
EinvoiceEANNum
| ||
CustTable
|
EndDisc
| ||
CustTable
|
EnterpriseNumber
| ||
CustTable
|
FactoringAccount
| ||
CustTable
|
FiscalCode
| ||
CustTable
|
ForecastDMPInclude
| ||
CustTable
|
FreightZone
| ||
CustTable
|
GiroType
| ||
CustTable
|
GiroTypeAccountStatement
| ||
CustTable
|
GiroTypeCollectionletter
| ||
CustTable
|
GiroTypeFreeTextInvoice
| ||
CustTable
|
GiroTypeInterestNote
| ||
CustTable
|
GiroTypeProjInvoice
| ||
CustTable
|
IdentificationNumber
| ||
CustTable
|
InclTax
| ||
CustTable
|
InterCompanyAllowIndirectCreation
| ||
CustTable
|
InterCompanyAutoCreateOrders
| ||
CustTable
|
InterCompanyDirectDelivery
| ||
CustTable
|
InventLocation
| ||
CustTable
|
InventSiteId
| ||
CustTable
|
InvoiceAccount
| ||
CustTable
|
InvoiceAddress
| ||
CustTable
|
LineDisc
| ||
CustTable
|
LineOfBusinessId
| ||
CustTable
|
MainContactWorker
| ||
CustTable
|
MandatoryCreditLimit
| ||
CustTable
|
MarkupGroup
| ||
CustTable
|
Memo
| ||
CustTable
|
MultiLineDisc
| ||
CustTable
|
numberSequenceGroup
| ||
CustTable
|
OneTimeCustomer
| ||
CustTable
|
OrderEntryDeadlineGroupId
| ||
CustTable
|
OrgId
| ||
CustTable
|
OurAccountNum
| ||
CustTable
|
PackMaterialFeeLicenseNum
| ||
CustTable
|
Party
| ||
CustTable
|
PartyCountry
| ||
CustTable
|
PartyState
| ||
CustTable
|
PaymDayId
| ||
CustTable
|
PaymIdType
| ||
CustTable
|
PaymMode
| ||
CustTable
|
PaymSched
| ||
CustTable
|
PaymSpec
| ||
CustTable
|
PaymTermId
| ||
CustTable
|
PBACustGroupId
| ||
CustTable
|
PriceGroup
| ||
CustTable
|
ResidenceForeignCountryRegionId_IT
| ||
CustTable
|
Rfc_MX
| ||
CustTable
|
RFIDCaseTagging
| ||
CustTable
|
RFIDItemTagging
| ||
CustTable
|
RFIDPalletTagging
| ||
CustTable
|
SalesCalendarId
| ||
CustTable
|
SalesDistrictId
| ||
CustTable
|
SalesGroup
| ||
CustTable
|
SalesPoolId
| ||
CustTable
|
SegmentId
| ||
CustTable
|
ShipCarrierAccount
| ||
CustTable
|
ShipCarrierAccountCode
| ||
CustTable
|
ShipCarrierBlindShipment
| ||
CustTable
|
ShipCarrierFuelSurcharge
| ||
CustTable
|
ShipCarrierId
| ||
CustTable
|
StateInscription_MX
| ||
CustTable
|
StatisticsGroup
| ||
CustTable
|
SubsegmentId
| ||
CustTable
|
SuppItemGroupId
| ||
CustTable
|
SyncEntityId
| ||
CustTable
|
SyncVersion
| ||
CustTable
|
TaxBorderNumber_FI
| ||
CustTable
|
TaxGroup
| ||
CustTable
|
TaxLicenseNum
| ||
CustTable
|
TaxWithholdCalculate_TH
| ||
CustTable
|
TaxWithholdGroup_TH
| ||
CustTable
|
VATNum
| ||
CustTable
|
VendAccount
| ||
CustTable
|
WebSalesOrderDisplay
|
Often times you also have to import Customer address details along with Customer data, that’s why Data Import Export Framework also provides a template for Customer address details
Table Name
|
Field Name
|
Data Type
|
Maximum Length/Value
|
DMFCustomerPostalAddressView
|
AccountNum
| ||
DMFCustomerPostalAddressView
|
Address
| ||
DMFCustomerPostalAddressView
|
BuildingCompliment
| ||
DMFCustomerPostalAddressView
|
City
| ||
DMFCustomerPostalAddressView
|
CountryCurrencyCode
| ||
DMFCustomerPostalAddressView
|
CountryRegionId
| ||
DMFCustomerPostalAddressView
|
County
| ||
DMFCustomerPostalAddressView
|
District
| ||
DMFCustomerPostalAddressView
|
DistrictName
| ||
DMFCustomerPostalAddressView
|
ISOcode
| ||
DMFCustomerPostalAddressView
|
Latitude
| ||
DMFCustomerPostalAddressView
|
Location
| ||
DMFCustomerPostalAddressView
|
LocationId
| ||
DMFCustomerPostalAddressView
|
LocationName
| ||
DMFCustomerPostalAddressView
|
Longitude
| ||
DMFCustomerPostalAddressView
|
PostalAddress
| ||
DMFCustomerPostalAddressView
|
PostalAddressRecId
| ||
DMFCustomerPostalAddressView
|
PostBox
| ||
DMFCustomerPostalAddressView
|
State
| ||
DMFCustomerPostalAddressView
|
Street
| ||
DMFCustomerPostalAddressView
|
StreetNumber
| ||
DMFCustomerPostalAddressView
|
TimeZone
| ||
DMFCustomerPostalAddressView
|
ValidFrom
| ||
DMFCustomerPostalAddressView
|
ValidTo
| ||
DMFCustomerPostalAddressView
|
ZipCode
|
Here’s what’s included into Data Import Export Framework template for Products import. Please note this template is for product definitions (Products and product masters) in Microsoft Dynamics AX 2012
Table Name
|
Field Name
|
DT
|
ML/V
|
InventTable
|
ABCContributionMargin
| ||
InventTable
|
ABCRevenue
| ||
InventTable
|
ABCTieUp
| ||
InventTable
|
ABCValue
| ||
InventTable
|
AltConfigId
| ||
InventTable
|
AltInventColorId
| ||
InventTable
|
AltInventSizeId
| ||
InventTable
|
AltInventStyleId
| ||
InventTable
|
AltItemId
| ||
InventTable
|
AssetGroupId_RU
| ||
InventTable
|
AssetId_RU
| ||
InventItemInventSetup
|
ATPApplyDemandTimeFence
| ||
InventItemInventSetup
|
ATPApplySupplyTimeFence
| ||
InventItemInventSetup
|
ATPBackwardDemandTimeFence
| ||
InventItemInventSetup
|
ATPBackwardSupplyTimeFence
| ||
InventItemInventSetup
|
ATPInclPlannedOrders
| ||
InventItemInventSetup
|
ATPTimeFence
| ||
InventTable
|
AutoReportFinished
| ||
InventTable
|
BatchNumGroupId
| ||
InventTable
|
BOMCalcGroupId
| ||
InventTable
|
BOMLevel
| ||
InventTable
|
BOMManualReceipt
| ||
InventTable
|
BOMUnitId
| ||
InventItemInventSetup
|
CalendarDays
| ||
InventTable
|
CommissionGroupId
| ||
InventTable
|
CostGroupId
| ||
InventTable
|
CostModel
| ||
InventTable
|
CustomsExportTariffCodeTable_IN
| ||
InventTable
|
CustomsImportTariffCodeTable_IN
| ||
InventTable
|
DefaultDimension
| ||
InventItemSetupSupplyType
|
DefaultOrderType
| ||
InventItemInventSetup
|
DeliveryDateControlType
| ||
InventTable
|
Density
| ||
InventTable
|
Depth
| ||
EcoResProduct
|
DisplayProductNumber
| ||
EcoResProductIdentifier
|
Product
| ||
EcoResStorageDimensionGroupProduct
|
Product
| ||
EcoResStorageDimensionGroupProduct
|
StorageDimensionGroup
| ||
EcoResStorageDimensionGroup
|
Description
| ||
EcoResStorageDimensionGroup
|
Name
| ||
EcoResStorageDimensionGroupItem
|
ItemDataAreaId
| ||
EcoResStorageDimensionGroupItem
|
ItemId
| ||
EcoResStorageDimensionGroupItem
|
StorageDimensionGroup
| ||
EcoResTrackingDimensionGroupProduct
|
Product
| ||
EcoResTrackingDimensionGroupProduct
|
TrackingDimensionGroup
| ||
EcoResTrackingDimensionGroup
|
Description
| ||
EcoResTrackingDimensionGroup
|
Name
| ||
EcoResTrackingDimensionGroupItem
|
ItemDataAreaId
| ||
EcoResTrackingDimensionGroupItem
|
ItemId
| ||
EcoResTrackingDimensionGroupItem
|
TrackingDimensionGroup
| ||
InventTable
|
EPCManager
| ||
InventTable
|
ExceptionCode_BR
| ||
InventTable
|
ExciseTariffCodes_IN
| ||
InventTable
|
EximProductGroupTable_IN
| ||
InventTable
|
FiscalLIFOAvoidCalc
| ||
InventTable
|
FiscalLIFONormalValue
| ||
InventTable
|
FiscalLIFONormalValueCalc
| ||
InventTable
|
ForecastDMPInclude
| ||
InventTable
|
grossDepth
| ||
InventTable
|
grossHeight
| ||
InventTable
|
grossWidth
| ||
InventFiscalLIFOGroup
|
GroupId
| ||
InventTable
|
Height
| ||
InventItemInventSetup
|
HighestQty
| ||
InventTable
|
ICMSOnService_BR
| ||
InventFiscalLIFOGroup
|
Individual
| ||
EcoResProduct
|
InstanceRelationType
| ||
InventTable
|
Intracode
| ||
InventTable
|
IntrastatExclude
| ||
InventTable
|
IntrastatProcId_CZ
| ||
InventTable
|
IntraUnit
| ||
InventItemInventSetup
|
InventDimId
| ||
InventItemInventSetup
|
InventDimIdDefault
| ||
InventTable
|
InventFiscalLIFOGroup
| ||
InventFiscalLIFOGroup
|
Name
| ||
InventItemGroupItem
|
ItemDataAreaId
| ||
InventItemGroupItem
|
ItemId
| ||
InventItemInventSetup
|
ItemId
| ||
InventItemSetupSupplyType
|
ItemDataAreaId
| ||
InventItemSetupSupplyType
|
ItemId
| ||
InventModelGroupItem
|
ItemDataAreaId
| ||
InventModelGroupItem
|
ItemId
| ||
InventTable
|
InventProductType_BR
| ||
InventTable
|
ItemId
| ||
InventTable
|
Product
| ||
InventTableModule
|
AllocateMarkup
| ||
InventTableModule
|
EndDisc
| ||
InventTableModule
|
InterCompanyBlocked
| ||
InventTableModule
|
ItemId
| ||
InventTableModule
|
LineDisc
| ||
InventTableModule
|
Markup
| ||
InventTableModule
|
MarkupGroupId
| ||
InventTableModule
|
MarkupSecCur_RU
| ||
InventTableModule
|
MaximumRetailPrice_IN
| ||
InventTableModule
|
MaxPriceInclVAT
| ||
InventTableModule
|
MinPriceInclVAT
| ||
InventTableModule
|
ModuleType
| ||
InventTableModule
|
MultiLineDisc
| ||
InventTableModule
|
OverDeliveryPct
| ||
InventTableModule
|
PDSPricingPrecision
| ||
InventTableModule
|
Price
| ||
InventTableModule
|
PriceDate
| ||
InventTableModule
|
PriceInclVAT
| ||
InventTableModule
|
PriceQty
| ||
InventTableModule
|
PriceSecCur_RU
| ||
InventTableModule
|
PriceUnit
| ||
InventTableModule
|
SuppItemGroupId
| ||
InventTableModule
|
TaxItemGroupId
| ||
InventTableModule
|
TaxWithholdCalculate_TH
| ||
InventTableModule
|
TaxWithholdItemGroupHeading_TH
| ||
InventTableModule
|
UnderDeliveryPct
| ||
InventTableModule
|
UnitId
| ||
InventTableModule
|
AllocateMarkup
| ||
InventTableModule
|
EndDisc
| ||
InventTableModule
|
InterCompanyBlocked
| ||
InventTableModule
|
ItemId
| ||
InventTableModule
|
LineDisc
| ||
InventTableModule
|
Markup
| ||
InventTableModule
|
MarkupGroupId
| ||
InventTableModule
|
MarkupSecCur_RU
| ||
InventTableModule
|
MaximumRetailPrice_IN
| ||
InventTableModule
|
MaxPriceInclVAT
| ||
InventTableModule
|
MinPriceInclVAT
| ||
InventTableModule
|
ModuleType
| ||
InventTableModule
|
MultiLineDisc
| ||
InventTableModule
|
OverDeliveryPct
| ||
InventTableModule
|
PDSPricingPrecision
| ||
InventTableModule
|
Price
| ||
InventTableModule
|
PriceDate
| ||
InventTableModule
|
PriceInclVAT
| ||
InventTableModule
|
PriceQty
| ||
InventTableModule
|
PriceSecCur_RU
| ||
InventTableModule
|
PriceUnit
| ||
InventTableModule
|
SuppItemGroupId
| ||
InventTableModule
|
TaxItemGroupId
| ||
InventTableModule
|
TaxWithholdCalculate_TH
| ||
InventTableModule
|
TaxWithholdItemGroupHeading_TH
| ||
InventTableModule
|
UnderDeliveryPct
| ||
InventTableModule
|
UnitId
| ||
InventTableModule
|
AllocateMarkup
| ||
InventTableModule
|
EndDisc
| ||
InventTableModule
|
InterCompanyBlocked
| ||
InventTableModule
|
ItemId
| ||
InventTableModule
|
LineDisc
| ||
InventTableModule
|
Markup
| ||
InventTableModule
|
MarkupGroupId
| ||
InventTableModule
|
MarkupSecCur_RU
| ||
InventTableModule
|
MaximumRetailPrice_IN
| ||
InventTableModule
|
MaxPriceInclVAT
| ||
InventTableModule
|
MinPriceInclVAT
| ||
InventTableModule
|
ModuleType
| ||
InventTableModule
|
MultiLineDisc
| ||
InventTableModule
|
OverDeliveryPct
| ||
InventTableModule
|
PDSPricingPrecision
| ||
InventTableModule
|
Price
| ||
InventTableModule
|
PriceDate
| ||
InventTableModule
|
PriceInclVAT
| ||
InventTableModule
|
PriceQty
| ||
InventTableModule
|
PriceSecCur_RU
| ||
InventTableModule
|
PriceUnit
| ||
InventTableModule
|
SuppItemGroupId
| ||
InventTableModule
|
TaxItemGroupId
| ||
InventTableModule
|
TaxWithholdCalculate_TH
| ||
InventTableModule
|
TaxWithholdItemGroupHeading_TH
| ||
InventTableModule
|
UnderDeliveryPct
| ||
InventTableModule
|
UnitId
| ||
EcoResTrackingDimensionGroup
|
IsSerialNumberControlEnabled
| ||
EcoResStorageDimensionGroup
|
IsWarehouseMandatoryEnabled
| ||
EcoResStorageDimensionGroup
|
IsWarehousePrimaryStockingEnabled
| ||
InventTable
|
ItemBuyerGroupId
| ||
InventTable
|
ItemDimCostPrice
| ||
InventItemGroupItem
|
ItemGroupDataAreaId
| ||
InventItemGroupItem
|
ItemGroupId
| ||
InventTable
|
ItemPriceToleranceGroupId
| ||
InventTable
|
ItemTaggingLevel
| ||
InventTable
|
ItemType
| ||
InventItemInventSetup
|
LeadTime
| ||
InventItemInventSetup
|
LowestQty
| ||
InventItemInventSetup
|
MandatoryInventLocation
| ||
InventItemInventSetup
|
MandatoryInventSite
| ||
InventTable
|
MarkupCode_RU
| ||
InventTable
|
MatchingPolicy
| ||
InventTable
|
MinimumPalletQuantity
| ||
InventModelGroupItem
|
ModelGroupDataAreaId
| ||
InventModelGroupItem
|
ModelGroupId
| ||
InventItemInventSetup
|
MultipleQty
| ||
InventTable
|
NameAlias
| ||
InventTable
|
NetWeight
| ||
InventTable
|
NGPCodesTable_FR
| ||
InventFiscalLIFOGroup
|
NormalValue
| ||
InventTable
|
NRTaxGroup_LV
| ||
InventTable
|
OrigCountryRegionId
| ||
InventTable
|
OrigCountyId
| ||
InventTable
|
OrigStateId
| ||
InventItemInventSetup
|
Override
| ||
InventTable
|
PackagingGroupId
| ||
InventTable
|
Packing_RU
| ||
InventTable
|
PalletTagging
| ||
InventTable
|
PBAAutoStart
| ||
InventTable
|
PBAHideApproval
| ||
InventTable
|
PBAHideDialog
| ||
InventTable
|
PBAInventItemGroupId
| ||
InventTable
|
PBAItemAutoGenerated
| ||
InventTable
|
PBAItemConfigurable
| ||
InventTable
|
PBAMandatoryConfig
| ||
InventTable
|
PDSBaseAttributeId
| ||
InventTable
|
PdsBestBefore
| ||
EcoResProduct
|
PdsCWProduct
| ||
InventTable
|
PdsCWWMSMinimumPalletQty
| ||
InventTable
|
PdsCWWMSQtyPerLayer
| ||
InventTable
|
PdsCWWMSStandardPalletQty
| ||
InventTable
|
PdsFreightAllocationGroupId
| ||
InventTable
|
PdsItemRebateGroupId
| ||
InventTable
|
PDSPotencyAttribRecording
| ||
InventTable
|
PdsShelfAdvice
| ||
InventTable
|
PdsShelfLife
| ||
InventTable
|
PDSTargetFactor
| ||
InventTable
|
PdsVendorCheckItem
| ||
InventTable
|
Phantom
| ||
InventTable
|
PKWiUCode_PL
| ||
InventTable
|
PmfPlanningItemId
| ||
InventTable
|
PmfProductType
| ||
InventTable
|
PmfYieldPct
| ||
InventTable
|
PrimaryVendorId
| ||
InventTable
|
ProdFlushingPrincip
| ||
InventTable
|
ProdGroupId
| ||
InventTable
|
ProdPoolId
| ||
EcoResProductIdentifier
|
ProductNumber
| ||
EcoResProduct
|
ProductType
| ||
InventTable
|
projCategoryId
| ||
InventTable
|
PropertyId
| ||
InventTable
|
PurchModel
| ||
InventTable
|
qtyPerLayer
| ||
InventTable
|
ReqGroupId
| ||
InventTable
|
SADRateCode_PL
| ||
InventTable
|
SalesContributionRatio
| ||
InventTable
|
SalesModel
| ||
InventTable
|
SalesPercentMarkup
| ||
InventTable
|
SalesPriceModelBasic
| ||
InventTable
|
ScrapConst
| ||
InventTable
|
ScrapVar
| ||
EcoResProduct
|
SearchName
| ||
InventTable
|
SerialNumGroupId
| ||
InventTable
|
ServiceCodeTable_IN
| ||
InventTable
|
SkipIntraCompanySync_RU
| ||
InventTable
|
sortCode
| ||
InventTable
|
StandardConfigId
| ||
InventTable
|
StandardInventColorId
| ||
InventTable
|
StandardInventSizeId
| ||
InventTable
|
StandardInventStyleId
| ||
InventTable
|
standardPalletQuantity
| ||
InventItemInventSetup
|
StandardQty
| ||
InventTable
|
StatisticsFactor
| ||
InventItemInventSetup
|
Stopped
| ||
InventTable
|
TaraWeight
| ||
InventTable
|
TaxationOrigin_BR
| ||
InventTable
|
TaxFiscalClassification_BR
| ||
InventTable
|
TaxPackagingQty
| ||
InventTable
|
TaxServiceCode_BR
| ||
InventTable
|
UnitVolume
| ||
InventTable
|
UseAltItemId
| ||
InventFiscalLIFOGroup
|
ValueCalc
| ||
InventTable
|
Width
| ||
InventTable
|
WMSArrivalHandlingTime
| ||
InventTable
|
WMSPalletTypeId
| ||
InventTable
|
WMSPickingQtyTime
|
In case you want to import items in specific companies (Released products) you can use Items import template in Data Import Export Framework
Table Name
|
Field Name
|
DT
|
ML/V
|
InventTable
|
ABCContributionMargin
| ||
InventTable
|
ABCRevenue
| ||
InventTable
|
ABCTieUp
| ||
InventTable
|
ABCValue
| ||
InventTable
|
AltConfigId
| ||
InventTable
|
AltInventColorId
| ||
InventTable
|
AltInventSizeId
| ||
InventTable
|
AltInventStyleId
| ||
InventTable
|
AltItemId
| ||
InventTable
|
AssetGroupId_RU
| ||
InventTable
|
AssetId_RU
| ||
InventItemInventSetup
|
ATPApplyDemandTimeFence
| ||
InventItemInventSetup
|
ATPApplySupplyTimeFence
| ||
InventItemInventSetup
|
ATPBackwardDemandTimeFence
| ||
InventItemInventSetup
|
ATPBackwardSupplyTimeFence
| ||
InventItemInventSetup
|
ATPInclPlannedOrders
| ||
InventItemInventSetup
|
ATPTimeFence
| ||
InventTable
|
AutoReportFinished
| ||
InventTable
|
BatchNumGroupId
| ||
InventTable
|
BOMCalcGroupId
| ||
InventTable
|
BOMLevel
| ||
InventTable
|
BOMManualReceipt
| ||
InventTable
|
BOMUnitId
| ||
InventItemInventSetup
|
CalendarDays
| ||
InventTable
|
CommissionGroupId
| ||
InventTable
|
CostGroupId
| ||
InventTable
|
CostModel
| ||
InventTable
|
CustomsExportTariffCodeTable_IN
| ||
InventTable
|
CustomsImportTariffCodeTable_IN
| ||
InventTable
|
DefaultDimension
| ||
InventItemSetupSupplyType
|
DefaultOrderType
| ||
InventItemInventSetup
|
DeliveryDateControlType
| ||
InventTable
|
Density
| ||
InventTable
|
Depth
| ||
InventTable
|
EPCManager
| ||
InventTable
|
ExceptionCode_BR
| ||
InventTable
|
ExciseTariffCodes_IN
| ||
InventTable
|
EximProductGroupTable_IN
| ||
InventTable
|
FiscalLIFOAvoidCalc
| ||
InventTable
|
FiscalLIFONormalValue
| ||
InventTable
|
FiscalLIFONormalValueCalc
| ||
InventTable
|
ForecastDMPInclude
| ||
InventTable
|
grossDepth
| ||
InventTable
|
grossHeight
| ||
InventTable
|
grossWidth
| ||
InventFiscalLIFOGroup
|
GroupId
| ||
InventTable
|
Height
| ||
InventItemInventSetup
|
HighestQty
| ||
InventTable
|
ICMSOnService_BR
| ||
InventFiscalLIFOGroup
|
Individual
| ||
InventTable
|
Intracode
| ||
InventTable
|
IntrastatExclude
| ||
InventTable
|
IntrastatProcId_CZ
| ||
InventTable
|
IntraUnit
| ||
InventItemInventSetup
|
InventDimId
| ||
InventItemInventSetup
|
InventDimIdDefault
| ||
InventTable
|
InventFiscalLIFOGroup
| ||
InventItemInventSetup
|
ItemId
| ||
InventItemSetupSupplyType
|
ItemId
| ||
InventTable
|
InventProductType_BR
| ||
InventTable
|
ItemId
| ||
InventTableModule
|
AllocateMarkup
| ||
InventTableModule
|
EndDisc
| ||
InventTableModule
|
InterCompanyBlocked
| ||
InventTableModule
|
ItemId
| ||
InventTableModule
|
LineDisc
| ||
InventTableModule
|
Markup
| ||
InventTableModule
|
MarkupGroupId
| ||
InventTableModule
|
MarkupSecCur_RU
| ||
InventTableModule
|
MaximumRetailPrice_IN
| ||
InventTableModule
|
MaxPriceInclVAT
| ||
InventTableModule
|
MinPriceInclVAT
| ||
InventTableModule
|
ModuleType
| ||
InventTableModule
|
MultiLineDisc
| ||
InventTableModule
|
OverDeliveryPct
| ||
InventTableModule
|
PDSPricingPrecision
| ||
InventTableModule
|
Price
| ||
InventTableModule
|
PriceDate
| ||
InventTableModule
|
PriceInclVAT
| ||
InventTableModule
|
PriceQty
| ||
InventTableModule
|
PriceSecCur_RU
| ||
InventTableModule
|
PriceUnit
| ||
InventTableModule
|
SuppItemGroupId
| ||
InventTableModule
|
TaxItemGroupId
| ||
InventTableModule
|
TaxWithholdCalculate_TH
| ||
InventTableModule
|
TaxWithholdItemGroupHeading_TH
| ||
InventTableModule
|
UnderDeliveryPct
| ||
InventTableModule
|
UnitId
| ||
InventTableModule
|
AllocateMarkup
| ||
InventTableModule
|
EndDisc
| ||
InventTableModule
|
InterCompanyBlocked
| ||
InventTableModule
|
ItemId
| ||
InventTableModule
|
LineDisc
| ||
InventTableModule
|
Markup
| ||
InventTableModule
|
MarkupGroupId
| ||
InventTableModule
|
MarkupSecCur_RU
| ||
InventTableModule
|
MaximumRetailPrice_IN
| ||
InventTableModule
|
MaxPriceInclVAT
| ||
InventTableModule
|
MinPriceInclVAT
| ||
InventTableModule
|
ModuleType
| ||
InventTableModule
|
MultiLineDisc
| ||
InventTableModule
|
OverDeliveryPct
| ||
InventTableModule
|
PDSPricingPrecision
| ||
InventTableModule
|
Price
| ||
InventTableModule
|
PriceDate
| ||
InventTableModule
|
PriceInclVAT
| ||
InventTableModule
|
PriceQty
| ||
InventTableModule
|
PriceSecCur_RU
| ||
InventTableModule
|
PriceUnit
| ||
InventTableModule
|
SuppItemGroupId
| ||
InventTableModule
|
TaxItemGroupId
| ||
InventTableModule
|
TaxWithholdCalculate_TH
| ||
InventTableModule
|
TaxWithholdItemGroupHeading_TH
| ||
InventTableModule
|
UnderDeliveryPct
| ||
InventTableModule
|
UnitId
| ||
InventTableModule
|
AllocateMarkup
| ||
InventTableModule
|
EndDisc
| ||
InventTableModule
|
InterCompanyBlocked
| ||
InventTableModule
|
ItemId
| ||
InventTableModule
|
LineDisc
| ||
InventTableModule
|
Markup
| ||
InventTableModule
|
MarkupGroupId
| ||
InventTableModule
|
MarkupSecCur_RU
| ||
InventTableModule
|
MaximumRetailPrice_IN
| ||
InventTableModule
|
MaxPriceInclVAT
| ||
InventTableModule
|
MinPriceInclVAT
| ||
InventTableModule
|
ModuleType
| ||
InventTableModule
|
MultiLineDisc
| ||
InventTableModule
|
OverDeliveryPct
| ||
InventTableModule
|
PDSPricingPrecision
| ||
InventTableModule
|
Price
| ||
InventTableModule
|
PriceDate
| ||
InventTableModule
|
PriceInclVAT
| ||
InventTableModule
|
PriceQty
| ||
InventTableModule
|
PriceSecCur_RU
| ||
InventTableModule
|
PriceUnit
| ||
InventTableModule
|
SuppItemGroupId
| ||
InventTableModule
|
TaxItemGroupId
| ||
InventTableModule
|
TaxWithholdCalculate_TH
| ||
InventTableModule
|
TaxWithholdItemGroupHeading_TH
| ||
InventTableModule
|
UnderDeliveryPct
| ||
InventTableModule
|
UnitId
| ||
InventTable
|
ItemBuyerGroupId
| ||
InventItemSetupSupplyType
|
ItemDataAreaId
| ||
InventTable
|
ItemDimCostPrice
| ||
InventTable
|
ItemPriceToleranceGroupId
| ||
InventTable
|
ItemTaggingLevel
| ||
InventTable
|
ItemType
| ||
InventItemInventSetup
|
LeadTime
| ||
InventItemInventSetup
|
LowestQty
| ||
InventItemInventSetup
|
MandatoryInventLocation
| ||
InventItemInventSetup
|
MandatoryInventSite
| ||
InventTable
|
MarkupCode_RU
| ||
InventTable
|
MatchingPolicy
| ||
InventTable
|
MinimumPalletQuantity
| ||
InventItemInventSetup
|
MultipleQty
| ||
InventFiscalLIFOGroup
|
Name
| ||
InventTable
|
NameAlias
| ||
InventTable
|
NetWeight
| ||
InventTable
|
NGPCodesTable_FR
| ||
InventFiscalLIFOGroup
|
NormalValue
| ||
InventTable
|
NRTaxGroup_LV
| ||
InventTable
|
OrigCountryRegionId
| ||
InventTable
|
OrigCountyId
| ||
InventTable
|
OrigStateId
| ||
InventItemInventSetup
|
Override
| ||
InventTable
|
PackagingGroupId
| ||
InventTable
|
Packing_RU
| ||
InventTable
|
PalletTagging
| ||
InventTable
|
PBAAutoStart
| ||
InventTable
|
PBAHideApproval
| ||
InventTable
|
PBAHideDialog
| ||
InventTable
|
PBAInventItemGroupId
| ||
InventTable
|
PBAItemAutoGenerated
| ||
InventTable
|
PBAItemConfigurable
| ||
InventTable
|
PBAMandatoryConfig
| ||
InventTable
|
PDSBaseAttributeId
| ||
InventTable
|
PdsBestBefore
| ||
InventTable
|
PdsCWWMSMinimumPalletQty
| ||
InventTable
|
PdsCWWMSQtyPerLayer
| ||
InventTable
|
PdsCWWMSStandardPalletQty
| ||
InventTable
|
PdsFreightAllocationGroupId
| ||
InventTable
|
PdsItemRebateGroupId
| ||
InventTable
|
PDSPotencyAttribRecording
| ||
InventTable
|
PdsShelfAdvice
| ||
InventTable
|
PdsShelfLife
| ||
InventTable
|
PDSTargetFactor
| ||
InventTable
|
PdsVendorCheckItem
| ||
InventTable
|
Phantom
| ||
InventTable
|
PKWiUCode_PL
| ||
InventTable
|
PmfPlanningItemId
| ||
InventTable
|
PmfProductType
| ||
InventTable
|
PmfYieldPct
| ||
InventTable
|
PrimaryVendorId
| ||
InventTable
|
ProdFlushingPrincip
| ||
InventTable
|
ProdGroupId
| ||
InventTable
|
ProdPoolId
| ||
InventTable
|
Product
| ||
InventTable
|
projCategoryId
| ||
InventTable
|
PropertyId
| ||
InventTable
|
PurchModel
| ||
InventTable
|
qtyPerLayer
| ||
InventTable
|
ReqGroupId
| ||
InventTable
|
SADRateCode_PL
| ||
InventTable
|
SalesContributionRatio
| ||
InventTable
|
SalesModel
| ||
InventTable
|
SalesPercentMarkup
| ||
InventTable
|
SalesPriceModelBasic
| ||
InventTable
|
ScrapConst
| ||
InventTable
|
ScrapVar
| ||
InventTable
|
SerialNumGroupId
| ||
InventTable
|
ServiceCodeTable_IN
| ||
InventTable
|
SkipIntraCompanySync_RU
| ||
InventTable
|
sortCode
| ||
InventTable
|
StandardConfigId
| ||
InventTable
|
StandardInventColorId
| ||
InventTable
|
StandardInventSizeId
| ||
InventTable
|
StandardInventStyleId
| ||
InventTable
|
standardPalletQuantity
| ||
InventItemInventSetup
|
StandardQty
| ||
InventTable
|
StatisticsFactor
| ||
InventItemInventSetup
|
Stopped
| ||
InventTable
|
TaraWeight
| ||
InventTable
|
TaxationOrigin_BR
| ||
InventTable
|
TaxFiscalClassification_BR
| ||
InventTable
|
TaxPackagingQty
| ||
InventTable
|
TaxServiceCode_BR
| ||
InventTable
|
UnitVolume
| ||
InventTable
|
UseAltItemId
| ||
InventFiscalLIFOGroup
|
ValueCalc
| ||
InventTable
|
Width
| ||
InventTable
|
WMSArrivalHandlingTime
| ||
InventTable
|
WMSPalletTypeId
| ||
InventTable
|
WMSPickingQtyTime
|
As the result you will be able to consistently import Customer and Product master data into multiple companies in Microsoft Dynamics AX 2012 using Data Import Export Framework
Summary: This document describes how to use Microsoft Dynamics AX 2012 Data Import Export Framework in Master Data Management scenarios for multiple instances of Microsoft Dynamics AX 2012. In particular I explained the process of how you can create Processing group, define entities for data synchronization and execute actual data synchronization process to support Master Data Management scenario for Customers and Products. Microsoft Dynamics AX 2012 Data Import Export Framework ships with 70 entity templates which cover all main types of master data in Microsoft Dynamics AX 2012. Microsoft Dynamics AX 2012 Data Import Export Framework also allows you to establish batch tasks for periodic data synchronization which may support ongoing Master Data Management activities. <Edited>Please note that Data Import Export Framework is a multi-purpose framework which facilitates data migration efforts and supports integration scenarios in Microsoft Dynamics AX 2012. It can be used for synchronization of master data between different companies or even different instances of Microsoft Dynamics AX 2012, however it's not designed to provide full-fledged Master Data Management capabilities (Content, Relationship, Access, Change, Process), that’s why please review my other articles on how to implement Master Data Management scenario for Microsoft Dynamics using SQL Server Master Data Services.<Edited>
Tags: Dynamics AX 2012, Data Migration Framework, Data Import Export Framework, Master Data Management, Customers, Products.
Note: This document is intended for information purposes only, presented as it is with no warranties from the author. This document may be updated with more content to better outline the issues and describe the solutions.
Author: Alex Anikiev, PhD, MCP
Alex,
ReplyDeleteThank you for your post!
Is there a standard way for importing Product variants using Data Import Export Framework?
Hi Alex,
DeleteCan we import Multiple Addresses for a Customer or Vendor through Data Import Export Framework in (AX 2012 R2) ???
Thanks in advance...
Sreekanth.
The Le_Meridian Funding Service went above and beyond their requirements to assist me with my loan which i used expand my pharmacy business,They were friendly, professional, and absolute gems to work with.I will recommend anyone looking for loan to contact. Email..lfdsloans@lemeridianfds.com Or lfdsloans@outlook.com.
ReplyDeleteWhatsApp ... + 19893943740.