DKPDCCOMPLIST

Contains the components within a predefined configuration.

Column Descriptions:

NameTypeDescription
DKPDCCOMPLIST_IDBIGINT NOT NULLThe ID of the component in the predefined configuration.
DKPREDEFCONF_IDBIGINT NOT NULLThe ID of the predefined configuration.
CATENTRY_IDBIGINT NOT NULLThe catalog entry of the component within the predefined configuration.
GROUPNAMEVARCHAR (254)Header name used to group like components for display.
SEQUENCEDOUBLE NOT NULL DEFAULT 0The sequence number used to determine the order in which to display the component.
QUANTITYDOUBLE NOT NULLThe amount of this component that is in the predefined configuration.
QTYUNIT_IDCHAR (16)The unit of measure corresponding to the quantity of the component in the predefined configuration.
DKPDCREL_IDBIGINTReserved for IBM internal use. The ID of the structure of a pre-defined Nested Dynamic Kit. (No longer supported)
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>DKPDCCOMPLIST_IDPrimary Key
I0000414DKPREDEFCONF_ID+CATENTRY_IDUnique Index
I0000413DKPDCREL_IDNon-Unique Index
I0000908QTYUNIT_IDNon-Unique Index
I0001256CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1062DKPDCREL_IDDKPDCRELDKPDCREL_IDCascade
F_1181DKPREDEFCONF_IDDKPREDEFCONFDKPREDEFCONF_IDCascade
F_1182CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_1183QTYUNIT_IDQTYUNITQTYUNIT_IDCascade