CST_WRITEOFF_COSTS_S_GT
This is a global temporary table used in internal processing within the cost processor to temporarily store Current Transactions and Overhead Costs.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WRITEOFF_COST_ID | NUMBER | 18 | Yes | Unique identifier for a writeoff cost. | |
| TRANSACTION_ID | NUMBER | 18 | Yes | Identifies the costing transaction. | |
| REC_TRXN_ID | NUMBER | 18 | Yes | Transaction identifier of a receipt transaction. | |
| DEP_TRXN_ID | NUMBER | 18 | Yes | Transaction identifier of a depleting transaction. | |
| COST_ELEMENT_ID | NUMBER | 18 | Yes | Cost element corresponding to the cost of the transaction. | |
| EXPENSE_POOL_ID | NUMBER | 18 | Yes | Identifies the expense pool of cost. | |
| EFF_DATE | TIMESTAMP | Yes | Date from which the cost is effective. | ||
| TRANSACTION_COST_ID | NUMBER | 18 | Yes | Unique identifier for a transaction cost. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory item identifier associated with cost. | |
| VAL_UNIT_ID | NUMBER | 18 | Yes | Valuation unit identifier associated with cost. | |
| COST_DATE | TIMESTAMP | Identifies the Transaction Cost Date. | |||
| PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | ||
| BASE_TXN_TYPE_ID | NUMBER | 18 | Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table. | ||
| COST_SOURCE | VARCHAR2 | 30 | Source from which the cost is used. | ||
| COST_REFERENCE | VARCHAR2 | 100 | Reference type of the cost used. | ||
| COST_TRANSACTION_TYPE | VARCHAR2 | 10 | Cost Transaction Type is used by the costing engine to categorize group processing. Set to 'ADJUST' for adjustments, null otherwise. | ||
| ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 240 | Additional Processing Code is an optional further definition of the Cost Transaction Type. It is used on adjustment transactions (Cost Transaction Type is set to 'ADJUST') and is set to 'USER' when the adjustment was done by the user; otherwise, it is set to null. | ||
| ABSORPTION_TYPE | VARCHAR2 | 30 | Absorption type: 1=Include in Inventory, 2=Expense. | ||
| QUANTITY | NUMBER | Quantity of the transaction layer. | |||
| UOM_CODE | VARCHAR2 | 25 | Unit of measure for the transaction quantity. | ||
| UNIT_COST | NUMBER | Current transaction cost for one quantity. | |||
| CURRENCY_CODE | VARCHAR2 | 30 | Yes | Identifies the currency of the transaction / cost. | |
| ADJ_POSTED_FLAG | VARCHAR2 | 1 | Yes | Indicates if the status of adjustment propagation: 'X' = Not applicable, 'N' = Adjustment not propagated, 'Y' = Adjustment Propagated. | |
| WO_COST_POSTED_FLAG | VARCHAR2 | 1 | Yes | Indicates if costs related to WIP have been transferred to CST_WORK_ORDER_COSTS. Possible values N - No, Y - Yes, X- Not required. | |
| SVC_WIP_ADJ_POSTED_FLAG | VARCHAR2 | 1 | Indicates the status of adjustment propagation on the service cost recognition or service cost recognition reversal transaction. Possible values are: N - Adjustment not propagated, Y - Adjustment propagated, NULL - Not applicable. | ||
| POSTED_FLAG | VARCHAR2 | 5 | Indicates the processing status of the transaction. Possible values are N-Not processed, Y-Processed, X-Excluded. | ||
| VAL_ONHAND_FLAG | VARCHAR2 | 1 | Indicates if the onhand calculations have been done for the layer. Values: N = Not processed, NULL = Processed for onhand calculations. | ||
| DISTRIBUTION_ID | NUMBER | 18 | Single column FK: Identifies the cost distribution header record. | ||
| ONHAND_VALUE | NUMBER | Contains the onhand value for the inventory at the time this layer was costed. The value is stored at the item/cost element level. | |||
| ONHAND_QUANTITY | NUMBER | Contains the onhand quantity of the inventory at the time this layer was costed. | |||
| ONHAND_VALUE_STATUS_FLAG | VARCHAR2 | 1 | Indicates onhand value status. U-Unprocessed, P-Processed, X-Exclude, L-Latest. | ||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| DISTRIBUTION_TYPE | VARCHAR2 | 30 | Indicates the distribution type. Useful if the same event type may go into different accounting line types; depending on some attribute on the cost. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_WRITEOFF_COSTS_S_GT_U1 | Unique | TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID, COST_ELEMENT_ID, EXPENSE_POOL_ID, EFF_DATE, COST_TRANSACTION_TYPE, ADDITIONAL_PROCESSING_CODE, ABSORPTION_TYPE |
| CST_WRITEOFF_COSTS_S_GT_U2 | Unique | WRITEOFF_COST_ID |