Tuesday, May 14, 2013

Microsoft Dynamics AX 2012 Data Import Export Framework in Master Data Management Scenario

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 
 
 

2 comments:

  1. Alex,

    Thank you for your post!
    Is there a standard way for importing Product variants using Data Import Export Framework?

    ReplyDelete
    Replies
    1. Hi Alex,
      Can we import Multiple Addresses for a Customer or Vendor through Data Import Export Framework in (AX 2012 R2) ???

      Thanks in advance...
      Sreekanth.

      Delete