SI.OBJECTDEFINITION

Created by Damien Zwillinger, Modified on Wed, 13 Sep, 2023 at 11:30 PM by Damien Zwillinger

Applies to:

Velixo NX
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.

TABLE OF CONTENTS

Syntax
Parameters
Example

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

There are many objects defined within Sage Intacct for which you can retrieve the Object Definition:

For 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.