VRM_PERF_OBLIG_TEMPLATES_B
This table contains information about the performance obligation templates.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
VRM_PERF_OBLIG_TEMPL_B_PK |
PERF_OBLIGATION_TEMPLATE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERF_OBLIGATION_TEMPLATE_ID | NUMBER | 18 | Yes | Internal identifier of the performance obligation template. | |
| SATISFACTION_METHOD | VARCHAR2 | 30 | Specifies whether the obligation is satisfied at a point in time or over time. Values are derived from ORA_VRM_SATISFACTION_METHOD lookup type. | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Indicates if the performance obligation template is active. | ||
| CREATED_FROM | VARCHAR2 | 30 | Yes | The process or user interface from which this row is created.. | |
| 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PRIORITY | NUMBER | 6 | Yes | Order in which performance obligation templates will be picked for processing. | |
| DERIVE_PDC_FLAG | VARCHAR2 | 1 | Yes | Indicates whether to derive the pricing dimension combination from source documents for a performance obligation template. | |
| IN_USE_FLAG | VARCHAR2 | 1 | Indicates if the performance obligation template is in-use and cannot be updated. | ||
| RESIDUAL_APPROACH_FLAG | VARCHAR2 | 1 | Indicates the pricing for the goods or services is variable or missing and the standalone selling price for the resulting performance obligation is estimated using the residual approach. Valid values are from the lookup type VRM_YES/NO. | ||
| ALLOCATION_BASIS_CODE | VARCHAR2 | 30 | The basis used to calculate the ratio of the allocated revenue for performance obligation distributions to their underlying promise detail lines. Valid values are from the lookup type ORA_VRM_ALLOC_BASIS. | ||
| EXEMPT_FROM_ALLOCATION_FLAG | VARCHAR2 | 1 | Indicates if the performance obligation created using this template should be exempted from allocation. | ||
| START_DATE_ACTIVE | DATE | Date when the template becomes active. | |||
| END_DATE_ACTIVE | DATE | Date when the template becomes inactive. | |||
| CLASSIFICATION_CODE | VARCHAR2 | 30 | Code name of a performance obligation group classification. Values are derived from the ORA_VRM_OBLIG_CLASSIF_CODE lookup type. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| vrm_perf_oblig_templ_assigns | vrm_perf_oblig_templates_b | PERF_OBLIGATION_TEMPLATE_ID |
| vrm_perf_obligations | vrm_perf_oblig_templates_b | PERF_OBLIGATION_TEMPLATE_ID |
| vrm_perf_oblig_templates_tl | vrm_perf_oblig_templates_b | PERF_OBLIGATION_TEMPLATE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_PERF_OBLIG_TEMPL_B_U1 | Unique | Default | PERF_OBLIGATION_TEMPLATE_ID |