Custom Lists
Data for each custom list in your account is exposed as a table. The name of each table corresponds to the name of the custom list. Each table includes all custom columns and the following additional columns.
|
Table name: any |
||
|---|---|---|
|
Column Name |
Description |
Relates to |
|
date_created |
Date Created (GMT) |
— |
|
last_modified_date |
Last Modified Date (GMT) |
— |
|
is_record_inactive |
Value of the Inactive box. F =the list is active. T =the list is inactive. |
— |
|
list_id |
Unique ID (auto-incremented number) |
— |
|
list_item_name |
This column contains the Name of the list. If translations have been provided for this value, then the column will contain the value translated in to the user's selected locale. |
— |
|
<ListName>_extid |
External ID If a custom list’s name starts with a number or an underscore (_), the column name is N_<ListName>_extid. |
— |
Column names are case insensitive and do not contain spaces. Any spaces in your custom column names will be replaced by underscores in the underlying column names.
Custom column names that contain non-ASCII characters appear without those characters in the SuiteAnalytics Connect schema. If the custom column name contains only non-ASCII characters, the column's field ID is used instead.
Identifying primary and foreign keys in custom lists
To find primary and foreign keys in a custom list, you can use the following query, replacing CUSTOM_LIST_NAME with your custom list name:
select pktable_name, pkcolumn_name, pk_name, fktable_name, fkcolumn_name, fk_name from oa_fkeys where pktable_name = 'CUSTOM_LIST_NAME';
In the query output, the pk_name column contains the primary key name, and the fk_name column shows the foreign key name. For more examples of queries over primary and foreign keys, see oa_fkeys.