STOREINV
Reserved for HCL internal use. STOREINV is a view used by the Catalog search bean. It collates several fields from the INVENTORY table. There is a column ALLOCATIONGOODFOR in the STORE table. If this column is set to zero, the search bean makes use of this view.
Column Descriptions:
Name | Type | Description |
---|---|---|
STORE_ID | INTEGER NOT NULL | Reserved for HCL internal use. |
CATENTRY_ID | BIGINT NOT NULL | Reserved for HCL internal use. |
STOREQUANTITY | DOUBLE | Reserved for HCL internal use. |
QUANTITYMEASURE | CHAR (16) NOT NULL | Reserved for HCL internal use. |
C5 | INTEGER NOT NULL | Reserved for HCL internal use. |