Nota
O acesso a esta página requer autorização. Pode tentar iniciar sessão ou alterar os diretórios.
O acesso a esta página requer autorização. Pode tentar alterar os diretórios.
Esta referência mostra como as tabelas fornecidas pela Microsoft são nomeadas ao longo das camadas do framework de arquivo. Cada linha mapeia a mesma entidade lógica à medida que se move pelo pipeline de arquivo: da tabela de transações em tempo real no Dynamics 365 finanças e operações, para a tabela de histórico, para a entidade de dados de finanças e operações, e finalmente para a tabela de data lake gerida pelo Dataverse.
Use esta referência para:
- Compreender as convenções de nomenclatura entre camadas de arquivo.
- Procura os nomes das tabelas correspondentes ao implementar personalizações.
- Verifica os nomes das entidades para os contratos de trabalho do teu arquivo.
- Mapear dados entre diferentes camadas de armazenamento.
Convenções de nomenclatura de tabelas
| Layer | Naming pattern | Example |
|---|---|---|
| Live table | Nome original da tabela de finanças e operações do Dynamics 365 | SALESTABLE |
| History table | Tabela ao vivo e sufixo "História" | SALESTABLEHISTORY |
| Entidade de dados de finanças e operações | Tabela ativa e sufixo "BiEntity" | SalestableBiEntity |
| Dataverse table | Prefixo "mserp_" + nome da entidade de dados | mserp_SalestableBiEntity |
Note
Estas entidades de dados financeiros e operacionais utilizam o sufixo "BiEntity" nos seus nomes técnicos (por exemplo, SalestableBiEntity). Esta convenção de nomenclatura identifica-os como entidades de dados concebidas para a integração de arquivo e Dataverse.
Supported scenarios
A tabela seguinte lista todos os cenários de arquivo fornecidos pela Microsoft e os respetivos nomes de tabelas em cada camada.
| Scenario | Live table | History table | Entidade de dados de finanças e operações | Tabela datalake gerida pelo Dataverse |
|---|---|---|---|---|
| Livro de razão geral de Finanças | 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 | |
| Gestão da Cadeia de Abastecimento de Encomendas de Vendas | 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 | |
| Gestão da Cadeia de Abastecimento Transação de Inventário | INVENTTRANSARCHIVE | INVENTTRANSARCHIVEHISTORY | InventtransarchiveBiEntity | mserp_InventTransArchiveBiEntity |
| Diário de Inventário de Gestão da Cadeia de Abastecimento | INVENTJOURNALTABLE | INVENTJOURNALTABLEHISTORY | InventjournaltableBiEntity | mserp_InventjournaltableBiEntity |
| INVENTJOURNALTABLE_IN | INVENTJOURNALTABLE_INHISTORY | InventjournaltableinBiEntity | mserp_InventjournaltableinBiEntity | |
| INVENTJOURNALTRANS | INVENTJOURNALTRANSHISTORY | InventjournaltransBiEntity | mserp_InventjournaltransBiEntity | |
| INVENTJOURNALTRANS_IN | INVENTJOURNALTRANS_INHISTORY | InventjournaltransinBiEntity | mserp_InventjournaltransinBiEntity | |
| Transação de Impostos Financeiros | 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 | |
| Fatura do Cliente Financeiro | 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 |