VRM_ACCOUNTING_EVENTS_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
VRM_ACCOUNTING_EVENTS_GT_PK |
ACCOUNTING_EVENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ACCOUNTING_EVENT_ID | NUMBER | 18 | Yes | Revenue management accounting event unique identifier. | |
| DOCUMENT_LINE_ID | NUMBER | 18 | Source document line unique identifier | ||
| ACCOUNTING_EVENT_TYPE_CODE | 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 | Yes | Accounting date of the accounting event. | ||
| AMOUNT | NUMBER | Accounting event amount in the performance obligation currency. | |||
| ACCTD_AMOUNT | NUMBER | Yes | Accounting event amount in the revenue contract currency. | ||
| CONTRACT_ACTIVITY_GROUP_ID | NUMBER | 18 | Customer contract activity group identifier. | ||
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Customer contract header unique identifier. | ||
| PERF_OBLIGATION_ID | NUMBER | 18 | Yes | Performance obligation unique identifier. | |
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Performance obligation line unique identifier. | ||
| DEVOLVED_PERF_OBLIG_DTL_ID | NUMBER | 18 | Oracle internal use only. Detailed devolved performance obligation unique record identifier. Value in this column is populated only for initial performance event type accounting events of devolved performance obligations. | ||
| REVERSED_FLAG | VARCHAR2 | 1 | Indicates if the accounting event was reversed. Blank indicates reversed. | ||
| REVERSED_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or marked this row as reversed. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of customer contract. | ||
| PROCESS_STATUS_CODE | VARCHAR2 | 30 | Accounting event processing status. Values are from the lookup ORA_ACCOUNTING_EVENT_STATUS. | ||
| PROCESSED_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that processed this row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| POB_FIRST_BE_FLAG | VARCHAR2 | 1 | Indicates whether the current event being processed is the first billing event after sorting based on the accounting date under the performance obligation. | ||
| POB_FIRST_SE_FLAG | VARCHAR2 | 1 | Indicates if current event being processed is the first satisfaction event after sorting based on the accounting date under the performance obligation line. | ||
| POB_ENTER_CUR_ALLOCATED_AMT | NUMBER | Total allocated transaction price in the performance obligation currency at the performance obligation level. | |||
| POB_CONTR_CUR_ALLOCATED_AMT | NUMBER | Total allocated transaction price in the revenue contract currency at the performance obligation level. | |||
| POB_TOTAL_AE_AMOUNT | NUMBER | Total accounting event amount for satisfaction events in the performance obligation currency at the performance obligation level. | |||
| POB_TOTAL_AE_ACCTD_AMOUNT | NUMBER | Total accounted satisfaction event amount in the contract currency at the performance obligation level. | |||
| DEVOLVED_PDL_AMOUNT | NUMBER | Oracle internal use only. Promised detail line amount that is apportioned by accounting period. This amount is used to compute the devolved performance obligation amount while creating a record in the devolved performance obligation details entity. | |||
| POL_CONTR_CUR_NET_CONSIDER_AMT | NUMBER | Oracle internal use only. Net consideration amount of the promised detail line in the contract currency. This amount is used to determine if there is any rounding difference. Sum total amount of the column value of DEVOLVED_PDL_AMOUNT is compared with the value of this column to determine the rounding difference amount. | |||
| DEVOLVE_PO_FLAG | VARCHAR2 | 1 | Oracle internal use only. Indicates if the performance obligation of this record is devolved. A performance obligation is devolved if the Devolve performance obligation option is set to Yes in either the performance obligation identification rule or the implied obligation template that was used during identification of the performance obligations. | ||
| SATISFACTION_PERIOD_START_DATE | DATE | Oracle internal use only. Start date of the satisfaction event period of a promised detail line. The value in this column is populated only for satisfaction event type accounting events that are related to promised detail lines with a satisfaction measurement model of Measure Period Satisfied. | |||
| ACCOUNTING_EVENT_SEQ_NUMBER | NUMBER | 18 | Sequence number of the accounting event record. | ||
| POB_LAST_EVENT_FLAG | VARCHAR2 | 1 | Indicates whether the current event being processed is the last satisfaction or billing event after sorting based on the accounting date under the performance obligation. | ||
| POL_LAST_SE_FLAG | VARCHAR2 | 1 | Oracle internal use only. Indicates whether the current accounting event is the last satisfaction event, after sorting it based on the accounting date under the promised detail line. For a promised detail line, if there is any rounding difference between the sum of the devolved line amount and the net consideration amount, the difference is adjusted on the accounting event when this column is set to Yes. | ||
| ACCOUNTING_EVENT_STATUS_CODE | VARCHAR2 | 30 | Oracle internal use only. Used during internal processing to identify whether the accounting event is newly created or not. | ||
| ALLOCATION_METHOD_CODE | VARCHAR2 | 30 | The allocation currency basis used to allocate and recognize revenue for a contract. Valid values are from the lookup type ORA_VRM_ALLOCATION_METHOD. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_ACCOUNTING_EVENTS_GT_N1 | Non Unique | REQUEST_ID |
| VRM_ACCOUNTING_EVENTS_GT_U1 | Unique | ACCOUNTING_EVENT_ID |