Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: INVADJUST
This table records adjustments made to inventory.
Column Name Column Type Description INVADJUST_ID BIGINT NOT NULL System generated identifier which groups together the RECEIPT rows that were updated during an adjustment. INVADJUSTNUM INTEGER NOT NULL A number that uniquely identifies this receipt adjustment along with its specified INVADJUST_ID. INVADJCODE_ID BIGINT NOT NULL Foreign key to INVADJCODE table to indicate the type of adjustment being done. RECEIPT_ID BIGINT NOT NULL Indicates the receipt which was adjusted. ADJUSTMENTDATE TIMESTAMP Timestamp of adjustment. QUANTITY INTEGER Quantity adjusted for this receipt. ADJUSTMENTCOMMENT VARCHAR(254) Comment. LASTUPDATE TIMESTAMP Timestamp of last update. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030345480 INVADJUST_ID+INVADJUSTNUM Primary Key I0000136 INVADJUST_ID+INVADJCODE_ID+ADJUSTMENTDATE Non-Unique Index I0000592 RECEIPT_ID Non-Unique Index I0000593 INVADJCODE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_391 INVADJCODE_ID INVADJCODE INVADJCODE_ID Cascade F_392 RECEIPT_ID RECEIPT RECEIPT_ID Cascade
Related reference
_vcc_freeselect_bottom_