CST_OVERHEAD

Details

Schema: FUSION
Object owner: CST
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
CST_OVERHEAD_RULES_PK	RULE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
RULE_ID	NUMBER		18	Yes	Primary Key for CST_OVERHEAD_RULES
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
RULE_CODE	VARCHAR2	30		Yes	Name that describes the overhead rule used for absorbing overheads.
COST_ORGANIZATION_ID	NUMBER		18	Yes	Identifier of the cost organization in which overhead rules are defined for absorption.
COST_BOOK_ID	NUMBER		18	Yes	Identifier of the cost book in which overhead rules are defined for absorption.
INACTIVE	VARCHAR2	1			Indicates if the overhead rule is active or in active for absorption.	Obsolete
EXPENSE_POOL_ID	NUMBER		18	Yes	Identifier of the expense pool that pools the overhead absorbed across overhead rules.
COST_ELEMENT_ID	NUMBER		18	Yes	Identifier of the cost element for absorbing the overheads based on overhead rules.
TRANSACTION_GROUP_ID	NUMBER		18	Yes	Transaction Group Identifier - Values from Fnd lookup CST_TRANSACTION_GROUPS
TRANSACTION_FLOW	VARCHAR2	18		Yes	Transaction Flow- Receipt or Issue
TRANSACTION_TYPE_ID	NUMBER		18		Transaction Type Identifier corresponding to transaction groups in CST_TRANSACTION_GROUPS table.
CATEGORY_ID	NUMBER		18		Identifier of the item category used for grouping items based on a common characteristic or usage within the costing catalog.
INVENTORY_ORG_ID	NUMBER		18		Inventory Organization Identifier
INVENTORY_ITEM_ID	NUMBER		18		Identifier of the inventory item used as cost driver for absorbing overheads.
COST_DRIVER	VARCHAR2	18		Yes	Cost Driver - LOT, UNIT, PER_TXN or PER_VALUE
COST_DRIVER_VALUE	NUMBER		18		Cost Driver Value - FK from Cost Element Group Id in CST_COST_ELEMENT_GRPS_VL
ABSORPTION_TYPE	VARCHAR2	3		Yes	Absorption Type - Include in Inventory or Expense
POSTED_FLAG	VARCHAR2	1			Posted Flag - C-create, U- Update , P - Posted
DELETED_FLAG	VARCHAR2	1			Deleted Flag - D- Delete else null
PROCESSED_FLAG	VARCHAR2	1			Indicates if the overhead rule is picked up for absorption of overheads for transactions. Possible values are: N - rule updated, W - rule is currently being processed, X - rule marked for delete, Y - rule marked as processed.
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.
RATE	NUMBER				Unused column in parent to facilitate migration of date effectivity enhancement to customers while keeping the original column rate.

Foreign Keys

Table	Foreign Table	Foreign Key Column
cst_overhead_rule_details	cst_overhead_rules	RULE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CST_OVERHEAD_RULES_N1	Non Unique	Default	PROCESSED_FLAG
CST_OVERHEAD_RULES_PK	Unique	Default	RULE_ID
CST_OVERHEAD_RULES_U1	Unique	Default	RULE_CODE, COST_ORGANIZATION_ID, COST_BOOK_ID, DELETED_FLAG
CST_OVERHEAD_RULES_U2	Unique	Default	COST_ORGANIZATION_ID, COST_BOOK_ID, EXPENSE_POOL_ID, TRANSACTION_GROUP_ID, TRANSACTION_FLOW, TRANSACTION_TYPE_ID, INVENTORY_ORG_ID, CATEGORY_ID, INVENTORY_ITEM_ID, COST_DRIVER, ABSORPTION_TYPE, DELETED_FLAG