CST_CP_DRIVERS_ARCHIVE
This table stores the historical records that are purged from the cst_cp_drivers table. Contains the detail level parameters used by the individual processors and is created and maintained by the Cost Process main program.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: DEFAULT
Primary Key
| Name | Columns |
|---|---|
|
CST_CP_DRIVERS_ARCHIVE_PK |
REQ_ID, COST_ORG_ID, COST_BOOK_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQ_ID | NUMBER | 18 | Yes | ESS request Identifier of the process that created this record. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | |
| COST_CUTOFF_FLAG | VARCHAR2 | 1 | Yes | Indicates the cost cutoff option specified by the user and to be used during the Cost Process. It is specified for each cost organization book on the request. U - User-Defined, A - Auto. The LOOKUP_TYPE for these values is CST_COST_CUTOFF_FLAG. | |
| COST_CUTOFF_DATE | TIMESTAMP | Yes | Identifies the cost cutoff date by cost organization and book for the request. | ||
| SERVER_TZ_COST_CUTOFF_DATE | TIMESTAMP | Cost Cutoff Date in Server time zone. | |||
| STATUS | VARCHAR2 | 1 | Yes | Indicates the processing status of the request by cost organization book. A - Active, C - Complete, I - Incomplete, B - Blocked, E - Error, S - Setup data missing. There is no LOOKUP_TYPE for these codes. | |
| BLOCKING_REQUEST_ID | NUMBER | 18 | Indicates the blocking request identifier for which a cost organization book is already being processed on an active run. | ||
| 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. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Period for which cost processor is run. This value is populated for the transactions in periodic average cost method. | ||
| PERIODIC_AVERAGE_FLAG | VARCHAR2 | 1 | Flag to identify if the cost book is periodic average cost book. | ||
| PERIOD_START_DATE | DATE | Identifies start date of costing period. | |||
| PAC_ERROR_FLAG | VARCHAR2 | 2 | Flag to track different validation errors for periodic average cost book. | ||
| TRANSFER_DISABLED_FLAG | VARCHAR2 | 1 | Flag determines if transfers processing should be disabled. Possible values are Y, NULL. | ||
| CURRENCY_ROUNDING_RULE | VARCHAR2 | 30 | Indicates how amount will be rounded when rounding is performed. Possible Values are: Up: The amount will be rounded up, Down: The amount will be rounded down, Nearest: The amount will be rounded to the nearest number. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_CP_DRIVERS_ARCHIVE_N1 | Non Unique | DEFAULT | REQ_ID, STATUS, COST_ORG_ID, COST_BOOK_ID |
| CST_CP_DRIVERS_ARCHIVE_U1 | Unique | DEFAULT | REQ_ID, COST_ORG_ID, COST_BOOK_ID |