Each row represents an DOM inventory cache
configuration.
Column Descriptions:
| Name | Type | Description |
| INVCNF_ID | BIGINT NOT NULL | Internal ID of this inventory configuration. |
| IDENTIFIER | VARCHAR (64) NOT NULL | External identifier of this inventory
configuration. |
| DESCRIPTION | VARCHAR (254) | Administrative description of this inventory
configuration. |
| PRECEDENCE | DOUBLE NOT NULL DEFAULT 0 | Precedence of this inventory configuration when
an item is associated with multiple inventory configurations at the
location specified. |
| FLAGS | INTEGER NOT NULL DEFAULT 0 | A bit field for specifying the following
inventory configuration options:
- 0
- The default value. None of the following flags are
applicable.
- 1
- Cache inventory availability in a WebSphere distributed object
cache.
- 2
- Cache inventory availability in the Commerce database.
- 4
- Retrieve inventory availability from DOM by making an outbound
GetInventoryAvailability service request when the information is
not cached locally, or when the cached information is no longer
valid.
- 8
- Decrement the cached inventory availability records when an
order/shopping cart is submitted for processing.
- 16
- Update the cached inventory availability records as the
information is retrieved from DOM.
|
| THRESHOLDQUANTITY | DOUBLE | The threshold quantity. It determines the expiry
time used. A value of NULL is equivalent to a value of negative
infinity, which means that the cached available quantity (minus the
requested quantity if present) is always greater than or equal to
the threshold quantity. |
| CHEXPABOVETHRES | INTEGER | The expiry time of a cached inventory
availability record when the cached available quantity (minus the
requested quantity if present) is greater than or equal to the
threshold quantity. Such a record has expired when the number of
seconds elapsed since the record was last updated is greater than
this value. A value of 0 means that the record expires immediately,
and a value of NULL means that the record never expires. |
| CHEXPBELOWTHRES | INTEGER | The expiry time of a cached inventory
availability record when the cached available quantity (minus the
requested quantity if present) is less than the threshold quantity.
Such a record has expired when the number of seconds elapsed since
the record was last updated is greater than this value. A value of
0 means that the record expires immediately, and a value of NULL
means that the record never expires. |
| CACHEPRIORITY | INTEGER NOT NULL DEFAULT 0 | The priority of a cached inventory availability
record when cached in the WebSphere distributed object cache.
Records with higher priorities will remain in the cache longer than
those with lower priorities in the case of cache overflow. |
| FALLBACKINVSTAT | CHAR (4) | Fallback inventory status. |
| FALLBACKAVAILTIME | TIMESTAMP | Fallback availability date. |
| FALLBACKINVOFFSET | INTEGER | Fallback availability offset in seconds. |
| FIELD1 | INTEGER | Customizable |
| FIELD2 | DECIMAL (20,5) | Customizable |
| FIELD3 | VARCHAR (254) | Customizable |
| QUANTITYMEASURE | CHAR (16) NOT NULL DEFAULT 'C62' | Unit of measure of the quantity above. |
| 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> | INVCNF_ID | Primary Key |
| I0001226 | IDENTIFIER | Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3585 | QUANTITYMEASURE | QTYUNIT | QTYUNIT_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_3589 | INVCNF_ID | INVCNFREL | INVCNF_ID | Cascade |