Looking for table names 1

[dfeller]

I'm looking for the table names for G/L, A/R, and A/P detailed transactions.

I believe G/L is GL20000.

Dawn

 

[winthropdc]

You can use the Tools >> Resource Descriptions >> Tables option to find information about tables.

The main tables for posted and history are as follows:

GL_YTD_TRX_OPEN (GL20000)
GL_Account_TRX_HIST (GL30000)
RM_OPEN (RM20101)
RM_HISTORY (RM30101)
PM_Transaction_OPEN (PM20000)
PM_Paid_Transaction_HIST (PM30200)

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)

http://www.microsoft.com/Dynamics

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.