VRM_CONTR_CARVEOUT_HDRS_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_HEADER_ID | NUMBER | 18 | Yes | Performance obligation discount unique identifier. | |
| CUSTOMER_CONTRACT_HEADER_ID | NUMBER | 18 | Customer contract header unique identifier. | ||
| PERF_OBLIGATION_ID | NUMBER | 18 | Performance obligation line unique identifier. | ||
| TOTAL_CARVEOUT_AMOUNT | NUMBER | Total discount amount of the performance obligation. | |||
| PREV_CONTR_CARVEOUT_HEADER_ID | NUMBER | 18 | Previous performance obligation 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 or not. Possible values are Yes or No. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_CONTR_CO_HDRS_GT_N1 | Non Unique | CUSTOMER_CONTRACT_HEADER_ID |
| VRM_CONTR_CO_HDRS_GT_N2 | Non Unique | PERF_OBLIGATION_ID, DISPLAY_FLAG |