HZ_ACCOUNT_ROLLUPS
The HZ_ACCOUNT_ROLLUPS table stores information Rollup Metrics data.
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ORGANIZATION_PROFILE_ID | NUMBER | 18 | Yes | An identifier for the organization profiles used as a foreign key to the HZ_ORGANIZATION_PROFILES table. | |
HIER_CURR_FY_POTENTIAL_REVENUE | NUMBER | The cumulative total of all of the current fiscal year's potential revenue within an account hierarchy. | |||
HIER_EMPLOYEES_TOTAL | NUMBER | The count of employees, based on the account number of the employees for each account hierarchy. | |||
OPEN_OPTY_REVENUE_AMT | NUMBER | The cumulative total of open opportunity potential revenue amount for the account. | |||
HIER_OPEN_OPTY_REVENUE_AMT | NUMBER | The cumulative total of open opportunity potential revenue amount within the account hierarchy. | |||
WON_OPTY_REVENUE_AMT | NUMBER | The cumulative total of won opportunity potential revenue amount for the account. | |||
HIER_WON_OPTY_REVENUE_AMT | NUMBER | The cumulative total of potential revenue amount from won opportunities, within the account hierarchy. | |||
NUM_OF_OPEN_OPTY | NUMBER | The count of open opportunities within an account. | |||
HIER_NUM_OF_OPEN_OPTY | NUMBER | Count of opportunities that are open within an account hierarchy. | |||
OPEN_ORDER_AMT | NUMBER | Cumulative total of quote and order amount for the account where status is Open or Processing. | |||
HIER_OPEN_ORDER_AMT | NUMBER | Cumulative total of quote and order amount within the account hierarchy, where status is Open or Processing. | |||
WON_ORDER_AMT | NUMBER | The cumulative total of the order amount for the account where status is Closed. | |||
HIER_WON_ORDER_AMT | NUMBER | Total of orders within an account hierarchy, where the status is Closed. | |||
NUM_OF_OPEN_SR | NUMBER | The number of open service requests for the account. | |||
HIER_NUM_OF_OPEN_SR | NUMBER | The number of open service requests for the account hierarchy. | |||
NUM_OF_OPEN_CRITICAL_SR | NUMBER | The number of open service requests for the account that have a severity equal to one. | |||
HIER_NUM_OF_OPEN_CRITICAL_SR | NUMBER | The number of open service requests within an account hierarchy, where the severity is one. | |||
NUM_OF_OPEN_LEAD | NUMBER | Count of leads that are open on the account. | |||
HIER_NUM_OF_OPEN_LEAD | NUMBER | Count of leads that are in Open status within an account hierarchy. | |||
NUM_OF_OPEN_HOT_LEAD | NUMBER | Count of leads that are open and are ranked Hot. | |||
HIER_NUM_OF_OPEN_HOT_LEAD | NUMBER | Count of leads that are open and are ranked Hot within an account hierarchy. | |||
NUM_OF_OPEN_ACTY | NUMBER | Count of activities that are open within an account. | |||
HIER_NUM_OF_OPEN_ACTY | NUMBER | Count of activities that are open within an account hierarchy. | |||
NUM_OF_CALL_MADE | NUMBER | Number of calls made to an account. | |||
HIER_NUM_OF_CALL_MADE | NUMBER | Number of calls made to an account and its hierarchy. | |||
NUM_OF_EMAIL_SENT | NUMBER | Total number of emails sent to an account. | |||
HIER_NUM_OF_EMAIL_SENT | NUMBER | Total number of emails sent to an account and its hierarchy. | |||
LAST_CALL_MADE | TIMESTAMP | The date when last call was made to an account. | |||
HIER_LAST_CALL_MADE | TIMESTAMP | The date when last call was made to an account and its hierarchy. | |||
LAST_EMAIL_SENT | TIMESTAMP | The date when last email was sent to an account. | |||
HIER_LAST_EMAIL_SENT | TIMESTAMP | The date when last email was sent to an account and its hierarchy. | |||
NUM_OF_TOUCHES | NUMBER | Total number of touches with an account. Touches refer to outbound communications such as email, phone and so on. | |||
HIER_NUM_OF_TOUCHES | NUMBER | Total number of touches with an account and its hierarchy. Touches refer to communications such as email, phone, email, phone and so on. | |||
LAST_TOUCH | TIMESTAMP | The date when the last touch was made with an account. | |||
HIER_LAST_TOUCH | TIMESTAMP | The date when the last touch was made with an account and its hierarchy. | |||
OPEN_LEAD_DEAL_AMT | NUMBER | The sum of the potential revenues from qualified and unqualified open leads of an account. | |||
HIER_OPEN_LEAD_DEAL_AMT | NUMBER | The sum of the potential revenues from qualified and unqualified open leads of an account and its hierarchy. | |||
SUM_OF_ACTIVE_SUBS_MRR | NUMBER | The cumulative monthly recurring revenue from active subscription lines on an account. | |||
HIER_SUM_OF_ACTIVE_SUBS_MRR | NUMBER | The cumulative monthly recurring revenue from active subscription lines on an account and its hierarchy. | |||
SUM_OF_ACTIVE_SUBS_TCV | NUMBER | The cumulative total contract value amounts from active subscription lines on an account. | |||
HIER_SUM_OF_ACTIVE_SUBS_TCV | NUMBER | The cumulative total contract value amounts from active subscription lines on an account and its hierarchy. | |||
SUM_OF_UPCOMING_RENEW_MRR | NUMBER | The cumulative monthly recurring revenue from expiring subscription lines on an account that haven't been amended, closed, suspended, or renewed. | |||
HIER_SUM_OF_UPCOMING_RENEW_MRR | NUMBER | The cumulative monthly recurring revenue from expiring subscription lines on an account and its hierarchy that haven't been amended, closed, suspended, or renewed. | |||
SUM_OF_LAPSED_RENEW_MRR | NUMBER | The cumulative monthly recurring revenue from expired subscription lines on an account that don't have renewal lines. | |||
HIER_SUM_OF_LAPSED_RENEW_MRR | NUMBER | The cumulative monthly recurring revenue from expired subscription lines on an account and its hierarchy that don't have renewal lines. | |||
SUM_OF_CLOSED_SUBS_MRR | NUMBER | The cumulative monthly recurring revenue from subscription lines on an account that were closed in a given period of time. | |||
HIER_SUM_OF_CLOSED_SUBS_MRR | NUMBER | The cumulative monthly recurring revenue from subscription lines on an account and its hierarchy that were closed in a given period of time. | |||
LAST_COMPLETED_ACTIVITY | TIMESTAMP | The date of last completed activity with an account. Activity includes task, appointment, and call report. | |||
HIER_LAST_COMPLETED_ACTIVITY | TIMESTAMP | The date of last completed activity with an account and its hierarchy. Activity includes task, appointment, and call report. | |||
TOTAL_COMPLETED_ACTIVITIES | NUMBER | The total number of completed activities with an account. | |||
HIER_TOTAL_COMPLETD_ACTIVITIES | NUMBER | The total number of completed activities with an account and its hierarchy. | |||
NEXT_TASK_DUE | TIMESTAMP | The date when a task is due with an account. | |||
HIER_NEXT_TASK_DUE | TIMESTAMP | The date when a task is due with an account and its hierarchy. | |||
TOTAL_NOTES | NUMBER | The total number of public notes associated with an account. | |||
HIER_TOTAL_NOTES | NUMBER | The total number of public notes associated with an account and its hierarchy. | |||
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. | |
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. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
CURRENCY_CODE | VARCHAR2 | 15 | The currency code. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. | ||
CORP_CURRENCY_CODE | VARCHAR2 | 15 | The corporate currency code associated with the account. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task. | ||
CURCY_CONV_RATE_TYPE | VARCHAR2 | 30 | The currency conversion rate type. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. | ||
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. | ||
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). | |||
NUMBER_OF_SUBS_EXP_QTR | NUMBER | The count of subscription products where the associated subscription is expiring in the current quarter. | |||
HIER_NUMBER_OF_SUBS_EXP_QTR | NUMBER | The count of subscription products where the associated subscription is expiring in the current quarter and its hierarchy. | |||
NUMBER_OF_SUBS_EXP_NXT_QTR | NUMBER | The count of subscription products where the associated subscription is expiring in the next quarter | |||
HIER_NUM_OF_SUBS_EXP_NXT_QTR | NUMBER | The count of subscription products where the associated subscription is expiring in the next quarter and its hierarchy. | |||
ARR_FROM_ACTIVE_SUBSCRIPTIONS | NUMBER | Annual Recurring Revenue from Active Subscriptions. | |||
HIER_ARR_FROM_ACTIVE_SUBS | NUMBER | The annual recurring revenue from all active subscriptions and its hieararchy. | |||
SUM_OPEN_OPTY_REVENUE_THIS_QTR | NUMBER | Total revenue from open opportunities with expected close date falling in the current quarter. | |||
HIER_SUM_OPEN_OPTY_REV_QTR | NUMBER | The total revenue from open opportunities with expected close date falling in the current quarter and its hierarchy. | |||
SUM_OPEN_OPTY_REVENUE_NXT_QTR | NUMBER | Total revenue from open opportunities with expected close date falling in the next quarter. | |||
HIER_SUM_OPEN_OPTY_REV_NXT_QTR | NUMBER | The total revenue from open opportunities with expected close date falling in the next quarter and its hierarchy. | |||
SUM_OPTY_REVENUE_WON_THIS_QTR | NUMBER | The total revenue of an account from won opportunities with a close date falling in this quarter. | |||
HIER_SUM_OPTY_REV_WON_QTR | NUMBER | The total revenue of an account and its hieararchy from won opportunities with close date falling in this quarter. | |||
DATE_NEXT_OPTY_CLOSED | DATE | Date when the next opportunity is expected to close | |||
HIER_DATE_NEXT_OPTY_CLOSED | DATE | The date when the next opportunity is expected to close in account hierarchy. | |||
DATE_LAST_OPTY_CLOSED | DATE | Date when the last opportunity closed. | |||
HIER_DATE_LAST_OPTY_CLOSED | DATE | The date when the last opportunity closed in account hierarchy. | |||
NUMBER_OF_QUALIFIED_HOT_LEADS | NUMBER | The count of leads that are qualified and hot. | |||
HIER_NUM_OF_QUAL_HOT_LEADS | NUMBER | The count of leads that are qualified and hot and its hierarchy. | |||
NUMBER_OF_QUALIFIED_LEADS | NUMBER | Total Number of Qualified Leads | |||
HIER_NUMBER_OF_QUALIFIED_LEADS | NUMBER | The count of leads that are qualified and its hierarchy. | |||
DATE_LAST_LEAD_CREATED | TIMESTAMP | Last Creation Date of a Qualified Lead | |||
HIER_DATE_LAST_LEAD_CREATED | TIMESTAMP | The date last lead was created in account hierarchy. | |||
POTENTIAL_REV_OPEN_LEADS | NUMBER | The total potential revenue from qualified leads. | |||
HIER_POTENTIAL_REV_OPEN_LEADS | NUMBER | The total Potential Revenue from Open Leads and its hierarchy. | |||
NUM_OF_DECISION_MAKER_CONTACTS | NUMBER | Total Number of Decision Maker Contacts | |||
HIER_NUM_OF_DEC_MAKER_CONTACTS | NUMBER | The count of contacts with buying role of either decision maker or secondary decision maker and its hierarchy. | |||
NUM_OF_SR_CLOSED_PAST_WEEK | NUMBER | Total Number of Service Requests closed in the past week | |||
HIER_NUM_OF_SR_CLOSE_PAST_WEEK | NUMBER | The count of Service Requests with close date falling in the past 7 days and its hierarchy. | |||
EXTN_ATTRIBUTE_TIMESTAMP001 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP001 | |||
EXTN_ATTRIBUTE_TIMESTAMP002 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP002 | |||
EXTN_ATTRIBUTE_TIMESTAMP003 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP003 | |||
EXTN_ATTRIBUTE_NUMBER001 | NUMBER | EXTN_ATTRIBUTE_NUMBER001 | |||
EXTN_ATTRIBUTE_NUMBER002 | NUMBER | EXTN_ATTRIBUTE_NUMBER002 | |||
EXTN_ATTRIBUTE_NUMBER003 | NUMBER | EXTN_ATTRIBUTE_NUMBER003 | |||
EXTN_ATTRIBUTE_NUMBER004 | NUMBER | EXTN_ATTRIBUTE_NUMBER004 | |||
EXTN_ATTRIBUTE_NUMBER005 | NUMBER | EXTN_ATTRIBUTE_NUMBER005 | |||
EXTN_ATTRIBUTE_NUMBER006 | NUMBER | EXTN_ATTRIBUTE_NUMBER006 | |||
EXTN_ATTRIBUTE_NUMBER007 | NUMBER | EXTN_ATTRIBUTE_NUMBER007 | |||
EXTN_ATTRIBUTE_NUMBER008 | NUMBER | EXTN_ATTRIBUTE_NUMBER008 | |||
EXTN_ATTRIBUTE_TIMESTAMP004 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP004 | |||
EXTN_ATTRIBUTE_TIMESTAMP005 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP005 | |||
EXTN_ATTRIBUTE_TIMESTAMP006 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP006 | |||
EXTN_ATTRIBUTE_NUMBER009 | NUMBER | EXTN_ATTRIBUTE_NUMBER009 | |||
EXTN_ATTRIBUTE_NUMBER010 | NUMBER | EXTN_ATTRIBUTE_NUMBER010 | |||
EXTN_ATTRIBUTE_NUMBER011 | NUMBER | EXTN_ATTRIBUTE_NUMBER011 | |||
EXTN_ATTRIBUTE_NUMBER012 | NUMBER | EXTN_ATTRIBUTE_NUMBER012 | |||
EXTN_ATTRIBUTE_NUMBER013 | NUMBER | EXTN_ATTRIBUTE_NUMBER013 | |||
EXTN_ATTRIBUTE_NUMBER014 | NUMBER | EXTN_ATTRIBUTE_NUMBER014 | |||
EXTN_ATTRIBUTE_NUMBER015 | NUMBER | EXTN_ATTRIBUTE_NUMBER015 | |||
EXTN_ATTRIBUTE_NUMBER016 | NUMBER | EXTN_ATTRIBUTE_NUMBER016 | |||
EXTN_ATTRIBUTE_TIMESTAMP007 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP007 | |||
EXTN_ATTRIBUTE_TIMESTAMP008 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP008 | |||
EXTN_ATTRIBUTE_TIMESTAMP009 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP009 | |||
EXTN_ATTRIBUTE_NUMBER017 | NUMBER | EXTN_ATTRIBUTE_NUMBER017 | |||
EXTN_ATTRIBUTE_NUMBER018 | NUMBER | EXTN_ATTRIBUTE_NUMBER018 | |||
EXTN_ATTRIBUTE_NUMBER019 | NUMBER | EXTN_ATTRIBUTE_NUMBER019 | |||
EXTN_ATTRIBUTE_NUMBER020 | NUMBER | EXTN_ATTRIBUTE_NUMBER020 | |||
EXTN_ATTRIBUTE_NUMBER021 | NUMBER | EXTN_ATTRIBUTE_NUMBER021 | |||
EXTN_ATTRIBUTE_NUMBER022 | NUMBER | EXTN_ATTRIBUTE_NUMBER022 | |||
EXTN_ATTRIBUTE_NUMBER023 | NUMBER | EXTN_ATTRIBUTE_NUMBER023 | |||
EXTN_ATTRIBUTE_NUMBER024 | NUMBER | EXTN_ATTRIBUTE_NUMBER024 | |||
EXTN_ATTRIBUTE_TIMESTAMP010 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP010 | |||
EXTN_ATTRIBUTE_TIMESTAMP011 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP011 | |||
EXTN_ATTRIBUTE_TIMESTAMP012 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP012 | |||
EXTN_ATTRIBUTE_NUMBER025 | NUMBER | EXTN_ATTRIBUTE_NUMBER025 | |||
EXTN_ATTRIBUTE_NUMBER026 | NUMBER | EXTN_ATTRIBUTE_NUMBER026 | |||
EXTN_ATTRIBUTE_NUMBER027 | NUMBER | EXTN_ATTRIBUTE_NUMBER027 | |||
EXTN_ATTRIBUTE_NUMBER028 | NUMBER | EXTN_ATTRIBUTE_NUMBER028 | |||
EXTN_ATTRIBUTE_NUMBER029 | NUMBER | EXTN_ATTRIBUTE_NUMBER029 | |||
EXTN_ATTRIBUTE_NUMBER030 | NUMBER | EXTN_ATTRIBUTE_NUMBER030 | |||
EXTN_ATTRIBUTE_NUMBER031 | NUMBER | EXTN_ATTRIBUTE_NUMBER031 | |||
EXTN_ATTRIBUTE_NUMBER032 | NUMBER | EXTN_ATTRIBUTE_NUMBER032 | |||
EXTN_ATTRIBUTE_TIMESTAMP013 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP013 | |||
EXTN_ATTRIBUTE_TIMESTAMP014 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP014 | |||
EXTN_ATTRIBUTE_TIMESTAMP015 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP015 | |||
EXTN_ATTRIBUTE_NUMBER033 | NUMBER | EXTN_ATTRIBUTE_NUMBER033 | |||
EXTN_ATTRIBUTE_NUMBER034 | NUMBER | EXTN_ATTRIBUTE_NUMBER034 | |||
EXTN_ATTRIBUTE_NUMBER035 | NUMBER | EXTN_ATTRIBUTE_NUMBER035 | |||
EXTN_ATTRIBUTE_NUMBER036 | NUMBER | EXTN_ATTRIBUTE_NUMBER036 | |||
EXTN_ATTRIBUTE_NUMBER037 | NUMBER | EXTN_ATTRIBUTE_NUMBER037 | |||
EXTN_ATTRIBUTE_NUMBER038 | NUMBER | EXTN_ATTRIBUTE_NUMBER038 | |||
EXTN_ATTRIBUTE_NUMBER039 | NUMBER | EXTN_ATTRIBUTE_NUMBER039 | |||
EXTN_ATTRIBUTE_NUMBER040 | NUMBER | EXTN_ATTRIBUTE_NUMBER040 | |||
EXTN_ATTRIBUTE_TIMESTAMP016 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP016 | |||
EXTN_ATTRIBUTE_TIMESTAMP017 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP017 | |||
EXTN_ATTRIBUTE_TIMESTAMP018 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP018 | |||
EXTN_ATTRIBUTE_NUMBER041 | NUMBER | EXTN_ATTRIBUTE_NUMBER041 | |||
EXTN_ATTRIBUTE_NUMBER042 | NUMBER | EXTN_ATTRIBUTE_NUMBER042 | |||
EXTN_ATTRIBUTE_NUMBER043 | NUMBER | EXTN_ATTRIBUTE_NUMBER043 | |||
EXTN_ATTRIBUTE_NUMBER044 | NUMBER | EXTN_ATTRIBUTE_NUMBER044 | |||
EXTN_ATTRIBUTE_NUMBER045 | NUMBER | EXTN_ATTRIBUTE_NUMBER045 | |||
EXTN_ATTRIBUTE_NUMBER046 | NUMBER | EXTN_ATTRIBUTE_NUMBER046 | |||
EXTN_ATTRIBUTE_NUMBER047 | NUMBER | EXTN_ATTRIBUTE_NUMBER047 | |||
EXTN_ATTRIBUTE_NUMBER048 | NUMBER | EXTN_ATTRIBUTE_NUMBER048 | |||
EXTN_ATTRIBUTE_TIMESTAMP019 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP019 | |||
EXTN_ATTRIBUTE_TIMESTAMP020 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP020 | |||
EXTN_ATTRIBUTE_TIMESTAMP021 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP021 | |||
EXTN_ATTRIBUTE_NUMBER049 | NUMBER | EXTN_ATTRIBUTE_NUMBER049 | |||
EXTN_ATTRIBUTE_NUMBER050 | NUMBER | EXTN_ATTRIBUTE_NUMBER050 | |||
EXTN_ATTRIBUTE_NUMBER051 | NUMBER | EXTN_ATTRIBUTE_NUMBER051 | |||
EXTN_ATTRIBUTE_NUMBER052 | NUMBER | EXTN_ATTRIBUTE_NUMBER052 | |||
EXTN_ATTRIBUTE_NUMBER053 | NUMBER | EXTN_ATTRIBUTE_NUMBER053 | |||
EXTN_ATTRIBUTE_NUMBER054 | NUMBER | EXTN_ATTRIBUTE_NUMBER054 | |||
EXTN_ATTRIBUTE_NUMBER055 | NUMBER | EXTN_ATTRIBUTE_NUMBER055 | |||
EXTN_ATTRIBUTE_NUMBER056 | NUMBER | EXTN_ATTRIBUTE_NUMBER056 | |||
EXTN_ATTRIBUTE_TIMESTAMP022 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP022 | |||
EXTN_ATTRIBUTE_TIMESTAMP023 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP023 | |||
EXTN_ATTRIBUTE_TIMESTAMP024 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP024 | |||
EXTN_ATTRIBUTE_NUMBER057 | NUMBER | EXTN_ATTRIBUTE_NUMBER057 | |||
EXTN_ATTRIBUTE_NUMBER058 | NUMBER | EXTN_ATTRIBUTE_NUMBER058 | |||
EXTN_ATTRIBUTE_NUMBER059 | NUMBER | EXTN_ATTRIBUTE_NUMBER059 | |||
EXTN_ATTRIBUTE_NUMBER060 | NUMBER | EXTN_ATTRIBUTE_NUMBER060 | |||
EXTN_ATTRIBUTE_NUMBER061 | NUMBER | EXTN_ATTRIBUTE_NUMBER061 | |||
EXTN_ATTRIBUTE_NUMBER062 | NUMBER | EXTN_ATTRIBUTE_NUMBER062 | |||
EXTN_ATTRIBUTE_NUMBER063 | NUMBER | EXTN_ATTRIBUTE_NUMBER063 | |||
EXTN_ATTRIBUTE_NUMBER064 | NUMBER | EXTN_ATTRIBUTE_NUMBER064 | |||
EXTN_ATTRIBUTE_TIMESTAMP025 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP025 | |||
EXTN_ATTRIBUTE_TIMESTAMP026 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP026 | |||
EXTN_ATTRIBUTE_TIMESTAMP027 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP027 | |||
EXTN_ATTRIBUTE_NUMBER065 | NUMBER | EXTN_ATTRIBUTE_NUMBER065 | |||
EXTN_ATTRIBUTE_NUMBER066 | NUMBER | EXTN_ATTRIBUTE_NUMBER066 | |||
EXTN_ATTRIBUTE_NUMBER067 | NUMBER | EXTN_ATTRIBUTE_NUMBER067 | |||
EXTN_ATTRIBUTE_NUMBER068 | NUMBER | EXTN_ATTRIBUTE_NUMBER068 | |||
EXTN_ATTRIBUTE_NUMBER069 | NUMBER | EXTN_ATTRIBUTE_NUMBER069 | |||
EXTN_ATTRIBUTE_NUMBER070 | NUMBER | EXTN_ATTRIBUTE_NUMBER070 | |||
EXTN_ATTRIBUTE_NUMBER071 | NUMBER | EXTN_ATTRIBUTE_NUMBER071 | |||
EXTN_ATTRIBUTE_NUMBER072 | NUMBER | EXTN_ATTRIBUTE_NUMBER072 | |||
EXTN_ATTRIBUTE_TIMESTAMP028 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP028 | |||
EXTN_ATTRIBUTE_TIMESTAMP029 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP029 | |||
EXTN_ATTRIBUTE_TIMESTAMP030 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP030 | |||
EXTN_ATTRIBUTE_NUMBER073 | NUMBER | EXTN_ATTRIBUTE_NUMBER073 | |||
EXTN_ATTRIBUTE_NUMBER074 | NUMBER | EXTN_ATTRIBUTE_NUMBER074 | |||
EXTN_ATTRIBUTE_NUMBER075 | NUMBER | EXTN_ATTRIBUTE_NUMBER075 | |||
EXTN_ATTRIBUTE_NUMBER076 | NUMBER | EXTN_ATTRIBUTE_NUMBER076 | |||
EXTN_ATTRIBUTE_NUMBER077 | NUMBER | EXTN_ATTRIBUTE_NUMBER077 | |||
EXTN_ATTRIBUTE_NUMBER078 | NUMBER | EXTN_ATTRIBUTE_NUMBER078 | |||
EXTN_ATTRIBUTE_NUMBER079 | NUMBER | EXTN_ATTRIBUTE_NUMBER079 | |||
EXTN_ATTRIBUTE_NUMBER080 | NUMBER | EXTN_ATTRIBUTE_NUMBER080 | |||
EXTN_ATTRIBUTE_TIMESTAMP031 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP031 | |||
EXTN_ATTRIBUTE_TIMESTAMP032 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP032 | |||
EXTN_ATTRIBUTE_TIMESTAMP033 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP033 | |||
EXTN_ATTRIBUTE_NUMBER081 | NUMBER | EXTN_ATTRIBUTE_NUMBER081 | |||
EXTN_ATTRIBUTE_NUMBER082 | NUMBER | EXTN_ATTRIBUTE_NUMBER082 | |||
EXTN_ATTRIBUTE_NUMBER083 | NUMBER | EXTN_ATTRIBUTE_NUMBER083 | |||
EXTN_ATTRIBUTE_NUMBER084 | NUMBER | EXTN_ATTRIBUTE_NUMBER084 | |||
EXTN_ATTRIBUTE_NUMBER085 | NUMBER | EXTN_ATTRIBUTE_NUMBER085 | |||
EXTN_ATTRIBUTE_NUMBER086 | NUMBER | EXTN_ATTRIBUTE_NUMBER086 | |||
EXTN_ATTRIBUTE_NUMBER087 | NUMBER | EXTN_ATTRIBUTE_NUMBER087 | |||
EXTN_ATTRIBUTE_NUMBER088 | NUMBER | EXTN_ATTRIBUTE_NUMBER088 | |||
EXTN_ATTRIBUTE_TIMESTAMP034 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP034 | |||
EXTN_ATTRIBUTE_TIMESTAMP035 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP035 | |||
EXTN_ATTRIBUTE_TIMESTAMP036 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP036 | |||
EXTN_ATTRIBUTE_NUMBER089 | NUMBER | EXTN_ATTRIBUTE_NUMBER089 | |||
EXTN_ATTRIBUTE_NUMBER090 | NUMBER | EXTN_ATTRIBUTE_NUMBER090 | |||
EXTN_ATTRIBUTE_NUMBER091 | NUMBER | EXTN_ATTRIBUTE_NUMBER091 | |||
EXTN_ATTRIBUTE_NUMBER092 | NUMBER | EXTN_ATTRIBUTE_NUMBER092 | |||
EXTN_ATTRIBUTE_NUMBER093 | NUMBER | EXTN_ATTRIBUTE_NUMBER093 | |||
EXTN_ATTRIBUTE_NUMBER094 | NUMBER | EXTN_ATTRIBUTE_NUMBER094 | |||
EXTN_ATTRIBUTE_NUMBER095 | NUMBER | EXTN_ATTRIBUTE_NUMBER095 | |||
EXTN_ATTRIBUTE_NUMBER096 | NUMBER | EXTN_ATTRIBUTE_NUMBER096 | |||
EXTN_ATTRIBUTE_TIMESTAMP037 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP037 | |||
EXTN_ATTRIBUTE_TIMESTAMP038 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP038 | |||
EXTN_ATTRIBUTE_TIMESTAMP039 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP039 | |||
EXTN_ATTRIBUTE_NUMBER097 | NUMBER | EXTN_ATTRIBUTE_NUMBER097 | |||
EXTN_ATTRIBUTE_NUMBER098 | NUMBER | EXTN_ATTRIBUTE_NUMBER098 | |||
EXTN_ATTRIBUTE_NUMBER099 | NUMBER | EXTN_ATTRIBUTE_NUMBER099 | |||
EXTN_ATTRIBUTE_NUMBER100 | NUMBER | EXTN_ATTRIBUTE_NUMBER100 | |||
EXTN_ATTRIBUTE_TIMESTAMP040 | TIMESTAMP | EXTN_ATTRIBUTE_TIMESTAMP040 |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
HZ_ACCOUNT_ROLLUPS | hz_organization_profiles | ORGANIZATION_PROFILE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
HZ_ACCOUNT_ROLLUPS_U1 | Unique | FUSION_TS_TX_DATA | ORGANIZATION_PROFILE_ID |