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 |