1. Tables and Views for Financials
  2. VRM_REV_LINE_CONTS_ALL

VRM_REV_LINE_CONTS_ALL

VRM_REV_LINE_CONTS_ALL contains revenue contingencies, per revenue document line, that impact the revenue recognition.

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

VRM_REV_LINE_CONTS_ALL_PK

REVENUE_DOCUMENT_LINE_ID, CONTINGENCY_ID

Columns

Name Datatype Length Precision Not-null Comments Status
REVENUE_DOCUMENT_LINE_ID NUMBER 18 Yes Revenue document line unique identifier. Active
ACCEP_OM_REQUEST_ID NUMBER 18 Indicates the Enterprise Service Scheduler request ID of the Acceptance details Job that processed the row.
CONTINGENCY_CODE VARCHAR2 30 Oracle internal use only. 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
CONT_AR_REQUEST_ID NUMBER 18 The Enterprise Service Scheduler request ID of the payment contingency job that processed the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who 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. Possible values are Y or No. 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
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.
ACCEPTANCE_PROCESSED_FLAG VARCHAR2 1 Acceptance processed flag. Possible values are Yes or No.
EXPIRATION_METHOD VARCHAR2 30 Indicates the expiration method.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
VRM_REV_LINE_CONTS_ALL vrm_revenue_doc_lines_all REVENUE_DOCUMENT_LINE_ID

Indexes

Index Uniqueness Tablespace Columns Status
VRM_REV_LINE_CONTS_ALL_N1 Non Unique Default ACCEP_OM_REQUEST_ID
VRM_REV_LINE_CONTS_ALL_N2 Non Unique Default CONT_AR_REQUEST_ID
VRM_REV_LINE_CONTS_ALL_U1 Unique Default REVENUE_DOCUMENT_LINE_ID, CONTINGENCY_ID Obsolete
VRM_REV_LINE_CONTS_ALL_U2 Unique VRM_REV_LINE_CONTS_ALL_U2 PERF_OBLIGATION_LINE_ID, CONTINGENCY_ID