从 Dynamics AX 2009 数据字典配置中提取所有表
4.00/5 (1投票)
从 Dynamics AX 2009 数据字典配置键中提取所有表
- 下载 Class_ExtractTablesNamesFromConfigs - 5.29 KB
- 下载 List_of_Dynamics_AX_2009_database_Config_Names.zip - 8.33 KB
引言
本文主要面向熟悉 X++ 和 MorphX 的中级 Microsoft Dynamics AX 用户。本文的目的是帮助用户从 Microsoft Dynamics AX 2009 数据字典中提供的配置键中提取表名。该代码实用工具对于中级到高级用户分析和理解与模块相关的架构和表设计非常有用。这可能在项目初期分析和设计阶段有所帮助。
Microsoft 在 Microsoft Dynamics 品牌下有一系列产品，这些产品更适用于小型、中型和大型企业组织。Microsoft Dynamics AX（前身为 Axapta）是 Microsoft Dynamics ERP 的主要产品之一。
X++ 是用于构建 Dynamics AX 的语言。MorphX 是 Microsoft Dynamics AX 中的集成开发环境，允许开发人员以图形方式设计 GUI。通过启动 X++ 代码编辑器，MorphX 可以访问应用程序中可用的应用程序类。
Dynamics AX 2009 数据字典中的配置键应如上图所示。
背景
XPO 是 Dynamics AX 对象的一种输出格式。XPO 对象可以在 Microsoft Dynamics AX 中导入和导出。
反向工程工具和交叉引用工具的使用和解释超出了本文的范围。
ExtractTablesNamesFromConfigs 类
此类主要用于演示从配置键中提取表信息的某个方法。可用于分析。这是一个简单的类，它基于数据字典中的配置键名称即时创建文本文件。
这些配置键包含表信息。可以通过属性窗口中的标签信息来确定它与哪个模块相关。代码使用 MorphX IDE 使用 X++ 代码编写。
ExtractTablesNamesFromConfigs 类是一个实用工具，用于将所有表名从配置键提取到文本文件中。所有文本文件都将在“C:\AllTables\Configs”文件夹下以相关的配置名称创建。
使用代码
从 zip 文件中提取 xpo 文件，然后将 Class_ExtractTablesNamesFromConfigs.xpo 对象导入 AOT。导入后，您将能够在 AOT 类树的末尾看到该对象。单击打开以运行此类。执行后，可以在“C:\AllTables\Configs”文件夹下找到文本文件。
为了更好地理解关系和数据模型，用户可以使用交叉引用工具和反向工程工具。
Dynamics AX 2009 中的交叉引用工具有助于理解对象关系。有关更多信息，请参阅以下链接的在线文档：http://msdn.microsoft.com/en-us/library/aa626961(v=ax.50).aspx
反向工程工具使您能够通过创建 UML 数据模型、UML 对象模型和 ERX ER 数据模型来可视化 Microsoft Dynamics AX 中的数据和类。有关更多信息，请参阅以下链接的在线文档：http://msdn.microsoft.com/en-us/library/aa499193(v=ax.50).aspx
Dynamics AX 中的大多数配置都已在此处添加，如果您想添加新的配置，请在此处的以下方法中进行自定义。
public void execMethod()
{
int i;
str sConKeyName[];
sConKeyName[1]="AIF"; //Application Integration Framework
sConKeyName[2]="AIFWebService"; //Application Integration Framework Web Services
sConKeyName[3]="Asset"; //Fixed assets
sConKeyName[4]="AssetDepBook"; //Fixed asset depreciation books
sConKeyName[5]="Bank"; //Bank
sConKeyName[6]="BankCheque"; //Check
sConKeyName[7]="BankDeposit"; //Desposit slip
sConKeyName[8]="BankElectronicBanking"; //Electronic Banking
sConKeyName[9]="BAS"; //Business analysis
sConKeyName[10]="BOM"; //Bill of materials
sConKeyName[11]="BOMApprove"; //BOM approval
sConKeyName[12]="BOMCostBreakdown"; //Allow cost breakdown activation
sConKeyName[13]="BOMVersion"; //BOM versions
sConKeyName[14]="Commission"; //Commission
sConKeyName[15]="ComplianceMgmt"; //Compliance Management II
sConKeyName[16]="Config"; //Item dimension - configuration
sConKeyName[17]="COSAllocation"; //Allocation
sConKeyName[18]="COSBaseModule"; //Cost accounting
sConKeyName[19]="COSBudget"; //Budgeting
sConKeyName[20]="COSCalculation"; //Calculation
sConKeyName[21]="COSCostDistribution"; //Cost distribution
sConKeyName[22]="COSImportCAC"; //Import Transaction from previous version
sConKeyName[23]="COSOpenDimension"; //Unlimited dimensions
sConKeyName[24]="COSPlanCostCalc"; //Flexible Budgeting
sConKeyName[25]="COSWorkAllocation"; //Internal cost allocation
sConKeyName[26]="COSWorkDistribution"; //Service distribution
sConKeyName[27]="COSWorkUnits"; //Service categories
sConKeyName[28]="CreditCard"; //Credit card
sConKeyName[29]="CRSEMultiple"; //Multiple countries/regions
sConKeyName[30]="CSS"; //Customer Self-Service
sConKeyName[31]="Currency"; //
sConKeyName[32]="CurrencyEuro"; //Euro
sConKeyName[33]="CurrencySecondaryCurrency"; //Secondary currency
sConKeyName[34]="CustBillOfExchange"; //Bill of exchange
sConKeyName[35]="CustCentralizedCustStatement"; //Centralized Customer Statement
sConKeyName[36]="CustCollectionLetter"; //Collection Letter
sConKeyName[37]="CustGiro"; //Giro
sConKeyName[38]="CustInterest "; //Interest
sConKeyName[39]="CustMultipleInterestRates "; //Multiple Interest Rates
sConKeyName[40]="CustVendCreditInvoicing "; //Credit Invoicing
sConKeyName[41]="CustVendNegotiableInstrument"; //Negotiable Instrument
sConKeyName[42]="DataExport"; //Data Export
sConKeyName[43]="DimensionSetHierarchy "; //Dimension Set Hierarchy
sConKeyName[44]="EMS "; //Environmental Sustainability
sConKeyName[45]="EP"; //Enterprise Portal
sConKeyName[46]="EPCompliance"; //Compliance site
sConKeyName[47]="EPSalesRep"; //Sales Representative
sConKeyName[48]="ESS"; //Employee Self-Service
sConKeyName[49]="Event"; //Event
sConKeyName[50]="Forecast"; //Inventory forecast
sConKeyName[51]="ForecastDMPBase"; //Demand Planning Base
sConKeyName[52]="ForeignTrade"; //Foreign trade
sConKeyName[53]="FullSettlement "; //Full Settlement
sConKeyName[54]="HRMADA"; //ADA
sConKeyName[55]="HRMAdministration"; //Human Resource I
sConKeyName[56]="HRMAdministrationCompensation"; //Compensation
sConKeyName[57]="HRMAdministrationPayrollInfo "; //Payroll Information
sConKeyName[58]="HRMCollaborative"; //Human Resource III
sConKeyName[59]="HRMCollaborativeCourse"; //Course
sConKeyName[60]="HRMEPEmployeeServices"; //Employee Services Role
sConKeyName[61]="HRMi9"; //I-9
sConKeyName[62]="HRMManagement "; //Human Resource II
sConKeyName[63]="HRMManagementAbsence"; //Absence
sConKeyName[64]="HRMManagementRecruiting"; //Recruiting
sConKeyName[65]="InventItemDimColor"; //Item dimension - Color
sConKeyName[66]="InventItemDimSize "; //Item dimension - Size
sConKeyName[67]="InventPackaging "; //Packaging duty
sConKeyName[68]="InventQualityManagement "; //Quality Management
sConKeyName[69]="InventTransferOrders "; //Transfer orders
sConKeyName[70]="Jmg "; //Shop Floor Control
sConKeyName[71]="JmgEPSFCEmployee"; //Enterprise portal SFC employee role
sConKeyName[72]="JmgJob"; //Shop Floor Control - Job registration
sConKeyName[73]="JmgPayroll"; //Shop Floor Control - Pay generation
sConKeyName[74]="KMBPM"; //Business Process Management
sConKeyName[75]="KMBPMActionPlan"; //Action plans
sConKeyName[76]="KMBPMGameplan"; //Strategic plan
sConKeyName[77]="KMBSC"; //Balanced Scorecard
sConKeyName[78]="KMEPPerformanceManagement"; //Performance Management Role
sConKeyName[79]="KMEPQuestionnaire "; //Questionnaire Role
sConKeyName[80]="KMQuestionnaireAdvanced "; //Questionnaire II
sConKeyName[81]="KMQuestionnaireBasic "; //Questionnaire I
sConKeyName[82]="LedgerAdvAllocation "; //Allocation
sConKeyName[83]="LedgerAdvanced"; //General ledger - advanced
sConKeyName[84]="LedgerAdvanced2"; //General ledger - advanced II
sConKeyName[85]="LedgerAdvCashflowForecast "; //Cash flow forecast
sConKeyName[86]="LedgerAdvConsolidations "; //Consolidate
sConKeyName[87]="LedgerAdvIntercompanyAccounting "; //Intercompany accounting
sConKeyName[88]="LedgerAllocationRules "; //Generated allocation
sConKeyName[89]="LedgerBasic "; //General ledger
sConKeyName[90]="LedgerBasicBudget"; //Budget
sConKeyName[91]="LedgerBasicJournalizeTransactions"; //Journalizing
sConKeyName[92]="LedgerBasicReversingEntries"; //Reversing entries
sConKeyName[93]="LedgerBasicSalesTax"; //Sales tax
sConKeyName[94]="LedgerBasicSalesTaxJurisdictions"; //Sales tax jurisdictions
sConKeyName[95]="LedgerBasicWithholdingTax"; //Withholding tax
sConKeyName[96]="LogisticsAdvanced"; //Logistics
sConKeyName[97]="LogisticsBasic"; //Trade
sConKeyName[98]="LogisticsOverUnderDelivery"; //Over/underDelivery
sConKeyName[99]="LogisticsRegistration "; //Registration/picking
sConKeyName[100]="Markup"; //Misc. charges
sConKeyName[101]="PaymMan "; //Payment management
sConKeyName[102]="PaymSched"; //Payment schedule
sConKeyName[103]="PBA_ProductBuilder"; //Product Builder
sConKeyName[104]="PBA_ProductBuildingWebApp"; //Product Building WebApp
sConKeyName[105]="PHRPayroll "; //Payroll
sConKeyName[106]="PHRPayrollJurisdiction"; //Payroll jurisdiction
sConKeyName[107]="PHRPayrollJurisdictionCanada"; //Canada
sConKeyName[108]="PHRPayrollJurisdictionUnitedStates"; //United States
sConKeyName[109]="PHRSystem"; //System update utilities
sConKeyName[110]="Presence"; //Presence Support
sConKeyName[111]="PriceDisc"; //Price/Discount
sConKeyName[112]="Prod"; //Production I
sConKeyName[113]="ProdRouting"; //Production II
sConKeyName[114]="ProdShop "; //Production III
sConKeyName[115]="ProjAdvanced "; //Project - advanced
sConKeyName[116]="ProjAdvCashFlow "; //Cash flow
sConKeyName[117]="ProjAdvCostControl"; //Cost control
sConKeyName[118]="ProjAdvEstimate "; //Estimate projects
sConKeyName[119]="ProjAdvEstimateFixedPrice"; //Fixed-price
sConKeyName[120]="ProjAdvEstimateInvestment"; //Investment
sConKeyName[121]="ProjAdvWorkInProgress"; //Work In Process
sConKeyName[122]="ProjBasic"; //Project
sConKeyName[123]="ProjBasicCost"; //Expense
sConKeyName[124]="ProjBasicForecast"; //Forecast
sConKeyName[125]="ProjBasicHour"; //Hours
sConKeyName[126]="ProjBasicInternalProject"; //Cost and internal project
sConKeyName[127]="ProjBasicOnAcc"; //On account
sConKeyName[128]="ProjBasicRevenue"; //Fee
sConKeyName[129]="ProjBasicTimeMaterial"; //Time and material
sConKeyName[130]="ProjQuotation"; //Project quotation
sConKeyName[131]="ProjServerIntegration"; //Project Server Integration
sConKeyName[132]="PurchInvoiceMatching "; //Invoice matching
sConKeyName[133]="PurchReq"; //Purchase Requisition
sConKeyName[134]="QuotationBasic"; //Quotations
sConKeyName[135]="ReportingServices"; //Reporting Services
sConKeyName[136]="Req"; //Master planning
sConKeyName[137]="ReqSchedAction "; //Action message
sConKeyName[138]="ReturnItem "; //Return orders
sConKeyName[139]="RFID"; //RFID
sConKeyName[140]="RFIDBusinessProcessing"; //RFID Business processing
sConKeyName[141]="RFIDTagging"; //RFID tagging
sConKeyName[142]="RouteApprove"; //Approval of routes
sConKeyName[143]="RuntimeBUS"; //BUS Runtime
sConKeyName[144]="RuntimeVAR"; //VAR Runtime
sConKeyName[145]="SalesDeliveryDateControl"; //Delevery date control
sConKeyName[146]="SalesQuotation"; //Sales quotation
sConKeyName[147]="SalesShipments"; //Shipments
sConKeyName[148]="ShipCarrier"; //Shiping Carrier
sConKeyName[149]="SIG "; //Electronic signature
sConKeyName[150]="SMA"; //Service
sConKeyName[151]="SMABom"; //Service Management - BOM
sConKeyName[152]="SMAManagement"; //Service management
sConKeyName[153]="SMARepair"; //Service Management - Repair
sConKeyName[154]="SMASubscription"; //Subscription
sConKeyName[155]="SMASubscription_Indexation"; //Subscription indexation
sConKeyName[156]="SmmCRM"; //Customer Relation Manager Series
sConKeyName[157]="SmmLead"; //Leads
sConKeyName[158]="SmmMA"; //Marketing automation
sConKeyName[159]="smmMACampaignProcess"; //Campaign process
sConKeyName[160]="smmOutlook"; //MS Office Outlook synchronization
sConKeyName[161]="smmPhone"; //Telephony integration
sConKeyName[162]="SmmSM"; //Sales management
sConKeyName[163]="smmSMLeadProcess"; //Lead qualifying process
sConKeyName[164]="smmSMSalesProcess"; //Sales process
sConKeyName[165]="SmmTM"; //Telemarketing
sConKeyName[166]="SuppItem"; //Supplementary item
sConKeyName[167]="SysAdmin"; //Administration
sConKeyName[168]="SysAPI"; //Optional APIs
sConKeyName[169]="SysAPIDDE"; //Dynamic Data Exchange API
sConKeyName[170]="SysAPIPipeClient"; //Pipe Client API
sConKeyName[171]="SysCOM"; //Business Connector status
sConKeyName[172]="SysCompanyInfo"; //Company accounts
sConKeyName[173]="SysDatabaseLog"; //Database Log
sConKeyName[174]="SysDeletedObjects40"; //Keep update objects 4.0
sConKeyName[175]="SysDeletedObjects41"; //Keep update objects 4.1
sConKeyName[176]="SysDevelopmentMorphX"; //Development
sConKeyName[177]="SysDevelopmentXPP"; //X++ development
sConKeyName[178]="SysDomain"; //Domains
sConKeyName[179]="SysFillUtility"; //Fill utility
sConKeyName[180]="SysMSSQL"; //Microsoft SQL Server
sConKeyName[181]="SysOracle "; //Oracle
sConKeyName[182]="SysRecordLevelSecurity"; //Record level security
sConKeyName[183]="SysSign"; //Life Science Electronic signature
sConKeyName[184]="SysTest "; //Test framework
sConKeyName[185]="SysUserLog"; //User log
sConKeyName[186]="TaxUnrealized"; //Unrealized sales tax
sConKeyName[187]="TradeAgreements"; //Trade agreements
sConKeyName[188]="TradeBlanketOrder"; //Blanket order
sConKeyName[189]="TradeInterCompany"; //Intercompany
sConKeyName[190]="TradeMultiShipTo"; //Multiple ship-to
sConKeyName[191]="TradePrintManagement"; //Print management
sConKeyName[192]="TransactionReversal_Cust"; //Customer transaction reversal
sConKeyName[193]="TransactionReversal_Ledger"; //Ledger transaction reversal
sConKeyName[194]="TransactionReversal_Vend"; //Vendor transaction reversal
sConKeyName[195]="Trv "; //Expense management
sConKeyName[196]="TRVAdvance"; //Cash advance
sConKeyName[197]="TrvElectronicPayment"; //Credit Card Import
sConKeyName[198]="TrvPerDiem "; //Per diems
sConKeyName[199]="VendInvoicePool"; //Invoice pool excl. posting
sConKeyName[200]="VendInvoiceRegister"; //Invoice journal
sConKeyName[201]="VendInvoiceRegisterApproval"; //Invoice register and invoice approval journal
sConKeyName[202]="VendPromissoryNote"; //Promissory note
sConKeyName[203]="VSS"; //Vendor Self-Service
sConKeyName[204]="WMSAdvanced"; //Warehouse Management II
sConKeyName[205]="WMSBasic"; //Warehouse Management I
sConKeyName[206]="WMSPallet"; //Pallets
sConKeyName[207]="WrkCtr"; //Resources
for (i=1; i<=207; ++ i)
{
this.FindAllTablesFromConfigKey(sConKeyName[i]);
}
info(strfmt("Execution finished sucessfully, Check the folder for files under 'C:\AllTables\Configs'."));
} 这将有助于功能和技术分析师以及用户分析与子模块和模块相关的架构和表，因为它会从每个配置中检索所有表。
以下是 Dynamics AX 2009 中的一些配置。名称、标签、许可证和父级描述有助于理解配置属于哪个模块。
| 配置名称 | Label | LicenseCode | ParentKey |
| AIF | 应用程序集成框架 | AIF | |
| AIFWebService | 应用程序集成框架 Web 服务 | AIFWebService | |
| 资产 | 固定资产 | 资产 | |
| AssetDepBook | 固定资产折旧簿 | 资产 | |
| 银行 | 银行 | 分类帐 | |
| BankCheque | Check | 银行 | |
| BankDeposit | 存款单 | 银行 | |
| BankElectronicBanking | 电子银行 | BankElectronicBanking | |
| BAS | 业务分析 | BAS | |
| BOM | 物料清单 | LogisticsAdvanced | |
| BOMApprove | BOM 审批 | BOMVersion | |
| BOMCostBreakdown | 允许成本明细激活 | BOM | |
| BOMVersion | BOM 版本 | BOM | |
| Commission | Commission | LogisticsBasic | |
| ComplianceMgmt | 合规性管理 II | ComplianceMgmt | |
| 配置 | 项目维度 - 配置 | ||
| COSAllocation | 分配 | COSCalculation | |
| COSBaseModule | 成本核算 | COSCostCenter | |
| COSBudget | 预算 | COSBaseModule | |
| COSCalculation | 计算 | COSBaseModule | |
| COSCostDistribution | 成本分配 | COSCalculation | |
| COSImportCAC | 从以前版本导入交易 | COSBaseModule | |
| COSOpenDimension | 无限维度 | COSOpenDim | |
| COSPlanCostCalc | 灵活预算 | COSPlanCostCalc | |
| COSWorkAllocation | 内部成本分配 | COSIntCostAlloc | |
| COSWorkDistribution | 服务分配 | COSCalculation | |
| COSWorkUnits | 服务类别 | COSBaseModule | |
| CreditCard | 信用卡 | LedgerBasic | |
| CRSEMultiple | 多国/地区 | CRSECountry | |
| CSS | 客户自助服务 | CSS | |
| 货币 | 分类帐 | ||
| CurrencyEuro | 欧元 | 货币 | |
| CurrencySecondaryCurrency | 次要货币 | 货币 | |
| CustBillOfExchange | 汇票 | CustVendNegotiableInstrument | |
| CustCentralizedCustStatement | 集中客户对账单 | LedgerAdvanced2 | |
| CustCollectionLetter | 催款函 | LedgerBasic | |
| CustGiro | Giro | LedgerBasic | |
| CustInterest | 兴趣 | LedgerBasic | |
| CustMultipleInterestRates | 多个利率 | CRSEMultiple | |
| CustVendCreditInvoicing | 信用开票 | CRSEMultiple | |
| CustVendNegotiableInstrument | 票据 | 银行 | |
| DataExport | 数据导出 | CRSEMultiple | |
| DimensionSetHierarchy | 维度集层次结构 | LedgerAdvanced | |
| EMS | 环境可持续性 | EMS | |
| EP | 企业门户 | EP | |
| EPCompliance | 合规性站点 | ComplianceMgmt | |
| EPSalesRep | 销售代表 | EPSalesRep | |
| ESS | 员工自助服务 | ESS | |
| 事件 | 事件 | ||
| 预报 | 库存预测 | LogisticsAdvanced | |
| ForecastDMPBase | 需求计划基础 | ForecastDMPBase | |
| ForeignTrade | 对外贸易 | LogisticsBasic | |
| FullSettlement | 全额结算 | CRSEMultiple | |
| HRMADA | ADA | HRMAdministration | |
| HRMAdministration | 人力资源 I | HRMAdministration | |
| HRMAdministrationCompensation | 薪酬 | HRMAdministration | |
| HRMAdministrationPayrollInfo | 薪资信息 | HRMAdministration | |
| HRMCollaborative | 人力资源 III | HRMCollaborative | |
| HRMCollaborativeCourse | 课程 | HRMCollaborative | |
| HRMEPEmployeeServices | 员工服务角色 | HRMEPEmployeeServices | |
| HRMi9 | I-9 | HRMAdministration | |
| HRMManagement | 人力资源 II | HRMManagement | |
| HRMManagementAbsence | 缺勤 | HRMManagement | |
| HRMManagementRecruiting | 招聘 | HRMManagement | |
| InventItemDimColor | 项目维度 - 颜色 | LogisticsAdvanced | |
| InventItemDimSize | 项目维度 - 尺寸 | LogisticsAdvanced | |
| InventPackaging | 包装费 | LogisticsBasic | |
| InventQualityManagement | 质量管理 | InventQualityManagement | |
| InventTransferOrders | 调拨订单 | LogisticsAdvanced | |
| Jmg | 车间控制 | SFC1 | |
| JmgEPSFCEmployee | 企业门户 SFC 员工角色 | SFCEPTimeCard | |
| JmgJob | 车间控制 - 工作注册 | SFC2 | |
| JmgPayroll | 车间控制 - 工资生成 | SFC3 | |
| KMBPM | 业务流程管理 | KMBPM | |
| KMBPMActionPlan | 行动计划 | KMBPM | |
| KMBPMGameplan | 战略计划 | KMBPM | |
| KMBSC | 平衡记分卡 | KMBSC | |
| KMEPPerformanceManagement | 绩效管理角色 | KMEPPerformanceManagement | |
| KMEPQuestionnaire | 问卷角色 | KMEPQuestionnaire | |
| KMQuestionnaireAdvanced | 问卷 II | KMQuestionnaireAdvanced | |
| KMQuestionnaireBasic | 问卷 I | KMQuestionnaireBasic | |
| LedgerAdvAllocation | 分配 | LedgerAdvanced | |
| LedgerAdvanced | 总账 - 高级 | LedgerAdvanced | |
| LedgerAdvanced2 | 总账 - 高级 II | LedgerAdvanced2 | |
| LedgerAdvCashflowForecast | 现金流预测 | LedgerAdvanced | |
| LedgerAdvConsolidations | 合并 | LedgerAdvanced | |
| LedgerAdvIntercompanyAccounting | 公司间会计 | LedgerAdvanced | |
| LedgerAllocationRules | 生成的分配 | LedgerAdvanced2 | |
| LedgerBasic | 总账 | 分类帐 | |
| LedgerBasicBudget | 预算 | LedgerBasic | |
| LedgerBasicJournalizeTransactions | 日记账化 | LedgerBasic | |
| LedgerBasicReversingEntries | 冲销分录 | LedgerBasic | |
| LedgerBasicSalesTax | 销售税 | LedgerBasic | |
| LedgerBasicSalesTaxJurisdictions | 销售税管辖区 | LedgerBasicSalesTax | |
| LedgerBasicWithholdingTax | 预扣税 | LedgerBasic | |
| LogisticsAdvanced | Logistics | LogisticsAdvanced | |
| LogisticsBasic | 贸易 | LogisticsBasic | |
| LogisticsOverUnderDelivery | 超/短装 | LogisticsBasic | |
| LogisticsRegistration | 注册/拣货 | LogisticsBasic | |
| 标记 | 杂费 | LogisticsBasic | |
| PaymMan | 支付管理 | LedgerBasic | |
| PaymSched | 付款计划 | LedgerBasic | |
| PBA_ProductBuilder | 产品构建器 | PBAProductBuilder | |
| PBA_ProductBuildingWebApp | 产品构建 Web 应用 | PBA_ProductBuildingWebApp | |
| PHRPayroll | 薪资 | PayrollforDynamicsAX | |
| PHRPayrollJurisdiction | 工资管辖区 | PHRPayroll | |
| PHRPayrollJurisdictionCanada | Canada | PHRPayrollJurisdiction | |
| PHRPayrollJurisdictionUnitedStates | United States | PHRPayrollJurisdiction | |
| PHRSystem | 系统更新工具 | PHRPayroll | |
| Presence | Presence Support | SysAdmin | |
| PriceDisc | 价格/折扣 | TradeAgreements | |
| Prod | 生产 I | Prod | |
| ProdRouting | 生产 II | ProdRouting | |
| ProdShop | 生产 III | ProdShop | |
| ProjAdvanced | 项目 - 高级 | ProjAdvanced | |
| ProjAdvCashFlow | 现金流 | ProjAdvanced | |
| ProjAdvCostControl | 成本控制 | ProjAdvanced | |
| ProjAdvEstimate | 估算项目 | ProjAdvanced | |
| ProjAdvEstimateFixedPrice | 固定价格 | ProjAdvEstimate | |
| ProjAdvEstimateInvestment | 投资 | ProjAdvEstimate | |
| ProjAdvWorkInProgress | 在制品 | ProjAdvanced | |
| ProjBasic | 项目 | ProjBasic | |
| ProjBasicCost | 费用 | ProjBasic | |
| ProjBasicForecast | 预报 | ProjBasic | |
| ProjBasicHour | 小时数 | ProjBasic | |
| ProjBasicInternalProject | 成本和内部项目 | ProjBasic | |
| ProjBasicOnAcc | 暂收款 | ProjBasic | |
| ProjBasicRevenue | 费用 | ProjBasic | |
| ProjBasicTimeMaterial | 工料计价 | ProjBasic | |
| ProjQuotation | 项目报价 | QuotationBasic | |
| ProjServerIntegration | Project Server 集成 | ProjBasic | |
| PurchInvoiceMatching | 发票匹配 | LogisticsBasic | |
| PurchReq | 采购申请 | PurchReq | |
| QuotationBasic | Quotations | Quotations | |
| ReportingServices | Reporting Services | SysUsers | |
| Req | 主计划 | Req | |
| ReqSchedAction | 操作消息 | Req | |
| ReturnItem | 退货订单 | LogisticsBasic | |
| RFID | RFID | RFID | |
| RFIDBusinessProcessing | RFID 业务处理 | RFID | |
| RFIDTagging | RFID 标签 | RFID | |
| RouteApprove | 路线审批 | ProdRouting | |
| RuntimeBUS | BUS Runtime | RuntimeBUS | |
| RuntimeVAR | VAR Runtime | RuntimeVAR | |
| SalesDeliveryDateControl | 交货日期控制 | LogisticsAdvanced | |
| SalesQuotation | 销售报价 | QuotationBasic | |
| SalesShipments | 发货 | LogisticsBasic | |
| ShipCarrier | 运输承运商 | LogisticsBasic | |
| SIG | 电子签名 | ||
| SMA | Service | ProjBasic | |
| SMABom | 服务管理 - BOM | SMAManagement | |
| SMAManagement | 服务管理 | ServiceManagement | |
| SMARepair | 服务管理 - 维修 | SMAManagement | |
| SMASubscription | 订阅 | ServiceSubscription | |
| SMASubscription_Indexation | 订阅索引 | SMASubscription | |
| SmmCRM | 客户关系管理系列 | smmSalesForceAutomation | |
| SmmLead | 潜在客户 | SmmCRM | |
| SmmMA | 营销自动化 | smmMarketingAutomation | |
| smmMACampaignProcess | 活动流程 | SmmMA | |
| smmOutlook | MS Office Outlook 同步 | ||
| smmPhone | 电话集成 | SmmCRM | |
| SmmSM | 销售管理 | smmSalesManagement | |
| smmSMLeadProcess | 潜在客户资格流程 | SmmLead | |
| smmSMSalesProcess | 销售流程 | SmmCRM | |
| SmmTM | 电话营销 | smmTelemarketing | |
| SuppItem | 补充项目 | TradeAgreements | |
| SysAdmin | Administration | SysUsers | |
| SysAPI | 可选 API | SysUsers | |
| SysAPIDDE | 动态数据交换 API | SysAPI | |
| SysAPIPipeClient | 管道客户端 API | SysAPI | |
| SysCOM | Business Connector 状态 | SysCOMUsers | |
| SysCompanyInfo | 公司账户 | SysCompanies | |
| SysDatabaseLog | 数据库日志 | SysDatabaseLog | |
| SysDeletedObjects40 | 保留更新对象 4.0 | SysAdmin | |
| SysDeletedObjects41 | 保留更新对象 4.1 | SysAdmin | |
| SysDevelopmentMorphX | 开发 | SysMorphX | |
| SysDevelopmentXPP | X++ 开发 | SysXpp | |
| SysDomain | 域名 | SysDomain | |
| SysFillUtility | 填充实用程序 | SysAdmin | |
| SysMSSQL | Microsoft SQL Server | SysMSSQL | |
| SysOracle | Oracle | SysOracle | |
| SysRecordLevelSecurity | 记录级别安全性 | SysRecordLevelSecurity | |
| SysSign | 生命科学电子签名 | Prod | |
| SysTest | 测试框架 | SysDevelopmentXPP | |
| SysUserLog | 用户日志 | ||
| TaxUnrealized | 未实现销售税 | ||
| TradeAgreements | Trade agreements | TradeAgreements | |
| TradeBlanketOrder | 协议订单 | LogisticsBasic | |
| TradeInterCompany | 公司间 | TradeInterCompany | |
| TradeMultiShipTo | 多个收货地 | LogisticsBasic | |
| TradePrintManagement | 打印管理 | LogisticsBasic | |
| TransactionReversal_Cust | 客户交易冲销 | LedgerBasic | |
| TransactionReversal_Ledger | 总账交易冲销 | LedgerBasic | |
| TransactionReversal_Vend | 供应商交易冲销 | LedgerBasic | |
| Trv | 费用管理 | Trv | |
| TRVAdvance | 现金预支 | Trv | |
| TrvElectronicPayment | 信用卡导入 | Trv | |
| TrvPerDiem | 每日津贴 | Trv | |
| VendInvoicePool | 发票池（不含过账） | LedgerBasic | |
| VendInvoiceRegister | 发票日记账 | LedgerBasic | |
| VendInvoiceRegisterApproval | 发票注册和发票审批日记账 | LedgerBasic | |
| VendPromissoryNote | 本票 | CustVendNegotiableInstrument | |
| VSS | 供应商自助服务 | VSS | |
| WMSAdvanced | 仓库管理 II | WMSAdvanced | |
| WMSBasic | 仓库管理 I | WMSBasic | |
| WMSPallet | 托盘 | WMSAdvanced | |
| WrkCtr | 资源 | WrkCtr |
以上列表中已省略了几个 CRSE 相关配置。
该代码已在 Microsoft Dynamics AX 2009 中进行测试。
Microsoft Dynamics AX 2012 中大约有 4584 个表。有关更多信息，请从此链接下载完整的表列表：http://www.microsoft.com/download/en/details.aspx?id=17093
参考文献
http://msdn.microsoft.com/en-us/library/aa626961(v=ax.50).aspx
http://msdn.microsoft.com/en-us/library/aa499193(v=ax.50).aspx
http://www.microsoft.com/download/en/details.aspx?id=17093
http://stackoverflow.com/users/624368/10p
历史
2012年1月28日