Skip to main content
Solved

I understand ther are currently 200 plus screens in Acumatica . How many standard fields are there in Acumatica ?


Forum|alt.badge.img

Overall how many standard fields are there in Acumatica ? Is there a way in the system I could see the number of standard fields for a specific module ?

Best answer by Naveen Boga

@skumar98  I don’t think we have a place to see the standard field count but if you have a database access on your local machine you can run the below query to give the Field count for each table.

Unfortunately, we don’t have a place to see the count of fields but you can Inspect Element and click on the DAC, so that you can see the fields in that particular DAC.

 

SELECT 
    TABLE_NAME, 
    COUNT(*) AS FieldCount
FROM 
    INFORMATION_SCHEMA.COLUMNS
GROUP BY 
    TABLE_NAME
ORDER BY 
    FieldCount DESC;

 

 

 

 

View original
Did this topic help you find an answer to your question?

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3410 replies
  • September 1, 2024

 HI @skumar98 Please create a brand new instance and you can go the site map screen and there you can see the screens for each modules.

In the site map, we can also see the Reports and Generic Inquiry, you can ignore them if required.


Forum|alt.badge.img
  • Author
  • Freshman I
  • 19 replies
  • September 1, 2024

@Naveen Boga Thank you . How many ‘unique standard fields’ are there in Acumatica ? (I am looking for a number) ?


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3410 replies
  • Answer
  • September 2, 2024

@skumar98  I don’t think we have a place to see the standard field count but if you have a database access on your local machine you can run the below query to give the Field count for each table.

Unfortunately, we don’t have a place to see the count of fields but you can Inspect Element and click on the DAC, so that you can see the fields in that particular DAC.

 

SELECT 
    TABLE_NAME, 
    COUNT(*) AS FieldCount
FROM 
    INFORMATION_SCHEMA.COLUMNS
GROUP BY 
    TABLE_NAME
ORDER BY 
    FieldCount DESC;

 

 

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings