Edit

Archive table naming reference

Note

Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.

This reference shows how Microsoft-provided tables are named across the archive framework layers. Each row maps the same logical entity as it moves through the archive pipeline: from the live transaction table in Dynamics 365 finance and operations, to the history table, to the finance and operations data entity, and finally to the Dataverse-managed data lake table.

Use this reference to:

  • Understand naming conventions across archive layers.
  • Look up corresponding table names when implementing customizations.
  • Verify entity names for your archive job contracts.
  • Map data between different storage layers.

Table naming conventions

Layer Naming pattern Example
Live table Original Dynamics 365 finance and operations table name SALESTABLE
History table Live table and "History" suffix SALESTABLEHISTORY
Finance and operations data entity Live table and "BiEntity" suffix SalestableBiEntity
Dataverse table "mserp_" prefix + data entity name mserp_SalestableBiEntity

Note

These finance and operations data entities use the "BiEntity" suffix in their technical names (for example, SalestableBiEntity). This naming convention identifies them as data entities designed for archive and Dataverse integration.

Supported scenarios

The following table lists all Microsoft-provided archive scenarios and their corresponding table names across each layer.

Scenario Live table History table Finance and operations data entity Dataverse-managed data lake table
Finance General ledger 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
Supply Chain Management Sales order 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
Supply Chain Management Inventory transaction INVENTTRANSARCHIVE INVENTTRANSARCHIVEHISTORY InventtransarchiveBiEntity mserp_InventTransArchiveBiEntity
Supply Chain Management Inventory Journal INVENTJOURNALTABLE INVENTJOURNALTABLEHISTORY InventjournaltableBiEntity mserp_InventjournaltableBiEntity
INVENTJOURNALTABLE_IN INVENTJOURNALTABLE_INHISTORY InventjournaltableinBiEntity mserp_InventjournaltableinBiEntity
INVENTJOURNALTRANS INVENTJOURNALTRANSHISTORY InventjournaltransBiEntity mserp_InventjournaltransBiEntity
INVENTJOURNALTRANS_IN INVENTJOURNALTRANS_INHISTORY InventjournaltransinBiEntity mserp_InventjournaltransinBiEntity
Finance Tax Trans 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
Finance Customer Invoice 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 Load 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

Related content

  • Last updated on