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 |