CST_LAYER_COSTS
Current Transactions and Overhead Costs.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_LAYER_COSTS_PK |
LAYER_COST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| LAYER_COST_ID | NUMBER | 18 | Yes | Unique identifier for a layer cost. | Active | |
| TRANSACTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the costing transaction. | Active | |
| REC_TRXN_ID | NUMBER | 18 | Yes | Transaction identifier of a receipt transaction. | Active | |
| DEP_TRXN_ID | NUMBER | 18 | Yes | Transaction identifier of a depleting transaction. | Active | |
| COST_ELEMENT_ID | NUMBER | 18 | Yes | Cost element corresponding to the cost of the transaction. | Active | |
| EXPENSE_POOL_ID | NUMBER | 18 | Yes | Identifies the expense pool of cost. | Active | |
| EFF_DATE | TIMESTAMP | Yes | Date from which the cost is effective. | Active | ||
| TRANSACTION_COST_ID | NUMBER | 18 | Yes | Single column FK: Identifies the transaction cost. | Active | |
| COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization associated with the inventory organization. | Active | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | Active | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory item identifier associated with cost. | Active | |
| VAL_UNIT_ID | NUMBER | 18 | Yes | Valuation unit identifier associated with cost. | Active | |
| COST_DATE | TIMESTAMP | Cost date used for processing transaction. | Active | |||
| 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. | Active | ||
| 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. | Active | ||
| 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. | Active | ||
| ABSORPTION_TYPE | VARCHAR2 | 30 | Overhead Absorption Rule: 1=Include In Inventory Value, 2=Expense. | Active | ||
| QUANTITY | NUMBER | Quantity of the transaction layer. | Active | |||
| UOM_CODE | VARCHAR2 | 25 | Unit of measure for the transaction quantity. | Active | ||
| UNIT_COST | NUMBER | Current transaction cost for one quantity. | Active | |||
| CURRENCY_CODE | VARCHAR2 | 30 | Yes | Identifies the currency of the transaction / cost. | Active | |
| ADJ_POSTED_FLAG | VARCHAR2 | 5 | 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. | ||
| POSTED_FLAG | VARCHAR2 | 5 | Indicates the processing status of the transaction. Possible values are N-Not processed, Y-Processed, X-Excluded. | Active | ||
| 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. | Active | ||
| 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. | |||
| 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. | Active | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | Active | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | Active | ||
| 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. | |||
| PERIODIC_COST_ID | NUMBER | 18 | Unique identifier for a periodic average cost row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_LAYER_COSTS | cst_transactions | TRANSACTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| CST_LAYER_COSTS_N1 | Non Unique | FUSION_TS_TX_DATA | TRANSACTION_ID | Obsolete |
| CST_LAYER_COSTS_N10 | Non Unique | Default | VAL_ONHAND_FLAG, COST_ORG_ID, COST_BOOK_ID, TRUNC("COST_DATE") | |
| CST_LAYER_COSTS_N2 | Non Unique | FUSION_TS_TX_DATA | POSTED_FLAG | |
| CST_LAYER_COSTS_N3 | Non Unique | FUSION_TS_TX_DATA | DISTRIBUTION_ID | |
| CST_LAYER_COSTS_N4 | Non Unique | FUSION_TS_TX_DATA | COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID, COST_DATE | |
| CST_LAYER_COSTS_N5 | Non Unique | FUSION_TS_TX_DATA | ADJ_POSTED_FLAG | |
| CST_LAYER_COSTS_N6 | Non Unique | FUSION_TS_TX_DATA | REC_TRXN_ID, EFF_DATE | |
| CST_LAYER_COSTS_N7 | Non Unique | Default | ONHAND_VALUE_STATUS_FLAG | |
| CST_LAYER_COSTS_N8 | Non Unique | Default | WO_COST_POSTED_FLAG, COST_ORG_ID, COST_BOOK_ID | |
| CST_LAYER_COSTS_N9 | Non Unique | Default | REQUEST_ID, STD_COST_ID, COST_DATE | |
| CST_LAYER_COSTS_PK | Unique | FUSION_TS_TX_DATA | LAYER_COST_ID | Active |
| CST_LAYER_COSTS_U1 | Unique | FUSION_TS_TX_DATA | TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID, COST_ELEMENT_ID, EXPENSE_POOL_ID, EFF_DATE | Active |