Referință denumire tabel arhivă

Note

Grupurile de interes din comunitate s-au mutat acum din Yammer în Microsoft Viva Engage. Pentru a vă alătura unei comunități Viva Engage și a participa la cele mai recente discuții, completați Request acces la Finanțe și Operațiuni Viva Engage Comunitate și alegeți comunitatea la care doriți să vă asociați.

Această referință arată modul în care tabelele furnizate de Microsoft sunt denumite în straturile cadru de arhivare. Fiecare rând mapează aceeași entitate logică pe care o parcurge prin canal de arhivare: de la tabelul de tranzacții live din Finanțe și operațiuni Dynamics 365, la tabelul istoric, la entitatea de date finanțe și operațiuni și, în cele din urmă, la tabelul Lacul de date gestionate de Dataverse.

Utilizați această referință la:

  • Înțelegeți convențiile de denumire din straturile arhivă.
  • Căutați numele de tabele corespunzătoare atunci când implementați particularizări.
  • Verificați numele entităților pentru contractele de lucrări arhivă.
  • Maparea datelor între diferite straturi de stocare.

Convenții de denumire a tabelelor

Layer Naming pattern Example
Live table Numele original al tabelului de operațiuni și finanțe Dynamics 365 SALESTABLE
History table Tabel live și sufix "Istoric" SALESTABLEHISTORY
Entitatea de date finanțe și operațiuni Tabel live și sufix "BiEntity" SalestableBiEntity
Dataverse table Prefixul "mserp_" + numele entității de date mserp_SalestableBiEntity

Note

Aceste entități de date financiare și operațiuni utilizează sufixul "BiEntity" în numele lor tehnice (de SalestableBiEntityexemplu, ). Această convenție de denumire îi identifică ca entități de date concepute pentru integrarea arhivării și Dataverse.

Supported scenarios

Următorul tabel listează toate scenariile de arhivă furnizate de Microsoft și numele lor de tabel corespunzătoare din fiecare strat.

Scenario Live table History table Entitatea de date finanțe și operațiuni Dataverse managed data lake tabelul
Contabilitate financiară 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
Comanda De gestionare a lanțului de aprovizionare 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
Tranzacție inventar gestionare lanț de aprovizionare INVENTTRANSARCHIVE INVENTTRANSARCHIVEHISTORY InventtransarchiveBiEntity mserp_InventTransArchiveBiEntity
Jurnal inventar gestionare lanț de aprovizionare INVENTJOURNALTABLE INVENTJOURNALTABLEHISTORY InventjournaltableBiEntity mserp_InventjournaltableBiEntity
INVENTJOURNALTABLE_IN INVENTJOURNALTABLE_INHISTORY InventjournaltableinBiEntity mserp_InventjournaltableinBiEntity
INVENTJOURNALTRANS INVENTJOURNALTRANSHISTORY InventjournaltransBiEntity mserp_InventjournaltransBiEntity
INVENTJOURNALTRANS_IN INVENTJOURNALTRANS_INHISTORY InventjournaltransinBiEntity mserp_InventjournaltransinBiEntity
Trans de taxe financiare 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
Factură pentru clienți finanțați 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