VRM_PERF_OBLIG_LIN_DISTS_GT
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_POL_DISTS_GT_PK |
PERF_OBLIGATION_LINE_DIST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| PERF_OBLIGATION_LINE_DIST_ID | NUMBER | 18 | Yes | Performance obligation line distribution unique identifier. | ||
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Performance obligation line unique identifier. | |||
| PERF_OBLIGATION_LINE_SPLIT_ID | NUMBER | 18 | Performance obligation line split unique identifier. | |||
| ACCOUNTING_EVENT_ID | NUMBER | 18 | Revenue management accounting event unique identifier for which this distribution is created. | |||
| POL_SATISFACTION_EVENT_ID | NUMBER | 18 | No longer used. | |||
| POL_BILLING_EVENT_ID | NUMBER | 18 | No longer used. | |||
| ACCOUNT_CLASS | VARCHAR2 | 30 | Account class of the distribution. Values are from the lookup type ORA_CONTRACT_DIST_CLASS. | |||
| ACCOUNTING_DATE | DATE | Accounting date of the distribution. | ||||
| AMOUNT | NUMBER | Distribution amount in the entered currency. | ||||
| ACCTD_AMOUNT | NUMBER | Distribution amount in the ledger currency. | ||||
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Customer contract header unique identifier. | |||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of customer contract. | |||
| CODE_COMBINATION_ID | NUMBER | 18 | Code combination of a distribution flexfield. | |||
| POSTED_TO_SLA_FLAG | VARCHAR2 | 1 | NA | Obsolete | ||
| POSTING_CONTROL_ID | NUMBER | 18 | NA | Obsolete | ||
| POSTED_TO_SLA_DATE | DATE | NA | Obsolete | |||
| EVENT_ID | NUMBER | 18 | Subledger accounting event unique identifier. | |||
| ORIGINAL_ACCOUNTING_DATE | DATE | Original accounting date of the distribution. | ||||
| PERF_OBLIGATION_ID | NUMBER | 18 | Performance obligation to which this this distribution belongs to. | |||
| CONCATENATED_SEGMENTS | VARCHAR2 | 1000 | An identifier of the accounting flexfield for the current distribution. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| POL_EVENT_TYPE | VARCHAR2 | 30 | No longer used. | |||
| 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_POL_DISTS_GT_N1 | Non Unique | ACCOUNTING_EVENT_ID |
| VRM_POL_DISTS_GT_U1 | Unique | PERF_OBLIGATION_LINE_DIST_ID |