ACN_REQUIREMENT_LINE_ITEM
Thsi table contains all line items (and their attributes) that belong to each version of the requirement object. The parent and child relationship of the line items is also captured here.
Details
-
Schema: FUSION
-
Object owner: ACN
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
ACN_REQUIREMENT_LINE_ITEM_PK |
REQUIREMENT_LINE_ITEM_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
REQUIREMENT_LINE_ITEM_ID | NUMBER | 18 | Yes | This is the primary key of the table | |
CURRENCY_CODE | VARCHAR2 | 15 | Column containing the Currency Code | ||
CORP_CURRENCY_CODE | VARCHAR2 | 15 | Column with the Corporate Currency Code | ||
CURCY_CONV_RATE_TYPE | VARCHAR2 | 30 | Type of the Currency Conversion Rate | ||
OBJECT_ID | NUMBER | 18 | This is the requirement version id of the associated req spec | ||
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. | |
BASE_LINE_ITEM_ID | NUMBER | 18 | Base line item id from the line item id when it is originallly created | ||
NAME | VARCHAR2 | 400 | Yes | This is the name of the requirement line item | |
REQUIREMENT_VERSION_ID | NUMBER | 18 | Yes | This is the (root) requirement version id | |
PARENT_LINE_ITEM_ID | NUMBER | 18 | Line item ID of the direct parent. Null for the first level child. | ||
SECTION_CODE | VARCHAR2 | 400 | This is the section code used to sort the line item table. | ||
SECTION_NUMBER | VARCHAR2 | 400 | This is the section number used to indicate the section of the requirement line item ??? for flat table display | ||
SCOPE | VARCHAR2 | 30 | This is the scope of the requirement line item. Lookup Type: ACN_REQUIREMENT_SCOPE. Possible values might be: In Scope/Out of Scope list, or Yes/No list | ||
PRIORITY | VARCHAR2 | 30 | This is the priority of the requirement line item. Lookup Type: CAN_REQUIREMENT_PRIORITY Lookup Code: MUST HAVE, SHOULD HAVE, NICE TO HAVE | ||
FULFILLED | VARCHAR2 | 30 | This is the fulfillment of the requirement line item. | ||
ESTIMATES | NUMBER | 18 | This is the estimates of the requirement line item. Its unit is defined by customer (such as in days) | ||
CONTENT | CLOB | a rich text field of the requirement line item | |||
DESCRIPTION | VARCHAR2 | 1000 | A description field for requirement line item. | ||
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 |
---|---|---|
ACN_REQUIREMENT_LINE_ITEM | acn_req_version_b | REQUIREMENT_VERSION_ID |
ACN_REQUIREMENT_LINE_ITEM | acn_requirement_line_item | PARENT_LINE_ITEM_ID |
ACN_REQUIREMENT_LINE_ITEM | acn_req_version_b | OBJECT_ID |
acn_req_comment | acn_requirement_line_item | ID |
acn_requirement_line_item | acn_requirement_line_item | PARENT_LINE_ITEM_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
ACN_REQUIREMENT_LINE_ITEM_N1 | Non Unique | Default | REQUIREMENT_VERSION_ID |
ACN_REQUIREMENT_LINE_ITEM_N10 | Non Unique | Default | BASE_LINE_ITEM_ID |
ACN_REQUIREMENT_LINE_ITEM_N2 | Non Unique | Default | EXTN_ATTRIBUTE_NUMBER001 |
ACN_REQUIREMENT_LINE_ITEM_N3 | Non Unique | Default | EXTN_ATTRIBUTE_NUMBER002 |
ACN_REQUIREMENT_LINE_ITEM_N4 | Non Unique | Default | EXTN_ATTRIBUTE_NUMBER003 |
ACN_REQUIREMENT_LINE_ITEM_N5 | Non Unique | Default | EXTN_ATTRIBUTE_CHAR001 |
ACN_REQUIREMENT_LINE_ITEM_N6 | Non Unique | Default | EXTN_ATTRIBUTE_CHAR002 |
ACN_REQUIREMENT_LINE_ITEM_N7 | Non Unique | Default | OBJECT_ID |
ACN_REQUIREMENT_LINE_ITEM_N8 | Non Unique | Default | UPPER("NAME"), OBJECT_VERSION_NUMBER |
ACN_REQUIREMENT_LINE_ITEM_N9 | Non Unique | Default | PARENT_LINE_ITEM_ID |
ACN_REQUIREMENT_LINE_ITEM_U1 | Unique | Default | REQUIREMENT_LINE_ITEM_ID |