Архивна препратка към наименуване на таблица

Тази препратка показва как таблиците, предоставени от Microsoft, са наименувани в слоевете на рамката за архивиране. Всеки ред съпоставя един и същ логически обект, както преминава през канала на архива: от таблицата за транзакции в реално време в Dynamics 365 финанси и операции, към таблицата с хронологията, към обекта с данни за финанси и операции и накрая към таблицата на езерото с данни, управлявано от Dataverse.

Използвайте тази препратка за:

• Разбиране на конвенциите за именуване в слоевете на архивите.
• Потърсете съответните имена на таблици, когато прилагате персонализации.
• Проверете имената на обектите за вашите договори за задание за архивиране.
• Нанасяне на данни между различни слоеве за съхранение.

Конвенции за наименуване на таблици

Layer	Naming pattern	Example
Live table	Първоначално име на таблицата за финанси и операции на Dynamics 365	SALESTABLE
History table	Таблица на живо и суфикс "Хронология"	SALESTABLEHISTORY
Субект на данни за финанси и операции	Таблица на живо и суфикс "BiEntity"	SalestableBiEntity
Dataverse table	Префикс "mserp_" + име на обект с данни	mserp_SalestableBiEntity

Note

Тези субекти на данни за финанси и операции използват суфикса "BiEntity" в техните технически имена (например SalestableBiEntity). Тази конвенция за именуване ги идентифицира като данни, предназначени за интеграция между архиви и Dataverse.

Supported scenarios

Следващата таблица описва всички предоставени от Microsoft архивни сценарии и съответните им имена на таблици във всеки слой.

Scenario	Live table	History table	Субект на данни за финанси и операции	Dataverse-управлявана таблица с лейк на данни
Счетоводство за финанси	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 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
• Добавяне на полета по избор към управлявани от Microsoft таблици
• Добавяне на таблици по избор към стандартни сценарии
• Създайте свой собствен сценарий за архивиране по избор