AggregateColumnMode
Specifies how aggregate columns, which consolidate data from child collections, are handled. This property applies only when Schema is set to SuiteTalk.
Possible Values
Ignore, List, ListAndRetrieveData Type
string
Default Value
"Ignore"
Remarks
Aggregate columns consolidate all data from child collections into the base table, which can lead to significant size and complexity. This property determines how these columns are handled, balancing usability with performance.
In scenarios like writing data to an offline database, consider setting this property to Ignore or List. Child data remains accessible through child tables if IncludeChildTables is set to true.
Setting AggregateColumnMode to List still allows aggregate columns to be included in INSERT and UPDATE operations.
This property applies only when Schema is set to SuiteTalk.
| Value | Description |
| Ignore | Aggregate columns are ignored entirely and do not appear in the table schema. |
| List | Aggregate columns are included in the schema for all tables. However, on base tables such as SalesOrders, these columns do not return data from NetSuite. |
| ListAndRetrieve | Aggregate columns are included in the schema and return data when queried, for all applicable tables. |