Standard export of data

Hello,

I was wondering what all data gets exported when you do a standard export of data in AX?does it export shared data/Table as well? how does the export work?please shed some light or point me to some article.

thanks.

The tables that are exported as Default Data are the ones who has the table property TableContents set to Default Data or Default data + Base data. This is the list for DAX 2009 RTM:

Info Message (03:42:06 pm) AddressFormatHeading
Info Message (03:42:06 pm) AddressFormatLines
Info Message (03:42:06 pm) BankGroup
Info Message (03:42:06 pm) BankTransType
Info Message (03:42:06 pm) DEL_BatchJournalTypeJob
Info Message (03:42:06 pm) DEL_BatchJournalType
Info Message (03:42:06 pm) BOMParameters
Info Message (03:42:06 pm) BudgetModel
Info Message (03:42:06 pm) IntrastatTransactionCode
Info Message (03:42:06 pm) BusinessStatisticsDef
Info Message (03:42:06 pm) CashDisc
Info Message (03:42:06 pm) CompanyInfo
Info Message (03:42:06 pm) AddressCountryRegion
Info Message (03:42:06 pm) AddressCounty
Info Message (03:42:06 pm) Currency
Info Message (03:42:06 pm) LedgerBalColumnsDimQuery
Info Message (03:42:06 pm) CustGroup
Info Message (03:42:06 pm) CustInterest
Info Message (03:42:06 pm) CustInterestFee
Info Message (03:42:06 pm) CustLedger
Info Message (03:42:06 pm) CustLedgerAccounts
Info Message (03:42:06 pm) CustParameters
Info Message (03:42:06 pm) CustPaymModeTable
Info Message (03:42:06 pm) CustStatisticsGroup
Info Message (03:42:06 pm) StatRepInterval
Info Message (03:42:06 pm) StatRepIntervalLine
Info Message (03:42:06 pm) DlvMode
Info Message (03:42:06 pm) DlvTerm
Info Message (03:42:06 pm) DocuField
Info Message (03:42:06 pm) DocuTable
Info Message (03:42:06 pm) DocuType
Info Message (03:42:06 pm) ExchRates
Info Message (03:42:06 pm) ForecastModel
Info Message (03:42:06 pm) FormLetterRemarks
Info Message (03:42:06 pm) BOMCostGroup
Info Message (03:42:06 pm) BOMCostProfit
Info Message (03:42:06 pm) InventCountGroup
Info Message (03:42:06 pm) InventItemGroup
Info Message (03:42:06 pm) InventJournalName
Info Message (03:42:06 pm) InventPosting
Info Message (03:42:06 pm) InventLocation
Info Message (03:42:06 pm) InventNumGroup
Info Message (03:42:06 pm) InventParameters
Info Message (03:42:06 pm) ReqGroup
Info Message (03:42:06 pm) ReqPlanForecast
Info Message (03:42:06 pm) ReqParameters
Info Message (03:42:06 pm) ReqPlan
Info Message (03:42:06 pm) ReqPlanSched
Info Message (03:42:06 pm) LanguageTxt
Info Message (03:42:06 pm) LedgerAllocateKey
Info Message (03:42:06 pm) LedgerAllocateTrans
Info Message (03:42:06 pm) LedgerBalColumns
Info Message (03:42:06 pm) LedgerBalHeader
Info Message (03:42:06 pm) LedgerControlPosting
Info Message (03:42:06 pm) LedgerJournalName
Info Message (03:42:06 pm) LedgerParameters
Info Message (03:42:06 pm) LedgerPeriod
Info Message (03:42:06 pm) LedgerPeriodCode
Info Message (03:42:06 pm) LedgerTable
Info Message (03:42:06 pm) LedgerTableInterval
Info Message (03:42:06 pm) MarkupGroup
Info Message (03:42:06 pm) MarkupTable
Info Message (03:42:06 pm) GanttLine
Info Message (03:42:06 pm) GanttTable
Info Message (03:42:06 pm) ProdJournalName
Info Message (03:42:06 pm) ProdParameters
Info Message (03:42:06 pm) ProdPool
Info Message (03:42:06 pm) ProdGroup
Info Message (03:42:06 pm) NumberSequenceTable
Info Message (03:42:06 pm) PaymTerm
Info Message (03:42:06 pm) PaymSched
Info Message (03:42:06 pm) PaymSchedLine
Info Message (03:42:06 pm) EventParameters
Info Message (03:42:06 pm) ProjStatusTypeRule
Info Message (03:42:06 pm) ProdStatusParameters
Info Message (03:42:06 pm) PriceDiscGroup
Info Message (03:42:06 pm) PriceParameters
Info Message (03:42:06 pm) PurchParameters
Info Message (03:42:06 pm) RouteGroup
Info Message (03:42:06 pm) RouteJobSetup
Info Message (03:42:06 pm) RouteOprTable
Info Message (03:42:06 pm) RouteParameters
Info Message (03:42:06 pm) SalesParameters
Info Message (03:42:06 pm) AxdDocumentParameters
Info Message (03:42:06 pm) TaxExemptCodeTable
Info Message (03:42:06 pm) CustPaymMethodAttribute
Info Message (03:42:06 pm) VendPaymMethodAttribute
Info Message (03:42:06 pm) AddressState
Info Message (03:42:06 pm) SysExpImpTable
Info Message (03:42:06 pm) SysExpImpGroup
Info Message (03:42:06 pm) TaxAuthorityAddress
Info Message (03:42:06 pm) TaxData
Info Message (03:42:06 pm) TaxGroupData
Info Message (03:42:06 pm) TaxGroupHeading
Info Message (03:42:06 pm) TaxItemGroupHeading
Info Message (03:42:06 pm) TaxLedgerAccountGroup
Info Message (03:42:06 pm) TaxOnItem
Info Message (03:42:06 pm) TaxParameters
Info Message (03:42:06 pm) TaxPeriodHead
Info Message (03:42:06 pm) TaxReportPeriod
Info Message (03:42:06 pm) TaxTable
Info Message (03:42:06 pm) TransactTxt
Info Message (03:42:06 pm) Unit
Info Message (03:42:06 pm) UnitConvert
Info Message (03:42:06 pm) VendGroup
Info Message (03:42:06 pm) VendLedger
Info Message (03:42:06 pm) VendLedgerAccounts
Info Message (03:42:06 pm) VendParameters
Info Message (03:42:06 pm) VendPaymModeSpec
Info Message (03:42:06 pm) VendPaymModeTable
Info Message (03:42:06 pm) WorkCalendarDate
Info Message (03:42:06 pm) WorkCalendarDateLine
Info Message (03:42:06 pm) WorkCalendarTable
Info Message (03:42:06 pm) WorkTimeLine
Info Message (03:42:06 pm) WorkTimeTable
Info Message (03:42:06 pm) AddressZipCode
Info Message (03:42:06 pm) ReqReduceKey
Info Message (03:42:06 pm) ReqReduceLine
Info Message (03:42:06 pm) IntrastatItemCode
Info Message (03:42:06 pm) IntrastatParameters
Info Message (03:42:06 pm) WrkCtrProperty
Info Message (03:42:06 pm) WrkCtrPropertyLine
Info Message (03:42:06 pm) ProjCategory
Info Message (03:42:06 pm) ProjCategoryGroup
Info Message (03:42:06 pm) ProjGroup
Info Message (03:42:06 pm) ProjLineProperty
Info Message (03:42:06 pm) ProjJournalName
Info Message (03:42:06 pm) ProjJournalStatusLine
Info Message (03:42:06 pm) ProjJournalStatusTable
Info Message (03:42:06 pm) ProjPosting
Info Message (03:42:06 pm) ProjParameters
Info Message (03:42:06 pm) ProjPeriodTable
Info Message (03:42:06 pm) ProjPeriodLine
Info Message (03:42:06 pm) ReturnActionDefaults
Info Message (03:42:06 pm) BankTransactionTypeGroupHeader
Info Message (03:42:06 pm) BankTransTypeGroupDetails
Info Message (03:42:06 pm) WrkCtrParameters
Info Message (03:42:06 pm) WMSBlockingCause
Info Message (03:42:06 pm) WMSForkLift
Info Message (03:42:06 pm) WMSJournalName
Info Message (03:42:06 pm) WMSPalletType
Info Message (03:42:06 pm) WMSPalletTypeGroup
Info Message (03:42:06 pm) WMSPalletTypeGroupMember
Info Message (03:42:06 pm) WMSParameters
Info Message (03:42:06 pm) WMSStoreArea
Info Message (03:42:06 pm) WMSStoreZone
Info Message (03:42:06 pm) WMSStoreZoneArea
Info Message (03:42:06 pm) InventDimSetup
Info Message (03:42:06 pm) InventDimGroup
Info Message (03:42:06 pm) NumberSequenceReference
Info Message (03:42:06 pm) BankParameters
Info Message (03:42:06 pm) InventModelGroup
Info Message (03:42:06 pm) TaxReportCollection
Info Message (03:42:06 pm) InventBuyerGroup
Info Message (03:42:06 pm) ProjControl
Info Message (03:42:06 pm) SalesPool
Info Message (03:42:06 pm) PurchPool
Info Message (03:42:06 pm) ProjControlCostGroup
Info Message (03:42:06 pm) ProjControlCategory
Info Message (03:42:06 pm) IntrastatTransportMode
Info Message (03:42:06 pm) IntrastatPort
Info Message (03:42:06 pm) InventDimSetupGrid
Info Message (03:42:06 pm) SysExpImpField
Info Message (03:42:06 pm) NumberSequenceGroup
Info Message (03:42:06 pm) CustPaymMethodVal
Info Message (03:42:06 pm) VendPaymMethodVal
Info Message (03:42:06 pm) IntrastatStatProc
Info Message (03:42:06 pm) SysInetCSS
Info Message (03:42:06 pm) DEL_ProjTableStatusSetup
Info Message (03:42:06 pm) SysInetThemeTable
Info Message (03:42:06 pm) SysImageTable
Info Message (03:42:06 pm) PaymDay
Info Message (03:42:06 pm) PaymDayLine
Info Message (03:42:06 pm) DEL_BMScriptLine
Info Message (03:42:06 pm) DEL_BMScriptParmLine
Info Message (03:42:06 pm) DEL_BMScriptTable
Info Message (03:42:06 pm) ReqSafetyKey
Info Message (03:42:06 pm) ReqSafetyLine
Info Message (03:42:06 pm) DestinationCode
Info Message (03:42:06 pm) SuppItemGroup
Info Message (03:42:06 pm) SalesOrigin
Info Message (03:42:06 pm) ECPParameters
Info Message (03:42:06 pm) TaxPurchaseTaxTable
Info Message (03:42:06 pm) DEL_WebApplicationTable
Info Message (03:42:06 pm) LedgerPostingJournal
Info Message (03:42:06 pm) PurchReqParameters
Info Message (03:42:06 pm) CustInterestRate
Info Message (03:42:06 pm) TaxPAYGVariationTable
Info Message (03:42:06 pm) TaxReportLedgerAccounts
Info Message (03:42:06 pm) DEL_WebApplicationResources
Info Message (03:42:06 pm) TaxFringeVariationTable
Info Message (03:42:06 pm) CustClassificationGroup
Info Message (03:42:06 pm) WorkflowMessageText
Info Message (03:42:06 pm) AssetGroup
Info Message (03:42:06 pm) ProdParametersDim
Info Message (03:42:06 pm) WrkCtrParametersDim
Info Message (03:42:06 pm) AssetDepreciationProfile
Info Message (03:42:06 pm) AssetDisposalParameters
Info Message (03:42:06 pm) AssetLedger
Info Message (03:42:06 pm) AssetLocation
Info Message (03:42:06 pm) AssetParameters
Info Message (03:42:06 pm) CustPaymFormat
Info Message (03:42:06 pm) VendPaymFormat
Info Message (03:42:06 pm) ProjLinePropertySetup
Info Message (03:42:06 pm) BarcodeSetup
Info Message (03:42:06 pm) DEL_SalesTaxNotes
Info Message (03:42:06 pm) AssetConsumptionFactor
Info Message (03:42:06 pm) AssetConsumptionFactorLines
Info Message (03:42:06 pm) AssetConsumptionUnit
Info Message (03:42:06 pm) AssetReserveType
Info Message (03:42:06 pm) AssetRevaluationGroup
Info Message (03:42:06 pm) AssetRevaluationGroupSpec
Info Message (03:42:06 pm) ExtCodeTable
Info Message (03:42:06 pm) TutorialDefData
Info Message (03:42:06 pm) InventPostingParameters
Info Message (03:42:06 pm) InventPackagingGroup
Info Message (03:42:06 pm) InventPackagingMaterialCode
Info Message (03:42:06 pm) InventPackagingMaterialFee
Info Message (03:42:06 pm) AssetCalendar
Info Message (03:42:06 pm) AssetCalendarPeriod
Info Message (03:42:06 pm) AssetCalendarYear
Info Message (03:42:06 pm) ReqItemJournalName
Info Message (03:42:06 pm) GanttColorTable
Info Message (03:42:06 pm) LedgerAccountTypePrefix
Info Message (03:42:06 pm) VendDefaultAccounts
Info Message (03:42:06 pm) SMAParameters
Info Message (03:42:06 pm) SalesCarrier
Info Message (03:42:06 pm) SalesPackageAppearance
Info Message (03:42:06 pm) DlvReason
Info Message (03:42:06 pm) BankCodaParameters
Info Message (03:42:06 pm) TaxWithholdData
Info Message (03:42:06 pm) TaxWithholdGroupData
Info Message (03:42:06 pm) TaxWithholdGroupHeading
Info Message (03:42:06 pm) TaxWithholdLimit
Info Message (03:42:06 pm) TaxWithholdTable
Info Message (03:42:06 pm) COSPlanModel
Info Message (03:42:06 pm) LedgerBalHeaderDim
Info Message (03:42:06 pm) LedgerBalColumnsDim
Info Message (03:42:06 pm) SMAParametersSubscription
Info Message (03:42:06 pm) InventItemPriceToleranceGroup
Info Message (03:42:06 pm) VendPriceToleranceGroup
Info Message (03:42:06 pm) HRPLimitTypeTable
Info Message (03:42:06 pm) HRPLimitDefaultTableRelationship
Info Message (03:42:06 pm) HRPLimitTableRelationship
Info Message (03:42:06 pm) PurchRFQParameters
Info Message (03:42:06 pm) AssetAcquisitionMethod
Info Message (03:42:06 pm) AssetCondition
Info Message (03:42:06 pm) AssetMajorType
Info Message (03:42:06 pm) ReasonTable
Info Message (03:42:06 pm) CostingVersion
Info Message (03:42:06 pm) ISOCurrencyCode
Info Message (03:42:06 pm) RouteCostCategoryPrice
Info Message (03:42:06 pm) WorkflowParameters
Info Message (03:42:06 pm) BudgetRevision
Info Message (03:42:06 pm) DirParameters
Info Message (03:42:06 pm) SysWorkflowParameters
Info Message (03:42:06 pm) InventSite
Info Message (03:42:06 pm) KMKnowledgeJournalName
Info Message (03:42:06 pm) KMBSCParameters
Info Message (03:42:06 pm) FCMParameters

The criteria for setting this property is taken from Best Practices whitepaper:



Leave this property set to Not Specified for most tables.



Set to Default Data for customer-independent data. For example, time intervals and unit conversions.



Set to Base Data for customer-dependent data. This data is often from an existing system that has been imported or entered into Microsoft Dynamics AX. For example, customers and vendors.



Set to Default+Base Data for data that can be customer-dependent in some countries/regions, but not in others.





Hi Prashob,

http://blogs.msdn.com/b/emeadaxsupport/archive/2009/09/07/how-does-the-export-to-excel-feature-work-under-the-hood.aspx

Check this link for better undersatnding of the Export of data in AX2009 :slight_smile: