ODBC Driver for NetSuite

Build 24.0.9062

GetExtraTableInfo

Returns additional information about the listed tables beyond what may be obtained using the standard methods.

Result Set Columns

Name Type Description
CatalogName String The database containing the table.
SchemaName String The schema containing the table.
TableName String The name of the table.
TableType String The table type.
Description String A description of the table.
IsHidden Boolean If the table is hidden or not.
InternalId String The internalid of the table if this is a custom table.
ScriptId String The scriptid of the table if this is a custom table.
IsCustomTable Boolean A boolean indicating if this is a custom table.
SchemaFile String The xsd schema file the entity for the table is defined under.
NamespaceURI String The namespace for the table used when constructing SOAP messages.
SearchType String The search type used for the table used during SELECT statements.
SearchName String The name of the search used for the table during SELECT statements.
ListName String The name of the list this table represents. Only given a value if this table is a child table.
SubType String The subtype of object, used when describing item types.
CostingMethod String The costing method(s) avaialble. Used when describing a type of item type.
JoinColumnNames String Available columns that may be joined on.
JoinColumnTypes String Available types that may be joined on (correlated with the JoinColumnNames).
JoinCriteriaNames String Available criteria names that may be joined on.
JoinCriteriaTypes String Avaialble criteria types that may be joined on (correlated with the JoinCriteriaNames).
SupportsGetDeleted Boolean A boolean indicating if this table supports GetDeleted.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062