Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: INVCNF
Each row represents an DOM inventory cache configuration.
Column Name Column 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 Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type I0001226 IDENTIFIER Unique Index SQL100520030345780 INVCNF_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3585 QUANTITYMEASURE QTYUNIT QTYUNIT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3589 INVCNF_ID INVCNFREL INVCNF_ID Cascade _vcc_freeselect_bottom_