web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Table names and fields...

Finance | Project Operations, Human Resources, ...

Unanswered

Table names and fields in D365

(0) Share

Report

Report

Posted on by villica

82

Hello

We are in the process of migrating to D365 and have a few ssis packages that references tables from AX2009. As there no easy way to get access to the AOT, is there an easier way to find the new table names in d365 and the available fields

for Example

LedgerJournalTable

LedgerJournalTrans

LEDGERBUDGET
LEDGERBALANCES
LEDGERPERIOD
LEDGERTABLE
ASSETBOOK
ASSETTRANS
ASSETTABLE
LEDGERTRANS

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Martin Dráb 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Regarding LedgerTrans,you can find some information about the changed data model in documents about upgrade to AX 2012 (because the changed happened already at that time). For instance:

What's new: Ledger and subledger lines and distributions

Mapping the LedgerTrans table to General Journal Tables (White paper).

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 659

#2

André Arnaud de Cal... 465 Super User 2026 Season 1

#3

Syed Haris Shah 304 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans