1. Tables and Views for Financials
  2. VRM_CREATE_EVENT_DISTS_INTERIM

VRM_CREATE_EVENT_DISTS_INTERIM

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

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

VRM_CRE_EVENT_DISTS_INT_PK

ACCOUNTING_EVENT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
ACCOUNTING_EVENT_ID NUMBER 18 Yes Revenue management accounting event unique identifier.
ACCOUNTING_EVENT_TYPE VARCHAR2 30 Yes Accounting event type. Values are from the lookup VRM_ACCOUNTING_EVENT_TYPE.
REFERENCE_EVENT_ID NUMBER 18 Yes Reference to the identifier of the event that triggered the accounting event.
ACCOUNTING_DATE DATE Accounting date of the distribution.
AMOUNT NUMBER Accounting event amount in the performance obligation currency.
ACCTD_AMOUNT NUMBER Yes Accounting event amount in the revenue contract currency.
POL_EVENT_ID NUMBER 18 No longer used.
POL_EVENT_TYPE VARCHAR2 30 No longer used.
POL_ENTER_CUR_ALLOCATED_AMT NUMBER Allocated transaction price in the obligation currency.
POL_CONTR_CUR_ALLOCATED_AMT NUMBER Allocated transaction price in the ledger currency.
POB_ENTER_CUR_ALLOCATED_AMT NUMBER Total allocated transaction price in the obligation currency at the performance obligation level.
POB_CONTR_CUR_ALLOCATED_AMT NUMBER Total allocated transaction price in the ledger currency at the performance obligation level.
POB_CONTR_CUR_CARVE_OUT_AMT NUMBER Total discount amount in the ledger currency at the performance obligation level.
ORIGINAL_ACCOUNTING_DATE DATE Original accounting date of the distribution.
PERF_OBLIGATION_LINE_ID NUMBER 18 Performance obligation line identifier.
PERF_OBLIGATION_ID NUMBER 18 Performance obligation identifier.
CUSTOMER_CONTRACT_HEADER_ID NUMBER 18 Customer contract header unique identifier.
POB_FIRST_BE_FLAG VARCHAR2 1 Yes Indicates whether the current event being processed is the first billing event after sorting based on the accounting date under the performance obligation. Active
POB_FIRST_BE_PROCESSED_FLAG VARCHAR2 1 Yes Indicates whether the first billing event after sorting based on the accounting date under the performance obligation is processed. Active
POB_LAST_BE_FLAG VARCHAR2 1 Yes Indicates whether the current event being processed is the last billing event after sorting based on the accounting date under the performance obligation. Active
INITIAL_PERF_EVT_CREATED_FLAG VARCHAR2 1 Indicates if the initial performance accounting event was created.
INITIAL_PERF_EVT_ACTUAL_DATE DATE Date on which the initial performance event was created.
CONTRACT_CURRENCY VARCHAR2 30 Revenue contract currency code.
CONTRACT_CURRENCY_MAU NUMBER Minimum accountable unit of the revenue contract currency.
CONTRACT_CURRENCY_PRECISION NUMBER 1 Currency precision of the revenue contract currency.
ENTER_TO_CONTR_CONV_RATE_TYPE VARCHAR2 30 Conversion rate type used for converting amounts from the entered currency to the contract currency.
ENTER_TO_CONTR_CONV_RATE NUMBER Conversion rate for converting amounts from the entered currency to the contract currency.
ENTER_TO_CONTR_CONV_RATE_DATE DATE Conversion date used for converting amounts from the entered currency to the contract currency.
BU_ID NUMBER 18 The business unit associated to the row.
LEDGER_ID NUMBER 18 Unique identifier of a ledger.
SATISFACTION_METHOD VARCHAR2 30 Specifies whether the obligation is satisfied at a point in time or over time. Values are derived from the lookup type ORA_VRM_SATISFACTION_METHOD.
SATISFACTION_MEASUREMENT_MODEL VARCHAR2 30 Specifies how satisfaction will be measured and recorded for a performance obligation line. Values are from lookup type ORA_VRM_SATIS_MEAS_MODEL.
SATISFACTION_QUANTITY NUMBER No longer used.
SATISFACTION_PERCENT NUMBER No longer used.
NET_QUANTITY NUMBER Net quantity of the performance obligation line. Active
NET_LINE_AMT NUMBER Net line amount of the performance obligation line. Active
IS_MAX_ACCT_DATE_PASSED_FLAG VARCHAR2 1 Indicates the maximum satisfaction measurement date of all the satisfaction events under a performance obligation that has passed the accounting date. Active
ENTERED_CURRENCY VARCHAR2 30 Entered currency of the performance obligation line. Active
ENTERED_CURRENCY_MAU NUMBER Minimum accountable unit for the entered currency.
ENTERED_CURRENCY_PRECISION NUMBER 1 Precision for the entered currency.
FUNCTIONAL_CURRENCY VARCHAR2 30 No longer used.
FUNCTIONAL_CURRENCY_MAU NUMBER No longer used.
FUNCTIONAL_CURRENCY_PRECISION NUMBER 1 No longer used.
ENTER_TO_FUNC_CONV_RATE_TYPE VARCHAR2 30 No longer used.
ENTER_TO_FUNC_CONV_RATE NUMBER No longer used.
SOURCE_DOCUMENT_NUMBER VARCHAR2 30 Document number of a source document.
SOURCE_DOCUMENT_LINE_NUMBER VARCHAR2 30 Source document line number.
PERF_OBLIGATION_NUMBER NUMBER 18 Performance obligation number.
PERF_OBLIGATION_LINE_NUMBER NUMBER 18 Running sequence number within a customer contract.
CUSTOMER_CONTRACT_ALLOC_STATUS VARCHAR2 30 Allocation status of the customer contract. Values are derived from the lookup type ORA_VRM_CONTRACT_ALLOCN_STATUS.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
EVENT_STATUS VARCHAR2 30 No longer used.
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.
SATISFACTION_PERIOD_PROPORTION NUMBER No longer used.
SATISFACTION_BASE_PROPORTION NUMBER No longer used.
POL_CONTR_CUR_BILLED_AMT NUMBER Billed amount in the ledger currency.
POL_ENTER_CUR_BILLED_AMT NUMBER Billed amount in the obligation currency.
POL_PROCESSED_SATISFACTION_QTY NUMBER Yes Satisfaction quantity of the processed satisfaction events.
POL_RUN_TOT_SATISFACTION_QTY NUMBER Yes Performance obligation line running total of the satisfied quantity.
POB_FIRST_EVENT_FLAG VARCHAR2 1 Yes Indicates whether the current event being processed is the first event after sorting based on the accounting date under the performance obligation. Active
POB_FIRST_SE_FLAG VARCHAR2 1 Yes Indicates whether the current event being processed is the first satisfaction event after sorting based on the accounting date under the performance obligation.
POB_FIRST_SE_PROCESSED_FLAG VARCHAR2 1 Yes Indicates whether the first satisfaction event after sorting based on the accounting date under the performance obligation is processed.
POL_FIRST_SE_FLAG VARCHAR2 1 Yes Indicates whether the current event being processed is the first satisfaction event after sorting based on the accounting date under the performance obligation line.
POL_FIRST_SE_PROCESSED_FLAG VARCHAR2 1 Yes Indicates whether the first satisfaction event after sorting based on the accounting date under the performance obligation line is processed. Active
POB_LAST_SE_FLAG VARCHAR2 1 Yes Indicates whether the current event being processed is the last satisfaction event after sorting based on the accounting date under the performance obligation. Active
SUBSTANTIAL_DIST_CREATED_FLAG VARCHAR2 1 Yes Indicates whether substantial performance work distributions are created.
POB_SATISFACTION_STATUS VARCHAR2 30 Satisfaction status of the performance obligation to which the current event belongs. Values are derived from the lookup type ORA_VRM_LINE_SATISFACTN_STATUS.
POB_SATISFACTION_DATE DATE Date on which the performance obligation is satisfied.
ENTER_TO_FUNC_CONV_RATE_DATE DATE No longer used.
POB_CONTR_RUN_TOT_ASSET_AMT NUMBER Yes Total debit contract asset amount on the performance obligation. Running total will be computed and used in the internal processing. Active
POB_CONTR_RUN_TOT_LIAB_AMT NUMBER Yes Total credit contract liability amount on the performance obligation. Running total will be computed and used in the internal processing. Active
POB_CONTR_RUN_TOT_DISCOUNT_AMT NUMBER Yes Total debit discount amount on the performance obligation. Running total will be computed and used in the internal processing. Active
MASTER_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created the row.
BATCH_NUMBER NUMBER 18 Identifies the batch to be processed. Active
ACCOUNTING_EVENT_STATUS VARCHAR2 30 Accounting event processing status.
CURRENT_SET_EVENT_SEQ_NUMBER NUMBER 18 Running sequence number per the performance obligation after sorting by the accounting date, performance obligation event type, and performance obligation line number. Used for internal processing. Active

Foreign Keys

Table Foreign Table Foreign Key Column
VRM_CREATE_EVENT_DISTS_INTERIM vrm_perf_obligation_lines PERF_OBLIGATION_LINE_ID
VRM_CREATE_EVENT_DISTS_INTERIM vrm_perf_obligations PERF_OBLIGATION_ID
VRM_CREATE_EVENT_DISTS_INTERIM vrm_customer_contract_headers CUSTOMER_CONTRACT_HEADER_ID
VRM_CREATE_EVENT_DISTS_INTERIM gl_ledgers LEDGER_ID

Indexes

Index Uniqueness Tablespace Columns Status
VRM_CRE_EVENT_DISTS_INT_N1 Non Unique Default MASTER_REQUEST_ID, BATCH_NUMBER, ACCOUNTING_EVENT_STATUS
VRM_CRE_EVENT_DISTS_INT_N2 Non Unique Default PERF_OBLIGATION_ID
VRM_CRE_EVENT_DISTS_INT_U1 Unique Default ACCOUNTING_EVENT_ID Active