OSS_RMCS_DOC_SUB_LINES_T
This table stores RMCS source document sub lines data.
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
OSS_RMCS_DOC_SUB_LINES_T_PK |
DOCUMENT_SUB_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_SUB_LINE_ID | NUMBER | 18 | Yes | Primary Key for document sublines. | |
| DOCUMENT_LINE_ID | NUMBER | 18 | Yes | Document line id. | |
| DOCUMENT_TYPE_ID | NUMBER | 18 | Unique identifier of a source document type in Oracle Revenue Management Cloud | ||
| DOC_LINE_ID_INT_1 | NUMBER | First numeric column of the key that identifies source document line in source application. | |||
| DOC_LINE_ID_CHAR_2 | VARCHAR2 | 30 | Second character column of the key that identifies source document line in source application. | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| SATISFACTION_MEASUREMENT_DATE | DATE | Start date. | |||
| SATISFACTION_EVENT_QUANTITY | NUMBER | Prouct Quantity. | |||
| PROCESSED_FLAG | VARCHAR2 | 1 | Flaf represents whether records are processed or not. | ||
| SATISFACTION_EVENT_PERCENT | NUMBER | Used to derive the percent of a satisfaction event when the satisfaction measurement model is Measure Percentage Satisfied. | |||
| DOC_SUB_LINE_TYPE | VARCHAR2 | 30 | Document sub line type. | ||
| 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of 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 |
|---|---|---|---|
| OSS_RMCS_DOC_SUB_LINES_T_N1 | Non Unique | Default | DOCUMENT_LINE_ID |
| OSS_RMCS_DOC_SUB_LINES_T_U1 | Unique | Default | DOCUMENT_SUB_LINE_ID |