存档表命名参考

此参考介绍了如何跨存档框架层命名Microsoft提供的表。 每行将同一逻辑实体映射到存档管道:从 Dynamics 365 财务和操作中的实时事务表映射到历史记录表、财务和操作数据实体,最后映射到 Dataverse 管理的 Data Lake 表。

使用此引用可以:

  • 了解跨存档层的命名约定。
  • 实现自定义项时查找相应的表名称。
  • 验证存档作业协定的实体名称。
  • 在不同存储层之间映射数据。

表命名约定

Layer Naming pattern Example
Live table 原始 Dynamics 365 财务和操作表名称 SALESTABLE
History table 实时表和“历史记录”后缀 SALESTABLEHISTORY
财务和运营数据实体 Live 表和“BiEntity”后缀 SalestableBiEntity
Dataverse table “mserp_”前缀 + 数据实体名称 mserp_SalestableBiEntity

Note

这些财务和运营数据实体在其技术名称(例如, SalestableBiEntity)中使用“BiEntity”后缀。 这种命名规范将它们标识为归档和Dataverse集成而设计的数据实体。

Supported scenarios

下表列出了所有Microsoft提供的存档方案及其在每个层中对应的表名称。

Scenario Live table History table 财务和运营数据实体 Dataverse 托管的 Data Lake 表
财务总账本 GENERALJOURNALACCOUNTENTRY GENERALJOURNALACCOUNTENTRYHISTORY GeneraljournalaccountentryBiEntity mserp_GeneraljournalaccountentryBiEntity
GENERALJOURNALACCOUNTENTRY_W GENERALJOURNALACCOUNTENTRYHISTORY_W GeneraljournalaccountentrywBiEntity mserp_GeneraljournalaccountentrywBiEntity
GENERALJOURNALENTRY GENERALJOURNALENTRYHISTORY GeneraljournalentryBiEntity mserp_GeneraljournalentryBiEntity
GENERALJOURNALENTRY_W GENERALJOURNALENTRYHISTORY_W GeneraljournalentrywBiEntity mserp_GeneraljournalentrywBiEntity
LEDGERCONSOLIDATEHISTREF LEDGERCONSOLIDATEHISTREFHISTORY LedgerconsolidatehistrefBiEntity mserp_LedgerconsolidatehistrefBiEntity
LEDGERENTRY LEDGERENTRYHISTORY LedgerentryBiEntity mserp_LedgerentryBiEntity
LEDGERENTRYJOURNAL LEDGERENTRYJOURNALHISTORY LedgerentryjournalBiEntity mserp_LedgerentryjournalBiEntity
LEDGERENTRYJOURNALIZING LEDGERENTRYJOURNALIZINGHISTORY LedgerentryjournalizingBiEntity mserp_LedgerentryjournalizingBiEntity
LEDGERTRANSSETTLEMENT LEDGERTRANSSETTLEMENTHISTORY LedgertranssettlementBiEntity mserp_LedgertranssettlementBiEntity
SUBLEDGERVOUCHERGENERALJOURNALENTRY SUBLEDGERVOUCHERGENERALJOURNALENTRYHISTORY SubledgervouchergeneraljournalentryBiEntity mserp_SubledgervouchergeneraljournalentryBiEntity
供应链管理销售订单 MCRRETURNSALESTABLE MCRRETURNSALESTABLEHISTORY McrreturnsalestableBiEntity mserp_McrreturnsalestableBiEntity
MCRSALESLINE MCRSALESLINEHISTORY McrsaleslineBiEntity mserp_McrsaleslineBiEntity
MCRSALESTABLE MCRSALESTABLEHISTORY McrsalestableBiEntity mserp_McrsalestableBiEntity
RETAILSALESLINE RETAILSALESLINEHISTORY RetailsaleslineBiEntity mserp_RetailsaleslineBiEntity
RETAILSALESTABLE RETAILSALESTABLEHISTORY RetailsalestableBiEntity mserp_RetailsalestableBiEntity
SALESLINE SALESLINEHISTORY SaleslineBiEntity mserp_SaleslineBiEntity
SALESLINE_BR SALESLINEHISTORY_BR SaleslinebrBiEntity mserp_SaleslinebrBiEntity
SALESLINE_IN SALESLINEHISTORY_IN SaleslineinBiEntity mserp_SaleslineinBiEntity
SALESLINE_W SALESLINEHISTORY_W SaleslinewBiEntity mserp_SaleslinewBiEntity
SALESTABLE SALESTABLEHISTORY SalestableBiEntity mserp_SalestableBiEntity
SALESTABLE_BR SALESTABLEHISTORY_BR SalestablebrBiEntity mserp_SalestablebrBiEntity
SALESTABLE_RU SALESTABLEHISTORY_RU SalestableruBiEntity mserp_SalestableruBiEntity
SALESTABLE_W SALESTABLEHISTORY_W SalestablewBiEntity mserp_SalestablewBiEntity
供应链管理库存交易 INVENTTRANSARCHIVE INVENTTRANSARCHIVEHISTORY InventtransarchiveBiEntity mserp_InventTransArchiveBiEntity
供应链管理库存日志 INVENTJOURNALTABLE INVENTJOURNALTABLEHISTORY InventjournaltableBiEntity mserp_InventjournaltableBiEntity
INVENTJOURNALTABLE_IN INVENTJOURNALTABLE_INHISTORY InventjournaltableinBiEntity mserp_InventjournaltableinBiEntity
INVENTJOURNALTRANS INVENTJOURNALTRANSHISTORY InventjournaltransBiEntity mserp_InventjournaltransBiEntity
INVENTJOURNALTRANS_IN INVENTJOURNALTRANS_INHISTORY InventjournaltransinBiEntity mserp_InventjournaltransinBiEntity
财务税跨 TAXTRANS TAXTRANSHISTORY TaxtransBiEntity mserp_TaxtransBiEntity
TAXTRANS_BR TAXTRANSHISTORY_BR TaxtransbrBiEntity mserp_TaxtransbrBiEntity
TAXTRANSGENERALJOURNALACCOUNTENTRY TAXTRANSGENERALJOURNALACCOUNTENTRYHISTORY TaxtransgeneraljournalaccountentryBiEntity mserp_TaxtransgeneraljournalaccountentryBiEntity
TAXTRANS_IN TAXTRANSHISTORY_IN TaxtransinBiEntity mserp_TaxtransinBiEntity
TAXTRANS_IT TAXTRANSHISTORY_IT TaxtransitBiEntity mserp_TaxtransitBiEntity
TAXTRANS_REPORTING TAXTRANSHISTORY_REPORTING TaxtransreportingBiEntity mserp_TaxtransreportingBiEntity
TAXTRANS_RU TAXTRANSHISTORY_RU TaxtransruBiEntity mserp_TaxtransruBiEntity
TAXTRANSSUBLEDGERJOURNALACCOUNTENTRY TAXTRANSSUBLEDGERJOURNALACCOUNTENTRYHISTORY TaxtranssubledgerjournalaccountentryBiEntity mserp_TaxtranssubledgerjournalaccountentryBiEntity
TAXTRANS_TH TAXTRANSHISTORY_TH TaxtransthBiEntity mserp_TaxtransthBiEntity
TAXTRANS_W TAXTRANSHISTORY_W TaxtranswBiEntity mserp_TaxtranswBiEntity
Commerce transaction RetailTransactionTable RetailTransactionTableHistory RetailTransactionTableBIEntity mserp_RetailTransactionTableBIEntity
RetailTransactionCashManagementTrans RetailTransactionCashManagementTransHistory RetailTransactionCashManagementTransBIEntity mserp_RetailTransactionCashManagementTransBIEntity
RetailTransactionFiscalCustomer RetailTransactionFiscalCustomerHistory RetailTransactionFiscalCustomerBIEntity mserp_RetailTransactionFiscalCustomerBIEntity
RetailTransactionSupplementaryInvoice RetailTransactionSupplementaryInvoiceHistory RetailTransactionSupplementaryInvoiceBIEntity mserp_RetailTransactionSupplementaryInvoiceBIEntity
RetailTransactionTable_RU RetailTransactionTable_RUHistory RetailTransactionTable_RUBIEntity mserp_RetailTransactionTable_RUBIEntity
RetailTransactionBankedTenderTrans RetailTransactionBankedTenderTransHistory RetailTransactionBankedTenderTransBIEntity mserp_RetailTransactionBankedTenderTransBIEntity
RetailTransactionValidationError RetailTransactionValidationErrorHistory RetailTransactionValidationErrorBIEntity mserp_RetailTransactionValidationErrorBIEntity
RetailTransactionTenderDeclarationTrans RetailTransactionTenderDeclarationTransHistory RetailTransactionTenderDeclarationTransBIEntity mserp_RetailTransactionTenderDeclarationTransBIEntity
RetailTransactionTaxMeasure RetailTransactionTaxMeasureHistory RetailTransactionTaxMeasureBIEntity mserp_RetailTransactionTaxMeasureBIEntity
RetailTransactionSalesTrans RetailTransactionSalesTransHistory RetailTransactionSalesTransBIEntity mserp_RetailTransactionSalesTransBIEntity
RetailTransactionPaymentTrans RetailTransactionPaymentTransHistory RetailTransactionPaymentTransBIEntity mserp_RetailTransactionPaymentTransBIEntity
RetailTransactionPaymentTrans_BR RetailTransactionPaymentTrans_BRHistory RetailTransactionPaymentTrans_BRBIEntity mserp_RetailTransactionPaymentTrans_BRBIEntity
RetailTransactionSafeTenderTrans RetailTransactionSafeTenderTransHistory RetailTransactionSafeTenderTransBIEntity mserp_RetailTransactionSafeTenderTransBIEntity
RetailTransactionPaymentRefundableAmounts RetailTransactionPaymentRefundableAmountsHistory RetailTransactionPaymentRefundableAmountsBIEntity mserp_RetailTransactionPaymentRefundableAmountsBIEntity
RetailTransactionAdditionalAddressTrans RetailTransactionAdditionalAddressTransHistory RetailTransactionAdditionalAddressTransBIEntity mserp_RetailTransactionAdditionalAddressTransBIEntity
RetailTransactionAddressTrans RetailTransactionAddressTransHistory RetailTransactionAddressTransBIEntity mserp_RetailTransactionAddressTransBIEntity
RetailTransactionAffiliationTrans RetailTransactionAffiliationTransHistory RetailTransactionAffiliationTransBIEntity mserp_RetailTransactionAffiliationTransBIEntity
RetailTransactionAttributeTrans RetailTransactionAttributeTransHistory RetailTransactionAttributeTransBIEntity mserp_RetailTransactionAttributeTransBIEntity
RetailTransactionChargeTaxMeasure RetailTransactionChargeTaxMeasureHistory RetailTransactionChargeTaxMeasureBIEntity mserp_RetailTransactionChargeTaxMeasureBIEntity
RetailTransactionChargeTaxTrans RetailTransactionChargeTaxTransHistory RetailTransactionChargeTaxTransBIEntity mserp_RetailTransactionChargeTaxTransBIEntity
RetailTransactionChargeTaxTransGTE RetailTransactionChargeTaxTransGTEHistory RetailTransactionChargeTaxTransGTEBIEntity mserp_RetailTransactionChargeTaxTransGTEBIEntity
RetailTransactionCustomerAccountDepositTrans RetailTransactionCustomerAccountDepositTransHistory RetailTransactionCustomerAccountDepositTransBIEntity mserp_RetailTransactionCustomerAccountDepositTransBIEntity
RetailTransactionDiscountTrans RetailTransactionDiscountTransHistory RetailTransactionDiscountTransBIEntity mserp_RetailTransactionDiscountTransBIEntity
RetailTransactionFiscalTrans RetailTransactionFiscalTransHistory RetailTransactionFiscalTransBIEntity mserp_RetailTransactionFiscalTransBIEntity
RetailTransactionFiscalTransExtendedData RetailTransactionFiscalTransExtendedDataHistory RetailTransactionFiscalTransExtendedDataBIEntity mserp_RetailTransactionFiscalTransExtendedDataBIEntity
RetailTransactionIncomeExpenseTrans RetailTransactionIncomeExpenseTransHistory RetailTransactionIncomeExpenseTransBIEntity mserp_RetailTransactionIncomeExpenseTransBIEntity
RetailTransactionInfocodeTrans RetailTransactionInfocodeTransHistory RetailTransactionInfocodeTransBIEntity mserp_RetailTransactionInfocodeTransBIEntity
RetailTransactionKitsDisassemblyTrans RetailTransactionKitsDisassemblyTransHistory RetailTransactionKitsDisassemblyTransBIEntity mserp_RetailTransactionKitsDisassemblyTransBIEntity
RetailTransactionLoyaltyRewardPointTrans RetailTransactionLoyaltyRewardPointTransHistory RetailTransactionLoyaltyRewardPointTransBIEntity mserp_RetailTransactionLoyaltyRewardPointTransBIEntity
RetailTransactionMarkupTrans RetailTransactionMarkupTransHistory RetailTransactionMarkupTransBIEntity mserp_RetailTransactionMarkupTransBIEntity
RetailTransactionNoteTrans RetailTransactionNoteTransHistory RetailTransactionNoteTransBIEntity mserp_RetailTransactionNoteTransBIEntity
RetailTransactionOrderInvoiceTrans RetailTransactionOrderInvoiceTransHistory RetailTransactionOrderInvoiceTransBIEntity mserp_RetailTransactionOrderInvoiceTransBIEntity
RetailTransactionTaxTrans_IN RetailTransactionTaxTrans_INHistory RetailTransactionTaxTrans_INBIEntity mserp_RetailTransactionTaxTrans_INBIEntity
RetailTransactionTaxTrans RetailTransactionTaxTransHistory RetailTransactionTaxTransBIEntity mserp_RetailTransactionTaxTransBIEntity
RetailTransactionTaxTransGTE RetailTransactionTaxTransGTEHistory RetailTransactionTaxTransGTEBIEntity mserp_RetailTransactionTaxTransGTEBIEntity
RetailEodStatementControllerLog RetailEodStatementControllerLogHistory RetailEodStatementControllerLogBIEntity mserp_RetailEodStatementControllerLogBIEntity
RetailEodStatementEventLog RetailEodStatementEventLogHistory RetailEodStatementEventLogBIEntity mserp_RetailEodStatementEventLogBIEntity
RetailEodTransactionAggregationHeader RetailEodTransactionAggregationHeaderHistory RetailEodTransactionAggregationHeaderBIEntity mserp_RetailEodTransactionAggregationHeaderBIEntity
RetailEodTransactionAggregationTrans RetailEodTransactionAggregationTransHistory RetailEodTransactionAggregationTransBIEntity mserp_RetailEodTransactionAggregationTransBIEntity
RetailEodTransactionError RetailEodTransactionErrorHistory RetailEodTransactionErrorBIEntity mserp_RetailEodTransactionErrorBIEntity
RetailEodTransactionBankedTenderTrans RetailEodTransactionBankedTenderTransHistory RetailEodTransactionBankedTenderTransBIEntity mserp_RetailEodTransactionBankedTenderTransBIEntity
RetailEodTransactionIncomeExpenseTrans RetailEodTransactionIncomeExpenseTransHistory RetailEodTransactionIncomeExpenseTransBIEntity mserp_RetailEodTransactionIncomeExpenseTransBIEntity
RetailEodTransactionInfocodeTrans RetailEodTransactionInfocodeTransHistory RetailEodTransactionInfocodeTransBIEntity mserp_RetailEodTransactionInfocodeTransBIEntity
RetailEodTransactionOrderInvoiceTrans RetailEodTransactionOrderInvoiceTransHistory RetailEodTransactionOrderInvoiceTransBIEntity mserp_RetailEodTransactionOrderInvoiceTransBIEntity
RetailEodTransactionPaymentTrans RetailEodTransactionPaymentTransHistory RetailEodTransactionPaymentTransBIEntity mserp_RetailEodTransactionPaymentTransBIEntity
RetailEodTransactionSafeTenderTrans RetailEodTransactionSafeTenderTransHistory RetailEodTransactionSafeTenderTransBIEntity mserp_RetailEodTransactionSafeTenderTransBIEntity
RetailEodTransactionSalesTrans RetailEodTransactionSalesTransHistory RetailEodTransactionSalesTransBIEntity mserp_RetailEodTransactionSalesTransBIEntity
RetailEodTransactionTable RetailEodTransactionTableHistory RetailEodTransactionTableBIEntity mserp_RetailEodTransactionTableBIEntity
RetailEodTransactionTenderDeclarationTrans RetailEodTransactionTenderDeclarationTransHistory RetailEodTransactionTenderDeclarationTransBIEntity mserp_RetailEodTransactionTenderDeclarationTransBIEntity
RetailStatementJour RetailStatementJourHistory RetailStatementJourBIEntity mserp_RetailStatementJourBIEntity
RetailStatementTrans RetailStatementTransHistory RetailStatementTransBIEntity mserp_RetailStatementTransBIEntity
RetailStatementVoucher RetailStatementVoucherHistory RetailStatementVoucherBIEntity mserp_RetailStatementVoucherBIEntity
财务客户发票 CUSTINVOICEJOUR CUSTINVOICEJOURHISTORY CustinvoicejourBiEntity mserp_CustinvoicejourBiEntity
CUSTINVOICETRANS CUSTINVOICETRANSHISTORY CustinvoicetransBiEntity mserp_CustinvoicetransBiEntity
ACCOUNTINGDISTRIBUTION ACCOUNTINGDISTRIBUTIONHISTORY AccountingdistributionBiEntity mserp_AccountingdistributionBiEntity
ACCOUNTINGEVENT ACCOUNTINGEVENTHISTORY AccountingeventBiEntity mserp_AccountingeventBiEntity
CUSTINVOICEJOUR_INTRASTAT CUSTINVOICEJOURHISTORY_INTRASTAT CustinvoicejourintrastatBiEntity mserp_CustinvoicejourintrastatBiEntity
CUSTINVOICEJOUR_W CUSTINVOICEJOURHISTORY_W CustinvoicejourwBiEntity mserp_CustinvoicejourwBiEntity
CUSTINVOICELINE CUSTINVOICELINEHISTORY CustinvoicelineBiEntity mserp_CustinvoicelineBiEntity
CUSTINVOICELINEINTERPROJ CUSTINVOICELINEINTERPROJHISTORY CustinvoicelineinterprojBiEntity mserp_CustinvoicelineinterprojBiEntity
CUSTINVOICELINE_W CUSTINVOICELINEHISTORY_W CustinvoicelinewBiEntity mserp_CustinvoicelinewBiEntity
CUSTINVOICETABLE CUSTINVOICETABLEHISTORY CustinvoicetableBiEntity mserp_CustinvoicetableBiEntity
CUSTINVOICETABLECALCTOTALS CUSTINVOICETABLECALCTOTALSHISTORY CustinvoicetablecalctotalsBiEntity mserp_CustinvoicetablecalctotalsBiEntity
CUSTINVOICETABLE_W CUSTINVOICETABLEHISTORY_W CustinvoicetablewBiEntity mserp_CustinvoicetablewBiEntity
CUSTINVOICETRANS_INTRASTAT CUSTINVOICETRANSHISTORY_INTRASTAT CustinvoicetransintrastatBiEntity mserp_CustinvoicetransintrastatBiEntity
CUSTINVOICETRANS_W CUSTINVOICETRANSHISTORY_W CustinvoicetranswBiEntity mserp_CustinvoicetranswBiEntity
PDSCUSTINVOICETRANSPRICINGCALCULATION PDSCUSTINVOICETRANSPRICINGCALCULATIONHISTORY PdscustinvoicetranspricingcalculationBiEntity mserp_PdscustinvoicetranspricingcalculationBiEntity
PDSREBATECUSTINVOICETRANS PDSREBATECUSTINVOICETRANSHISTORY PdsrebatecustinvoicetransBiEntity mserp_PdsrebatecustinvoicetransBiEntity
PROJECTACCOUNTINGDISTRIBUTION PROJECTACCOUNTINGDISTRIBUTIONHISTORY ProjectaccountingdistributionBiEntity mserp_ProjectaccountingdistributionBiEntity
RETAILCUSTINVOICEJOURTABLE RETAILCUSTINVOICEJOURTABLEHISTORY RetailcustinvoicejourtableBiEntity mserp_RetailcustinvoicejourtableBiEntity
SOURCEDOCUMENTHEADER SOURCEDOCUMENTHEADERHISTORY SourcedocumentheaderBiEntity mserp_SourcedocumentheaderBiEntity
SOURCEDOCUMENTLINE SOURCEDOCUMENTLINEHISTORY SourcedocumentlineBiEntity mserp_SourcedocumentlineBiEntity
SUBLEDGERJOURNALACCOUNTENTRY SUBLEDGERJOURNALACCOUNTENTRYHISTORY SubledgerjournalaccountentryBiEntity mserp_SubledgerjournalaccountentryBiEntity
SUBLEDGERJOURNALACCOUNTENTRYDISTRIBUTION SUBLEDGERJOURNALACCOUNTENTRYDISTRIBUTIONHISTORY SubledgerjournalaccountentrydistributionBiEntity mserp_SubledgerjournalaccountentrydistributionBiEntity
SUBLEDGERJOURNALENTRY SUBLEDGERJOURNALENTRYHISTORY SubledgerjournalentryBiEntity mserp_SubledgerjournalentryBiEntity
Supply Chain Management WHS 负载 WHSLOADTABLE WHSLOADTABLEHISTORY WhsloadtableBiEntity mserp_WhsloadtableBiEntity
WHSLOADLINE WHSLOADLINEHISTORY WhsloadlineBiEntity mserp_WhsloadlineBiEntity
WHSSHIPMENTTABLE WHSSHIPMENTTABLEHISTORY WhsshipmenttableBiEntity mserp_WhsshipmenttableBiEntity
WHSWORKTABLE WHSWORKTABLEHISTORY WhsworktableBiEntity mserp_WhsworktableBiEntity
WHSWORKLINE WHSWORKLINEHISTORY WhsworklineBiEntity mserp_WhsworklineBiEntity
WHSWORKINVENTTRANS WHSWORKINVENTTRANSHISTORY WhsworkinventtransBiEntity mserp_WhsworkinventtransBiEntity
WHSWORKTRANS WHSWORKTRANSHISTORY WhsworktransBiEntity mserp_WhsworktransBiEntity