CST_PAC_TXN_INFO_GT
This session global temporary table is used to store the cost organization, PAC cost book and transaction level information for the active request.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Identifies the cost organization associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Identifies the cost book assigned to the cost organization. | |
| ID_NUM_1 | NUMBER | 18 | Surrogate numeric identifier of the transaction. | |
| PERIOD_NAME | VARCHAR2 | 15 | Indicates the costing period in which the transaction is processed. | |
| PAC_TXN_GROUP_ID | NUMBER | 18 | Unique identifier for the set of transactions for incremental processing. | |
| RESET_FLAG | VARCHAR2 | 1 | Indicates if the transaction needs delete/reset activity. Possible values are: Null: The transaction does not require delete/reset. Y: The transaction requires delete/reset. | |
| ID_NUM_2 | NUMBER | 18 | Surrogate numeric identifier of the transaction. |