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 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. |