QP_MATRIX_DIMENSIONS_INT
Interface Table for Matrix Dimensions
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
QP_MATRIX_DIMENSIONS_INT_PK |
MATRIX_INT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
MATRIX_INT_ID | NUMBER | Yes | Value that uniquely identifies the matrix dimension in the interface table. | ||
FILTER_COLUMN_ORDER | NUMBER | This column stores the order in which the dimensions needs to be evaluated in case there are filtered dimensions in a given batch. | |||
OPERATION_CODE | VARCHAR2 | 30 | Value that identifies the operation to perform on the matrix dimensions. | ||
SOURCE_ROOT_PARENT_ID | VARCHAR2 | 240 | Value that uniquely identifies the parent entity in the source system. For discount list, it will be the discount list ID. | ||
SOURCE_PARENT_ID | VARCHAR2 | 240 | Value that uniquely identifies the parent for this matrix in the source system. For example, for discount list, it will be the pricing term ID. | ||
SOURCE_MATRIX_ID | VARCHAR2 | 240 | Value that uniquely identifies the matrix in the source system. | ||
DIMENSION_NAME | VARCHAR2 | 100 | Name of the dimension for the matrix. | ||
DIMENSION_TYPE | VARCHAR2 | 50 | Type of the dimension for the matrix. Applicable values are condition or result. | ||
MAP_TO_RULE_COLUMN | VARCHAR2 | 30 | Column in the rules table to which the dimension is mapped. | ||
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. | ||
WEIGHT | NUMBER | 18 | Internally calculated attribute based on the predefined importance of the child records in a pricing batch. This attribute is used to determine weight of the item and helps batching the items so that the weight is distributed equally. | ||
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_ID | NUMBER | 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. | ||
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_DIMENSIONS_INT_N1 | Non Unique | FUSION_TS_TX_IDX | BATCH_ID, BATCH_JOB_ID, SUB_BATCH_NAME, SOURCE_MATRIX_ID, SOURCE_ROOT_PARENT_ID |
QP_MATRIX_DIMENSIONS_INT_N2 | Non Unique | FUSION_TS_TX_IDX | LOAD_REQUEST_ID, SOURCE_PARENT_ID, SOURCE_ROOT_PARENT_ID |
QP_MATRIX_DIMENSIONS_INT_U1 | Unique | FUSION_TS_TX_DATA | MATRIX_INT_ID |