oa_tables

This is a system table that contains the table name, table owner, table type and descriptions of all tables available in the SuiteAnalytics Connect schema.

Table name: oa_tables

Column Name

Description

table_qualifier

Name of the table qualifier

table_owner

Name of the table owner

table_name

Name of the table

table_type

Table type (NetSuite table, system table)

table_path

not supported

oa_userdata

Shows several values in 16 positions that describe information such as the feature required to access this data and relevant content about this column that you should consider. To view a detailed description of this column, see oa_userdata in oa_tables.

Note:

This column applies the NetSuite2.com data source only.

oa_support

not supported

remarks

Table description

oa_userdata in oa_tables

Note:

This column applies the NetSuite2.com data source only.

Position

Valid Values

Value Description

1

C or S

C means that this is a custom table.

S means that this is a standard table.

2

V or H

V means that this is a visible table.

H means that this is a hidden table.

3

M or hyphen (-)

M means that this table contains the Last Modified Date column.

A hyphen (-) means that this table does not contain the Last Modified Date column.

4

Not applicable

D means that the hard delete option is available for this table.

A hyphen (-) means that the hard delete option is not available for this table.

5-16

Not applicable

Not applicable

17

pipe (|)

The pipe (|) symbol is used as a delimiter between values.

18

Name of a NetSuite feature

Shows the feature required for accessing this table data.

Related Topics

Connect Data Source
Connect Schema
NetSuite2.com Data Source
Querying Data with Connect

General Notices