EGO_ITEM_VERSION_ORGANIZATIONS

Details

Schema: FUSION
Object owner: EGO
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
EGO_ITEM_VERSION_ORG_PK	ITEM_VERSION_ORG_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CHANGE_ID	NUMBER		18		Used to refer the change_id from ego_engineering_changes_b table
APPROVAL_STATUS	VARCHAR2	120			Identifier used to determine if the item approval status is in draft or approval status
CHANGE_LINE_ID	NUMBER		18		Used to refer the change_line_id from ego_change_lines_b table
ORGANIZATION_ID	NUMBER		18		It stores the organization id of the child org item being added as part of this version
VERSION_ID	NUMBER		18		Identifier used to store version_id from ego_versions_b. It is used to uniquely identify a version
PK1_VALUE	NUMBER		18		Identifier used to store the inventory_item_id of the item
PK2_VALUE	NUMBER		18		It stores the organization id of the parent item in which child organization is being added
PK3_VALUE	NUMBER		18		Used to refer any other identifier from other tables
PK4_VALUE	NUMBER		18		Used to refer any other identifier from other tables
PK5_VALUE	NUMBER		18		Used to refer any other identifier from other tables
ITEM_VERSION_ORG_ID	NUMBER		18	Yes	Identifier determining the organization id of the item version
INVENTORY_ITEM_STATUS_CODE	VARCHAR2	40			Identifier determining the status of the inventory item
PRIMARY_UOM_CODE	VARCHAR2	12			Unit which is primarily used to measure quantities of the item
TRACKING_QUANTITY_IND	VARCHAR2	120			Attribute indicating the unit of measure in which the item is tracked in inventory
ONT_PRICING_QTY_SOURCE	VARCHAR2	20			Attribute indicating the unit of measure in which the item is priced for selling of the products and services
SECONDARY_DEFAULT_IND	VARCHAR2	120			Defaulting control of the item attribute
SECONDARY_UOM_CODE	VARCHAR2	12			Attribute indicating the secondary unit of measure through which the item can be transacted
DUAL_UOM_DEVIATION_HIGH	NUMBER				Deviation allowed on the higher side for a transaction on the secondary quantity derived from the default conversion factor
DUAL_UOM_DEVIATION_LOW	NUMBER				Deviation allowed on the lower side for a transaction on the secondary quantity derived from the default conversion factor
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.
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.

Indexes

Index	Uniqueness	Tablespace	Columns
EGO_ITEM_VERSION_ORG_U1	Unique	Default	ITEM_VERSION_ORG_ID