CST_WO_OP_RESOURCES_TO_ADJ_GT
This table is used to hold the work order operations where the resource was transacted and need to be adjusted.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Surrogate ID identifying the cost organization. | |
| COST_BOOK_ID | NUMBER | 18 | Surrogate ID identifying the cost book. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Surrogate ID identifying the work order in costing. | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Surrogate ID identifying the work order opreation in costing. | |
| RESOURCE_ID | NUMBER | 18 | Surrogate ID identifying the resource. | |
| UOM_CODE | VARCHAR2 | 3 | Indicates the primary uom of the resource. | |
| ITEM_COST_PROFILE_ID | NUMBER | 18 | Surrogate ID identifying the item cost profile associate to the end item on the work order. | |
| INVENTORY_ORGANIZATION_ID | NUMBER | 18 | Surrogate ID identifying the plant where the work order is executed. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Surrogate ID identifying the end item on the work order. | |
| EFFECTIVE_START_DATE | DATE | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| EQUIPMENT_INSTANCE_ID | NUMBER | 18 | Represents the foreign key to the equipment instance record. | |
| LABOR_INSTANCE_ID | NUMBER | 18 | Represents the foreign key to the labor instance record. | |
| BASIS_TYPE | VARCHAR2 | 30 | Indicates the basis type for the resource/component usage rate. Fixed rate means that the resource/component is used once as per the resource usage rate for the entire batch. Variable rate means that for each item produced, the resource/component is used as per the resource usage rate specified. A value of 1 indicate 'Variable'. A value of 2 indicate 'Fixed'. |