INVCNFREL

Each row represents the relationship of an item and/or location with an inventory configuration.

Column Descriptions:

NameTypeDescription
INVCNFREL_IDBIGINT NOT NULLInternal ID of this relationship.
INVCNF_IDBIGINT NOT NULLThe inventory configuration ID.
CATENTRY_IDBIGINTThe catalog entry ID. A value of NULL means that this relationship applies to all items at the location specified. A value of NULL for CATENTRY_ID, STORE_ID and STLOC_ID means that this relationship applies to all items at all locations.
STORE_IDINTEGERThe online store ID. Either this or the physical store ID can be specified, but not both. A value of NULL for both STORE_ID and STLOC_ID means that this relationship applies to the item at all locations. A value of NULL for CATENTRY_ID, STORE_ID and STLOC_ID means that this relationship applies to all items at all locations.
STLOC_IDINTEGERThe physical store ID. Either this or the online store ID can be specified, but not both. A value of NULL for both STORE_ID and STLOC_ID means that this relationship applies to the item at all locations. A value of NULL for CATENTRY_ID, STORE_ID and STLOC_ID means that this relationship applies to all items at all locations.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>INVCNFREL_IDPrimary Key
I0001227CATENTRY_ID+STORE_ID+STLOC_IDUnique Index
I0001228STORE_IDNon-Unique Index
I0001229STLOC_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3586CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_3587STORE_IDSTORESTORE_IDCascade
F_3588STLOC_IDSTLOCSTLOC_IDCascade
F_3589INVCNF_IDINVCNFINVCNF_IDCascade