Applies to
⚠️ Velixo NX only
ERP: Sage Intacct
The SI.OJBECTDEFINITION function returns the set of columns available in the specified Sage Intacct object. That information can then be used when constructing queries - for example with the SI.QUERY function.
Syntax
SI.OBJECTDEFINITION(Connection, Object)
Parameters
The SI. OBJECTDEFINITION function uses the following parameters:
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Object | Required | The name of the Sage Intacct object |
Example
Here is the list of fields from the Sage Intacct GLACCOUNT object:
The SI.OBJECTDEFINTION function can be used to bring that same information into Excel:
Note: The SI.OBJECTDEFINITION function returns data that can be convenient to have when constructing a SI.QUERY function.