CST_LYR_COSTS_S_GT
This table is used to temporarily store a subset of the data from cst_layer_costs table for internal processing within the cost processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_LYR_COSTS_S_GT_PK |
LAYER_COST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LAYER_COST_ID | NUMBER | 18 | Yes | Unique identifier for a layer 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 | Identifies the cost organization associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | 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 cost date of the transaction. | |||
| 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 and is set to 'USER' when the adjustment was done by the user; otherwise, it is set to null. | ||
| ABSORPTION_TYPE | VARCHAR2 | 30 | Indicates the absorption type. Possible values are: 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 | 5 | Yes | Indicates if the status of adjustment propagation. Possible values are: '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 are: 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. Possible values are: N = Not processed, NULL = Processed for onhand calculations. | ||
| DISTRIBUTION_ID | NUMBER | 18 | Identifies the cost distribution header record. | ||
| PERPAVG_COST_ID | NUMBER | 18 | Identifies the perpetual cost used for this row. | ||
| STD_COST_ID | NUMBER | 18 | Identifies the standard cost used for this row. | ||
| PERIODIC_COST_ID | NUMBER | 18 | Unique identifier for a periodic average cost row. | ||
| 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 the onhand value status. Possible values are: U-Unprocessed, P-Processed, X-Exclude, L-Latest. | ||
| 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_LYR_COSTS_S_GT_U1 | Unique | LAYER_COST_ID |