GetExtraColumnInfo
Returns additional information about the listed columns beyond what may be obtained using the standard methods.
Input
| Name | Type | Description |
| TableName | String | The name of the table to return column information about. |
Result Set Columns
| Name | Type | Description |
| CatalogName | String | The name of the database containing the table. |
| SchemaName | String | The schema containing the table. |
| TableName | String | The name of the table containing the column. |
| ColumnName | String | The column name. |
| DataTypeName | String | The data type name. |
| DataType | Integer | An integer indicating the data type. This value is determined at run time based on the environment. |
| Length | Integer | The length in characters of the column or the numeric precision. |
| NumericPrecision | Integer | The maximum number of digits in numeric data. The column length in characters for character and date-time data. |
| NumericScale | Integer | The column scale or number of digits to the right of the decimal point. |
| IsNullable | Boolean | Whether the column can contain null. |
| Description | String | A brief description of the column. |
| Ordinal | Integer | The sequence number of the column. |
| IsAutoIncrement | String | Whether the column value is assigned in fixed increments. |
| IsGeneratedColumn | String | Whether the column is generated. |
| IsReadOnly | Boolean | Whether the column is read-only. |
| IsKey | Boolean | Whether the column is a primary key. |
| IsHidden | Boolean | Whether the column is hidden. |
| InternalColumnName | String | The internal column name used for making API requests, which may differ from the displayed name. |
| InternalType | String | The internal type of this column used for communications with NetSuite. |
| IsCustom | Boolean | Boolean indicating if this is a custom column. |
| CustomFieldListName | String | The custom field list this column is a part of if it is a customfield. |
| SearchColumn | String | The name of the column used during a select. |
| SelectType | String | The type for this column used during a select. |
| InternalId | String | The internalid of this column if it is a custom field. |
| ScriptId | String | The scriptid of this column if it is a custom field. |
| CriteriaType | String | The criteria type of this column used during a search. |
| Values | String | Available values for this column if it is an enumeration type. |
| CriteriaColumnName | String | The name of the column used in the criteria during a search. |
| MaxOccurrance | String | Maximum number of occurrances for this field. |
| IsList | Boolean | A boolean indicating if this column represents a list. |
| ChildTable | String | If this column represents a list and is on a parent table, indicates what child table the flattend values may be found under. |