CST_COST_DISTS_EVENTS_GT
Global temporary table used to update accounting status in the post create accounting hook program.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Yes | Reference to the transaction for which the distribution is created. | |
| ACCOUNTED_FLAG | VARCHAR2 | 1 | Indicates if the distribution has been accounted by the SLA. N - Not accounted, D - Draft Accounted, F - Final Accounted | ||
| EFF_DATE | TIMESTAMP | Effective date of the transaction. | |||
| COUNT_ACCOUNTED_FLAG | NUMBER | 18 | Count of distinct accounted flag after grouping by transaction id and effective date. |