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 |