Abstract ERP command center showing financial dashboards, workflows, data streams, and enterprise systems.

Microsoft Dynamics ERP consulting and support

ERP help for companies that cannot afford disruption.

Cole Solutions helps finance and operations leaders stabilize Dynamics GP, implement Business Central or Finance & Operations, and turn ERP data into automation, insight, and measurable control.

Schedule a readiness call Check readiness

30+Years ERP Experience

300+Implementations

98%Client Retention

Why buyers choose Cole Solutions

Senior ERP judgment, not a generic implementation factory.

Many partners want every GP customer to rush into a cloud migration. Cole Solutions gives clients a more useful answer: stabilize what must keep running, modernize what creates leverage, and build a phased path that respects finance calendars, integrations, audit needs, and user adoption.

Find the right ERP help

Start with the problem you need to solve.

Cole Solutions is a New Jersey-based Microsoft ERP consulting firm serving organizations across the United States. Choose a focused guide for clear answers, delivery outcomes, and the next step for your situation.

ERP consulting services

ERP help for finance and operations teams that need a clear answer.

Get senior ERP consulting for assessments, implementation rescue, integrations, reporting, support, and Microsoft Dynamics modernization.

Get focused guidance Microsoft Dynamics GP support

Keep Dynamics GP dependable while you plan what comes next.

Senior Microsoft Dynamics GP support for performance, SQL, reporting, integrations, year-end close, customizations, and modernization planning.

Get focused guidance Dynamics 365 Business Central consulting

Business Central designed around how your company actually operates.

Business Central consulting for solution fit, implementation, GP migration, finance, inventory, integrations, reporting, and Power Platform.

Get focused guidance Dynamics 365 Finance & Operations consulting

Enterprise finance and operations with control built into the design.

Dynamics 365 Finance & Operations consulting for enterprise finance, supply chain, data, integrations, reporting, controls, and implementation recovery.

Get focused guidance ERP modernization consulting

Modernize ERP without putting the close, customers, or operations at risk.

ERP modernization consulting for roadmaps, platform selection, data migration, integrations, testing, cutover, adoption, automation, and reporting.

Get focused guidance

Customer case studies

Real operating problems. Practical ERP outcomes.

Backed by 30+ years of ERP experience, 300+ implementations, and 98% client retention, Cole Solutions works across banking, staffing, technology services, facilities, and distribution—where dependable systems directly affect payroll, customer service, reporting, and control.

Banking and finance

LBDI

Enterprise banking operations modernized around D365 Finance & Operations.

Challenge: Unreliable branch connectivity and manual Central Bank reporting limited control and timely visibility.
Cole Solutions response: Supported a D365 Finance & Operations transformation, improved branch connectivity, and automated regulatory reporting workflows.
Business value: A stronger operational backbone, more reliable reporting, and a scalable foundation for continued modernization.

Staffing and workforce

CoWorx Staffing

Payroll-grade ERP integration for 50,000 weekly employees.

Challenge: Bullhorn, ERP, budgeting, and time data had to support complex, high-volume weekly payroll operations.
Cole Solutions response: Connected staffing, timesheet, budgeting, and ERP workflows around a payroll operation supporting 50,000 weekly employee records.
Business value: Fewer manual handoffs, stronger payroll execution, and clearer financial control across a high-volume staffing environment.

Technology services

Service Express

Dependable ERP operations for a fast-moving service organization.

Challenge: A growing technology services business required reliable financial workflows, integrations, and management reporting.
Cole Solutions response: Supported Microsoft ERP processes and the reporting and integration layers connecting finance with operating teams.
Business value: More dependable day-to-day execution and a stronger ERP foundation for continued growth.

Facilities and building services

Collins Building Services

Finance and operations aligned across a distributed service business.

Challenge: Labor-intensive service delivery created complexity across customer billing, finance, reporting, and operational control.
Cole Solutions response: Improved Dynamics workflows and reporting across the company’s operational and financial processes.
Business value: Better cross-functional visibility, cleaner reporting, and fewer spreadsheet-driven workarounds.

Sporting goods and distribution

A&R Sports

Inventory, distribution, and finance working from the same operating truth.

Challenge: Product, inventory, fulfillment, and financial data needed to stay aligned across a distribution-driven business.
Cole Solutions response: Strengthened Dynamics GP processes, reporting, and controls around inventory and finance.
Business value: More dependable information for purchasing, fulfillment, financial reporting, and management decisions.

Professional staffing

Execu|Search Group

Connected workflows for staffing, payroll, billing, and accounting.

Challenge: Staffing growth required tighter coordination across recruiting, time capture, payroll, billing, and finance.
Cole Solutions response: Connected staffing and ERP workflows while improving reporting and integration reliability.
Business value: Cleaner handoffs, stronger process control, and a more scalable operating foundation.

Solution comparison

Three valid paths. One must fit the operating reality.

The right answer is not automatically the newest platform. It is the solution whose depth, cost, risk, and operating model fit the business you need to run over the next five to ten years.

01Stabilize or stage

Dynamics GP

Best fit: Organizations already running GP whose immediate priority is continuity, control, and a deliberate modernization runway.
Core strength: Proven financial and distribution processes, familiar operations, SQL-based reporting, and lower near-term disruption.
Watch closely: Microsoft product support ends December 31, 2029. Technical debt, infrastructure, integrations, and customizations can increase risk.

Optimize GP and build the migration evidence before selecting a destination.

02Modernize for agility

Business Central

Best fit: Small and midsize organizations that want connected finance and operations with a manageable cloud operating model.
Core strength: Broad ERP coverage, Microsoft 365 and Power Platform integration, AL extensions, AppSource, and continuous cloud updates.
Watch closely: Highly complex global, manufacturing, warehousing, or enterprise-control requirements can exceed the intended operating model.

Choose BC when process standardization and speed matter more than enterprise-scale depth.

03Scale complex operations

Finance & Operations

Best fit: Midmarket and enterprise organizations with complex entities, volumes, controls, supply chains, manufacturing, or global requirements.
Core strength: Advanced finance, supply chain, manufacturing, warehousing, transportation, planning, localization, and enterprise extensibility.
Watch closely: The implementation, governance, testing, data, integration, and change-management effort is materially greater.

Choose F&O when operational complexity creates a clear return on the larger investment.

Side-by-side decision matrixCompare the operating tradeoffs.

Get a solution-fit assessment

Decision area	Dynamics GP	Business Central	Finance & Operations
Typical fit	Existing GP organization prioritizing stability	Small to midsize, moderately complex operations	Midmarket to enterprise, complex or global operations
Primary reason to choose it	Protect continuity while preparing the right next move	Modern cloud ERP without enterprise-level overhead	Depth, scale, control, and advanced operational capability
Deployment model	Customer-managed on-premises or hosted infrastructure	Cloud SaaS by default; on-premises option available	Cloud-first enterprise service with managed environments
Financial management	Strong core accounting and distribution foundation	Comprehensive finance for small and midsize businesses	Advanced global finance, controls, planning, tax, and close
Supply chain and distribution	Solid core inventory, sales, and purchasing	Broad inventory, warehouse, purchasing, and order management	Advanced planning, procurement, warehousing, transportation, and fulfillment
Manufacturing	Established capabilities, often extended by partners	Practical manufacturing for many small and midsize operations	Deep discrete, process, lean, planning, costing, and shop-floor capability
Multi-entity and global operations	Possible, but architecture and reporting require care	Multiple companies, consolidation, intercompany, and localizations	Designed for complex legal entities, shared services, and global scale
Customization model	Dexterity, .NET, SQL, VBA, integrations, and ISV products	AL extensions, AppSource, APIs, Power Platform, and Azure	X++ extensions, configuration, Power Platform, Azure, and ISV solutions
Integration approach	eConnect, Integration Manager, web services, SQL, and middleware	Standard APIs, API pages, web services, Dataverse, and Power Automate	Data entities, OData, business events, services, Dataverse, and Azure
Reporting and analytics	Management Reporter, SSRS, Excel, SQL, and Power BI	Built-in analytics, Excel, financial reporting, and Power BI	Financial reporting, operational workspaces, electronic reporting, and Power BI
Relative implementation effort	Lowest when optimizing the current environment	Moderate; can be rapid when scope and processes are controlled	Highest; requires enterprise program discipline and governance
Best next step	Health assessment and dependency inventory	Fit-to-standard discovery and migration assessment	Enterprise architecture, process, data, and value assessment

Product references:Dynamics GP Business Central Dynamics 365 Finance Supply Chain Management

Capabilities

One partner across the full ERP lifecycle.

Stabilize

Dynamics GP continuity

Keep Great Plains reliable with senior support, performance tuning, year-end close help, reporting repair, customizations, and a practical roadmap for the years ahead.

GP supportDexteritySQLManagement Reporter

Modernize

D365 modernization

Move from GP, AX, QuickBooks, spreadsheets, or disconnected systems into Business Central or Finance & Operations with clean migration planning and fit-to-process design.

Business CentralF&OData migrationGo-live

Connect

Automation and integration

Tie ERP to payroll, banking, logistics, portals, CRMs, ATS platforms, e-commerce, and approval workflows so the business runs with fewer handoffs.

Power PlatformAPIsEDIWorkflow

Advance

BI, AI, and controls

Turn operational data into executive visibility with Power BI, forecasting, exception monitoring, compliance reporting, and AI-assisted decision support.

Power BIAzure AIForecastingControls

Microsoft Dynamics GP support deadline

December 31, 2029

Product enhancements, regulatory updates, and technical support end.

—Days

—Hours

—Minutes

—Seconds

Use the runway deliberately

Three decisions prevent a rushed migration.

Security updates continue through April 30, 2031, but waiting that long leaves little room for a controlled ERP decision.

Microsoft lifecycle details

Now–2027

Stabilize the environment

Document customizations, integrations, reporting dependencies, version status, and the processes that cannot fail during close or payroll.

Discuss your GP roadmap

Modernization playbook

A practical path from risk to momentum.

The goal is not software theater. It is a cleaner operating model, trusted numbers, better controls, and fewer heroic workarounds.

Map the operating truth

Inventory systems, customizations, integrations, reports, data quality, month-end pain, and the decisions leadership cannot see clearly today.

Choose the right ERP path

Decide whether to optimize GP, move to Business Central, adopt Finance & Operations, or phase the transition by entity, region, or workflow.

De-risk the data and integrations

Prototype conversion, validate chart-of-accounts design, reconcile history, and prove the critical integrations before the schedule gets expensive.

Launch with adoption built in

Train by role, protect the close calendar, monitor exceptions, and keep a senior team close through go-live, stabilization, and optimization.

ERP readiness check

Turn warning signs into a practical next step.

Select the conditions that are true today. You will receive an immediate risk level and three actions your team can use to start reducing exposure.

ContinuityKey-person dependencyOnly one or two people know how to keep the ERP stable or complete critical processes. FinanceManual close workMonth-end depends on exports, re-keying, offline spreadsheets, or repeated reconciliation. ReportingConflicting numbersFinance, operations, and leadership reports do not consistently agree. SupportabilityUndocumented customizationsImportant custom code, reports, or workflows have unclear purpose, ownership, or support. IntegrationSilent integration failuresInterfaces fail without alerts or require recurring manual cleanup and reprocessing. ModernizationNo decision-ready roadmapLeadership has no agreed plan for GP support milestones, platform selection, data, or timing.

Executive resource center

Decision-grade ERP guidance, ready to use.

Built from 30+ years of ERP experience and 300+ implementations, these practical guides help leadership teams frame the right questions before the timeline, scope, or investment becomes difficult to control.

Dynamics GP9 pages

The Dynamics GP 2029 Exit Strategy

A board-ready roadmap to stabilize today, choose the right destination, and modernize without a forced or rushed migration.

A phased planning runway through the Microsoft support milestones
A practical framework for GP, Business Central, or F&O
A 90-day readiness program and executive checklist

Solution selection10 pages

Business Central vs. Finance & Operations

The CFO and CIO decision guide for choosing the Microsoft ERP platform that fits the operating model.

An eight-dimension platform fit scorecard
Architecture, implementation, and total-cost considerations
Fit-to-standard scenarios and decision gates

ERP transformation12 pages

ERP Modernization Without Disruption

A practical operating playbook for protecting continuity while changing systems, data, controls, and user behavior.

A stage-gated modernization roadmap
Data, integration, testing, and cutover controls
Adoption measures and a board-level risk dashboard

Complimentary PDF9 pages

The Dynamics GP 2029 Exit Strategy

Complete the short form and your download will begin immediately.

First name Last name Business email Company

Add optional details

Job title Phone ERP interest

We use this information to deliver the resource and respond to your request. Cole Solutions does not sell your information.

ERP knowledge center

Clear answers. Useful technical depth.

Expert-reviewed by the Cole Solutions ERP consulting team · Updated August 24, 2026

Start with the business questions prospects ask most, then explore a practical reference of common tables used in reporting, integration, troubleshooting, and migration work.

Open the research tool

Dynamics GP

Microsoft Dynamics GP

Physical SQL tables commonly used for reporting, troubleshooting, integrations, and migration discovery.

Frequently asked questions

Select a question to view the answer.

Do we need to move off Dynamics GP immediately?

No. A stable GP environment can continue operating while you assess risk and plan deliberately. The right timeline depends on your version, regulatory exposure, integrations, customizations, reporting needs, and internal capacity—not a generic cloud deadline.

What happens when Microsoft product support ends?

Microsoft has published December 31, 2029 as the end of product enhancements, regulatory updates, and technical support, with security updates continuing through April 30, 2031. Organizations should use the remaining runway to document dependencies, evaluate options, and avoid a rushed conversion.

Can Cole Solutions stabilize GP before a migration?

Yes. Typical work includes performance tuning, SQL and application health reviews, integration repair, reporting remediation, year-end support, customization documentation, security review, and reducing manual workarounds.

Can our GP history and customizations move to Dynamics 365?

Usually, but not every item should move in its current form. We classify history, master data, open transactions, integrations, reports, and custom code so each can be migrated, redesigned, archived, or retired with a clear business reason.

How do we choose between Business Central and Finance & Operations?

The decision is driven by operational complexity, legal entities, transaction volume, supply-chain depth, manufacturing, project accounting, global requirements, controls, and integration architecture. Company size alone is not enough.

Table	Area	What it is used for
`GL00100`Account Master	General ledger	Stores the chart-of-accounts master records and account-level setup.
`GL00105`Account Index Master	General ledger	Maps the internal account index used by transactions to the account number.
`GL20000`Year-to-Date Transaction Open	General ledger	Stores posted general-ledger transactions for open fiscal years.
`GL30000`Account Transaction History	General ledger	Stores posted general-ledger transaction history for historical years.
`RM00101`RM Customer Master	Receivables	Stores customer master data, terms, classes, addresses, and receivables settings.
`RM20101`RM Open File	Receivables	Stores open receivables documents and unapplied customer transactions.
`RM30101`RM History File	Receivables	Stores fully applied and moved-to-history receivables transactions.
`PM00200`PM Vendor Master File	Payables	Stores vendor master data, payment terms, classes, and payables settings.
`PM20000`PM Transaction Open File	Payables	Stores open vendor invoices, payments, credits, and other payables documents.
`PM30200`PM Paid Transaction History File	Payables	Stores fully applied payables documents moved to history.
`SOP10100`Sales Transaction Work	Sales order processing	Stores unposted sales document headers such as orders, invoices, and returns.
`SOP10200`Sales Transaction Amounts Work	Sales order processing	Stores unposted sales document line items and amounts.
`SOP30200`Sales Transaction History	Sales order processing	Stores posted or transferred sales document headers.
`SOP30300`Sales Transaction Amounts History	Sales order processing	Stores posted or transferred sales document lines.
`IV00101`Item Master	Inventory	Stores core item definitions, types, valuation methods, and item-level settings.
`IV00102`Item Quantity Master	Inventory	Stores item quantities and planning values by site or location.
`POP10100`Purchase Order Work	Purchasing	Stores active purchase-order header information.
`POP10110`Purchase Order Line	Purchasing	Stores active purchase-order line details, quantities, costs, and status.
`GL10000`Transaction Work	General ledger	Stores unposted general-ledger transaction headers and batch references.
`GL10001`Transaction Amounts Work	General ledger	Stores unposted general-ledger distribution lines and account amounts.
`RM00102`Customer Master Address File	Receivables	Stores customer address records used for billing, shipping, statements, and contacts.
`RM00301`Customer Class Master	Receivables	Stores customer-class defaults for terms, posting, finance charges, and account setup.
`PM00100`Vendor Class Master	Payables	Stores vendor-class defaults for payment terms, posting, accounts, and vendor setup.
`PM00300`Vendor Address Master	Payables	Stores vendor remit-to, purchase, primary, and other address records.
`IV00103`Item Vendor Master	Inventory	Links items to vendors and stores vendor item numbers, lead times, and purchasing defaults.
`IV30300`Transaction Amounts History	Inventory	Stores historical inventory transaction quantities, costs, sites, and document references.
`POP30300`Purchasing Receipt History	Purchasing	Stores posted purchasing receipt header history.
`POP30310`Purchase Receipt Line History	Purchasing	Stores posted purchasing receipt line detail, quantities, costs, and purchase-order links.
`CM00100`Checkbook Master	Cash management	Stores checkbook, bank-account, currency, and cash-account setup.
`SY00500`Posting Definitions Master	System	Stores batch headers, source series, posting dates, control totals, and workflow status.
`GL40000`General Ledger Setup	General ledger	Stores company-level general-ledger settings, retained earnings, history, and posting options.
`GL10110`Account Current Summary Master	General ledger	Stores current-year account balances summarized by fiscal period.
`GL10111`Account Summary History	General ledger	Stores historical-year account balances summarized by fiscal period.
`RM00103`Customer Master Summary	Receivables	Stores customer summary balances, aging totals, activity, and period history values.
`RM20201`RM Apply Open File	Receivables	Stores applications between open receivables debit and credit documents.
`RM30201`RM Apply History File	Receivables	Stores historical receivables document application detail.
`PM00201`Vendor Master Summary	Payables	Stores vendor summary balances, period activity, payment, and purchasing totals.
`PM20100`PM Apply To Open File	Payables	Stores applications between open payables debit and credit documents.
`PM30300`PM Apply To History File	Payables	Stores historical payables document application detail.
`SOP10102`Sales Payment Work and History	Sales order processing	Stores deposits and payments associated with sales documents.
`IV10200`Purchase Receipts Work	Inventory costing	Stores inventory purchase-receipt layers used for costing and quantity tracking.
`IV10201`Purchase Receipts Detail	Inventory costing	Stores detailed quantity and cost consumption against inventory receipt layers.
`IV30200`Transaction History	Inventory	Stores historical inventory transaction header and document information.
`IV40700`Site Setup	Inventory	Stores site and location master setup used for inventory quantities and transactions.
`POP10300`Purchasing Receipt Work	Purchasing	Stores unposted shipment and invoice receipt headers.
`POP10310`Purchasing Receipt Line	Purchasing	Stores unposted purchasing receipt line quantities, costs, and purchase-order references.
`POP10500`Purchasing Receipt Line Quantities	Purchasing	Tracks received, invoiced, returned, and remaining quantities for purchase-order lines.
`FA00100`Asset General Information Master	Fixed assets	Stores fixed-asset master descriptions, classes, locations, ownership, and acquisition data.
`FA00200`Asset Book Master	Fixed assets	Stores asset depreciation-book setup, methods, lives, costs, and accumulated depreciation.
`UPR00100`Employee Master	Payroll	Stores payroll employee master, status, department, position, tax, and payment setup.
`UPR30100`Employee Summary	Payroll	Stores payroll employee period and year-to-date earnings, deductions, and tax summaries.
`UPR30300`Payroll Transaction History	Payroll	Stores historical payroll transaction detail for earnings, deductions, benefits, and taxes.
`FA00902`Financial Detail Master	Fixed assets	Stores detailed fixed-asset financial transactions by asset, book, period, and transaction type.
`MC40000`Multicurrency Setup	Multicurrency	Stores company multicurrency settings, functional currency, rate behavior, and defaults.
`TX00101`Tax Schedule Master	Tax	Stores sales and purchasing tax schedule definitions.
`TX00201`Tax Schedule Detail	Tax	Links tax details to tax schedules and controls calculation order.
`SY01500`Company Master	System database	Stores registered company databases and company identifiers in the Dynamics system database.
`SY01400`Users Master	System database	Stores Dynamics GP user accounts and user-level system information.
`SY60100`User-Company Access	System database	Stores the companies each Dynamics GP user is authorized to access.
`SY40100`Period Setup	System	Stores fiscal-period dates and open or closed status by series.
`GL00200`Account Segment Master	General ledger	Stores account-segment numbers, descriptions, and segment-level setup used by the chart of accounts.
`GL10002`Transaction Tax Work	General ledger	Stores tax detail associated with unposted general-ledger transactions.
`GL20001`Transaction Tax Open	General ledger	Stores tax detail for posted general-ledger transactions in open fiscal years.
`GL30001`Transaction Tax History	General ledger	Stores tax detail for posted general-ledger transactions in historical fiscal years.
`RM10101`Cash Receipts Work	Receivables	Stores unposted customer cash receipts and receipt-level payment information.
`RM30301`Receivables Distribution History	Receivables	Stores historical general-ledger distributions created by receivables transactions.
`RM40101`Receivables Management Setup	Receivables	Stores company-wide receivables settings, defaults, numbering, aging, and history options.
`PM10000`Payables Transaction Work	Payables	Stores unposted vendor invoices, finance charges, miscellaneous charges, and credit documents.
`PM10100`Payables Distribution Work	Payables	Stores general-ledger distribution lines for unposted payables transactions.
`PM10200`Payables Apply Work	Payables	Stores temporary applications between payables documents before posting.
`PM30500`Payables Distribution History	Payables	Stores historical general-ledger distributions created by payables documents.
`PM40100`Payables Management Setup	Payables	Stores company-wide payables settings, numbering, aging, history, and payment defaults.
`SOP10101`Sales Commissions Work and History	Sales order processing	Stores salesperson commission detail associated with sales documents.
`SOP10201`Sales Serial and Lot Work and History	Sales order processing	Stores serial-number and lot-number assignments for sales document lines.
`SOP10202`Sales Kit Work and History	Sales order processing	Stores kit-component quantities and detail for sales documents containing kit items.
`IV10000`Inventory Transaction Work	Inventory	Stores unposted inventory adjustment, transfer, variance, and transaction headers.
`IV10001`Inventory Transaction Amounts Work	Inventory	Stores unposted inventory transaction line quantities, costs, sites, and document detail.
`IV00104`Item Kit Master	Inventory	Stores kit-component relationships, quantities, and sequencing for inventory kit items.
`IV00106`Item Purchasing Options	Inventory	Stores item purchasing controls, tolerance, receipt, and vendor-related defaults.
`UPR00300`Payroll Pay Code Master	Payroll	Stores employee pay-code definitions, rates, units, tax treatment, and posting setup.
`UPR00400`Payroll Deduction Master	Payroll	Stores employee deduction codes, calculation methods, limits, and account distributions.
`UPR00500`Payroll Benefit Master	Payroll	Stores employee benefit codes, employer calculations, limits, and posting distributions.
`WF00100`Workflow Setup	Workflow	Stores company workflow, web-service, and SMTP email configuration.
`WF00104`Workflow User Security	Workflow	Stores workflow names and the user accounts associated with workflow setup changes.
`WF100001`Workflow Type Table	Workflow	Stores the workflow types available for configuration in the installed Dynamics GP version.
`WF100002`Workflow Master	Workflow	Stores workflow definitions, activation status, descriptions, and workflow-level settings.
`WF100003`Workflow Step Table	Workflow	Stores workflow-step definitions, assigned approvers, conditions, timing, and escalation setup.
`WF30100`Workflow History	Workflow	Stores workflow actions such as submissions, approvals, rejections, recalls, and delegations.
`WF40200`Workflow Users	Workflow	Stores directory identities, names, aliases, domains, and login details for workflow users.
`WF40201`Workflow Roles	Workflow	Stores the approver, originator, manager, and other roles available to workflow types.
`WF40202`Workflow Template Fields	Workflow	Stores fields available for workflow email-notification templates.
`WF40300`Workflow Calendar	Workflow	Stores working-day definitions used to calculate workflow deadlines and escalation dates.
`WF40310`Workflow Calendar Down Days	Workflow	Stores holidays and nonworking dates excluded from workflow due-date calculations.
`WF40400`Workflow Email Notifications	Workflow	Stores workflow email-notification definitions and delivery settings.
`WF40500`Workflow User Delegation Master	Workflow	Stores workflow delegation headers, delegates, effective dates, and delegation status.
`WF40510`Workflow User Delegation Line	Workflow	Stores workflow types and detail covered by a user delegation.
`WFI10002`Workflow Instance Master	Workflow	Stores each submitted workflow instance, document reference, originator, and overall status.
`WFI10003`Workflow Step Instance	Workflow	Stores runtime workflow-step assignments, approvers, and step status for submitted documents.
`WFI10004`Workflow Tasks	Workflow	Stores actionable workflow tasks, assignees, due dates, and instance references.
`WFI10005`Workflow Step Instance Users	Workflow	Stores users associated with runtime workflow-step instances and approval assignments.

Representative reference only. Confirm the exact schema, version, installed modules, extensions, and company or legal-entity context before building a report, integration, or migration. Never write directly to production ERP tables without a supported design.

Microsoft Dynamics GP resource descriptions

Business Central

Dynamics 365 Business Central

Standard application table objects commonly used in finance, sales, purchasing, inventory, reporting, and extension work.

Frequently asked questions

Select a question to view the answer.

What type of organization is Business Central built for?

Business Central is typically a strong fit for small and midsize organizations that need connected finance, sales, purchasing, inventory, projects, service, or manufacturing without the operating complexity of a larger enterprise platform.

Is moving from GP to Business Central an upgrade?

It is a migration and operating-model change, not an in-place upgrade. Data, processes, reports, security, integrations, and customizations must be evaluated and deliberately redesigned for the cloud platform.

Can Business Central be customized?

Yes. Business Central uses AL extensions, AppSource solutions, APIs, Power Platform, and Azure services. The goal is to extend the product without modifying the base application in ways that make future updates difficult.

How long does a Business Central implementation take?

A focused implementation can move quickly, but timing depends on entities, modules, data quality, integrations, reporting, customization, testing, and user readiness. A discovery phase is the only credible way to set the schedule.

Can Business Central connect to payroll, banking, CRM, and other systems?

Yes. Supported options include standard APIs, custom API pages, web services, Power Automate, Dataverse, Azure integration services, and partner applications. The integration design should protect performance, security, and upgradeability.

Table	Area	What it is used for
`15`G/L Account	General ledger	Stores the chart of accounts and account-level posting and reporting settings.
`17`G/L Entry	General ledger	Stores posted general-ledger entries created by journals and subledger posting.
`18`Customer	Sales and receivables	Stores customer master data, posting groups, terms, contacts, and sales settings.
`21`Cust. Ledger Entry	Sales and receivables	Stores posted customer invoices, payments, credits, and remaining balances.
`23`Vendor	Purchasing and payables	Stores vendor master data, payment settings, posting groups, and contacts.
`25`Vendor Ledger Entry	Purchasing and payables	Stores posted vendor invoices, payments, credits, and remaining balances.
`27`Item	Inventory	Stores item master data, costing methods, replenishment, and inventory settings.
`32`Item Ledger Entry	Inventory	Stores posted inventory movements by item, location, quantity, and entry type.
`36`Sales Header	Sales	Stores unposted sales quote, order, invoice, return, and credit memo headers.
`37`Sales Line	Sales	Stores the lines associated with unposted sales documents.
`38`Purchase Header	Purchasing	Stores unposted purchase quote, order, invoice, return, and credit memo headers.
`39`Purchase Line	Purchasing	Stores the lines associated with unposted purchase documents.
`81`Gen. Journal Line	Journals	Stores unposted general, cash receipt, payment, recurring, and other journal lines.
`112`Sales Invoice Header	Posted sales	Stores posted sales invoice header information.
`113`Sales Invoice Line	Posted sales	Stores posted sales invoice line detail.
`122`Purch. Inv. Header	Posted purchasing	Stores posted purchase invoice header information.
`123`Purch. Inv. Line	Posted purchasing	Stores posted purchase invoice line detail.
`480`Dimension Set Entry	Dimensions	Stores the dimension-value combinations referenced by posted and unposted records.
`14`Location	Inventory	Stores warehouse and inventory-location setup, addresses, and handling rules.
`98`General Ledger Setup	General ledger	Stores company-wide general-ledger, posting, rounding, and reporting configuration.
`110`Sales Shipment Header	Posted sales	Stores posted sales shipment header information.
`111`Sales Shipment Line	Posted sales	Stores posted sales shipment quantities, items, locations, and source-order detail.
`120`Purch. Rcpt. Header	Posted purchasing	Stores posted purchase receipt header information.
`121`Purch. Rcpt. Line	Posted purchasing	Stores posted purchase receipt line quantities, items, locations, and source-order detail.
`349`Dimension Value	Dimensions	Stores the values available for each financial or analytical dimension.
`352`Default Dimension	Dimensions	Stores default and required dimension rules for master records and other sources.
`379`Detailed Cust. Ledg. Entry	Sales and receivables	Stores detailed customer applications, discounts, adjustments, and realized gains or losses.
`380`Detailed Vendor Ledg. Entry	Purchasing and payables	Stores detailed vendor applications, discounts, adjustments, and realized gains or losses.
`5802`Value Entry	Inventory costing	Stores the financial value, cost adjustments, and posting detail associated with inventory entries.
`5600`Fixed Asset	Fixed assets	Stores fixed-asset master data, classifications, responsible employees, and posting setup.
`2`Company Information	Company setup	Stores company identity, address, bank, registration, communication, and logo information.
`3`Payment Terms	Sales and purchasing	Stores due-date calculations, discount dates, and payment discount percentages.
`4`Currency	Currencies	Stores currency codes, rounding rules, realized gains or losses accounts, and reporting settings.
`10`Shipment Method	Sales and purchasing	Stores delivery and shipment-method codes used on customers, vendors, and documents.
`13`Salesperson/Purchaser	Sales and purchasing	Stores salesperson and purchaser codes used for ownership, commissions, and analysis.
`45`G/L Register	General ledger	Stores posting-register ranges that connect posted G/L entries to their source posting run.
`46`Item Register	Inventory	Stores posting-register ranges for item, value, and related inventory entries.
`254`VAT Entry	Tax	Stores posted VAT and sales-tax base, amount, document, and reporting detail.
`270`Bank Account	Cash management	Stores bank-account master data, currency, posting groups, and reconciliation settings.
`271`Bank Account Ledger Entry	Cash management	Stores posted bank-account receipts, payments, transfers, fees, and adjustments.
`287`Customer Bank Account	Sales and receivables	Stores customer bank-account details used for collections and electronic payments.
`288`Vendor Bank Account	Purchasing and payables	Stores vendor bank-account details used for electronic payments.
`308`No. Series	System setup	Stores numbering-series definitions used to assign document and master-record numbers.
`309`No. Series Line	System setup	Stores date-effective starting, ending, warning, and increment values for number series.
`330`Currency Exchange Rate	Currencies	Stores date-effective exchange rates and adjustment exchange rates by currency.
`337`Reservation Entry	Inventory	Stores reservations, order tracking, serial, lot, and supply-demand links.
`339`Item Application Entry	Inventory costing	Links outbound item ledger entries to the inbound entries whose cost they consume.
`5050`Contact	Relationship management	Stores company and person contacts, communication details, and profile information.
`5200`Employee	Human resources	Stores employee master, contact, employment, qualification, and organizational information.
`5405`Production Order	Manufacturing	Stores simulated, planned, firm-planned, and released production-order headers.
`5406`Prod. Order Line	Manufacturing	Stores production-order output items, quantities, dates, locations, and status detail.
`5407`Prod. Order Component	Manufacturing	Stores production-order material requirements, expected quantities, and consumption detail.
`5409`Prod. Order Routing Line	Manufacturing	Stores production-order operations, work centers, run times, and scheduling detail.
`5740`Transfer Header	Inventory transfers	Stores unposted inventory transfer-order headers between locations.
`5741`Transfer Line	Inventory transfers	Stores items, quantities, shipment dates, and receipt dates on transfer orders.
`5900`Service Header	Service management	Stores service quote, order, invoice, and credit memo header information.
`5901`Service Item Line	Service management	Stores service items, faults, response times, and service-order status detail.
`5902`Service Line	Service management	Stores service parts, resources, costs, prices, and billable line detail.
`7316`Warehouse Receipt Header	Warehouse management	Stores warehouse receipt document headers for inbound handling.
`7317`Warehouse Receipt Line	Warehouse management	Stores source documents, items, bins, and quantities on warehouse receipts.
`5`Finance Charge Terms	Sales and receivables	Stores finance-charge calculation rules, interest rates, grace periods, and posting settings.
`6`Customer Price Group	Sales pricing	Stores customer price-group codes used to apply shared sales pricing rules.
`7`Standard Text	Application setup	Stores reusable text codes and descriptions that can be inserted on documents and journals.
`8`Language	Localization	Stores language codes and Windows language identifiers used by the application.
`9`Country/Region	Localization	Stores country and region codes, address formats, and related localization settings.
`44`Sales Comment Line	Sales	Stores comments and notes associated with sales documents and posted sales records.
`47`Sales Header Archive	Sales archive	Stores archived versions of sales quote and order headers for change history and inquiry.
`48`Sales Line Archive	Sales archive	Stores archived versions of sales document lines linked to archived headers.
`50`Accounting Period	General ledger	Stores fiscal-period starting dates, closed status, and fiscal-year boundaries.
`80`Gen. Journal Template	Journals	Stores general-journal template definitions, types, source codes, and numbering settings.
`82`Item Journal Template	Inventory journals	Stores item-journal template definitions for adjustments, transfers, consumption, and output.
`83`Item Journal Line	Inventory journals	Stores unposted inventory, transfer, consumption, output, and revaluation journal lines.
`84`Acc. Schedule Name	Financial reporting	Stores financial-report and account-schedule definitions and default layout settings.
`85`Acc. Schedule Line	Financial reporting	Stores rows, formulas, totaling ranges, and presentation rules for financial reports.
`90`BOM Component	Assembly and manufacturing	Stores component items, resources, quantities, and positions used in bills of material.
`91`User Setup	Administration	Stores user-level posting limits, approval limits, responsibility centers, and application defaults.
`92`Customer Posting Group	Sales and receivables	Maps customer transactions to receivables, payment, interest, discount, and fee accounts.
`93`Vendor Posting Group	Purchasing and payables	Maps vendor transactions to payables, payment, discount, and application accounts.
`94`Inventory Posting Group	Inventory costing	Classifies items for inventory-account posting in combination with locations.
`95`G/L Budget Name	Budgeting	Stores budget definitions, descriptions, dimension selections, and blocked status.
`96`G/L Budget Entry	Budgeting	Stores budget amounts by account, date, business unit, and financial dimensions.
`97`Comment Line	Application setup	Stores comments attached to customers, vendors, items, contacts, and other master records.
`99`Item Vendor	Purchasing	Links items to vendors and stores vendor item numbers, lead times, and purchasing references.
`114`Sales Cr. Memo Header	Posted sales	Stores posted sales credit-memo header information, customer details, dates, and totals.
`115`Sales Cr. Memo Line	Posted sales	Stores posted sales credit-memo line quantities, values, items, accounts, and dimensions.
`124`Purch. Cr. Memo Hdr.	Posted purchasing	Stores posted purchase credit-memo header information, vendor details, dates, and totals.
`125`Purch. Cr. Memo Line	Posted purchasing	Stores posted purchase credit-memo line quantities, costs, items, accounts, and dimensions.
`169`Job Ledger Entry	Projects	Stores posted project usage, sales, costs, quantities, and resource or item activity.
`204`Unit of Measure	Application setup	Stores reusable units of measure and descriptions referenced by items, resources, and documents.
`232`Gen. Journal Batch	Journals	Stores journal batches, balancing accounts, number series, recurring settings, and posting controls.
`242`Source Code Setup	Audit and setup	Maps application processes to source codes used to identify the origin of ledger entries.
`250`Gen. Business Posting Group	Posting setup	Classifies customers and vendors for revenue, expense, tax, and inventory posting combinations.
`251`Gen. Product Posting Group	Posting setup	Classifies items, resources, and accounts for revenue, cost, tax, and inventory posting.
`252`General Posting Setup	Posting setup	Maps business and product posting-group combinations to revenue, cost, discount, and variance accounts.
`272`Check Ledger Entry	Cash management	Stores issued, voided, and financially posted check activity linked to bank accounts.
`273`Bank Acc. Reconciliation	Cash management	Stores bank reconciliation and payment-reconciliation journal headers and statement information.
`274`Bank Acc. Reconciliation Line	Cash management	Stores imported or entered bank statement lines and reconciliation matching results.
`277`Bank Account Posting Group	Cash management	Maps bank accounts to general-ledger accounts used for bank transactions.
`289`Payment Method	Payments	Stores payment-method codes, balancing behavior, direct-debit settings, and payment defaults.
`310`No. Series Line	Application setup	Stores number-series ranges, starting and ending numbers, warning numbers, and effective dates.

Microsoft Business Central table documentation

Finance & Operations

Dynamics 365 Finance & Operations

Core application tables commonly encountered in finance, supply chain, integration, reporting, and migration work.

Frequently asked questions

Select a question to view the answer.

When is Finance & Operations a better fit than Business Central?

Finance & Operations is generally the stronger fit when the business has complex global entities, high transaction volumes, advanced supply chain or manufacturing, sophisticated project operations, detailed controls, or enterprise-scale integration needs.

Can Finance & Operations be implemented in phases?

Yes. Programs can be phased by legal entity, country, module, business unit, or process. The sequence must still protect shared data, financial design, integrations, reporting, security, and the dependencies between workstreams.

How are Finance & Operations customizations handled?

Modern implementations use extensions, configuration, Power Platform, business events, supported integration patterns, and independent deployable packages. Overlayering the Microsoft application is not the cloud model.

What integration options are available?

Common patterns include data entities, OData, recurring integrations, business events, custom services, Dataverse, Power Platform, and Azure integration services. The correct pattern depends on latency, volume, transaction integrity, and ownership.

What usually drives the implementation timeline?

The largest drivers are process scope, countries and legal entities, master-data readiness, integrations, reporting, security, custom requirements, testing cycles, change management, and the availability of business subject-matter experts.

Table	Area	What it is used for
`MainAccount`Main accounts	General ledger	Stores the shared main-account definitions used in charts of accounts.
`GeneralJournalEntry`Posted journal entry header	General ledger	Stores accounting-entry header information for posted subledger and ledger events.
`GeneralJournalAccountEntry`Posted accounting entries	General ledger	Stores the debit and credit accounting lines, ledger dimensions, and amounts for posted entries.
`LedgerJournalTable`Journal batches	General ledger	Stores unposted journal batch headers and journal-level settings.
`LedgerJournalTrans`Journal lines	General ledger	Stores unposted general, payment, customer, vendor, and other journal transactions.
`CustTable`Customers	Accounts receivable	Stores customer master records and company-specific receivables settings.
`CustTrans`Customer transactions	Accounts receivable	Stores posted customer invoices, payments, credits, settlements, and balances.
`VendTable`Vendors	Accounts payable	Stores vendor master records and company-specific payables settings.
`VendTrans`Vendor transactions	Accounts payable	Stores posted vendor invoices, payments, credits, settlements, and balances.
`SalesTable`Sales order headers	Sales	Stores sales-order header information, customer references, status, and delivery terms.
`SalesLine`Sales order lines	Sales	Stores item, quantity, price, delivery, inventory-dimension, and line-status details.
`PurchTable`Purchase order headers	Procurement	Stores purchase-order header information, vendor references, status, and terms.
`PurchLine`Purchase order lines	Procurement	Stores item, quantity, cost, receipt, inventory-dimension, and line-status details.
`InventTable`Released products	Inventory	Stores company-specific released-product and item setup.
`InventTrans`Inventory transactions	Inventory	Stores inventory issue and receipt transactions and their operational status.
`InventDim`Inventory dimensions	Inventory	Stores combinations of site, warehouse, location, batch, serial, color, size, style, and other dimensions.
`DirPartyTable`Global address book parties	Organization	Stores shared organization and person party records used by customers, vendors, workers, and contacts.
`BankAccountTable`Bank accounts	Cash and bank	Stores legal-entity bank-account setup, currency, account identification, and reconciliation settings.
`CompanyInfo`Legal entities	Organization	Stores legal-entity identity, address, registration, and company-level information.
`Ledger`Ledger setup	General ledger	Stores the legal entity ledger, chart of accounts, currencies, calendars, and accounting configuration.
`DimensionAttributeValueCombination`Ledger dimension combinations	Financial dimensions	Stores valid main-account and financial-dimension combinations referenced by accounting records.
`CustInvoiceJour`Customer invoice headers	Accounts receivable	Stores posted sales and free-text customer invoice header information.
`CustInvoiceTrans`Customer invoice lines	Accounts receivable	Stores posted customer invoice line quantities, amounts, items, taxes, and dimensions.
`VendInvoiceJour`Vendor invoice headers	Accounts payable	Stores posted vendor invoice header information, invoice accounts, dates, and totals.
`VendInvoiceTrans`Vendor invoice lines	Accounts payable	Stores posted vendor invoice line quantities, costs, procurement references, and dimensions.
`InventLocation`Warehouses	Inventory	Stores warehouse setup, addresses, inventory parameters, and warehouse-management settings.
`InventSite`Sites	Inventory	Stores operational sites used to group warehouses and inventory planning.
`EcoResProduct`Shared products	Product information	Stores shared product definitions used across legal entities before or after product release.
`ProjTable`Projects	Project management	Stores project master records, project groups, contracts, status, and financial controls.
`HcmWorker`Workers	Human resources	Stores worker identities and employment references connected to people in the global address book.
`LogisticsPostalAddress`Postal addresses	Global address book	Stores date-effective postal addresses shared by parties, locations, and business records.
`LogisticsLocation`Locations	Global address book	Stores reusable physical and electronic location records linked to parties and addresses.
`DimensionAttribute`Financial dimensions	Financial dimensions	Stores financial-dimension definitions and their backing entity or custom-list configuration.
`DimensionAttributeValue`Financial dimension values	Financial dimensions	Stores dimension values used to classify and analyze financial transactions.
`DimensionAttributeValueSet`Default dimension sets	Financial dimensions	Stores reusable sets of default financial-dimension values referenced by source records.
`CustGroup`Customer groups	Accounts receivable	Stores customer-group defaults for posting, terms, tax, and account setup.
`VendGroup`Vendor groups	Accounts payable	Stores vendor-group defaults for posting, terms, tax, and account setup.
`CustSettlement`Customer settlements	Accounts receivable	Stores settlement relationships between customer invoices, payments, credits, and adjustments.
`VendSettlement`Vendor settlements	Accounts payable	Stores settlement relationships between vendor invoices, payments, credits, and adjustments.
`CustPackingSlipJour`Customer packing slip headers	Sales	Stores posted sales packing-slip header information and delivery references.
`CustPackingSlipTrans`Customer packing slip lines	Sales	Stores posted sales packing-slip quantities, items, dimensions, and source-order lines.
`VendPackingSlipJour`Vendor product receipt headers	Procurement	Stores posted vendor product-receipt header information.
`VendPackingSlipTrans`Vendor product receipt lines	Procurement	Stores posted vendor product-receipt quantities, items, dimensions, and purchase-order links.
`SalesQuotationTable`Sales quotation headers	Sales	Stores sales quotation customer, status, expiration, delivery, and commercial terms.
`SalesQuotationLine`Sales quotation lines	Sales	Stores quoted products, quantities, prices, costs, dates, and dimensions.
`InventSum`On-hand inventory summary	Inventory	Stores summarized physical, ordered, reserved, available, and financial quantities by item and dimensions.
`InventItemLocation`Item coverage by warehouse	Inventory planning	Stores item and warehouse planning, replenishment, counting, and operational defaults.
`InventJournalTable`Inventory journal headers	Inventory	Stores movement, adjustment, transfer, counting, BOM, and other inventory journal headers.
`InventJournalTrans`Inventory journal lines	Inventory	Stores item, quantity, cost, dimensions, and offset detail for inventory journal transactions.
`ProdTable`Production orders	Production control	Stores production-order headers, status, item, quantity, dates, and scheduling references.
`ProdBOM`Production order BOM lines	Production control	Stores estimated and actual material requirements for production orders.
`ProdRoute`Production order route operations	Production control	Stores production operations, resources, setup, run time, and scheduling values.
`BOMTable`Bills of materials	Product information	Stores BOM version headers, validity, approval, site, and quantity configuration.
`BOM`Bill of materials lines	Product information	Stores BOM component items, quantities, units, dimensions, and line types.
`WHSWorkTable`Warehouse work headers	Warehouse management	Stores warehouse work orders for picks, puts, replenishment, movement, and counting.
`WHSWorkLine`Warehouse work lines	Warehouse management	Stores warehouse work steps, locations, items, dimensions, quantities, and execution status.
`WHSLoadTable`Loads	Transportation and warehouse	Stores outbound and inbound load headers, carriers, equipment, dates, and load status.
`AssetTable`Fixed assets	Fixed assets	Stores fixed-asset master records, groups, locations, responsible workers, and status.
`AssetTrans`Fixed asset transactions	Fixed assets	Stores fixed-asset acquisitions, depreciation, disposals, transfers, and value adjustments.
`TaxTrans`Tax transactions	Tax	Stores calculated and posted sales-tax transactions, bases, amounts, codes, and settlement detail.
`FiscalCalendar`Fiscal calendars	General ledger	Stores shared fiscal-calendar definitions used by ledgers, budgets, and other financial processes.
`FiscalCalendarYear`Fiscal calendar years	General ledger	Stores fiscal years, date ranges, and year-level calendar references.
`FiscalCalendarPeriod`Fiscal calendar periods	General ledger	Stores fiscal-period names, dates, sequence, and period types within a calendar year.
`Currency`Currencies	Currency management	Stores currency codes, names, symbols, rounding rules, and conversion settings.
`ExchangeRateCurrencyPair`Exchange-rate currency pairs	Currency management	Defines the from-and-to currency pairs, rate types, and conversion factors used for exchange rates.
`ExchangeRate`Exchange rates	Currency management	Stores date-effective exchange rates for configured currency pairs and rate types.
`LedgerFiscalCalendarPeriod`Ledger fiscal calendar periods	General ledger	Stores legal-entity period status and module-level opening or closing controls.
`SubledgerJournalEntry`Subledger journal entry headers	General ledger	Stores accounting-event headers created by subledgers before or during transfer to the ledger.
`SubledgerJournalAccountEntry`Subledger journal account entries	General ledger	Stores subledger debit and credit lines, accounting distributions, dimensions, and amounts.
`SubledgerVoucherGeneralJournalEntry`Subledger voucher links	General ledger	Links subledger vouchers and accounting entries to the resulting general-journal entries.
`CustInvoiceTable`Free-text invoice headers	Accounts receivable	Stores unposted free-text customer invoice headers, billing details, dates, and payment terms.
`CustInvoiceLine`Free-text invoice lines	Accounts receivable	Stores free-text invoice descriptions, quantities, prices, ledger accounts, tax, and dimensions.
`CustPaymModeTable`Customer methods of payment	Accounts receivable	Stores customer payment-method rules, formats, posting behavior, fees, and bank settings.
`CustBankAccount`Customer bank accounts	Accounts receivable	Stores customer bank-account identifiers, routing details, currency, and payment information.
`VendInvoiceInfoTable`Pending vendor invoice headers	Accounts payable	Stores imported or entered vendor invoice headers before final posting.
`VendInvoiceInfoLine`Pending vendor invoice lines	Accounts payable	Stores pending vendor invoice quantities, costs, purchase-order matching, taxes, and dimensions.
`VendPaymModeTable`Vendor methods of payment	Accounts payable	Stores vendor payment-method rules, formats, posting behavior, fees, and bank requirements.
`VendBankAccount`Vendor bank accounts	Accounts payable	Stores vendor bank-account identifiers, routing details, currency, and electronic-payment information.
`BankAccountTrans`Bank account transactions	Cash and bank	Stores posted deposits, payments, transfers, fees, and other bank-account activity.
`MarkupTrans`Charges transactions	Sales and procurement	Stores header- and line-level charges, allocation rules, values, currency, and posting references.
`TaxTable`Sales tax codes	Tax	Stores sales-tax code configuration, authorities, settlement periods, calculation, and ledger posting.
`TaxGroupHeading`Sales tax groups	Tax	Stores sales-tax groups assigned to customers, vendors, addresses, and transaction headers.
`TaxItemGroupHeading`Item sales tax groups	Tax	Stores item sales-tax groups assigned to products, categories, and transaction lines.
`SpecTrans`Marked settlement transactions	Settlement	Stores temporary customer, vendor, and other transaction markings selected for settlement.
`DirPerson`People	Global address book	Stores person-specific names, personal details, and party relationships in the global address book.
`DirOrganization`Organizations	Global address book	Stores organization-specific names and classification for companies and other party organizations.
`DirPartyLocation`Party locations	Global address book	Links parties to postal or electronic locations and stores location roles and primary status.
`HcmEmployment`Employment records	Human resources	Stores worker employment relationships, legal entities, start and end dates, and employment status.
`HcmPosition`Positions	Human resources	Stores organizational positions, departments, jobs, availability dates, and position hierarchy references.
`HcmPositionWorkerAssignment`Position worker assignments	Human resources	Stores date-effective assignments of workers to positions and assignment status.
`HcmJob`Jobs	Human resources	Stores shared job definitions, descriptions, classifications, functions, and compensation references.
`InventModelGroup`Item model groups	Inventory costing	Stores costing, physical and financial update, reservation, and inventory-control policies for items.
`InventItemGroup`Item groups	Inventory costing	Stores item financial classifications and inventory posting-profile group references.
`InventTableModule`Item module settings	Product information	Stores sales, purchase, and inventory unit, price, quantity, and order settings for released products.
`InventItemPrice`Item cost and price records	Inventory costing	Stores pending and active item cost prices, cost versions, effective dates, and calculation quantities.
`EcoResProductTranslation`Product translations	Product information	Stores language-specific product names and descriptions for shared products.
`EcoResProductMaster`Product masters	Product information	Stores product masters used to generate variants through configuration dimensions.
`EcoResDistinctProductVariant`Distinct product variants	Product information	Stores individual product variants and their relationship to a product master.
`InventTransferTable`Transfer order headers	Inventory transfers	Stores transfer-order headers, from and to warehouses, status, dates, and shipment settings.
`InventTransferLine`Transfer order lines	Inventory transfers	Stores transfer items, quantities, dimensions, shipment and receipt status, and delivery dates.

Microsoft Finance & Operations data entities overview

Next step

Bring your ERP questions, constraints, and timeline.

Cole Solutions can help you decide what to fix now, what to modernize next, and how to make the business case credible before a major investment is approved.

Email info@colesolutions.net Call 732-800-1161