VRM_FP_DATA_SETS_INTERIM
VRM_FP_DATA_SETS_INTERIM contains price basis data sets, which are in the process of FMV calculation.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TEMPLATE_ID | NUMBER | 18 | Internal identifier of the template. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code of the data set. | ||
| COVERAGE_RANGE_START_DATE | DATE | Start date of a coverage period. | |||
| COVERAGE_RANGE_END_DATE | DATE | End date of a coverage period. | |||
| SET_STATUS | VARCHAR2 | 30 | Status of a Price Basis Data Set. Values are from the lookup VRM_VSOE_PRICE_SETS_STATUS. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_FP_DATA_SETS_INTERIM_N1 | Non Unique | Default | REQUEST_ID |