VRM_CREATE_EVENT_DISTS_GT
Oracle internal use only. This global temporary table is used in revenue recognition job during internal processing.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
VRM_CRE_EVENT_DISTS_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. | |
| ACCOUNTING_EVENT_TYPE_CODE | VARCHAR2 | 30 | Accounting event type. Values are from the lookup VRM_ACCOUNTING_EVENT_TYPE. | ||
| REFERENCE_EVENT_ID | NUMBER | 18 | Reference to the identifier of the event that triggered the accounting event. | ||
| ACCOUNTING_DATE | DATE | Accounting date of the accounting event. | |||
| ORIGINAL_ACCOUNTING_DATE | DATE | Original accounting date of the accounting event. | |||
| AMOUNT | NUMBER | Accounting event amount in performance obligation currency. | |||
| ACCTD_AMOUNT | NUMBER | Accounting event amount in customer contract currency. | |||
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Performance obligation line unique identifier. | ||
| PERF_OBLIGATION_ID | NUMBER | 18 | Performance obligation unique identifier. | ||
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Customer contract header unique identifier. | ||
| CUSTOMER_CONTRACT_NUMBER | NUMBER | 18 | Customer contract number. This is a running sequence number. | ||
| CUSTOMER_CONTRACT_DATE | DATE | Customer contract date. Used for deriving price effectivity period of the customer contract. | |||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity of the customer contract. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifer of the customer contract. | ||
| INITIAL_PERF_EVT_CREATED_FLAG | VARCHAR2 | 1 | Indicates if the initial performance accounting event was created. | ||
| POL_NET_LINE_AMT | NUMBER | Net line amount of performance obligation line. | |||
| POL_CONTR_CUR_ALLOCATED_AMT | NUMBER | Allocated transaction price of performance obligation line in the contract currency. | |||
| POL_CONTR_CUR_CARVE_OUT_AMT | NUMBER | Discount amount of performance obligation line in the contract currency. | |||
| POL_ENTERED_CUR_BILLED_AMT | NUMBER | Billed amount of performance obligation line in the entered currency. | |||
| POL_LAST_BE_FLAG | VARCHAR2 | 1 | Indicates whether the current event being processed is the last billing event after sorting based on the accounting date under the performance obligation line. | ||
| CONTRACT_CURRENCY | VARCHAR2 | 30 | Ledger currency of customer contract. | ||
| CONTRACT_CURRENCY_MAU | NUMBER | Minimum accountable unit for the contract currency. | |||
| CONTRACT_CURRENCY_PRECISION | NUMBER | 1 | Precision for the contract currency. | ||
| ENTER_TO_CONTR_CONV_RATE_TYPE | VARCHAR2 | 30 | Oracle Internal use only. | ||
| ENTER_TO_CONTR_CONV_RATE | NUMBER | Oracle Internal use only. | |||
| ENTER_TO_CONTR_CONV_RATE_DATE | DATE | Oracle Internal use only. | |||
| ENTERED_CURRENCY | VARCHAR2 | 30 | Entered currency of the performance obligation line. | ||
| SLA_EVENT_CREATION_MODE | VARCHAR2 | 30 | Oracle Internal use only. | ||
| 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. | ||
| CONVERSION_RATE_AVAILABLE_FLAG | VARCHAR2 | 1 | Indicates that the conversion rate is available for the conversion rate date. Possible values are Null or N. Null indicates conversion rate is available. | ||
| PROCESS_STATUS_CODE | VARCHAR2 | 30 | Accounting event processing status. Values are from the lookup type ORA_ACCOUNTING_EVENT_STATUS. | ||
| POL_ENTER_CURR_ALLOCATED_AMT | NUMBER | Allocated transaction price of the performance obligation line in the entered currency. | |||
| POL_ENTER_CURR_CARVE_OUT_AMT | NUMBER | Discount amount of the performance obligation line in the entered currency. | |||
| FOREIGN_CURR_TREATMENT_CODE | VARCHAR2 | 30 | The currency conversion treatment used for contract liability accounting distributions when processing foreign currency performance obligations for the ledger. Valid values are from the lookup type ORA_VRM_FX_CURR_TREATMENT. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_CRE_EVENT_DISTS_GT_N1 | Non Unique | ACCOUNTING_EVENT_TYPE_CODE |
| VRM_CRE_EVENT_DISTS_GT_N2 | Non Unique | POL_LAST_BE_FLAG |
| VRM_CRE_EVENT_DISTS_GT_N3 | Non Unique | SLA_EVENT_CREATION_MODE |
| VRM_CRE_EVENT_DISTS_GT_U1 | Unique | ACCOUNTING_EVENT_ID |