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:

NameTypeDescription
STORE_IDINTEGER NOT NULLReserved for HCL internal use.
CATENTRY_IDBIGINT NOT NULLReserved for HCL internal use.
STOREQUANTITYDOUBLEReserved for HCL internal use.
QUANTITYMEASURECHAR (16) NOT NULLReserved for HCL internal use.
C5INTEGER NOT NULLReserved for HCL internal use.