1. Tables and Views for SCM
  2. CST_WO_OSP_COSTS_I_GT

CST_WO_OSP_COSTS_I_GT

This table is used to temporarily store a subset of the data from cst_wo_osp_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_WO_OSP_COSTS_I_GT_PK

WO_OSP_COST_ID

Columns

Name Datatype Length Precision Not-null Comments
WO_OSP_COST_ID NUMBER 18 Yes Surrogate ID identifying a row in this table.
TRANSACTION_ID NUMBER 18 Yes Surrogate ID identifying a outside processing transaction in costing.
COST_ORG_ID NUMBER 18 Yes Surrogate ID identifying the cost organization associated to the plant of the work order.
COST_BOOK_ID NUMBER 18 Yes Surrogate ID identifying the cost book.
INVENTORY_ITEM_ID NUMBER 18 Yes Surrogate ID identifying the service item.
VAL_UNIT_ID NUMBER 18 Surrogate ID identifying the valuation unit.
EFF_DATE TIMESTAMP Yes Effective date of the cost used to create this transaction.
COST_DATE TIMESTAMP Yes Cost date of the outside processing transaction.
COST_ELEMENT_ID NUMBER 18 Yes Surrogate ID identifying the cost element against which the cost is captured.
EXPENSE_POOL_ID NUMBER 18 Yes Surrogate ID identifying the expense pool against which the cost is captured.
TRANSACTION_COST_ID NUMBER 18 Yes Surrogate ID identifying the transaction cost.
BASE_TXN_TYPE_ID NUMBER 18 Yes Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table. For origin as CST the value comes from CST_INTERNAL_TXN_TYPES_VL.
COST_SOURCE VARCHAR2 30 Identifies the source of the cost, such as Standard cost (STDC). 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 30 Yes Identifies the cost transaction type such as a RECEIPT or ISSUE or ADJUST.
ADDITIONAL_PROCESSING_CODE VARCHAR2 20 Additional Processing Code is an optional further definition of the Cost Transaction Type e.g. ACQUISITION denotes acquisition cost adjustment.
ABSORPTION_TYPE VARCHAR2 30 Indicates the absorption type on the transaction. NULL/3 ?? Include in WIP 2 ?? Expense. We should never ever have a value of 1 (Include in inventory).
QUANTITY NUMBER Yes Transaction quantity in costing UOM.
UOM_CODE VARCHAR2 3 Yes Costing unit of measure for the outside processing transaction.
UNIT_COST NUMBER Yes Per unit cost in cost book currency for each cost element and expense pool combination applicable on the transaction.
CURRENCY_CODE VARCHAR2 15 Yes Identifies the currency of the Cost org-cost book in which the resource transaction is processed.
POSTED_FLAG VARCHAR2 4 Indicates if the distributions have been created for this row. Y- Yes, N- No
DISTRIBUTION_ID NUMBER 18 Identifies the Distribution Header, if the distributions have been created for the outside processing transaction record.
STD_COST_ID NUMBER 18 Surrogate ID identifying the Frozen Standard Cost published to Cost Accounting that was used for deriving the transaction cost in STANDARD cost method.
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_WO_OSP_COSTS_I_GT_U1 Unique TRANSACTION_ID, COST_ELEMENT_ID, EXPENSE_POOL_ID, EFF_DATE
CST_WO_OSP_COSTS_I_GT_U2 Unique WO_OSP_COST_ID