SI.OBJECTDEFINITION

Created by Damien Zwillinger, Modified on Mon, 3 Mar at 5:01 AM by Grigorii Kosianenko

Applies to

Velixo NX
Sage Intacct

TABLE OF CONTENTS

Introduction
Syntax
Parameters
Output
Example

Introduction

If you look for the object structure and field names, use the SI.OJBECTDEFINITION function.
It returns the set of fields available in the specified Sage Intacct object and their description.

That can be helpful when constructing queries with the SI.QUERY function.

Syntax

=SI.OBJECTDEFINITION(ConnectionName, Object)

Parameters

Parameter

Required/Optional

Description

Connection

Required

The name of the connection, as specified in the Connection Manager

Object

Required

Sage Intacct object name (e.g., GLACCOUNT, INVDOCUMENT).
Use "Object (Subtype)" to retrieve column definitions for a specific subtype.

Example: SI.OBJECTDEFINITION("Sage", "INVDOCUMENT (Adjustment Decrease Value)")

Use the SI.EXPANDOBJECTRANGE function to get the list of Sage Intacct objects.

Output

The function returns a spill range with the set of fields of the specified object. For every field, the function returns its ID, label, description, optionality, editability, data type, valid values (if applicable), and the mark if the field is custom.

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 information into Excel: