JDBC Driver for NetSuite

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462