CST_CP_DRIVERS
Contains the detail level parameters used by the individual processors and is created and maintained by the Cost Process main program. This table is used apart from ESS request data and is used internally by the cost process to drive the background processing.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: DEFAULT
Primary Key
| Name | Columns |
|---|---|
|
CST_CP_DRIVERS_PK |
REQUEST_ID, COST_ORG_ID, COST_BOOK_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |
| 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 | DATE | Yes | Identifies the cost cutoff date by cost organization and book for the request. | ||
| SERVER_TZ_COST_CUTOFF_DATE | DATE | 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. | ||
| 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. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_CP_DRIVERS | cst_cp_requests | REQUEST_ID |
| CST_CP_DRIVERS | cst_cost_books_b | COST_BOOK_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_CP_DRIVERS_N1 | Non Unique | DEFAULT | REQUEST_ID, STATUS, COST_ORG_ID, COST_BOOK_ID |
| CST_CP_DRIVERS_N2 | Non Unique | DEFAULT | STATUS, JOB_DEFINITION_NAME |
| CST_CP_DRIVERS_U1 | Unique | Default | REQUEST_ID, COST_ORG_ID, COST_BOOK_ID |