MSC_PRCLST_COLLCYCLE_OPTNS
This table tracks the status of executing processes transactions on the destination server. The user interface and other user programs can determine the status of processes of interest by querying this table.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_PRCLST_COLLCYCLE_OPTN_PK |
CYCLE_OPTION_ID, MERGED_PRICE_LIST_NAME, MEMBER_PRICE_LIST_NAME |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| CYCLE_OPTION_ID | NUMBER | Yes | Sequence Generated Identifier, generated one per collection cycle | |
| MERGED_PRICE_LIST_NAME | VARCHAR2 | 80 | Yes | Name of the merged price list selected by user for the collections cycle |
| MERGED_PRICE_LIST_DESCRIPTION | VARCHAR2 | 240 | Description of the merged pricelist given by user | |
| MEMBER_PRICE_LIST_NAME | VARCHAR2 | 80 | Yes | Name of the price list which is part of the merged pricelist |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | 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 |
|---|---|---|---|
| MSC_PRCLST_COLLCYCLE_OPTNS_U1 | Unique | Default | CYCLE_OPTION_ID, MERGED_PRICE_LIST_NAME, MEMBER_PRICE_LIST_NAME |