Table name for "tmpsysQuery"?

Finance and Operations/AX Developer Forum
1

Hi All

I am a new developer in AX. Anyone can tell me which is table name for “tmpsysQuery”? I want to get info from this table. However, I can’t find this table in AOT.

I set some setting at General Ledger → Setup → Financial statement → Financial Statement on LedgerBalColumnsDim table.

Best Regards

Bobo

2

hi,

You can find the name and the label of the table when you right click → Properties.

you ll find the Name = TmpSysQuery

Label = Criteria

3

You can find this table from the AOT by Selecting the Data Dictionary → Tables → tmpsysQuery.

4

Hi,

For further info about the table check this link

http://msdn.microsoft.com/en-US/library/aa851990(v=AX.50).aspx

5

Thanks for the reply. Jasmine & Yeswanth.

However, why prompts error “invalid object name ‘TmpSysQuery’. “ when I use SQL Query in SQL Server Management Studio?

I just want to query results from this table.

6

Hi,

‘tmpSysQuery’ is a temporary table. By default, temporary tables do not live in SQL Server.

What are you trying to achieve?

7

Hi Harish

I want to get info from General Ledger → Setup → Financial statement → Financial Statement

->LedgerBalColumnsDim table. Do you tell me which table keep this info?

8883.FS3.JPG
8883.FS3.JPG942×565 95.3 KB