CZ_SS_ITEM_SUPPL_ATTR_VALUES
This table contains supplemental attribute values defined on Item Snapshots.
Details
-
Schema: FUSION
-
Object owner: CZ
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
CZ_SS_ITEM_SUPPL_ATTR_VALS_PK |
ATTR_VALUE_ID, PRODUCTION_FLAG |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ATTR_VALUE_ID | NUMBER | 18 | Yes | Attribute value identifier, part of primary key along with production_flag. | |
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory item identifier, part of the primary key for an Item Snapshot. | |
ORGANIZATION_ID | NUMBER | 18 | Yes | Organization identifier, part of the the primary key for an Item Snapshot. | |
PRODUCTION_FLAG | VARCHAR2 | 1 | Yes | Denotes whether the record is available in production (when Y) or only in test scenarios (when N). | |
ATTRIBUTE_ID | NUMBER | 18 | Yes | Indicates Supplemental Attribute, a foreign key to CZ_SUPPLEMENTAL_ATTRIBUTES_B.ATTRIBUTE_ID. | |
VALUE_ID | NUMBER | 18 | Value id in case when the value comes from an independent value set. Added in order to be able to efficiently account for value effectivity intervals if needed, but can be useful for other purposes. | ||
NUMBER_VALUE | NUMBER | Stores the value of a Format Only attribute if the attribute is of type NUMBER, otherwise NULL. | |||
TEXT_VALUE | CLOB | Stores the value of a Format Only attribute if the attribute is of type TEXT, otherwise NULL. | |||
DATE_VALUE | DATE | Stores the value of a Format Only attribute if the attribute is of type DATE, otherwise NULL. | |||
TIMESTAMP_VALUE | TIMESTAMP | Stores the value of a Format Only attribute if the attribute is of type TIMESTAMP, otherwise NULL. | |||
DELETED_FLAG | NUMBER | 18 | Yes | This flag indicates the logical deletion of the row. The Non-Zero value represents deleted state and 0 represents not-deleted state. A user controlled background purge process will physically delete the orphaned rows with the Non-Zero flag value. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
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. | |
EFFECTIVE_FROM | DATE | Yes | Date at which the value becomes effective. | ||
EFFECTIVE_UNTIL | DATE | Date at which the value becomes ineffective. | |||
EFFECTIVITY_CHANGE_DATE | DATE | This field will contain the date at which the production snapshot behavior will change upon snapshot release. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
CZ_SS_ITEM_SUPPL_ATTR_VALUES | cz_supplemental_attributes_b | ATTRIBUTE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CZ_SS_ITEM_SUPPL_ATTR_VALS_U1 | Unique | Default | ATTR_VALUE_ID, PRODUCTION_FLAG |
CZ_SS_ITEM_SUPPL_ATTR_VALS_U2 | Unique | Default | INVENTORY_ITEM_ID, ORGANIZATION_ID, ATTRIBUTE_ID, PRODUCTION_FLAG, DELETED_FLAG, EFFECTIVE_FROM |