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 |