CZ_CONFIG_LINES
A row of this table represents a line in a configuration.
Details
-
Schema: FUSION
-
Object owner: CZ
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CZ_CONFIG_LINES_PK |
HEADER_ID, REVISION_NUMBER, LINE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
LINE_ID | NUMBER | 18 | Yes | System generated unique identifier for the configuration line. | |
PERSISTENT_LINE_ID | NUMBER | 18 | System generated identifier while saving a new configuration line. Previously generated identifier will persist during a reconfiguration session. | ||
PARENT_LINE_ID | NUMBER | 18 | System generated unique identifier to the parent of this configuration line. | ||
HEADER_ID | NUMBER | 18 | Yes | System generated unique identifier for the configuration. FK to CZ_CONFIG_HEADERS | |
REVISION_NUMBER | NUMBER | 18 | Yes | Generated by Configurator to indicate the revision of a configuration. FK to CZ_CONFIG_HEADERS | |
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Item ID of the inventory item. | |
ORGANIZATION_ID | NUMBER | 18 | Yes | Organization ID of the inventory item. | |
QUANTITY | NUMBER | Item quantity ordered | |||
QUANTITY_UNROUNDED | NUMBER | Contains the original unrounded value of unit quantity which is saved by the Core in addition to the processed (rounded) value. | |||
UOM_CODE | VARCHAR2 | 3 | Unit of measure for the quantity | ||
COMPONENT_ID_PATH | VARCHAR2 | 2000 | Inventory ID path to the parent of this Line. Path format is ">" separated inventory item id. | ||
CONFIGURATOR_PATH | VARCHAR2 | 2000 | Runtime representation of the Inventory Item Id path to the component. Path format is "." Separated inventory item id. For multi-instantiable components instances are denoted by [<instance number>]. | ||
SHOW_IN_SALES | NUMBER | Attribute signifying if the item component can be shown in sales summary. Note: This value comes from configurator snapshot and it can be stale if further changes were made in PIM Item structure after a snapshot update.Possible values are 1 (Yes), 2 (hide Self), 3 (hide self and descendants) | |||
CONNECTED_LINE_TYPE | VARCHAR2 | 30 | Line Type Descriminator. Distinguishes between unconnected lines - 'NULL' and standard item connector types - 'ORA_STANDARD_ITEM'. Potential future value for connector type model - 'ORA_MODEL_ITEM'. | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
CZ_CONFIG_LINES | cz_config_headers | HEADER_ID, REVISION_NUMBER |
CZ_CONFIG_LINES | cz_config_lines | HEADER_ID, REVISION_NUMBER, PARENT_LINE_ID |
cz_config_messages | cz_config_lines | LINE_ID, HEADER_ID, REVISION_NUMBER |
cz_config_line_attrs | cz_config_lines | HEADER_ID, REVISION_NUMBER, LINE_ID |
cz_config_lines | cz_config_lines | HEADER_ID, REVISION_NUMBER, PARENT_LINE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CZ_CONFIG_LINES_U1 | Unique | Default | HEADER_ID, REVISION_NUMBER, LINE_ID |