CSE_GENEALOGY_COMPOSITION
The aggregate table to generate data for the genealogy composition subject area.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CSE_GENEALOGY_COMPOSITION_PK |
ROOT_GEN_OBJECT_ID, PARENT_GEN_OBJECT_ID, CHILD_GEN_OBJECT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ROOT_GEN_OBJECT_ID | NUMBER | 18 | Yes | Root genealogy object identifier in the hierarchy of genealogy objects . | |
| ROOT_ITEM_ID | NUMBER | 18 | The item identifier corresponding to the root genealogy object. | ||
| ROOT_ORGANIZATION_ID | NUMBER | 18 | The organization identifier corresponding to the root genealogy object. | ||
| ROOT_LOT_NUMBER | VARCHAR2 | 80 | The lot number corresponding to the root genealogy object. | ||
| ROOT_SERIAL_NUMBER | VARCHAR2 | 80 | The serial number corresponding to the root genealogy object. | ||
| ROOT_ORIG_DATE | TIMESTAMP | The origination date corresponding to the root genealogy object. | |||
| ROOT_ORIG_QUANTITY | NUMBER | The origination quantity corresponding to the root genealogy object. | |||
| ROOT_ORIG_DOC_TYPE | VARCHAR2 | 30 | The origination docuent type corresponding to the root genealogy object. | ||
| ROOT_ORIG_DOC_NUMBER | VARCHAR2 | 240 | The origination document number corresponding to the root genealogy object. | ||
| RELATIONSHIP_TYPE_CODE | VARCHAR2 | 30 | The relationship type code that is established between the parent and child genealogy objects. | ||
| PARENT_GEN_OBJECT_ID | NUMBER | 18 | Yes | Parent genealogy object identifier in the hierarchy of genealogy objects . | |
| PARENT_ITEM_ID | NUMBER | 18 | The item identifier corresponding to the parent genealogy object. | ||
| PARENT_ORGANIZATION_ID | NUMBER | 18 | The organization identifier corresponding to the parent genealogy object. | ||
| PARENT_LOT_NUMBER | VARCHAR2 | 80 | The lot number corresponding to the parent genealogy object. | ||
| PARENT_SERIAL_NUMBER | VARCHAR2 | 80 | The serial number corresponding to the parent genealogy object. | ||
| PARENT_ORIG_DATE | TIMESTAMP | The origination date corresponding to the parent genealogy object. | |||
| PARENT_ORIG_QUANTITY | NUMBER | The origination quantity corresponding to the parent genealogy object. | |||
| PARENT_ORIG_DOC_TYPE | VARCHAR2 | 30 | The origination docuent type corresponding to the parent genealogy object. | ||
| PARENT_ORIG_DOC_NUMBER | VARCHAR2 | 240 | The origination document number corresponding to the parent genealogy object. | ||
| CHILD_LEVEL | NUMBER | The level at which the child is at. | |||
| CHILD_GEN_OBJECT_ID | NUMBER | 18 | Yes | Child genealogy object identifier in the hierarchy of genealogy objects . | |
| CHILD_ITEM_ID | NUMBER | 18 | The item identifier corresponding to the child genealogy object. | ||
| CHILD_ORGANIZATION_ID | NUMBER | 18 | The organization identifier corresponding to the child genealogy object. | ||
| CHILD_LOT_NUMBER | VARCHAR2 | 80 | The lot number corresponding to the child genealogy object. | ||
| CHILD_SERIAL_NUMBER | VARCHAR2 | 80 | The serial number corresponding to the child genealogy object. | ||
| CHILD_ORIG_DATE | TIMESTAMP | The origination date corresponding to the child genealogy object. | |||
| CHILD_ORIG_QUANTITY | NUMBER | The origination quantity corresponding to the child genealogy object. | |||
| CHILD_ORIG_DOC_TYPE | VARCHAR2 | 30 | The origination docuent type corresponding to the child genealogy object. | ||
| CHILD_ORIG_DOC_NUMBER | VARCHAR2 | 240 | The origination document number corresponding to the child genealogy object. | ||
| 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 |
|---|---|---|---|
| CSE_GENEALOGY_COMPOSITION_U01 | Unique | Default | ROOT_GEN_OBJECT_ID, PARENT_GEN_OBJECT_ID, CHILD_GEN_OBJECT_ID |