CSE_GENEALOGY_OBJECTS
Entity to store the definition of the genealogy object.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CSE_GENEALOGY_OBJECTS_PK |
GEN_OBJECT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
GEN_OBJECT_ID | NUMBER | 18 | Yes | Unique identifier and Primary Key. System Generated using the Fusion Global Unique ID generator | |
ITEM_ID | NUMBER | 18 | Yes | Unique identifier of the genealogy object item. | |
ORGANIZATION_ID | NUMBER | 18 | Yes | Unique identifier of the genealogy object item organization. | |
SERIAL_NUMBER | VARCHAR2 | 80 | Serial number of the genealogy object. Populated only for serial controlled item. | ||
LOT_NUMBER | VARCHAR2 | 80 | Lot number of the genealogy object. Populated only for lot controlled item. | ||
ORIGINATION_DATE | TIMESTAMP | The origination date of this genealogy object. The date when this object is instantiated. | |||
ORIGINATION_QUANTITY | NUMBER | Yes | Quantity originally created for this genealogy object. | ||
ORIGINATION_DOCUMENT_TYPE | VARCHAR2 | 30 | Yes | Reference of the document that originally created this genealogy object. | |
ORIGINATION_DOCUMENT_NUMBER | VARCHAR2 | 240 | Yes | This is the user key of the origination document. | |
ANALYTICS_SYNC_FLAG | VARCHAR2 | 1 | Flag indicating whether the data is synced to aggregate tables used in composition and where used subject areas. | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
cse_assets_b | cse_genealogy_objects | GEN_OBJECT_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CSE_GENEALOGY_OBJECTS_N1 | Non Unique | Default | ITEM_ID, SERIAL_NUMBER |
CSE_GENEALOGY_OBJECTS_N2 | Non Unique | Default | ITEM_ID, ORGANIZATION_ID, LOT_NUMBER |
CSE_GENEALOGY_OBJECTS_U1 | Unique | Default | GEN_OBJECT_ID |