VRM_CONTR_CARVEOUT_LINES_GT
Oracle internal use only. This global temporary table is used in identify customer contracts job during internal processing.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONTRACT_CARVEOUT_LINE_ID | NUMBER | 18 | Yes | Performance obligation line discount unique identifier. | |
| PERF_OBLIGATION_LINE_ID | NUMBER | 18 | Yes | Performance obligation line unique identifier. | |
| CONTRACT_CARVEOUT_HEADER_ID | NUMBER | 18 | Performance obligation discount unique identifier. | ||
| CARVEOUT_AMOUNT | NUMBER | Discount amount of the performance obligation line. | |||
| PARENT_CONTR_CARVEOUT_LINE_ID | NUMBER | 18 | Previous performance obligation line discount unique identifier. | ||
| REVERSED_FLAG | VARCHAR2 | 1 | Indicates whether a discount is reversed. | ||
| DISPLAY_FLAG | VARCHAR2 | 1 | Indicate whether this is the latest discount applied on the performance obligation line or not. Possible values are Yes or No. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_CONTR_CO_LINES_GT_N1 | Non Unique | CONTRACT_CARVEOUT_HEADER_ID |
| VRM_CONTR_CO_LINES_GT_N2 | Non Unique | PERF_OBLIGATION_LINE_ID, DISPLAY_FLAG |