이 참조는 보관 프레임워크 계층에서 Microsoft에서 제공하는 테이블의 이름을 지정하는 방법을 보여 줍니다. 각 행은 Dynamics 365 재무 및 운영의 라이브 트랜잭션 테이블에서 기록 테이블, 재무 및 운영 데이터 엔터티, 마지막으로 Dataverse 관리형 데이터 레이크 테이블에 이르는 보관 파이프라인을 통해 이동하는 것과 동일한 논리 엔터티를 매핑합니다.
이 참조를 사용하여 다음을 수행합니다.
- 보관 계층의 명명 규칙을 이해합니다.
- 사용자 지정을 구현할 때 해당 테이블 이름을 조회합니다.
- 보관 작업 계약의 엔터티 이름을 확인합니다.
- 서로 다른 스토리지 계층 간에 데이터를 매핑합니다.
테이블 명명 규칙
| Layer | Naming pattern | Example |
|---|---|---|
| Live table | 원래 Dynamics 365 재무 및 운영 테이블 이름 | SALESTABLE |
| History table | 라이브 테이블 및 "기록" 접미사 | SALESTABLEHISTORY |
| 재무 및 운영 데이터 엔터티 | 라이브 테이블 및 "BiEntity" 접미사 | SalestableBiEntity |
| Dataverse table | "mserp_" 접두사 + 데이터 엔터티 이름 | mserp_SalestableBiEntity |
Note
이러한 재무 및 운영 데이터 엔터티는 기술 이름(예 SalestableBiEntity: )에 "BiEntity" 접미사를 사용합니다. 이 명명 규칙은 이들을 아카이브 및 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 | |
| 공급망 관리 WHS 부중 | 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 |