Understanding the Data Architecture portion of new releases in FinOps: New tables introduced in FinOps 10.41- 10.42.

-


Understanding the Data Architecture portion of new releases in FinOps:


Tables introduced in D365 Finance and Supply Chain Management 10.0.42

(Comparison of releases .41 and .42)


When Microsoft releases a new version, there is always a lot to consider before promoting to production. Beyond the surface-level features, we need to dive into the technical details: new tables, changes to existing fields, label updates, you name it. Your integration partner should be on top of these, but it's crucial for our internal SMEs to also do their homework. There are more independent FinOps customers that manage testing and promoting updates without partner assistance. 

To help with that, I've put together a list of the new tables added in 10.0.42. Please take a look and discuss these with your integrators and analytics teams. Let's make sure everything works smoothly in our sandbox environments before pushing anything to production. Understanding the underlying changes in each release is key to preventing those expensive 'oops' moments."

If you would like a list of new fields, label changes etc… reach out and I will update the blog. 

Additionally, you can also compare configuration across entities and environments in your FinOps ecosystem if there is value in doing so systematically. 

New Tables introduced from . 41 to .42

  • AppCopilotAgentTask (AppCopilotAgentTask)
  • AppCopilotAgentTaskHistory (AppCopilotAgentTaskHistory)
  • AssetProposalConfiguration (AssetProposalConfiguration)
  • AssetProposalQueue (AssetProposalQueue)
  • AssetProposalRequest (AssetProposalRequest)
  • CLMIntegrationEntityValidation (CLM integration entity validation)
  • CLMIntegrationExternalNavigationLinkKeyValueStaging (CLM integration external navigation link key-value pairs)
  • CLMIntegrationExternalNavigationLinkStaging (CLM integration external navigation links)
  • CLMIntegrationServiceInstanceStaging (CLM integration service instance)
  • CustAssignedInvoiceNumbers (Assigned free text invoice numbers)
  • CustAssignedInvoiceNumbersTempData(CustAssignedInvoiceNumbersTempData)
  • CustInvoiceJourAdjustmentHistory (CustInvoiceJourAdjustment history data)
  • CustInvoiceJourCorrectionTypeHistory_RU(CustInvoiceJourCorrectionType_RU history data)
  • CustInvoiceJourCorrLinkHistory_RU(CustInvoiceJourCorrLink_RU history data)
  • CustInvoiceJourExtensionHistory_CN(CustInvoiceJourExtension_CN history data)
  • CustInvoiceJourExtensionHistoryTH(CustInvoiceJourExtensionTH history data)
  • CustInvoiceJourHistory (CustInvoiceJour history data)
  • CustInvoiceJourHistory_BR (CustInvoiceJour_BR history data)
  • CustInvoiceJourHistory_FR (CustInvoiceJour_FR history data)
  • CustInvoiceJourHistory_IN (CustInvoiceJour_IN history data)
  • CustInvoiceJourHistory_Intrastat (CustInvoiceJour_Intrastat history data)
  • CustInvoiceJourHistory_Officials (CustInvoiceJour_Officials history data)
  • CustInvoiceJourHistory_PL (CustInvoiceJour_PL history data)
  • CustInvoiceJourHistory_RU (CustInvoiceJour_RU history data)
  • CustInvoiceJourHistory_W (CustInvoiceJour_W history data)
  • CustInvoiceJourPrintHistory (CustInvoiceJourPrint history data)
  • CustInvoiceJourSymbolHistory (CustInvoiceJourSymbol history data)
  • CustInvoiceLineAssetHistory (CustInvoiceLineAsset history data)
  • CustInvoiceLineCorrLinkHistory_RU(CustInvoiceLineCorrLink_RU history data)
  • CustInvoiceLineHistory (CustInvoiceLine history data)
  • CustInvoiceLineHistory_W (CustInvoiceLine_W history data)
  • CustInvoiceLineInterProjHistory (CustInvoiceLineInterProj history data)
  • CustInvoiceLineTaxExtensionHistoryIN(CustInvoiceLineTaxExtensionIN history data)
  • CustInvoiceTableCalcTotalsHistory (CustInvoiceTableCalcTotals history data)
  • CustInvoiceTableExtensionHistory_CN(CustInvoiceTableExtension_CN history data)
  • CustInvoiceTableExtensionHistoryTH(@SYS4083039@AccountsReceivable:CustInvoiceTableExtensionHistoryTHCaption)
  • CustInvoiceTableHistory (CustInvoiceTable history data)
  • CustInvoiceTableHistory_W (CustInvoiceTable_W history data)
  • CustInvoiceTableSymbolHistory (CustInvoiceTableSymbol history data)
  • CustInvoiceTransAssetHistory (CustInvoiceTransAsset history data)
  • CustInvoiceTransCorrLinkHistory_RU(CustInvoiceTransCorrLink_RU history data)
  • CustInvoiceTransHistory (CustInvoiceTrans history data)
  • CustInvoiceTransHistory_BR (CustInvoiceTrans_BR history data)
  • CustInvoiceTransHistory_IN (CustInvoiceTrans_IN history data)
  • CustInvoiceTransHistory_Intrastat (CustInvoiceTrans_Intrastat history data)
  • CustInvoiceTransHistory_RU (CustInvoiceTrans_RU history data)
  • CustInvoiceTransHistory_W (CustInvoiceTrans_W history data)
  • CustInvoiceTransTaxExtensionHistoryIN(CustInvoiceTransTaxExtensionIN history data)
  • CustomerInvoiceArchiveTrans (Customer invoice archive transactions)
  • DMFSingleUseCleanupParameters (Single use cleanup settings)
  • DMFSingleUseProjectsToRemove (Old single use projects to Remove)
  • EcoResInventTableItemIdRenameLog (Item number renaming logs)
  • EcoResInventTableItemIdRenameLogLine (Item number renaming log lines)
  • EximCustInvoiceTransHistory_IN (EximCustInvoiceTrans_IN history data)
  • FinTagByLegalEntity (Financial tag by legal entity)
  • FinTagConfigurationGlobalTmp (Financial tag configuration global temp table)
  • FinTagRule (Financial tag rules (preview))
  • FinTagRuleCopyTmp (Financial tag rules (preview))
  • FinTagRuleProcessingTime (Financial tag rule processing time)
  • FinTagRuleStaging (Financial tag rule entity)
  • GUPDiscountClaimTopPickingStaging(GUPDiscountClaimTopPickingStaging)
  • ImmersiveHomeUserPersonalization (Immersive home user personalization)
  • InventoryServiceDiagnosticProcessStatus(InventoryServiceDiagnosticProcessStatus)
  • InventSettlementArchiveTrans (Inventory settlement archive transactions)
  • InventSettlementHistory (Inventory settlement)
  • InventTransArchiveRecIdFilter (Transactions)
  • InventTransPostingArchiveTrans (Inventory transaction posting archive transactions)
  • InventTransPostingHistory (Inventory transaction posting)
  • LedgerFiscalPeriodV2Staging (Ledger fiscal calendar period V2)
  • LedgerTransferOpeningSettlementTmp(LedgerTransferOpeningSettlementTmp)
  • LedgerTransSettlementMarkedTransaction (Ledger settlements)
  • LedgerTransSettlementOpen (Ledger partial settlement)
  • LTMCustInvoiceJourHistory (LTMCustInvoiceJour history data)
  • LTMCustInvoiceTableHistory (LTMCustInvoiceTable history data)
  • PayIntV2EmploymentDetail (Payroll integration v2 employment detail table)
  • PayIntV2HcmEmployeeV2 (Payroll integration v2 employee v2)
  • PayIntV2HcmWorkerBase (Payroll integration v2 worker base)
  • PDSCustInvoiceTransPricingCalculationHistory(PDSCustInvoiceTransPricingCalculation history data)
  • PdsRebateCustInvoiceTransHistory (PdsRebateCustInvoiceTrans history data)
  • PurchCopilotAgentResultEmail (Agent created emails)
  • PurchCopilotInboundEmailMappingOrder (Mapped order data from inbound email)
  • PurchCopilotInboundEmailMappingOrderLine (Mapped order line data from inbound email)
  • PurchCopilotInboundEmailMatching (Email matching)
  • PurchCopilotInboundEmailMatchingOrder (Matching order)
  • PurchCopilotInboundEmailMatchingOrderLine (Matching order line)
  • PurchCopilotPurchaseFollowupResultPurchLineLink (Agent result - Purchase order relations)
  • ReconciliationAutomationFiscalPeriodData (Reconciliation automation framework table)
  • ReconciliationAutomationLedgerMainAccountMapping(Reconciliation automation framework table)
  • ReconciliationAutomationLinkTransactionDetails (Reconciliation automation link transaction details)
  • ReconciliationAutomationParameters (Reconciliation automation framework table)
  • ReconciliationAutomationVoucherExceptionLog (Reconciliation automation framework table)
  • ReconciliationAutomationVoucherSubledgerDetails(Reconciliation automation framework table)
  • ReconciliationAutomationVoucherSummary (Reconciliation automation framework table)
  • RetailCDXSeedDataHistory (RetailCDXSeedDataHistory)
  • RetailCDXTableDistributionHistory(RetailCDXTableDistributionHistory)
  • RetailCustInvoiceJourTableHistory (RetailCustInvoiceJourTable history data)
  • SCMCopilotAgent (Agent)
  • SCMCopilotAgentInboundEmailAttachmentStaging (Incoming email attachments)
  • SCMCopilotAgentInboundEmailStaging (Incoming emails)
  • SCMCopilotAgentResult (Result)
  • SCMCopilotInboundMatchingField (Contains information of the fields that will participate in matching logic.)
  • SCMCopilotInboundMatchingFieldValue (Contains mapping of field ids with field values, for all the fields that participate in inbound matching process.)
  • SourceDocumentCleanupForSalesOrderInvoiceRemoveQueue(The table is used in the SourceDocumentCleanupForSalesOrderInvoice data maintenance job. During the activity run, the table will have the recIds of SDH inserted, which potentially would be deleted by the job itself. The table helps to avoid performin)
  • SourceDocumentCleanupForSalesOrderPackingSlipRemoveQueue(The table is used in the SourceDocumentCleanupForSalesOrderPackingSlip data maintenance job. During the activity run, the table will have the recIds of SDH inserted, which potentially would be deleted by the job itself. The table helps to avoid perfo)
  • SubledgerGLSettlementQueue (SubledgerGLSettlementQueue)
  • SubledgerGLSettlementUnsettledTrans(SubledgerGLSettlementUnsettledTrans)
  • TaxIntegrationTaxFeatureSetupMigrationTaxCodeMap (Tax code mapping during tax feature migration)
  • TaxTransJurisdictionDetail (Posted sales tax detail)
  • TaxUncommittedJurisdictionDetail (Uncommitted sales tax detail)
  • TrvExpenseCopilotConfiguration(TrvExpenseCopilotConfiguration)
  • TrvExpenseCopilotConfigurationStaging (Configuration for Expense Agent)
  • TrvExpenseCopilotExecutionDetails(TrvExpenseCopilotExecutionDetails)
  • UdsConfigTable (UdsConfigTable)
  • VendAccountNumObjectReferences (Vendor account object references)
  • VendAccountNumRenameDataMaintenance (Vendor account rename data maintenance)
  • VendAccountNumRenameDataMaintenanceTracking (Vendor account data maintenance tracking table)
  • VendInvoiceTotalLastValue (VendInvoiceTotalLastValue)
  • WHSGS1PolicyLineIdentifier (Additional application identifiers for policy line)
  • WHSGS1PolicyLineIdentifierStaging (Additional application identifiers for policy line)
Things you didn’t know that you needed to know. 

Thanks
Tim Hartwig

Comments

Post a Comment

Popular posts from this blog

Inventory Consignment with Dynamics 365 Finance and Operations : What you didn’t know you needed to know

-
Image
Inventory Consignment in D365 FinOps: What you didn’t know you needed to know.  Today, I would like to cover the step by step process to explain the Inventory Consignment feature in D365 Finance and Operations.  Inventory Consignment Management is the new feature introduced in D365 FinOps. This feature was not available in AX2012 and previous versions. What is Consignment inventory? Consignment inventory is inventory that’s owned by a vendor but stored at your site. When you’re ready to consume or use the inventory, you take over the ownership of the inventory Consignor:  In consignment management, the supplier who sends/ships goods are called consignor. Consignee:  In consignment, the receiver of the goods is called consignee.  Who own the Inventory when using Inventory Consignment? Firstly the ownership of the inventory lies with the vendor. Once, the inventory has been consumed we need to transfer the ownership from Vendor to the Legal entity.  Configura...
Read more

What is “FinOps” - It’s probably not what you think.

-
Image
  What is “FinOps” according to Microsoft:  I’ll give you a hint and it’s not “Finance and Operations” FinOps combines financial management principles with cloud engineering and operations to provide organizations with a better understanding of their cloud spending. It also helps you make informed decisions on how to allocate and manage your cloud costs. Understand what you are saying when you reference “FinOps” across Microsoft and other cloud based ecosystems.  FinOps is an operational framework and cultural practice that enhances the business value derived from cloud technology. It promotes data-driven decision-making in a timely manner and fosters financial responsibility. It gets achieved through collaboration among engineering, finance, and business teams. FinOps is a discipline that combines financial management principles with cloud engineering and operations to provide organizations with a better understanding of their cloud spending. It also helps them make info...
Read more