VRM_PERF_OBLIG_LIN_SPLITS_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_SPLIT_GT_PK |
PERF_OBLIGATION_LINE_SPLIT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERF_OBLIGATION_LINE_SPLIT_ID | NUMBER | 18 | Yes | Performance obligation line split unique identifier. | |
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Performance obligation line unique identifier. | ||
| DOCUMENT_LINE_ID | NUMBER | 18 | Internal unique identifier of a source document line. | ||
| DOCUMENT_SUB_LINE_ID | NUMBER | 18 | Internal identifier of the source document subline. | ||
| SALESREP_ID | NUMBER | 18 | Unique identifier of a salesperson. | ||
| REVENUE_SPLIT_PERCENT | NUMBER | Percentage of the revenue split line. | |||
| REVENUE_SPLIT_AMOUNT | NUMBER | Revenue amount for the split line. | |||
| REVENUE_SPLIT_BASIS_CODE | VARCHAR2 | 30 | Basis on which revenue is split. Values are from the lookup type VRM_REV_LINE_SPLIT_REASON. | ||
| REVENUE_SPLIT_DATE | DATE | Date when the split of a performance obligation line are created. | |||
| REVENUE_SPLIT_LINE_NUMBER | NUMBER | 18 | Revenue split line number. | ||
| REVENUE_ACCOUNT_CCID | NUMBER | 18 | Code combination identifier of the revenue split account. | ||
| BU_ID | NUMBER | 18 | The identifier of the business unit associated to the row. | ||
| COMMENTS | VARCHAR2 | 1000 | Manually entered comments for the revenue line split. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_POL_SPLIT_GT_N1 | Non Unique | PERF_OBLIGATION_LINE_ID |
| VRM_POL_SPLIT_GT_U1 | Unique | PERF_OBLIGATION_LINE_SPLIT_ID |