CST_SCENARIO_ROLLUP_BOM_GT
This is a temporary table to store normalized BOM structure information used by the cost rollup processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| INPUT_SCN_ROLLUP_HDR_ID | NUMBER | 18 | Indicates the scenario rollup header record for the inventory organization, input type, and input identifier. | |
| WHERE_USED_SCN_ROLLUP_HDR_ID | NUMBER | 18 | Indicates the scenario rollup header record for the inventory organization, where used type, and where used identifier. | |
| INV_ORG_ID | NUMBER | 18 | Indicates the plant for which the BOM structure is defined. | |
| INPUT_TYPE | VARCHAR2 | 15 | Indicates the input type. The possible values are ITEM, RESOURCE, and OPERATION. | |
| INPUT_ID | NUMBER | 18 | Indicates the identifier for the input type. | |
| WHERE_USED_TYPE | VARCHAR2 | 15 | Indicates the where used type. The possible values are OPERATION and ITEM. | |
| WHERE_USED_ID | NUMBER | 18 | Indicates the identifier for the where used type. | |
| SOURCE_TYPE | VARCHAR2 | 30 | Indicates the cost rollup derived source table linked to the rollup header. | |
| SOURCE_ID | NUMBER | 18 | Indicates the cost rollup derived source identifier of the input material cost or the resource rate linked to the rollup header. | |
| COSTING_BATCH_OUTPUT_SIZE | NUMBER | Indicates the costing batch output size for work definition for which the snap shot is created. | ||
| BASIS_TYPE | VARCHAR2 | 30 | Indicates whether the usage is fixed (e.g., usage per lot produced) or variable (e.g., usage per item produced). | |
| QUANTITY_USAGE | NUMBER | Indicates the unscaled resource usage rate for the resource or the unscaled material quantity for the input material. | ||
| SCALED_USAGE | NUMBER | Indicates the scaled resource usage rate for the resource or the scaled material quantity for the input material. | ||
| QTY_UOM_CODE | VARCHAR2 | 3 | Indicates the unit of measure of the quantity usage and scaled usage. | |
| YIELD_FACTOR | NUMBER | Indicates the percentage of material quantity actually incorporated into the finished good. | ||
| RESOURCE_SEQ_NUMBER | NUMBER | Defines the actual sequence of the resource used in operations. Multiple resources can be scheduled to be working concurrently within the same operation. | ||
| WORK_CENTER_ID | NUMBER | 18 | Indicates the work center where the resource resides. | |
| PRIMARY_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor for converting from the Costing UOM to the Primary UOM. | ||
| OUTPUT_ALLOCATION_TYPE | VARCHAR2 | 30 | Indicates the allocation type based on cost allocation percentage. Valid values are FIXED_ALLOCATION and PERCENTAGE_ALLOCATION. | |
| BATCH_QUANTITY | NUMBER | Represents the quantity produced for the work definition. In process manufacturing, this is the batch quantity. | ||
| BATCH_UOM_CODE | VARCHAR2 | 3 | Represents the unit of measure code of the batch quantity. | |
| BATCH_PRIMARY_UOM_CODE | VARCHAR2 | 3 | Represents the primary unit of measure code of the batch quantity. | |
| BATCH_UOM_CONVERSION_FACTOR | NUMBER | Indicates the conversion factor from batch UOM to primary UOM | ||
| ELEVATED_FROM_PHANTOM_FLAG | VARCHAR2 | 1 | Indicates whether this component is elevated from phantom to parent level. Possible values are Y and null. | |
| OP_YIELD_FACTOR | NUMBER | Indicates the yield factor for the operation. Default value is 1 (100%). Used by Cost Rollup process for yield calculations. | ||
| OP_REV_YIELD_FACTOR | NUMBER | Indicates the reverse cumulative yield factor for the operation. Default value is 1 (100%). |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_SCN_ROLLUP_BOM_GT_N1 | Non Unique | INPUT_SCN_ROLLUP_HDR_ID |
| CST_SCN_ROLLUP_BOM_GT_N2 | Non Unique | WHERE_USED_SCN_ROLLUP_HDR_ID |