CST_PRIOR_PERIOD_TXNS_GT
This transaction temporary table is used to hold the transactions that are from prior period and need to be moved to current open period.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: DEFAULT
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Surrogate ID identifying a transaction in costing. | |
| COST_OWNED_FLAG | VARCHAR2 | 1 | Flag that indicates if the transaction is cost owned or cost derived. Valid values are Y and N. | |
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Surrogate ID indicating the transaction source. | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | Surrogate ID indicating the transaction action. | |
| PERIOD_NAME | VARCHAR2 | 15 | Indicates the current period for which the process is executed. | |
| CONSIGNED_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is consigned or owned. |