1. Tables and Views for SCM
  2. CST_LAYER_COSTS_I_GT

CST_LAYER_COSTS_I_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_LAYER_COSTS_I_GT_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
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 Identifies the source of the cost, such as Purchase Order (PO) or Accounts Payable (AP). The LOOKUP_TYPE for these values is CST_COST_SOURCES.
COST_REFERENCE VARCHAR2 100 Identifies a specific business object or value that further refines the cost source information, such as the source cost organization identifier or an effective date.
COST_TRANSACTION_TYPE VARCHAR2 10 Cost Transaction Type is used by the costing engine to categorize group processing. Set to 'ADJUST' for adjustments. 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 Posted Flag indicating if the distributions have been created for this rows. Active
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.
PERIOD_NAME VARCHAR2 15 Period in which the inventory valuation will be calculated.
START_DATE DATE Indicates Costing Period start date.
END_DATE DATE Indicates Costing Period end date.
PERIODIC_COST_ID NUMBER 18 Unique identifier for a periodic average cost row.

Indexes

Index Uniqueness Columns Status
CST_LAYER_COSTS_I_GT_U1 Unique LAYER_COST_ID Active