ACU.OBJECTDEFINITION function
Created by Velixo Team, Modified on Wed, 13 Aug at 7:43 AM by Velixo Team
Applies to
Velixo NX 2025.7 or higher
Acumatica, MYOB Acumatica, Cegid XRP Flex, Haufe X360, Jamis Prime
Introduction
When using the ACU.QUERY function, you may want to know the names and data types of the fields of the object you query.
Syntax
=ACU.OBJECTDEFINITION(ConnectionName, Object)
Parameters
Parameter | Required/Optional | Description |
|---|---|---|
ConnectionName | Required | The name of the connection, as specified in the Connection Manager |
Object | Required | Acumatica Data Access Class (DAC) name. For instance, GLAccount or PMCostProjection. Please use ACU.EXPANDOBJECTRANGE to explore available objects. |
Output
The function returns a spill range of the Acumatica DAC-based object fields and their attributes, sorted alphabetically by ID:
ID - the field name used in ACU.QUERY.
Required - indicates whether the field is required when creating the object.
Type - the field data type.
For example, the formula =ACU.OBJECTDEFINITION("Acumatica","PMCostProjection") returns the following results:
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article