CMR_TXN_CHUNKS
This table is used to store range of keys to be used for processing the data by chunks. Once the data is processed, corresponding chunk is removed from the table.
Details
-
Schema: FUSION
-
Object owner: CMR
-
Object type: TABLE
-
Tablespace: DEFAULT
Primary Key
| Name | Columns |
|---|---|
|
CMR_TXN_CHUNKS_PK |
CHUNK_TYPE, CHUNK_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CHUNK_ID | NUMBER | 18 | Yes | This column identifies a unique chunk within a chunk type. | |
| CHUNK_TYPE | VARCHAR2 | 30 | Yes | This column is used to group different chunks for processing based on purchase order, transfer order or inventory flow. | |
| LOW_KEY | NUMBER | 18 | Yes | This column identifies the lower range of surrogate key based on the type of chunk. | |
| HIGH_KEY | NUMBER | 18 | Yes | This column identifies the upper range of surrogate key based on the type of chunk. | |
| 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 |
|---|---|---|---|
| CMR_TXN_CHUNKS_U1 | Unique | DEFAULT | CHUNK_TYPE, CHUNK_ID |