CST_WORK_ORDER_COSTS
This table contains the WIP costs for a WO and is used for determining: The product cost for non-standard cost methods, the residual WIP balance for standard cost method products which are accounted as variances, the values of the WIP material return transaction. This table will be populated when a resource or inventory transaction belonging to a work order is successfully processed and included in the layer cost or resource cost table.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_WORK_ORDER_COSTS_PK |
WORK_ORDER_COST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WORK_ORDER_COST_ID | NUMBER | 18 | Yes | Surrogate ID identifying a work order cost. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost organization associated to the plan where the resource was consumed. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost book. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order where the resource was consumed. | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order operation where the resource was consumed. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Surrogate ID identifying the inventory item associated with the WIP inventory transaction. | ||
| RESOURCE_ID | NUMBER | 18 | Surrogate ID identifying the resource associated with the WIP resource transaction. | ||
| PO_ITEM_DESCRIPTION | VARCHAR2 | 240 | Item Description for purchase orders where purchase is made for non inventory items. | ||
| WIP_COST_TYPE | VARCHAR2 | 30 | Yes | Indicates the type of cost that is captured. Possible values are: COMPONENT, SCRAP, PRODUCT, RESOURCE. | |
| 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. | |
| COST_DATE | TIMESTAMP | Cost date of the inventory/resource transaction. | |||
| PERIOD_NAME | VARCHAR2 | 15 | Period in which the cost is processed. This value is populated for the transactions in periodic average cost method. | ||
| TRANSACTION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the transaction. This could be CT, CRT or COT transaction ID. | |
| COST_ID | NUMBER | 18 | Yes | Surrogate ID FK to join to the Pk of the corresponding table where the transaction is recorded. | |
| SOURCE_TABLE | VARCHAR2 | 30 | Yes | Identifies the source table where the cost is recorded. - cst_layer_costs - cst_resource_costs - cst_wo_cost_variances. | |
| QUANTITY | NUMBER | The quantity recorded on the inventory/resource transaction. | |||
| UOM_CODE | VARCHAR2 | 3 | The unit of measure on the corresponding transaction. | ||
| UNIT_COST | NUMBER | The unit cost recorded at cost element, expense pool level. | |||
| CURRENCY_CODE | VARCHAR2 | 20 | Yes | Currency code in which the cost is recorded. | |
| WIP_TXN_SIGN | NUMBER | 1 | Yes | Indicates if the cost row is to be added or subtracted from the total WIP cost. This value is multiplied with the quantity and cost to arrive at the net cost to be moved in or out of work order cost. Possible values are 1 or -1. | |
| ABSORPTION_TYPE | VARCHAR2 | 30 | Indicates whether the cost needs to be included in total WIP value or Expensed. | ||
| RECLOSE_FLAG | VARCHAR2 | 4 | Yes | Indicates if the work order cost was posted after the job was closed. | |
| 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. | ||
| WO_COST_ALLOCATION_BASIS | VARCHAR2 | 30 | The basis for cost allocation for output items in a process manufacturing work order. It can be either percentage or fixed value. Valid values exist in lookup ORA_WIS_COST_ALLOC_BASIS. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_WORK_ORDER_COSTS_N1 | Non Unique | Default | CST_WORK_ORDER_ID, COST_ORG_ID, COST_BOOK_ID, CST_WORK_ORDER_OPERATION_ID |
| CST_WORK_ORDER_COSTS_N2 | Non Unique | Default | COST_ORG_ID, COST_BOOK_ID, RECLOSE_FLAG |
| CST_WORK_ORDER_COSTS_N3 | Non Unique | Default | TRANSACTION_ID |
| CST_WORK_ORDER_COSTS_N4 | Non Unique | Default | TRUNC("COST_DATE") |
| CST_WORK_ORDER_COSTS_N5 | Non Unique | DEFAULT | COST_ORG_ID, COST_BOOK_ID, CST_WORK_ORDER_ID, COST_DATE |
| CST_WORK_ORDER_COSTS_PK | Unique | Default | WORK_ORDER_COST_ID |
| CST_WORK_ORDER_COSTS_U1 | Unique | Default | COST_ID, SOURCE_TABLE |