WebSphere Commerce database table: INVADJUST

This table records adjustments made to inventory.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031233880 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
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_391 INVADJCODE_ID INVADJCODE INVADJCODE_ID Cascade
F_392 RECEIPT_ID RECEIPT RECEIPT_ID Cascade

Feedback