1. Tables and Views for SCM
  2. CST_ROLLUP_REPORT_GT

CST_ROLLUP_REPORT_GT

This is a temporary table used to store all the Cost Rollup Details BIP Report data.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: DEFAULT

Columns

Name Datatype Length Not-null Comments
ROLLUP_HEADER_KEY VARCHAR2 120 Yes Unique identifier for each rollup header.
OP_REV_YIELD_FACTOR NUMBER Indicates the reverse cumulative yield factor for the operation.
OP_YIELD_FACTOR NUMBER Indicates the yield factor for the operation. Default value is 1 (100%).
PARENT_ROLLUP_HEADER_KEY VARCHAR2 120 Yes Unique identifier for each parent rollup header.
ROLLUP_HEADER_TYPE VARCHAR2 30 Yes Indicates the rollup header type. Valid values are ITEM, SOURCING_RULE, OPERATION, OVERHEAD, RESOURCE, OUTPUT_ITEM, or RESIDUAL.
DISPLAY_NAME VARCHAR2 4000 Yes Indicates the name of the output item, or resource, or operation, or input item, or overhead, or sourcing rule.
PARENT_ROLLUP_HEADER_TYPE VARCHAR2 30 Indicates the parent rollup header type. Valid values are ITEM, SOURCING_RULE, OPERATION, OVERHEAD, RESOURCE, OUTPUT_ITEM, or RESIDUAL.
STATUS_CODE VARCHAR2 30 Indicates the status of the rollup header. Valid values are NOT_PROCESSED, SUCCESS, CHANGED, or other message codes.
ENTERED_UNIT_COST NUMBER Identifies the manually entered unit cost. This can be - buy or standard cost of a component, resource rate or fixed output costs.
CURRENCY_CODE VARCHAR2 80 Indicates currency code for costs.
MATERIAL_COST NUMBER Identifies the cumulative cost of a material.
RESOURCE_COST NUMBER Identifies the cumulative cost of a resource.
OVERHEAD_COST NUMBER Identifies the cumulative cost of a material overhead.
EXTENDED_COST NUMBER Indicates the rate x usage scaled amount or the material cost x quantity scaled amount that takes into consideration the costing batch output size and basis type.
ALLOCATED_MATERIAL_COST NUMBER Identifies the allocated cost of a material.
ALLOCATED_RESOURCE_COST NUMBER Identifies the allocated cost of a resource.
ALLOCATED_OVERHEAD_COST NUMBER Identifies the allocated cost of an overhead.
ALLOCATED_EXTENDED_COST NUMBER Indicates the allocated rate x usage scaled amount or the allocated material cost x quantity scaled amount that takes into consideration the costing batch output size and basis type, along with the material yield when applicable,
UNIT_COST NUMBER Indicates the average per output amount calculated as EXTENDED_COST/COSTING_BATCH_OUTPUT_SIZE and is the amount used for rolling up to the next level.
COST_ALLOCATION_PERCENTAGE NUMBER Identifies the cost allocation percentage for an output item for a particular operation + cost allocation percentage for an output item for a prior operation for output at operation level in process manufacturing.
COST_ALLOCATION_FIXED NUMBER Captures the total of all the allocated unit cost for output at operation level in process manufacturing.
OUTPUT_COST NUMBER Captures the total of all the allocated extended cost for output in process manufacturing.
SOURCING_RULE_NAME VARCHAR2 80 This value indicates sourcing rule name.
SOURCING_RULE_RANK NUMBER This value indicates the rank of the sourcing rule.
SOURCING_RULE_TYPE VARCHAR2 80 Indicates the rule type. Valid values exist in the lookup with MSC_SOURCING_SOURCE_TYPE
SUPPLIER VARCHAR2 360 Indicates the supplier name for buy type sourcing rules.
SUPPLIER_SITE VARCHAR2 50 Indicates the supplier site identifier for buy type sourcing rules.
SUPPLY_ALLOCATION NUMBER Percent of supply allocated to this source.
TRANSFER_CHARGE_RULE_NAME VARCHAR2 200 This value indicates transfer charge rule name.
EXTRACTION_DATE DATE Indicates the date and time of the creation of the sourcing rule.
PLANT_ORG_NAME VARCHAR2 240 Denotes the name for the organization unit.
WORK_METHOD_NAME VARCHAR2 120 Indicates the name of the work method.
REFERENCE_TYPE VARCHAR2 80 Indicates the references type. Valid values are PURCHASE_ORDER, WORK_ORDER, ITEM_STRUCTURE, or WORK_DEFINITION.
WORK_DEFINITION_HEADER_NAME VARCHAR2 120 Represents the work definition name assigned to this work definition which is a foreign key to the WIS_WORK_DEFINITION_NAMES_B table.
WORK_DEFINITION_NAME VARCHAR2 150 Indicates the name of the work definition for which the snapshot is being created for.
BATCH_QUANTITY NUMBER Represents the quantity produced for the work definition. In process manufacturing, this is the batch quantity.
COSTING_BATCH_OUTPUT_SIZE NUMBER Indicates the costing batch output size for work definition.
OPERATION_SEQ_NUMBER NUMBER Indicates the sequence of the operation in the work definition snapshot.
OUTPUT_QUANTITY NUMBER Represents the output quantity expected to be produced.
UNIT_OF_MEASURE VARCHAR2 120 Indicates the unit of measure of the output.
BASIS_TYPE VARCHAR2 30 Indicates whether the item quantity is fixed (e.g., quantity per lot produced) or variable (e.g., quantity per item produced).
ABSORPTION_TYPE VARCHAR2 30 Identifies the absorption type of the overhead rate details.
OVERHEAD_RATE VARCHAR2 40 Indicates the unit rate of overhead that was applied by rollup.
OVERHEAD_RATE_DETAILS VARCHAR2 750 Indicates the overhead rate details.
ITEM_DESCRIPTION VARCHAR2 240 Indicates the output or input item description.
OUTPUT_TYPE VARCHAR2 30 Type of output produced by the operation. Valid values exist in the lookup with lookup type = ORA_WIS_WD_OUTPUT_MATERIAL.
DISPLAY_SEQ NUMBER Indicates the display sequence of this output line.
COST_ALLOCATION_SEQ NUMBER Sequence of cost allocation for output at operation level in process manufacturing.
OUTPUT_SEQ_NUMBER NUMBER Indicates the sequence of this output line.
RUNNING_TOTAL NUMBER Captures the running total of extended cost.
RESOURCE_SEQ_NUMBER NUMBER Indicates the resource sequence for the resource under the work definition operation.

Indexes

Index Uniqueness Columns
CST_ROLLUP_REPORT_GT_N1 Non Unique ROLLUP_HEADER_KEY, PARENT_ROLLUP_HEADER_KEY, ROLLUP_HEADER_TYPE, DISPLAY_NAME