Skip to main content
Answer

Acumatica Data Field Names

  • December 7, 2022
  • 3 replies
  • 857 views

Forum|alt.badge.img

Is there a place I can go to see all the field names for a given entity (ie: StockItems).

My reason is that I have some sync processes that download StockItems via the rest API. However, the properties/field names that the rest API returns are different than what I see in a Generic Inquiry. 

For instance, in the rest API, the field name for Description is “Description”. In the GI, its called DESC.

 

I was hoping there was some sort of way I can see how those mappings work. I am porting some of these REST Api calls over to oData and am unsure what the fields are called in the Generic Inquiry UI screen.

 

Thanks!

 

Eric

Best answer by eelliston

I think I found it by using the DAC Schema browser. Not exactly sure how the Rest API properties are defined, but this schema browser gets me going in the right direction.

3 replies

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • Answer
  • December 7, 2022

I think I found it by using the DAC Schema browser. Not exactly sure how the Rest API properties are defined, but this schema browser gets me going in the right direction.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • December 8, 2022

@eelliston  Just FYI, as you are working with REST API, below is best place to look at the fields.

 

 


Forum|alt.badge.img
  • Jr Varsity III
  • June 12, 2024

I think I found it by using the DAC Schema browser. Not exactly sure how the Rest API properties are defined, but this schema browser gets me going in the right direction.

I just want to add that using the DAC Schema browser is a great way to help find the name of a Table associated with the form as well.