Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[JOHN EBLING]

Can anyone tell me where the field “description” exists in the tables? We are wanting to possibly use this field for some SQL reporting but have been unable to find it anywhere so far. I’ve used the table finder feature and I’m coming up empty.

——————————
JOHN EBLING
Controller
Clipper Distributing Company
Saint Joseph
——————————

[Kerry Hataley]

Hi John,
Here are the tables / fields you need…
OPEN- RM20101 / TRXDSCRN
HISTORY – RM30101 / TRXDSCRN

——————————
Kerry Hataley
CEO & President
Nanook Software, Inc
——————————
——————————————-

[Jo deRuiter]

Hi

Unfortunately, out of the box and with no help there is no real place to find the SQL Column to GP Field relationships or names.

I’ve always used a site called DynDeveloper by the wonderful to help me. 

There’s the free version, but if you subscribe at $10.00 per month it opens up a WORLD of open-source notes and integer values on each table and field that can really assist you in any GP SQL Work, especially if you are just starting out working with GP.

Here is the link.  Again, there’s the free and then there’s the awesomeness of the $10.00 per month. 

http://dyndeveloper.com/DynModule.aspx

Here’s a screenshot of some information you get on the RM Transaction above:

??I don’t work for DynDeveloper, but it is true awesomeness that many in this community help keep up with, making notes on fields etc.

Good luck with your project!

——————————

——————————
——————————————-

[Blair Christensen]

John,

We had to try to find this for putting together ACH files for our bank, and it’s not as simple as it should be.  I suggest looking at Victoria Yudin’s view (https://victoriayudin.com/2010/02/15/sql-view-with-ar-apply-detail/), because the description is actually in the same table, but linked to the original transaction via the Apply Document Number.

——————————
Blair Christensen
Database Administrator
Oppenheimer Companies, Inc.
Boise ID
——————————
——————————————-