MOO_ROLLUP_ENTITIES
Extensible one-to-one relationship table used to store custom object rollup records.
Details
-
Schema: FUSION
-
Object owner: MOO
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MOO_ROLLUP_ENTITIES_PK |
ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ID | NUMBER | 18 | Yes | Unique identifier of the intersection row in this table. | |
| PARENT_ID1 | VARCHAR2 | 100 | Yes | Source entity identifier's first value.This will store the foreign key from the parent object. | |
| PARENT_ID2 | VARCHAR2 | 100 | Source entity identifier's second value.This will store the foreign key from the parent object. | ||
| PARENT_ID3 | VARCHAR2 | 100 | Source entity identifier's third value.This will store the foreign key from the parent object. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Yes | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CONFLICT_ID | NUMBER | 18 | Yes | Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). | |
| CPDRF_VER_SOR | NUMBER | 9 | Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version in System of Record (SOR) pillar when a record change is replicated to subscribing pillars by the replication flows. | ||
| CPDRF_VER_PILLAR | NUMBER | 9 | Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version when a record is changed by replication flows. | ||
| CPDRF_LAST_UPD | VARCHAR2 | 15 | Cross Pillar Data Replication Framework (CPDRF) system column for tracking source pillar name when a record is changed by the replication flows. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | The currency code for all currency amounts entered on this record. | ||
| CURCY_CONV_RATE_TYPE | VARCHAR2 | 30 | The currency conversion rate type defined as the standard rate type at the time the row is created. Used to calculate currency conversion rates between the entered currency and the corporate currency. | ||
| CORP_CURRENCY_CODE | VARCHAR2 | 20 | The corporate currency code defined as the standard front office reporting currency at the time the row is created. Currency conversion rates will be calculated between the entered currency and the corporate currency. | ||
| RECORD_NAME | VARCHAR2 | 80 | Record name: user recognizable identifier for this record. Uniquely identifies this record among others with the same structure definition (ATTRIBUTE_CATEGORY). | ||
| RECORD_NUMBER | VARCHAR2 | 64 | Yes | Record number: public unique identifier for this record. | |
| EXTN_ATTRIBUTE_TIMESTAMP001 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP002 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP003 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER001 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER002 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER003 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER004 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER005 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER006 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER007 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER008 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP004 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP005 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP006 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER009 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER010 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER011 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER012 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER013 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER014 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER015 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER016 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP007 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP008 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP009 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER017 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER018 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER019 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER020 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER021 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER022 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER023 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER024 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP010 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP011 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP012 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER025 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER026 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER027 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER028 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER029 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER030 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER031 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER032 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP013 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP014 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP015 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER033 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER034 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER035 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER036 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER037 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER038 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER039 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER040 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP016 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP017 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP018 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER041 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER042 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER043 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER044 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER045 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER046 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER047 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER048 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP019 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP020 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP021 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER049 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER050 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER051 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER052 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER053 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER054 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER055 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER056 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP022 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP023 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP024 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER057 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER058 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER059 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER060 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER061 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER062 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER063 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER064 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP025 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP026 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP027 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER065 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER066 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER067 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER068 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER069 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER070 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER071 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER072 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER073 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER074 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER075 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER076 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER077 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER078 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER079 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER080 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP028 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP029 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP030 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP031 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP032 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP033 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER081 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER082 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER083 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER084 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER085 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER086 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER087 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER088 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP034 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP035 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP036 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER089 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER090 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER091 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER092 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER093 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER094 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER095 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER096 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP037 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP038 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP039 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER097 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER098 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER099 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_NUMBER100 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
| EXTN_ATTRIBUTE_TIMESTAMP040 | TIMESTAMP | Runtime Extensibility: Column reserved for custom extension attributes. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MOO_ROLLUP_ENTITIES_N1 | Non Unique | Default | ATTRIBUTE_CATEGORY, PARENT_ID1 |
| MOO_ROLLUP_ENTITIES_N3 | Non Unique | Default | ATTRIBUTE_CATEGORY, CONFLICT_ID |
| MOO_ROLLUP_ENTITIES_N4 | Non Unique | Default | RECORD_NAME |
| MOO_ROLLUP_ENTITIES_N5 | Non Unique | Default | UPPER("RECORD_NAME") |
| MOO_ROLLUP_ENTITIES_N6 | Non Unique | Default | ATTRIBUTE_CATEGORY, TO_NUMBER("PARENT_ID1") |
| MOO_ROLLUP_ENTITIES_N2 | Non Unique | Default | ATTRIBUTE_CATEGORY, RECORD_NAME, CONFLICT_ID |
| MOO_ROLLUP_ENTITIES_PK | Unique | Default | ID |
| MOO_ROLLUP_ENTITIES_U1 | Unique | Default | PARENT_ID1, ATTRIBUTE_CATEGORY |
| MOO_ROLLUP_ENTITIES_U2 | Unique | Default | RECORD_NUMBER |
| MOO_ROLLUP_ENTITIES_X01 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER001 |
| MOO_ROLLUP_ENTITIES_X02 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER002 |
| MOO_ROLLUP_ENTITIES_X03 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER003 |
| MOO_ROLLUP_ENTITIES_X04 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER004 |
| MOO_ROLLUP_ENTITIES_X05 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER005 |
| MOO_ROLLUP_ENTITIES_X06 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER006 |
| MOO_ROLLUP_ENTITIES_X07 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER007 |
| MOO_ROLLUP_ENTITIES_X08 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER008 |
| MOO_ROLLUP_ENTITIES_X09 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER009 |
| MOO_ROLLUP_ENTITIES_X10 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER010 |
| MOO_ROLLUP_ENTITIES_X11 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER011 |
| MOO_ROLLUP_ENTITIES_X12 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER012 |
| MOO_ROLLUP_ENTITIES_X13 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER013 |
| MOO_ROLLUP_ENTITIES_X14 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER014 |
| MOO_ROLLUP_ENTITIES_X15 | Non Unique | Default | ATTRIBUTE_CATEGORY, EXTN_ATTRIBUTE_NUMBER015 |