GetExtraColumnInfo
Provides detailed metadata about specific table columns, including properties not available through standard queries.
Input
| Name | Type | Description |
| TableName | String | Specifies the table for which detailed column information should be retrieved. |
Result Set Columns
| Name | Type | Description |
| CatalogName | String | Displays the name of the database that contains the specified table. |
| SchemaName | String | Indicates the schema where the specified table is located. |
| TableName | String | Returns the name of the table that contains the listed columns. |
| ColumnName | String | Provides the name of the column being described. |
| DataTypeName | String | Shows the descriptive name of the column's data type. |
| DataType | Integer | Returns an integer representing the column's data type, determined at run time based on the environment. |
| Length | Integer | Displays the column length for character data or numeric precision for numeric data. |
| NumericPrecision | Integer | Specifies the maximum number of digits for numeric data or character length for text and date-time columns. |
| NumericScale | Integer | Indicates the number of digits to the right of the decimal point for numeric columns. |
| IsNullable | Boolean | Shows whether the column allows null values. |
| Description | String | Provides a detailed description of the column's purpose or content. |
| Ordinal | Integer | Displays the position of the column within the table. |
| IsAutoIncrement | String | Indicates whether the column's value automatically increases with each new record. |
| IsGeneratedColumn | String | Specifies whether the column's value is generated automatically, such as a computed column. |
| IsReadOnly | Boolean | Indicates whether the column value cannot be modified. |
| IsKey | Boolean | Shows if the column is a primary key for uniquely identifying records. |
| IsHidden | Boolean | Specifies whether the column is hidden from standard views. |
| InternalColumnName | String | Displays the internal name used for API requests, which may differ from the column's display name. |
| InternalType | String | Indicates the internal data type of the column used in NetSuite communications. |
| IsCustom | Boolean | Indicates whether this column is a custom field defined in NetSuite. |
| CustomFieldListName | String | Provides the name of the custom field list that includes this column, if applicable. |
| SearchColumn | String | Displays the column name used when performing search operations. |
| SelectType | String | Shows the data type expected when the column is used in a SELECT statement. |
| InternalId | String | Returns the internal identifier for the column, used for custom fields. |
| ScriptId | String | Displays the script identifier for the column, relevant for custom fields. |
| CriteriaType | String | Specifies the data type or format expected when using the column in search criteria. |
| Values | String | Lists the possible values for enumeration-type columns, separated by commas with a space after each comma. |
| CriteriaColumnName | String | Provides the column name used to apply search filters or criteria. |
| MaxOccurrance | String | Indicates the maximum number of times this field can appear. |
| IsList | Boolean | Shows if the column represents a list of values rather than a single value. |
| ChildTable | String | Identifies the child table that stores the expanded list values if the column represents a list on a parent table. |