Each row represents the relationship of an item
and/or location with an inventory configuration.
Column Descriptions:
| Name | Type | Description |
| INVCNFREL_ID | BIGINT NOT NULL | Internal ID of this relationship. |
| INVCNF_ID | BIGINT NOT NULL | The inventory configuration ID. |
| CATENTRY_ID | BIGINT | The 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_ID | INTEGER | The 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_ID | INTEGER | The 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. |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | INVCNFREL_ID | Primary Key |
| I0001227 | CATENTRY_ID+STORE_ID+STLOC_ID | Unique Index |
| I0001228 | STORE_ID | Non-Unique Index |
| I0001229 | STLOC_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3586 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
| F_3587 | STORE_ID | STORE | STORE_ID | Cascade |
| F_3588 | STLOC_ID | STLOC | STLOC_ID | Cascade |
| F_3589 | INVCNF_ID | INVCNF | INVCNF_ID | Cascade |