QP_MATRIX_RULES_INT
Interface table for matrix rules table
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
QP_MATRIX_RULES_INT_PK |
MATRIX_RULE_INT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MATRIX_RULE_INT_ID | NUMBER | Yes | Value that uniquely identifies the matrix rule in the interface table. | ||
| OPERATION_CODE | VARCHAR2 | 30 | Value that identifies the operation to perform on the matrix rules. | ||
| SOURCE_ROOT_PARENT_ID | VARCHAR2 | 240 | Value that uniquely identifies the parent entity in the source system. For example, for discount list, it will be the discount list ID. | ||
| SOURCE_MATRIX_ID | VARCHAR2 | 240 | Value that uniquely identifies the matrix in the source system. | ||
| SOURCE_RULE_ID | VARCHAR2 | 240 | Value that uniquely identifies the matrix rule in the source system. | ||
| VALUE_STRING1 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING2 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING3 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING4 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING5 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING6 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING7 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING8 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING9 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING10 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING11 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING12 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING13 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING14 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING15 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING16 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING17 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING18 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING19 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING20 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING21 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING22 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING23 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING24 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| VALUE_STRING25 | VARCHAR2 | 100 | This column holds the value of the dimension. | ||
| START_DATE | TIMESTAMP | Start date of the defined matrix rule. | |||
| END_DATE | TIMESTAMP | End date of the defined matrix rule. | |||
| CODE_STRING1 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING2 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING3 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING4 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING5 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING6 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING7 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING8 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING9 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING10 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING11 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING12 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING13 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING14 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING15 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING16 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING17 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING18 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING19 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING20 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING21 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING22 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING23 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING24 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| CODE_STRING25 | VARCHAR2 | 100 | Code or Id of the dimension. This is an internal attribute. | ||
| DYNAMIC_MTX_RULE_GUID | VARCHAR2 | 64 | This is a unique identifier generated for the matrix rules (GUID). | ||
| INTERFACE_STATUS | VARCHAR2 | 30 | Status of the record, such as New, Error, Updated, Imported, and Validated. | ||
| LOAD_REQUEST_ID | NUMBER | Unique ID of the Load ESS job used to import into an interface table. | |||
| BATCH_NAME | VARCHAR2 | 50 | Identifies the batch to be processed. | ||
| SUB_BATCH_NAME | VARCHAR2 | 80 | Identifies the sub batch to be processed. | ||
| BATCH_ATTRIBUTE_CHAR1 | VARCHAR2 | 50 | Generic column to store information related to batching logic. | ||
| BATCH_ATTRIBUTE_CHAR2 | VARCHAR2 | 50 | Generic column to store information related to batching logic. | ||
| DYNAMIC_MATRIX_ID | NUMBER | 18 | Number that uniquely identifies the matrix. The application updates this value based on Source Matrix Id and is used internally. | ||
| BATCH_ID | NUMBER | 18 | Value that identifies the pricing batch to process. | ||
| BATCH_JOB_ID | NUMBER | 18 | Value that identifies the records in the batch that belong to the current run.This is the request id of the parent ESS job. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| MATRIX_RULE_ID | NUMBER | ID of the row created for matrix rule after successful import. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created 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 |
|---|---|---|---|
| QP_MATRIX_RULES_INT_N1 | Non Unique | FUSION_TS_TX_IDX | LOAD_REQUEST_ID, SOURCE_MATRIX_ID, SOURCE_ROOT_PARENT_ID |
| QP_MATRIX_RULES_INT_N2 | Non Unique | FUSION_TS_TX_IDX | BATCH_ID, BATCH_JOB_ID, SUB_BATCH_NAME, SOURCE_MATRIX_ID, SOURCE_ROOT_PARENT_ID |
| QP_MATRIX_RULES_INT_U1 | Unique | FUSION_TS_TX_IDX | MATRIX_RULE_INT_ID |