Odkaz na pomenovanie tabuľky Archivovať

Tento odkaz ukazuje, ako sú tabuľky poskytnuté spoločnosťou Microsoft pomenované vo vrstvách architektúry archívu. Každý riadok mapuje rovnakú logickú entitu ako kanál archívu: z tabuľky dynamických transakcií v systéme Dynamics 365 finance and operations do tabuľky história, cez entitu údajov finance and operations a nakoniec do tabuľky data lake spravovanej službou Dataverse.

Použite tento odkaz na:

• Porozumejte konvenciám pomenovania naprieč vrstvami archívu.
• Vyhľadajte zodpovedajúce názvy tabuliek pri implementácii prispôsobení.
• Overte názvy entít pre zmluvy na prácu s archívom.
• Mapovať údaje medzi rôznymi vrstvami úložiska.

Konvencie pomenovania tabuliek

Layer	Naming pattern	Example
Live table	Pôvodný názov tabuľky dynamics 365 finance and operations	SALESTABLE
History table	Dynamická tabuľka a prípona "História"	SALESTABLEHISTORY
Údajová entita Finance and Operations	Dynamická tabuľka a prípona BiEntity	SalestableBiEntity
Dataverse table	predpona mserp_ + názov entity údajov	mserp_SalestableBiEntity

Note

Tieto entity údajov finance and operations používajú príponu "BiEntity" vo svojich technických názvoch (napríklad SalestableBiEntity). Táto konvencia pomenovania ich identifikuje ako dátové entity navrhnuté na integráciu archívu a Dataverse.

Supported scenarios

V nasledujúcej tabuľke sú uvedené všetky archívne scenáre poskytnuté spoločnosťou Microsoft a zodpovedajúce názvy tabuliek pre každú vrstvu.

Scenario	Live table	History table	Údajová entita Finance and Operations	Tabuľka dataverse managed data lake
Financie Financie Financie	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
Predajná objednávka na riadenie dodávateľského reťazca	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
Transakcia Supply Chain Management Inventory	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
Finančná daň 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
Finančná faktúra pre zákazníka	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

• Archive customization
• Pridanie vlastných polí do tabuliek spravovaných spoločnosťou Microsoft
• Pridanie vlastných tabuliek do štandardných scenárov
• Vytvorenie vlastného scenára s archívom