ACE_PORTFOLIO_B
Contains detailed information for Portfolio.
Details
-
Schema: FUSION
-
Object owner: ACE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
ACE_PORTFOLIO_B_PK |
PORTFOLIO_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
PORTFOLIO_ID | NUMBER | 18 | Yes | Primary Key which will be system generated Application Unique Id. | |
CORP_CURRENCY_CODE | VARCHAR2 | 15 | The code of the corporate currency. | ||
CURCY_CONV_RATE_TYPE | VARCHAR2 | 30 | The type of the currency conversion rate. | ||
LATEST_REVISION_ID | NUMBER | 18 | The unique ID of the latest portfolio revision. | ||
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. | |
CLASS_TYPE | VARCHAR2 | 80 | Yes | Column for Class Management Type. | |
PORTFOLIO_TYPE | VARCHAR2 | 30 | Yes | Product Portfolio type. The supported types are defined in the Lookup type with the name ACE_PORTFOLIO_TYPE. The possible values codes and translatable names as follows, Code: REGULAR Value: Regular Code: TEMPLATE.Value: Template | |
OWNER | VARCHAR2 | 100 | Yes | Stores the user id of the user who owns the Product Portfolio. Owner is a application user. | |
PLANNING_PERIOD_ID | NUMBER | 18 | Planning period for this portfolio. The value stored in this column will be foreign key to ACE_PLANNING_PERIOD_D (described in PPM Setup TDD) table. | ||
COMPANY_NODE_ID | VARCHAR2 | 30 | Company Hierarchy at which this portfolio is associated. | ||
CREATED_FROM_PORTFOLIO_ID | NUMBER | 18 | Stores the primary key of the portfolio from which this portfolio got created. The column is a foreign key to PORTFOLIO_ID of ACE_PORTFOLIO_B table. | ||
BUDGET | NUMBER | Budget allocated to Portfolio (manually or via parent portfolio) | |||
TARGET_COST | NUMBER | Target Cost allocated to Portfolio (manually or via parent portfolio) | |||
TARGET_REVENUE | NUMBER | Target Revenue allocated to Portfolio (manually or via parent portfolio) | |||
TARGET_MARGIN | NUMBER | Target Margin allocated to Portfolio (derived from Target Cost & Target Revenue) | |||
CURRENCY_CODE | VARCHAR2 | 15 | The currency code in which all the cost values are stored for this portfolio. This column is a foreign key to CURRENCY_CODE column of FND_CURRENCIES_B table. | ||
REVENUE_EXPECTATION | NUMBER | Expected revenue from portfolio | |||
CURRENT_PLAN_ID | NUMBER | 18 | Refers to the Scenario which is the current plan of this portfolio. It is a foreign key of PLAN_ID column in ACE_PORTFOLIO_PLAN_B table. | ||
PROPOSED_PLAN_ID | NUMBER | 18 | Refers to the Scenario which is the plan being proposed for this portfolio. It is a foreign key of PLAN_ID column in ACE_PORTFOLIO_PLAN_B table. | ||
PRIMARY_JUSTIFICATION | VARCHAR2 | 30 | Primary justification for this portfolio. The supported types are defined in the Lookup type with the name ACE_PRIMARY_JUSTIFICATIONS. The possible values codes and translatable names as follows, Code: NEW_MARKET Value: Enter New Markets Code: NEW_REGION Value: Enter New Regions Code: EXPAND_MARKET Value: Expand Market Share Code: EXIT_MARKET Value: Exit Market | ||
SECONDARY_JUSTIFICATION | VARCHAR2 | 30 | Secondary justification for this portfolio. The supported types are defined in the Lookup type with the name ACE_SECONDARY_JUSTIFICATIONS. The possible values codes and translatable names as follows, Code: NEW_MARKET Value: Enter New Markets Code: NEW_REGION Value: Enter New Regions Code: EXPAND_MARKET Value: Expand Market Share Code: EXIT_MARKET Value: Exit Market | ||
LIFECYCLE_PHASE | VARCHAR2 | 30 | Current lifecycle of the portfolio. The supported types are defined in the Lookup type with the name ACE_PFOLIO_LIFECYCLE_PHASES. The possible values codes and translatable names as follows, Code: DRAFT Value: Draft Code: SUBMITTED Value: Submitted Code: RELEASED Value: Released Code: APPROVED Value: Approved | ||
DELETED_FLAG | VARCHAR2 | 1 | Deleted Flag. ???Y??? indicates the portfolio is deleted and ???N??? indicates the portfolio is still active. The default value is ???N???. | ||
ARCHIVE_FLAG | VARCHAR2 | 1 | Archive flag. ???Y??? indicates the portfolio is archived and ???N??? indicates the portfolio is not archived. The default value is ???N???. | ||
WORKFLOW | VARCHAR2 | 30 | Stores the workflow through which the current portfolio is routed. | ||
BUSINESS_UNIT | VARCHAR2 | 30 | Business unit of the portfolio. The values for this column will be maintained in FND_LOOKUPS under the ACE_BUSINESS_UNITS lookup type. The possible values are configured by the customer. | ||
PRODUCT_LINE | VARCHAR2 | 30 | Product line of the portfolio. The values for this column will be maintained in FND_LOOKUPS under the ACE_PRODUCT_LINES lookup type. The possible values are configured by the customer. | ||
PROJECTED_REVENUE | NUMBER | Sum of all projected revenues for portfolio | |||
PROJECTED_COST | NUMBER | Sum of all projected costs for portfolio | |||
COST_DEVIATION | NUMBER | Difference between the Target and Projected Cost devided by the Target Cost | |||
REVENUE_DEVIATION | NUMBER | Difference between the Target and Projected Revenue devided by the Target Revenue | |||
WORST_ALLOC_RESOURCE_POOL | VARCHAR2 | 30 | Worst allocated resource pool of the scenario | ||
MAX_RESOURCE_SHORTAGE | NUMBER | Maximum shortage of the resource pool | |||
MOST_DELAYED_PROPOSAL | NUMBER | 18 | Foreign key to product propoal table | ||
DELAYED_PRPSL_PLND_LAUNCH_DATE | DATE | Planned launch date of the proposal | |||
DELAYED_PRPSL_ACTL_LAUNCH_DATE | DATE | Actual launch date of the proposal | |||
PROPOSAL_LAUNCH_DELAY | NUMBER | Delay of the product shown in months. | |||
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. | ||
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_CHAR001 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR002 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR003 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR004 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR005 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR006 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR007 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR008 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR009 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR010 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR011 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR012 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR013 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR014 | VARCHAR2 | 4000 | 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_CHAR015 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR016 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR017 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR018 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR019 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR020 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR021 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR022 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR023 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR024 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR025 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR026 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR027 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR028 | VARCHAR2 | 4000 | 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_CHAR029 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR030 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR031 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR032 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR033 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR034 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR035 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR036 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR037 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR038 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR039 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR040 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR041 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR042 | VARCHAR2 | 4000 | 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_CHAR043 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR044 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR045 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR046 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR047 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR048 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR049 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR050 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR051 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR052 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR053 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR054 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR055 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR056 | VARCHAR2 | 4000 | 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_CHAR057 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR058 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR059 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR060 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR061 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR062 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR063 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR064 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR065 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR066 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR067 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR068 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR069 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR070 | VARCHAR2 | 4000 | 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_CHAR071 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR072 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR073 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR074 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR075 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR076 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR077 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR078 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR079 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR080 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR081 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR082 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR083 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR084 | VARCHAR2 | 4000 | 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_NUMBER049 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_NUMBER050 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CHAR085 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR086 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR087 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR088 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR089 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR090 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR091 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR092 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR093 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR094 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR095 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR096 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR097 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR098 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR099 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_CHAR100 | VARCHAR2 | 4000 | Runtime Extensibility: Column reserved for custom extension attributes. | ||
EXTN_ATTRIBUTE_NUMBER201 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_NUMBER202 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_NUMBER203 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_NUMBER204 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_NUMBER205 | NUMBER | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB001 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB002 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB003 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB004 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB005 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB006 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB007 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB008 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB009 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB010 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB011 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB012 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB013 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB014 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB015 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB016 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB017 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB018 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB019 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB020 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB021 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB022 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB023 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB024 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. | |||
EXTN_ATTRIBUTE_CLOB025 | CLOB | Runtime Extensibility: Column reserved for custom extension attributes. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
ACE_PORTFOLIO_B | ace_portfolio_b | CREATED_FROM_PORTFOLIO_ID |
ACE_PORTFOLIO_B | ace_planning_period_b | PLANNING_PERIOD_ID |
ACE_PORTFOLIO_B | acd_product_proposal | MOST_DELAYED_PROPOSAL |
ace_portfolio_revision | ace_portfolio_b | PORTFOLIO_ID |
ace_pf_scenario_b | ace_portfolio_b | PORTFOLIO_ID |
ace_portfolio_b | ace_portfolio_b | CREATED_FROM_PORTFOLIO_ID |
ace_resource_capacity | ace_portfolio_b | PORTFOLIO_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
ACE_PORTFOLIO_B_N1 | Non Unique | Default | PORTFOLIO_TYPE |
ACE_PORTFOLIO_B_N2 | Non Unique | Default | CLASS_TYPE |
ACE_PORTFOLIO_B_N3 | Non Unique | Default | EXTN_ATTRIBUTE_NUMBER001 |
ACE_PORTFOLIO_B_N4 | Non Unique | Default | EXTN_ATTRIBUTE_NUMBER002 |
ACE_PORTFOLIO_B_N5 | Non Unique | Default | EXTN_ATTRIBUTE_NUMBER003 |
ACE_PORTFOLIO_B_N6 | Non Unique | Default | EXTN_ATTRIBUTE_CHAR001 |
ACE_PORTFOLIO_B_N7 | Non Unique | Default | EXTN_ATTRIBUTE_CHAR002 |
ACE_PORTFOLIO_B_U1 | Unique | Default | PORTFOLIO_ID |