CST_PERIOD_STATUSES_GT
Temporary table used within the distribution processor to get the period statuses from the Costing and GL. Both period statuses are used to validate the that the transactions for which the distributions are created fall in an open period.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Reference to the Cost Organization of the period | ||
| COST_BOOK_ID | NUMBER | 18 | Reference to Cost Book of the period | ||
| INV_ORG_ID | NUMBER | 18 | Reference to the Inventory organization of the period | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| PERIOD_NAME | VARCHAR2 | 60 | Indicates Costing Period name | ||
| STATUS_CODE | VARCHAR2 | 30 | Period status in costing. | ||
| PERIOD_START_DATE | DATE | Indicates Costing Period start date | |||
| PERIOD_END_DATE | DATE | Indicates Costing Period end date | |||
| GL_APPLICATION_ID | NUMBER | 18 | Application for which the GL Period status is stored. For now this is always GL ( 101) | ||
| GL_LEDGER_ID | NUMBER | 18 | Ledger ( corresponding to the Cost Book) for which the GL Period status is stored. | ||
| GL_CLOSING_STATUS | VARCHAR2 | 1 | GL Period Status | ||
| NEXT_OPEN_PERIOD_START_DATE | DATE | If the Costing period is final closed, this is the start date on the next available open costing period. | |||
| NEXT_OPEN_GL_CLOSING_STATUS | VARCHAR2 | 1 | The status of the GL period for the date in the next_open_period_start_date column. | ||
| NEXT_CST_PERIOD_STATUS | VARCHAR2 | 1 | The status of the costing period for the date in the next_open_period_start_date column. | ||
| PROCESS_START_DATE | DATE | Used in the reports processor to store the date and time when the reports processor starts processing. This field is used in filtering the data until this date. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_PERIOD_STATUSES_GT_N1 | Non Unique | COST_ORG_ID, COST_BOOK_ID, PERIOD_START_DATE, PERIOD_END_DATE |
| CST_PERIOD_STATUSES_GT_N2 | Non Unique | GL_LEDGER_ID, PERIOD_NAME |