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
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 doesn't 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. |