Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
Denne reference viser, hvordan Microsoft-leverede tabeller navngives på tværs af arkivstrukturlagene. Hver række tilknytter det samme logiske objekt, som det bevæger sig gennem arkivpipelinen: fra tabellen med dynamiske transaktioner i Dynamics 365 finance and operations til oversigtstabellen, til dataobjektet finance and operations og til sidst til data lake-tabellen Dataverse-managed.
Brug denne reference til:
- Forstå navngivningskonventioner på tværs af arkivlag.
- Slå tilsvarende tabelnavne op, når du implementerer tilpasninger.
- Kontrollér enhedsnavnene for dine arkivjobkontrakter.
- Tilknyt data mellem forskellige lagerlag.
Navngivningskonventioner for tabeller
| Layer | Naming pattern | Example |
|---|---|---|
| Live table | Oprindeligt navn på økonomi- og operationstabel i Dynamics 365 | SALESTABLE |
| History table | Direkte tabel og suffiks af typen "Historik" | SALESTABLEHISTORY |
| Dataobjektet Finance and Operations | Live table og "BiEntity"-suffiks | SalestableBiEntity |
| Dataverse table | Præfikset "mserp_" + dataenhedsnavn | mserp_SalestableBiEntity |
Note
Disse økonomi- og driftsdataenheder bruger suffikset "BiEntity" i deres tekniske navne (f.eks. SalestableBiEntity). Denne navngivningskonvention identificerer dem som dataenheder designet til arkiv- og Dataverse-integration.
Supported scenarios
I følgende tabel vises alle Microsoft-leverede arkivscenarier og deres tilsvarende tabelnavne på tværs af hvert lag.
| Scenario | Live table | History table | Dataobjektet Finance and Operations | Dataverse-administreret data lake-tabel |
|---|---|---|---|---|
| Finansbogholderiet | 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 | |
| Salgsordre for supply chain management | 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-lagertransaktion | INVENTTRANSARCHIVE | INVENTTRANSARCHIVEHISTORY | InventtransarchiveBiEntity | mserp_InventTransArchiveBiEntity |
| Lagerkladde for supply chain management | INVENTJOURNALTABLE | INVENTJOURNALTABLEHISTORY | InventjournaltableBiEntity | mserp_InventjournaltableBiEntity |
| INVENTJOURNALTABLE_IN | INVENTJOURNALTABLE_INHISTORY | InventjournaltableinBiEntity | mserp_InventjournaltableinBiEntity | |
| INVENTJOURNALTRANS | INVENTJOURNALTRANSHISTORY | InventjournaltransBiEntity | mserp_InventjournaltransBiEntity | |
| INVENTJOURNALTRANS_IN | INVENTJOURNALTRANS_INHISTORY | InventjournaltransinBiEntity | mserp_InventjournaltransinBiEntity | |
| Finans Skattetrans | 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 | |
| Finanskundefaktura | 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 |