CST_PERIOD_CLOSE_ACTIONS
Table for keeping track of log of period close actions.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_PERIOD_CLOSE_ACTIONS_PK |
RUN_ID, COST_ORG_ID, COST_BOOK_ID, PERIOD_NAME |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RUN_ID | NUMBER | 18 | Yes | Request Id of the job submitted. | |
| PENDING_ACCOUNTING_EVENTS | VARCHAR2 | 1 | Flag to indicate the Pending Accounting Events Creation Validation. | ||
| PENDING_INTERFACE_TXNS | VARCHAR2 | 1 | Flag to indicate the Pending Interface transactions validation. | ||
| COMPL_WO_NOT_CLOSED | VARCHAR2 | 1 | Flag to indicate the Completed Work Orders Not Closed Validation. | ||
| COMPL_WO_PENDING_COUNT | NUMBER | Count of completed WO not closed. | |||
| PENDING_OH_RATES_ABSORPTION | VARCHAR2 | 1 | Flag to indicate Pending Accounting Overhead Rates Absorption validation. | ||
| PEND_OH_RATES_ABS_COUNT | NUMBER | Count of Overhead Rules that are not yet processed. | |||
| PENDING_SCENARIO_ABSORPTION | VARCHAR2 | 1 | Flag to indicate pending scenario absorption validation. (Y indicates validations for pending scenarios would be performed / N indicates validations for pending scenarios would not be performed) | ||
| PEND_SCENARIO_ABS_COUNT | NUMBER | Count of scenarios that are not yet processed. | |||
| PEND_ACCT_EVENTS_COUNT | NUMBER | Count of transactions for which accounting event creation is pending. | |||
| COST_ORG_ID | NUMBER | 18 | Yes | Single column Foreign Key: Identifies the Cost Organization associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Single column Foreign Key: Identifies the Cost Book assigned to the Cost Organization. | |
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Current Period Name for which the validations are run. | |
| FROM_STATUS_CODE | VARCHAR2 | 30 | Yes | Current status code of the period for which validation is run. | |
| PROCESS_START_DATE | TIMESTAMP | Start time at which this process was run. | |||
| TO_STATUS_CODE | VARCHAR2 | 30 | Status code for which validation was run. (C - closed/ F- Permanently closed/ R - Run Validation) | ||
| PROCESS_STATUS_CODE | VARCHAR2 | 30 | This shows the status of the submitted job. | ||
| CST_INV_ONHAND_MISMATCH_QTY | NUMBER | Items with costing and inventory on hand mismatch. | |||
| INV_PENDING_COUNT | NUMBER | Count of pending preprocessing transactions. | |||
| WIP_PENDING_COUNT | NUMBER | Count of WIP transactions pending preprocessing. | |||
| CITE_PENDING_COUNT | NUMBER | Count of trade event interface transactions pending preprocessing. | |||
| CTE_PENDING_COUNT | NUMBER | Count of trade event transactions pending preprocessing. | |||
| INV_ERRORS_COUNT | NUMBER | Count of inventory error transactions. | |||
| UNCOSTED_TXN_COUNT | NUMBER | Count of transactions which are pending for cost processing. | |||
| DISTRIBUTION_PENDING_COUNT | NUMBER | Count of Distributions that are not processed. | |||
| DISTRIBUTION_ERRORS_COUNT | NUMBER | Count of Distributions with errors. | |||
| JOURNALS_PENDING_COUNT | NUMBER | Count of transactions which are pending for accounting. | |||
| PENDING_INTF_TXN_COUNT | NUMBER | Count of transactions that are yet to be interfaced. | |||
| JOURNALS_ERRORS_COUNT | NUMBER | Count of transactions with Accounting in error. | |||
| AR_PENDING_COUNT | NUMBER | Count of transactions which are pending for revenue recognition events import. | |||
| AR_ERRORS_COUNT | NUMBER | Count of errored revenue recognition events. | |||
| 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. | ||
| UNIMPORTED_INV_TRANSACTIONS | VARCHAR2 | 1 | Flag to indicate the Pending Preprocessing validation. | ||
| UNCOSTED_TRANSACTIONS | VARCHAR2 | 1 | Flag to indicate the Pending cost Processing validation. | ||
| UNPROCESSED_DISTRIBUTIONS | VARCHAR2 | 1 | Flag to indicate Unprocessed Distributions Validation. | ||
| UNPROCESSED_JOURNALS | VARCHAR2 | 1 | Flag to indicate Pending create accounting in final mode validation. | ||
| PENDING_DCOGS_TRANSACTIONS | VARCHAR2 | 1 | Flag for pending revenue recognition import. | ||
| MATCH_INV_ONHAND_WITH_CST | VARCHAR2 | 1 | Flag for items with costing and inventory on hand mismatch. | ||
| VALIDATION_CLOSE_SOURCE | VARCHAR2 | 30 | Indicates the source where the period close process was triggered. Valid values are contained in lookup type ORA_CST_PERIOD_CLOSE_SOURCE. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_PERIOD_CLOSE_ACTIONS | cst_cost_org_books | COST_ORG_ID, COST_BOOK_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_PERIOD_CLOSE_ACTIONS_N1 | Non Unique | Default | COST_ORG_ID, COST_BOOK_ID, PERIOD_NAME |
| CST_PERIOD_CLOSE_ACTIONS_U1 | Unique | Default | RUN_ID, COST_ORG_ID, COST_BOOK_ID, PERIOD_NAME |