1. Tables and Views for Financials
  2. VRM_REV_ADJ_LINE_CONTS_GT

VRM_REV_ADJ_LINE_CONTS_GT

This is a temporary table which is used internally by Oracle.

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Columns

Name Datatype Length Precision Not-null Comments Status
REVENUE_DOCUMENT_LINE_ID NUMBER 18 Yes Revenue document line unique identifier. Active
CONTINGENCY_CODE VARCHAR2 30 Yes Contingency code on the revenue line. Active
EXPIRATION_DATE DATE Date the contingency expires on the revenue line. Active
EXPIRATION_DAYS NUMBER Number of days from the Date considered for fulfillment to automatically consider the additional satisfaction event as fully satisfied. Active
EXPIRED_FLAG VARCHAR2 1 Indicates that the contingencies are expired on the revenue line. Possible values are Yes or No. Active
PRIMARY_REMOVAL_EVENT VARCHAR2 30 The primary contingency removal event on the revenue line. Active
OPTIONAL_REMOVAL_EVENT VARCHAR2 30 The optional contingency removal event on the revenue line. Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
EXPIRATION_EVENT_DATE DATE Date the contingency was expired on the revenue line. Active
REASON_REMOVAL_DATE DATE Date the contingency was removed on the revenue line. Active
EXPIRED_BY VARCHAR2 64 Who column: displays the user who expired the contingency. Active
DEFAULTED_IN_VRM_FLAG VARCHAR2 1 Indicates the contingency was defaulted based on a rule. Active
CONTINGENCY_ID NUMBER 18 Yes Unique identifier of the additional satisfaction event. Active
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. Active
COMMENTS VARCHAR2 2000 Comments entered by the user during the add revenue contingency adjustment process. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
PERF_OBLIGATION_LINE_ID NUMBER 18 Performance obligation line identifier.
ADDITIONAL_SE_TYPE_CODE VARCHAR2 30 Additional satisfaction event used in the rule. Valid values are from the lookup type ORA_VRM_ADDL_SATIS_EVENTS.
ASE_FULFILLMENT_DATE_TYPE_CODE VARCHAR2 30 Date that is considered for the automatic fulfillment of additional satisfaction events. The additional satisfaction event is considered to be fulfilled when the number of days specified in the setup have elapsed starting with the selected date. Valid values are from the lookup type ORA_VRM_DATE_ADDL_SATIS_EVENT.
ELIGIBLE_ASE_VALUE NUMBER Value of the fulfillment of the additional satisfaction event according to the satisfaction measurement model. The value indicates the satisfied quantity, satisfied percent, or period equivalent amount.
ELIGIBLE_PSE_VALUE NUMBER Value of the fulfillment of the primary satisfaction event according to the satisfaction measurement model. The value indicates the satisfied quantity, satisfied percent, or period equivalent amount.
ELIGIBLE_REVENUE_AMOUNT NUMBER Amount equivalent to the fulfillment of all the available additional satisfaction events.

Indexes

Index Uniqueness Columns Status
VRM_REV_ADJ_LINE_CONTS_N1 Non Unique REVENUE_DOCUMENT_LINE_ID Obsolete